[Kamailio-Users] /usr/local/sbin/kamdbctl create error

[Daniel-Constantin Mierla]

please cc the mailing list, otherwise your emails will be ignored.

do you have the mysql client installed? Can you connect to the mysql 
server from terminal with 'mysql' command?

Cheers,
Daniel

On 25.11.2009 19:42 Uhr, YÜKSEL wrote:
> Dear Daniel,
>
> Thanks for your response :  Actually I am getting an error below when 
> I try to create DB with  `/usr/local/sbin/kamdbctl create`
>
> debian:/usr/local/src/kamailio-1.5.0/sip-server#  
> /usr/local/sbin/kamdbctl create
> MySQL password for root:
> INFO: test server charset
> /usr/local/lib/kamailio/kamctl/kamdbctl.mysql: line 105: mysql: 
> command not found
> /usr/local/lib/kamailio/kamctl/kamdbctl.mysql: line 106: mysql: 
> command not found
> Usage: grep [OPTION]... PATTERN [FILE]...
> Try `grep --help' for more information.
> /usr/local/lib/kamailio/kamctl/kamdbctl.mysql: line 112: [: =: unary 
> operator expected
> INFO: creating database openser ...
> /usr/local/lib/kamailio/kamctl/kamdbctl.mysql: line 71: mysql: command 
> not found
> ERROR: Creating core database and grant privileges failed!
>
> I`ve applied the instructor one by one but I didn`t understand whay I 
> am getting this error.
>
> Regards,
>
> Yuksel
>
>
> --- On *Wed, 11/25/09, Daniel-Constantin Mierla /<miconda at gmail.com>/* 
> wrote:
>
>
>     From: Daniel-Constantin Mierla <miconda at gmail.com>
>     Subject: Re: [Kamailio-Users] /usr/local/sbin/kamdbctl create error
>     To: "lazturk" <lazturk at yahoo.com>
>     Cc: users at lists.kamailio.org
>     Date: Wednesday, November 25, 2009, 12:33 PM
>
>     Hello,
>
>
>     On 25.11.2009 17:59 Uhr, lazturk wrote:
>     > Hello,
>     >
>     > How did you solve this problem bcz I am getting a similar error ;
>     >   
>
>     which one? the one related to no database engine specified or the
>     one related to mysql socket file?
>
>     First: updated the kamctlrc file -- see the comments inside.
>
>     Second: check if mysql server is running and if yes, check the
>     mysql config to see where the server is listening and where the
>     mysql client tries to connect to. They must be the same.
>
>     Cheers,
>     Daniel
>
>     >
>     > Thanks for your feedback.
>     >
>     > 
>     > vivi-8 wrote:
>     >   
>     >> Hi all
>     >> I have specify the wanted db type (DBENGINE=MYSQL) in the
>     >> /usr/local/etc/kamailio/kamctlrc
>     >> then I using "/usr/local/sbin/kamdbctl create"  to create MySQL
>     database,
>     >> but I got this error:
>     >>
>     >> 
>     >> 
>     >> ERROR: database engine not specified, please setup one in the
>     config
>     >> script
>     >>
>     >> root at acer:/usr/local/src/kamailio-1.5.0/sip-server# vim
>     >> /usr/local/etc/kamailio/kamctlrc
>     >>
>     >> root at acer:/usr/local/src/kamailio-1.5.0/sip-server#
>     >> /usr/local/sbin/kamdbctl
>     >> create
>     >>
>     >> MySQL password for root:
>     >>
>     >> INFO: test server charset
>     >>
>     >> ERROR 2002 (HY000): Can't connect to local MySQL server through
>     socket
>     >> '/var/run/mysqld/mysqld.sock' (2)
>     >>
>     >> ERROR 2002 (HY000): Can't connect to local MySQL server through
>     socket
>     >> '/var/run/mysqld/mysqld.sock' (2)
>     >>
>     >> Usage: grep [OPTION]... PATTERN [FILE]...
>     >>
>     >> Try `grep --help' for more information.
>     >>
>     >> /usr/local/lib/kamailio/kamctl/kamdbctl.mysql: line 112: [: =:
>     unary
>     >> operator expected
>     >>
>     >> INFO: creating database openser ...
>     >>
>     >> ERROR 2002 (HY000): Can't connect to local MySQL server through
>     socket
>     >> '/var/run/mysqld/mysqld.sock' (2)
>     >>
>     >> ERROR: Creating core database and grant privileges failed!
>     >>
>     >> 
>     >> 
>     >> Cheers,
>     >>
>     >> vivi
>     >>
>     >>
>     >> _______________________________________________
>     >> Kamailio (OpenSER) - Users mailing list
>     >> Users at lists.kamailio.org </mc/compose?to=Users at lists.kamailio.org>
>     >> http://lists.kamailio.org/cgi-bin/mailman/listinfo/users
>     >> http://lists.openser-project.org/cgi-bin/mailman/listinfo/users
>     >>
>     >>     
>     >
>     >   
>
>     -- Daniel-Constantin Mierla
>     * http://www.asipto.com/
>
>

-- 
Daniel-Constantin Mierla
* http://www.asipto.com/