Difference between revisions of "Instalasi WebERP"

From OnnoWiki
Jump to navigation Jump to search
(New page: # cp webERP_3.071.zip /var/www mysql mysql> SET PASSWORD FOR root@localhost=PASSWORD('password'); Alternatively # mysql -u root -p Enter password: mysql> grant INSERT,SELECT on ro...)
 
Line 1: Line 1:
# cp webERP_3.071.zip /var/www
+
Siapkan aplikasi pendukung seperti
  
  mysql
+
  # apt-get install libsyncml0 libsyncml-dev libsyncml-utils \
  mysql> SET PASSWORD FOR root@localhost=PASSWORD('password');
+
opensync-plugin-syncml php-pear php5-gd php5-imap php5-odbc \
 +
php5-pgsql apache2 mysql-server libmysqlclient15-dev libphp-adodb \
 +
  libgd2-xpm libgd2-xpm-dev php5-mysql php5-gd php5-curl php-pear \
 +
php5-xmlrpc libnet-ssleay-perl
  
Alternatively
+
Ambil [[source code]] WebERP dari
 +
 
 +
http://sourceforge.net/projects/web-erp/
 +
 
 +
Copykan [[source code]]
 +
 
 +
cp webERP_3.11.zip /var/www
 +
cd /var/www
 +
unzip webERP_3.11.zip
 +
 
 +
 
 +
Konfigurasi [[database]]
  
 
  # mysql -u root -p
 
  # mysql -u root -p
 
  Enter password:
 
  Enter password:
  mysql> grant INSERT,SELECT on root.* to weberp@localhost;
+
  create database weberp;
  mysql> SET PASSWORD FOR weberp@localhost=PASSWORD('weberp');
+
grant INSERT,SELECT on root.* to weberp@localhost;
  mysql> GRANT ALL PRIVILEGES ON *.* TO weberp@localhost IDENTIFIED BY 'some-password' WITH GRANT OPTION;
+
  SET PASSWORD FOR weberp@localhost=PASSWORD('weberp');
  mysql> exit
+
  GRANT ALL PRIVILEGES ON *.* TO weberp@localhost IDENTIFIED BY 'some-password' WITH GRANT OPTION;
 +
  exit
  
 +
atau bagi yang masih pemula
  
  # vi /var/www/webERP/config.php
+
  # mysql -u root -p
 +
Enter password:
 +
create database weberp;
 +
grant INSERT,SELECT on root.* to weberp@localhost;
 +
SET PASSWORD FOR weberp@localhost=PASSWORD('weberp');
 +
GRANT ALL PRIVILEGES ON *.* TO weberp@localhost IDENTIFIED BY 'weberp' WITH GRANT OPTION;
 +
exit
 +
 
 +
 
 +
 
 +
Edit file konfigurasi WebERP & pastikan dbuser & dbpassword sbb:
 +
 
 +
cd /var/www/webERP
 +
cp /var/www/webERP/config.distrib.php /var/www/webERP/config.php
 +
vi /var/www/webERP/config.php
 
     $dbuser = 'weberp';
 
     $dbuser = 'weberp';
 
     $dbpassword = 'weberp';
 
     $dbpassword = 'weberp';
 +
    $DefaultCompany = 'weberpdemo';
 +
 +
  
 +
Masukan data mentah
  
  # mysql --user=weberp --password='weberp' > /var/www/webERP/sql/mysql/weberp-demo.sql
+
  # mysql --user=weberp --password='weberp' < /var/www/webERP/sql/mysql/weberp-demo.sql

Revision as of 08:07, 10 November 2009

Siapkan aplikasi pendukung seperti

# apt-get install libsyncml0 libsyncml-dev libsyncml-utils \
opensync-plugin-syncml php-pear php5-gd php5-imap php5-odbc \
php5-pgsql apache2 mysql-server libmysqlclient15-dev libphp-adodb \
libgd2-xpm libgd2-xpm-dev php5-mysql php5-gd php5-curl php-pear \
php5-xmlrpc libnet-ssleay-perl

Ambil source code WebERP dari

http://sourceforge.net/projects/web-erp/

Copykan source code

cp webERP_3.11.zip /var/www
cd /var/www
unzip webERP_3.11.zip


Konfigurasi database

# mysql -u root -p
Enter password:
create database weberp;
grant INSERT,SELECT on root.* to weberp@localhost;
SET PASSWORD FOR weberp@localhost=PASSWORD('weberp');
GRANT ALL PRIVILEGES ON *.* TO weberp@localhost IDENTIFIED BY 'some-password' WITH GRANT OPTION;
exit

atau bagi yang masih pemula

# mysql -u root -p
Enter password:
create database weberp;
grant INSERT,SELECT on root.* to weberp@localhost;
SET PASSWORD FOR weberp@localhost=PASSWORD('weberp');
GRANT ALL PRIVILEGES ON *.* TO weberp@localhost IDENTIFIED BY 'weberp' WITH GRANT OPTION;
exit


Edit file konfigurasi WebERP & pastikan dbuser & dbpassword sbb:

cd /var/www/webERP
cp /var/www/webERP/config.distrib.php /var/www/webERP/config.php 
vi /var/www/webERP/config.php
   $dbuser = 'weberp';
   $dbpassword = 'weberp';
   $DefaultCompany = 'weberpdemo';


Masukan data mentah

# mysql --user=weberp --password='weberp' < /var/www/webERP/sql/mysql/weberp-demo.sql