2013-01-01 00:00
873661 43224 2
Blog Home / SIDU
You need to check official websites as howto. Here is a quick guide for ubuntu users as howto install Apache2+PHP5, MySQL, PostgreSQL, SQLite, CUBRID, MSSQL
A. Install apache2+php5: windows xampp; ubuntu:
sudo apt-get install apache2 php5 libapache2-mod-php5 php5-gd
B1. Install MySQL database and php driver: [optional]
sudo apt-get install mysql-server mysql-client php5-mysql
B2. Install PostgreSQL database and php driver: [optional]
sudo apt-get install postgresql php5-pgsql
Setup password for user postgres via terminal
sudo -u postgres psql ## login via cmd
\password postgres ## input new password twice
\q ## exit psql
B3. Install php driver for SQLite: [optional]
sudo apt-get install php5-sqlite
B4. Install CUBRID database and php driver: [optional]
sudo add-apt-repository ppa:cubrid/cubrid
sudo apt-get update
sudo apt-get install cubrid php5-cubrid cubrid-demodb
You need to start db each time on use:
cubrid server start demodb
B5. Install Microsoft SQL Server (MSSQL): [optional]
sudo apt-get install freetds-common freetds-bin unixodbc php5-sybase
C. Restart apache server: ubuntu
sudo service apache2 restart
Back « SIDU Support and Help Desk
Next » Optional sidu_fk table
Leave a comment
How to install databases
You need to check official websites as howto. Here is a quick guide for ubuntu users as howto install Apache2+PHP5, MySQL, PostgreSQL, SQLite, CUBRID, MSSQL
A. Install apache2+php5: windows xampp; ubuntu:
sudo apt-get install apache2 php5 libapache2-mod-php5 php5-gd
B1. Install MySQL database and php driver: [optional]
sudo apt-get install mysql-server mysql-client php5-mysql
B2. Install PostgreSQL database and php driver: [optional]
sudo apt-get install postgresql php5-pgsql
Setup password for user postgres via terminal
sudo -u postgres psql ## login via cmd
\password postgres ## input new password twice
\q ## exit psql
B3. Install php driver for SQLite: [optional]
sudo apt-get install php5-sqlite
B4. Install CUBRID database and php driver: [optional]
sudo add-apt-repository ppa:cubrid/cubrid
sudo apt-get update
sudo apt-get install cubrid php5-cubrid cubrid-demodb
You need to start db each time on use:
cubrid server start demodb
B5. Install Microsoft SQL Server (MSSQL): [optional]
sudo apt-get install freetds-common freetds-bin unixodbc php5-sybase
C. Restart apache server: ubuntu
sudo service apache2 restart
Back « SIDU Support and Help Desk
Next » Optional sidu_fk table
Leave a comment
Comments
- 1
- 2
- 3
- »
Category
Top Read
» How to install databases» Godaddy Magic Quotes Problem
» Optional sidu_fk table
» Wiki: Topnew DB helper
» SIDU import/export data clean
» SIDU SQL in charts: howto
» Localhost SIDU ssh connect remote site localhost
» SIDU hotkey list
» SIDU feature request and bug
» SQL row sum