[OpenSIPS-Devel] [ opensips-Bugs-3189294 ] opensips-cp unknown database

[SourceForge.net]

Bugs item #3189294, was opened at 2011-02-22 18:26
Message generated for change (Comment added) made by untiptun
You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=1086410&aid=3189294&group_id=232389

Please note that this message will contain a full copy of the comment thread,
including the initial issue submission, for this request,
not just the latest update.
Category: None
Group: None
Status: Open
Resolution: None
Priority: 5
Private: No
Submitted By: Naser  Saeed (adroit9)
Assigned to: Alex Ionescu (untiptun)
Summary: opensips-cp unknown database

Initial Comment:
I am new in opensips and just configured opensips-cp 4.0 over ubuntu10. I have gone through all the necessary step in the documentation to configure opensips-cp, but when i try to access mysql to create admin account in /var/www/opensips-cp/config/tools/admin/add_admin by the command 

mysql -Dopensips -p < ocp_admin_privileges.mysql

it gives an error unknown database 'opensips'.

If i create a database with the name of opensips that database has no tables.... so anyone please help me in this problem i am stucked here for a week and almost read out all the tutorial for all the versions and even i reinstall my ubuntu to completely clean the system.

Thanks..

----------------------------------------------------------------------

>Comment By: Alex Ionescu (untiptun)
Date: 2011-06-26 11:41

Message:
Hi,

I you create a database called 'opensips' and run 'mysql -Dopensips -p <
ocp_admin_privileges.mysql' then you should see a table created in the
opensips database.
Try to copy the create table syntax from ocp_admin_privileges.sql and run
in the mysql cli. You should receive an error or something

Regards,
Alex

----------------------------------------------------------------------

You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=1086410&aid=3189294&group_id=232389