17 Mar
2008
17 Mar
'08
6:48 a.m.
Hi,
I have installed OpenSER, openser-1.3.1-notls from:
http://openser.org/pub/openser/1.3.1/src/ on Fedora Core 8.
I have followed the steps given in:
http://www.openser.org/dokuwiki/doku.php/install:openser-from-svn
For the make command, I used: make install include_modules="mysql"
I have completed all the steps successfully. However, I am not able to
create database as said in step 7. To check that MySQL is working on my
system, I used the command: /etc/init.d/mysqld start
It says: Starting MySQL : [OK]
To check openser is running: I used the command, /etc/init.d/openser start
I get on command line: Starting openser: [OK]
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!
I checked the file mysql.socket in /var/lib/mysql, there is only an empty
file with this name.
As seen in forums, I saw that many people have this file in /tmp/ folder.
However, I dont have this file there also!
I am unable to create the database and therefore I cannot register the
client using X-lite or SJPhone.
Kindly help me out with this. I am badly stuck with this problem since 3
days and have been looking in forums a lot. I am not getting any clue of how
to proceed further. Please help me out if anybody has any clue.
I look forward to this mailing list as my only help. I need to proceed
further as I have lot of things ot be done in this project and my deadline
is very near.
Looking forward to your co-operation.
Thanks in advance.
Megha
17 Mar
17 Mar
10:39 a.m.
New subject: [OpenSER-Users] Cant connect to local MySQL server through socket
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
11:10 a.m.
New subject: [OpenSER-Users] Cant connect to local MySQL server through socket
Hello,
Thanks for the quick reply!
I have edited my file: /etc/openser/openserctlrc and using the command
openserdbctl create, I am able to create the database.
But if I run the command : /usr/local/sbin/openserctl moni
I am getting error:
database engine 'MYSQL' loaded
Control engine 'FIFO' loaded
ERROR: Error opening OpenSER's FIFO /tmp/openser_fifo
ERROR: Make sure you have the line 'modparam("mi_fifo",
"fifo_name",
"/tmp/openser_fifo")' in your config
ERROR: and also have loaded the mi_fifo module.
I have checked openser.cfg file and checked that I have included necessary
lines in it for fifo module, i.e. I have loaded the module as well as
included the line: 'modparam("mi_fifo", "fifo_name",
"/tmp/openser_fifo")'
in openser.cfg file.
I dont know where I am doing the mistake. Please help me if you are able to
run openser successfully and also register the user client on it.
Also, I dotn know how to de-install the existing version of openser so that
I can re-install the fedora version of openser as said by you. However,
since I am able to run this version from /etc/init.d/openser start and also
able to create databases and add users, should I proceed with this only?
I get the mysql.sock error only when I try to start openser from
/usr/local/sbin/openser start. Why is it so?
When I run start openser and have created the users and I try to register
them, I get problem that: Destination unreachable. Is it due to that UDP
sockets are not in LISTEN mode initially and only TCP ports are?
Please help me with whatever knowledge you have. I am really stucked. :(
Thanks again
Megha
On Mon, Mar 17, 2008 at 3:09 PM, Jan ONDREJ (SAL) <ondrejj(a)salstar.sk>
wrote:
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
7:10 p.m.
I have completed all the steps successfully. However,
I am not able to
create database as said in step 7. To check that MySQL is working on my
system, I used the command: /etc/init.d/mysqld start
It says: Starting MySQL : [OK]
To check openser is running: I used the command, /etc/init.d/openser start
I get on command line: Starting openser: [OK]
However, when i try to create database: /usr/local/sbin/openserdbctl
create
I get the error as:
ERROR 2002 (HY000): Can't connect to local MySQL server through socket
'/var/lib/mysql/mysql.socket' (2)
Hi Megha,
do you verified that the mysql database is accessible at the system, using
the mysql client? Perhaps there is a misconfiguration on your system,
causes eg. that only access over a certain network interface is possible.
The empty socket file that is present on your system is ok.
Cheers,
Henning
6059
days inactive
6059
days old
3 comments
3 participants
participants (3)
-
henning Westerholt -
Jan ONDREJ (SAL) -
Megha Saini