Difference between revisions of "Instalasi WebERP"

From OnnoWiki
Jump to navigation Jump to search
Line 31: Line 31:
  
 
  mysql -u root -p123456
 
  mysql -u root -p123456
drop database weberpdemo;
 
 
  create database weberpdemo;
 
  create database weberpdemo;
  grant INSERT,SELECT on root.* to weberp@localhost;
+
  grant ALL on root.* to weberp@localhost;
  SET PASSWORD FOR weberp@localhost=PASSWORD('weberp');
+
  grant ALL on weberpdemo.* to weberp@localhost identified by 'weberp';
  GRANT ALL PRIVILEGES ON *.* TO weberp@localhost IDENTIFIED BY 'weberp' WITH GRANT OPTION;
+
  grant ALL on weberpdemo.* to weberp identified by 'weberp';
 
  exit
 
  exit
  
Line 49: Line 48:
 
Masukan data mentah
 
Masukan data mentah
  
  # mysql --user=weberp --password='weberp' < /var/www/webERP/sql/mysql/weberp-demo.sql
+
  mysql -u weberp -pweberp weberpdemo < /var/www/webERP/sql/mysql/weberp-demo.sql
  
 
+
Akses ke Web
==Beberapa Bug==
 
 
 
Edit file
 
 
 
vi /var/www/webERP/sql/mysql/weberp-demo.sql
 
 
 
Remark
 
 
 
line 6326
 
/* INSERT INTO `factorcompanies` VALUES (5,'None','','','','','','','','','',''); */
 
 
 
line 6327
 
/* INSERT INTO `factorcompanies` VALUES (6,'None','','','','','','','','','',''); */
 
 
 
==Akses ke WebERP==
 
  
 
  http://localhost/webERP
 
  http://localhost/webERP

Revision as of 06:41, 17 September 2011

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_4.0.2.zip /var/www
cd /var/www
unzip webERP_4.0.2.zip


Konfigurasi database

# mysql -u root -p
Enter password:
drop database weberpdemo;
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 -p123456
create database weberpdemo;
grant ALL on root.* to weberp@localhost;
grant ALL on weberpdemo.* to weberp@localhost identified by 'weberp';
grant ALL on weberpdemo.* to weberp identified by 'weberp';
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 -u weberp -pweberp weberpdemo < /var/www/webERP/sql/mysql/weberp-demo.sql

Akses ke Web

http://localhost/webERP
username admin
password weberp
Weberp1.jpeg


Pranala Menarik