Build a php+java+mysql project in Linux system

1. Check out the code from a version control system.
From svn:
svn co svn+ssh://user@127.0.0.1/filepath/trunk localpath

note: keep the structure in the version control system.

2. Install php, java, mysql, and php-mysql, php5-curl

For the mysql 5.6 installation. You can check on my other blog Install MYSQL 5.6 in ubuntu 12.04 and set password

If you get error as below:
Fatal error: Call to undefined function mysql_connect()
It is most possible that your php-mysql is not correctly installed. And needs to be installed:
shell>sudo apt-get install php5-mysql
If you get error as below:
PHP Notice:  Use of undefined constant CURLOPT_RETURNTRANSFER

It is because you do not install php5-curl, and you can install it like this:
shell>sudo apt-get install php5-curl
3. set the java lib path
set the $CLASSPATH for java project, there are three ways to set the value.

solution 1:
~$ export CLASSPATH=$CLASSPATH:/path/to/external/lib:/path/to/external/jar/file/example.jar
This is only available in your currently open terminal.

solution 2:
Add the CLASSPATH value in .profile. Open .profile in the user root folder and add the line below at the end of the file:
export CLASSPATH=$CLASSPATH:/path/to/external/lib:/path/to/external/jar/file/example.jar

solution 3:
Add the same line above in the shell file before running a java script if you use a shell file to call the java script.

solution 4:
It is possible that for some reasons, the above 3 methods do not work (maybe environment setting issues).  and then we use solution 4 to add the lib path on the command line, pay attention to the 2 tricky part:
java -cp .:/usr/lib/jvm/java-1.6.0-openjdk-i386/jre/lib/*:/usr/lib/jvm/java-1.6.0-openjdk-common/jre/lib/ext/*:/more/jarlib/*:/more/otherclasses YourCompleedClass
And if you use package in your java class:
~$cd package/parent/
~package/parent/$ java -cp .:/usr/lib/jvm/java-1.6.0-openjdk-i386/jre/lib/*:/usr/lib/jvm/java-1.6.0-openjdk-common/jre/lib/ext/*:/more/jarlib/*:/more/otherclasses packagepath/YourCompleedClass

4. Make your database remote accessible.
When you are in developing process, it is necessary to set your database server can be accessed remotely, then needs to configure the setting in the my.cnf file.
Comment these lines in my.cnf:
skip-networking
bind-address = 127.0.0.1

Comments

Post a Comment

Popular posts from this blog

install postgreSQL in ubuntu 16.04

When following the Install PostgreSQL in Ubuntu  in Ubuntu 16.04, got error as below: $ apt-get install postgresql-9.6 Reading package lists... Done Building dependency tree Reading state information... Done You might want to run 'apt-get -f install' to correct these: The following packages have unmet dependencies: adobereader-enu:i386 : Depends: libgtk2.0-0:i386 (>= 2.4) but it is not going to be installed postgresql-9.6 : Depends: postgresql-client-9.6 Depends: postgresql-common (>= 171~) but it is not going to be installed Recommends: postgresql-contrib-9.6 but it is not going to be installed E: Unmet dependencies. Try 'apt-get -f install' with no packages (or specify a solution). The suggested solution in the last line and a normal ubuntu upgrade do not solve the issue,  and the cmd below can fix it: $sudo apt full-upgrade After the fix, then can apt-get to install postgresql again. After install postgresql,
Keep reading

timestamp with 16, 13 and 10 digits to Qlik date

Sometimes, we need to convert the Linux timestamps to Qlik date, it can be done in the SQL script, and can also be done in the Qlik Load/expression. Linux timestamps with 16 digits are microseconds timestamps, and 13 digits are milliseconds, and 10 digits are second timestamps. To convert to a Qlik date, hour or time as following: As the timestamps starts from "19700101 00:00:00",  then this start timestamps needs be added: For 16 digits: Date(Date#('19700101', 'YYYYMMDD')+(SynchronousQuery_ Event_Time/1000000/86400) or  Date(25569+Round(SynchronousQuery_ Event_Time/1000000/86400),'YYYYMMDD') 25569 is the number format for date '19700101' For 13 digits: Date(Date#('19700101', 'YYYYMMDD')+(SynchronousQuery_ Event_Time/1000/86400) or  Date(25569+Round(SynchronousQuery_ Event_Time/1000/86400),'YYYYMMDD') For 10 digits: Date(Date#('19700101', 'YYYYMMDD')+(SynchronousQuery_ Event_T
Keep reading

install ipython in Cloudera VM using pip

I am practicing pyspark in Cloudera VM, and pyspack need be launched by ipython. In all the old Cloudera VM guide, it use easy_install to install ipython, but it does not work in Virtualbox 5.2.0 r118431 and later. And will get the error : $sudo easy_install ipython==1.2.1 ... error: Could not find suitable distribution for Requirement.parse('ipython==1.2.1') The solution for this is to use pip to install ipython. But by default, pip is not installed in cloudera VM, and pip can not be installed by eacy_install as well. And after some search, I  noticed cloudera has yum installed, and yum can install pip: $sudo yum install python-pip ... $which pip /usr/bin/pip Now ipython can be installed b pip: $sudo pip install ipython=1.2.1 ... Succesfully installled ipython-1.2.1 After that, launch spack by ipython: $PYSPARK_DRIVER_PYTHON=ipython pyspark ... Welcome to       ____                       __      / __ /__  ___ _____/  /__     _\ \/ _   \/  _  ` /  __/    '_ /
Keep reading