Difference between revisions of "Menggunakan opensipsdbctl"
Jump to navigation
Jump 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) |
||
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 17: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