[OpenSER-Users] Cant connect to local MySQL server through socket

[Jan ONDREJ (SAL)]

Hello,

On Mon, Mar 17, 2008 at 11:18:50AM +0530, Megha Saini wrote:
> Hi,
> 
> I have installed OpenSER, openser-1.3.1-notls from:
> http://openser.org/pub/openser/1.3.1/src/ on Fedora Core 8.

Why you don't use Fedora packages?
You can install openser-1.3.0 from fedora updates or openser-1.3.1 from
updates-testing using yum:
  yum install --enablerepo=updates-testing openser openser-mysql

> However, when i try to create database:   /usr/local/sbin/openserdbctl
> create
> I get the error as:
> 
> database engine 'mysql' loaded
> INFO: test server charset
> ERROR 2002 (HY000): Can't connect to local MySQL server through socket
> '/var/lib/mysql/mysql.socket' (2)
> ERROR 2002 (HY000): Can't connect to local MySQL server through socket
> '/var/lib/mysql/mysql.socket' (2)
> Usage: egrep [OPTION]... PATTERN [FILE]...
> Try `egrep --help' for more information.
> /usr/local/lib/openser/openserctl/openserdbctl.mysql: line 112: [: =: unary
> operator expected
> INFO: creating database openser ...
> ERROR 2002 (HY000): Can't connect to local MySQL server through socket
> '/var/lib/mysql/mysql.socket' (2)
> ERROR: Creating core database and grant privileges failed!

Looks like your mysql root passowrd is wrong.
Please do not set openser RO and RW user to root. This script does not like
it. Please edit /etc/openser/openserctlrc file and set your options and then
try to run:
  openserdbctl create
again.

Works for me, but not for UTF8 engoding (keys are too long here).

			SAL