i-amolo

How to Install PHP 7.0 MSSQL Driver on CentOS 7

Adapted from: http://fdta.com.br/2017/03/19/como-usar-o-freetds-e-o-unixodbc-em-um-centos-7-com-php-5-4-para-acessar-bancos-de-dados-sql-server-e-sybase-asa/

1. Update CentOS with the following command

yum check-update 
yum update

i-amolo

Backend Server Platform

Core stack

• Hardware/VM host:
• VM:
• Operating System:
• Data store:
• Application Framework:
• Application Server:

i-amolo

#
# Cutom Environment Variables for Tomcat
#
############################################
export JAVA_HOME=/usr/lib/jvm/java-7-oracle/jre
export PATH=${JAVA_HOME}/bin:${PATH}

############################################
#
# JAVA_OPTS

i-amolo

运行tomcat会出现 org.apache.catalina.webresources.Cache.backgroundProcess The background cache eviction process was unable to free [10] percent of the cache for Context [/QiiiBuoy] - consider increasing the maximum size of the cache. After eviction approximately [9,506] KB of data remained in the cache.
 在tomcat的/conf/context.xml中的Context中追加一句
<Resources cachingAllowed="true" cacheMaxSize="100000" />
变成如下

<?xml version='1.0' encoding='utf-8'?>
<Context>
    <WatchedResource>WEB-INF/web.xml</WatchedResource>
    <WatchedResource>${catalina.base}/conf/web.xml</WatchedResource>
    <Resources cachingAllowed="true" cacheMaxSize="100000" />

i-amolo

AWS Certification notes

Those are my personal notes on AWS Solution Architect certification preparation. Hope you find them usefull.

To pass AWS certification, you should have:

• Sound knowledge about most of the AWS services ( EC2, VPC, RDS, Cloudfront, S3, Route53 etc,)
• Hands on experience with AWS services.

i-amolo

Becoming a Spring Certified Professional without the Core Spring Course

Until recently, the only way you could become a Certified Spring Professional was to take Pivotal’s compulsory, 4-day, Core Spring training course. On completion of the course, participants received an exam voucher that allowed them to schedule an exam at a certification centre.

At approximately £2.5k per attendee, the course is not cheap putting certification out of the reach of many self-funded developers and those that work for organisations without generous training budgets.

In May 2017 Pivotal changed their policy. Spring Certification Exams became available for individual purchase without enrolling in the course. I set out to see if it was possible to pass the exam without the Core Spring course and only using publically available material.

I set myself a budget of £250, ap

i-amolo

====== Build your own PHP on Windows ======

===== Before you Begin =====

Building PHP on Windows will require three things
  - A properly set up build environment, including a compiler with the right SDK's and some binary tools used by the build system
  - Prebuilt libraries and headers for third party libraries that PHP uses in the correct location
  - The PHP source

===== Compiler =====

i-amolo

Reset MySQL 8.0 root Password in Windows

1. Stop the MySQL 8.0service from services
2. Go to path C:\Program Files\MySQL\MySQL Server 8.0\bin and open cmd
3. Run mysqld --console --skip-grant-tables --shared-memory
4. Open new cmd in the same path
5. Run following commands
6. mysql -u root
7. select authentication_string,host from mysql.user where user='root';
8. UPDATE mysql.user SET authentication_string='' WHERE user='root';

i-amolo

CREATE FUNCTION [dbo].[udf_FormatBytes] 
( 
	@InputNumber DECIMAL(38,7), 
	@InputUOM VARCHAR(5) = 'Bytes' 
) 
RETURNS VARCHAR(20) 
WITH SCHEMABINDING 
AS 
BEGIN 
-- Declare the return variable here 

i-amolo

<VirtualHost *:80>
    DocumentRoot "/www/project1"
    ServerName site1.localhost
    
    <Directory "/www/project1">
        Require all granted
        AllowOverride All
    </Directory>
</VirtualHost>