Menggunakan opensipsdbctl: Difference between revisions

From OnnoCenterWiki
Jump to navigationJump to search
Onnowpurbo (talk | contribs)
New page: Setup database # vi /usr/local/etc/opensips/opensipsctlrc atau # vi /etc/opensips/opensipsctlrc Pastikan DBENGINE=MYSQL DBHOST=localhost DBNAME=opensips DBRWUSER=opensips
 
Onnowpurbo (talk | contribs)
No edit summary
Line 13: Line 13:
  DBNAME=opensips
  DBNAME=opensips
  DBRWUSER=opensips
  DBRWUSER=opensips
Pastikan MySQL beroperasi
$ sudo su -
# /etc/init.d/mysql restart
Buat MySQL database
# mysql -u root -p
Enter password:
mysql> create database opensips;
mysql> grant INSERT,SELECT on root.* to opensips@localhost;
mysql> grant CREATE, INSERT, SELECT, DELETE, UPDATE on opensips.* to opensips@localhost identified by 'opensipspass';
mysql> grant CREATE, INSERT, SELECT, DELETE, UPDATE on opensips.* to opensips identified by 'opensipspass';
mysql> exit

Revision as of 10:05, 27 March 2009

Setup database

# vi /usr/local/etc/opensips/opensipsctlrc 

atau

# vi /etc/opensips/opensipsctlrc 

Pastikan

DBENGINE=MYSQL
DBHOST=localhost
DBNAME=opensips
DBRWUSER=opensips

Pastikan MySQL beroperasi

$ sudo su -
# /etc/init.d/mysql restart

Buat MySQL database

# mysql -u root -p
Enter password:
mysql> create database opensips;
mysql> grant INSERT,SELECT on root.* to opensips@localhost;
mysql> grant CREATE, INSERT, SELECT, DELETE, UPDATE on opensips.* to opensips@localhost identified by 'opensipspass';
mysql> grant CREATE, INSERT, SELECT, DELETE, UPDATE on opensips.* to opensips identified by 'opensipspass';
mysql> exit