Difference between revisions of "SMEOnffLine: Instalasi WebERP"

From OnnoWiki
Jump to navigation Jump to search
 
(9 intermediate revisions by the same user not shown)
Line 1: Line 1:
 
Siapkan aplikasi pendukung seperti
 
Siapkan aplikasi pendukung seperti
−
 
+
−
  # apt-get install libsyncml0 libsyncml-dev libsyncml-utils \
+
sudo su
 +
  apt-get install libsyncml0 libsyncml-dev libsyncml-utils \
 
  opensync-plugin-syncml php-pear php5-gd php5-imap php5-odbc \
 
  opensync-plugin-syncml php-pear php5-gd php5-imap php5-odbc \
 
  php5-pgsql apache2 mysql-server libmysqlclient15-dev libphp-adodb \
 
  php5-pgsql apache2 mysql-server libmysqlclient15-dev libphp-adodb \
 
  libgd2-xpm libgd2-xpm-dev php5-mysql php5-gd php5-curl php-pear \
 
  libgd2-xpm libgd2-xpm-dev php5-mysql php5-gd php5-curl php-pear \
 
  php5-xmlrpc libnet-ssleay-perl
 
  php5-xmlrpc libnet-ssleay-perl
 +
 +
Ambil [[source code]] WebERP dari
 +
 +
http://sourceforge.net/projects/web-erp/
  
 
Copykan [[source code]]
 
Copykan [[source code]]
  
−
cd /usr/local/src
+
  cp webERP_4.05.zip /var/www
−
  cp webERP_3.11.1.zip /var/www
 
 
  cd /var/www
 
  cd /var/www
−
  unzip webERP_3.11.1.zip
+
  unzip webERP_4.05.zip
  
  
Line 20: Line 24:
 
  Enter password:
 
  Enter password:
 
  drop database weberpdemo;
 
  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;
 
  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';
 +
Ambil [[source code]] WebERP dari
 +
 +
http://sourceforge.net/projects/web-erp/
 +
 +
Copykan [[source code]]
 +
 +
cp webERP_4.05.zip /var/www
 +
cd /var/www
 +
unzip webERP_4.05.zip
 +
 +
 +
Konfigurasi [[database]]
 +
 +
# mysql -u root -p
 +
Ambil [[source code]] WebERP dari
 +
 +
http://sourceforge.net/projects/web-erp/
 +
 +
Copykan [[source code]]
 +
 +
cp webERP_4.05.zip /var/www
 +
cd /var/www
 +
unzip webERP_4.05.zip
 +
 +
 +
Konfigurasi [[database]]
 +
 +
# mysql -u root -p
 +
Enter password:
 +
drop database weberpdemo;
 
  grant INSERT,SELECT on root.* to weberp@localhost;
 
  grant INSERT,SELECT on root.* to weberp@localhost;
 
  SET PASSWORD FOR weberp@localhost=PASSWORD('weberp');
 
  SET PASSWORD FOR weberp@localhost=PASSWORD('weberp');
−
  GRANT ALL PRIVILEGES ON *.* TO weberp@localhost IDENTIFIED BY 'weberp' WITH GRANT OPTION;
+
  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
 
  exit
  
Line 37: Line 100:
 
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
 +
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';
  
−
==Beberapa Bug==
+
Masukan data mentah
  
−
Edit file
+
mysql -u weberp -pweberp weberpdemo < /var/www/webERP/sql/mysql/weberp-demo.sql
 +
    $DefaultCompany = 'weberpdemo';
  
−
vi /var/www/webERP/sql/mysql/weberp-demo.sql
+
Masukan data mentah
  
−
Remark
+
mysql -u weberp -pweberp weberpdemo < /var/www/webERP/sql/mysql/weberp-demo.sql
  
−
line 6326
 
−
/* INSERT INTO `factorcompanies` VALUES (5,'None','','','','','','','','','',''); */
 
  
−
line 6327
 
−
/* INSERT INTO `factorcompanies` VALUES (6,'None','','','','','','','','','',''); */
 
  
 
==Akses ke WebERP==
 
==Akses ke WebERP==
  
−
  http://localhost/webERP
+
  http://192.168.0.254/webERP
  
 
  username admin
 
  username admin
Line 61: Line 145:
  
 
[[Image:Weberp1.jpeg|center|200px|thumb]]
 
[[Image:Weberp1.jpeg|center|200px|thumb]]
−
 
  
 
==Pranala Menarik==
 
==Pranala Menarik==

Latest revision as of 10:20, 28 September 2011

Siapkan aplikasi pendukung seperti 

sudo su
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.05.zip /var/www
cd /var/www
unzip webERP_4.05.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';

Ambil source code WebERP dari 

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

Copykan source code 

cp webERP_4.05.zip /var/www
cd /var/www
unzip webERP_4.05.zip


Konfigurasi database 

# mysql -u root -p

Ambil source code WebERP dari 

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

Copykan source code 

cp webERP_4.05.zip /var/www
cd /var/www
unzip webERP_4.05.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
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
   $DefaultCompany = 'weberpdemo';

Masukan data mentah 

mysql -u weberp -pweberp weberpdemo < /var/www/webERP/sql/mysql/weberp-demo.sql


Akses ke WebERP

http://192.168.0.254/webERP

username admin
password weberp
Weberp1.jpeg

Pranala Menarik

Retrieved from "https://onnocenter.or.id/wiki/index.php?title=SMEOnffLine:_Instalasi_WebERP&oldid=28160"