SMEOnffLine: Instalasi WebERP: Difference between revisions

From OnnoCenterWiki
Jump to navigationJump to search
← Older edit
Onnowpurbo (talk | contribs)
69,477 edits
Onnowpurbo (talk | contribs)
69,477 edits
No edit summary
Onnowpurbo (talk | contribs)
69,477 edits
No edit summary
 
Line 1: Line 1:
Siapkan aplikasi pendukung seperti
Siapkan aplikasi pendukung seperti
 
  apt-get install libsyncml-dev libsyncml-utils \
sudo su
  php-pear php5-gd php5-imap php5-odbc \
  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 \
  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
mv webERP_3.11.3.zip /var/www
  cd /var/www
  cd /var/www
  unzip webERP_3.11.3.zip
  unzip webERP_4.05.zip
mv /var/www/webERP-temp /var/www/webERP
 


Konfigurasi [[database]]
Konfigurasi [[database]]


  # mysql -u root -p123456
  # mysql -u root -p
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
 
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;
  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
  exit


Line 31: Line 122:
  cp /var/www/webERP/config.distrib.php /var/www/webERP/config.php  
  cp /var/www/webERP/config.distrib.php /var/www/webERP/config.php  
  vi /var/www/webERP/config.php
  vi /var/www/webERP/config.php
    $dbuser = 'weberp';
    $dbpassword = 'weberp';
    $DefaultCompany = 'weberpdemo';
Masukan data mentah


  $dbuser = 'weberp';
  mysql -u weberp -pweberp weberpdemo < /var/www/webERP/sql/mysql/weberp-demo.sql
$dbpassword = 'weberp';
    $DefaultCompany = 'weberpdemo';
$DefaultCompany = 'weberpdemo';


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




Latest revision as of 03: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

Pranala Menarik

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