[SR-Users] Creating a database error

[Timo Reimann]

On 12.10.2011 20:26, Peter Schrock wrote:
> Yes, I was just verifying the mysql installation before I installed
> kamailio. Although, I do have to type the full path name to open the
> client. Do you think this is the problem? I will try by setting this up.

This means that the mysql binary is not in a directory found in $PATH.
So one way to fix this is to extend $PATH to cover the location where
mysql is installed.

If you installed mysql from your distribution's package manager,
however, this should already be the case. You possibly didn't compile
and install (or not install) mysql yourself, did you?


Cheers,

--Timo



> On Oct 12, 2011, at 1:52 AM, davy van de moere
> <davy.van.de.moere at gmail.com <mailto:davy.van.de.moere at gmail.com>> wrote:
> 
>> Are you sure you have mysql-client installed ?
>>
>> (check with just typing mysql in your shell)
>>
>>
>> 2011/10/12 Peter Schrock
>> <<mailto:peter.schrock at gmail.com>peter.schrock at gmail.com
>> <mailto:peter.schrock at gmail.com>>
>>
>>     This is what I am getting:
>>     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 looked at the files and cannot find the problem. Please help.
>>
>>     Peter