[OpenSIPS-Users] Error using MySQL with opensips

[anurag]

Thanx a lot Uwe!

Actually with " mysql -u root -p -h 192.168.8.83" it was giving
access problem therefore I changed it to " mysql -u root -p -h localhost"
and it worked fine. (Don't know difference it did make to mysql?)

Thereafter, I updated " opensipsctlrc" with "localhost" and was able
to create and populate DB using "./opensipsdbctl create" command.

Now opensips is coming up without any issues.

Thanx,
Anurag

-----Original Message-----
From: Uwe Kastens [mailto:kiste at kiste.org] 
Sent: Friday, July 03, 2009 2:46 PM
To: anurag
Cc: users at lists.opensips.org
Subject: Re: [OpenSIPS-Users] Error using MySQL with opensips

Hi,

So you can connect via cli:
mysql -u root -p -h 192.168.8.83

and you can create/drop a database?
mysqladmin create opensips -p -u root -h 192.168.8.83

The error looks like a mysql access right problem

BR

Uwe


anurag schrieb:
> Thanx Uwe,
> 
> I've modified opensipsctlrc for DB details as following:
> 
> =======================
> DBENGINE=MYSQL
> 
> ## database host
> DBHOST=192.168.8.83
> 
> ## database name (for ORACLE this is TNS name)
> DBNAME=opensips
> 
> # database path used by dbtext or db_berkeley
> # DB_PATH="/usr/local/etc/opensips/dbtext"
> 
> ## database read/write user
> DBRWUSER=opensips
> 
> ## password for database read/write user
> DBRWPW="opensipsrw"
> =======================
> 
> However, now when I'm running "opensipsdbctl create" it is giving
> access denied error:
> 
> =========================
> [root at bplinux90 sbin]# ./opensipsdbctl create
> MySQL password for root:
> INFO: test server charset
> ERROR 1045 (28000): Access denied for user 'root'@'bplinux90' (using
> password: YES)
> ERROR 1045 (28000): Access denied for user 'root'@'bplinux90' (using
> password: YES)
> Usage: grep [OPTION]... PATTERN [FILE]...
> Try `grep --help' for more information.
> /root/opensips/install/lib/opensips/opensipsctl/opensipsdbctl.mysql: line
> 114: [: =: unary operator expected
> INFO: creating database opensips ...
> ERROR 1045 (28000): Access denied for user 'root'@'bplinux90' (using
> password: YES)
> ERROR: Creating core database and grant privileges failed!
> [root at bplinux90 sbin]#
> =========================
> 
> Though, I'm able to login as root user MySQL database by supplying
> configured password (mysql).
> 
> Pls tell if there is any other setting that I need to do to resolve this
> issue.
> 
> Thanx in advance,
> Anurag
> 
> -----Original Message-----
> From: Uwe Kastens [mailto:kiste at kiste.org] 
> Sent: Friday, July 03, 2009 1:39 PM
> To: Anurag Guru
> Cc: users at lists.opensips.org
> Subject: Re: [OpenSIPS-Users] Error using MySQL with opensips
> 
> Hi,
> 
> opensipsdbctl create
> 
> Therefore you will need configure the   opensipsctlrc file.
> 
> BR
> 
> Uwe
> 
> Anurag Guru schrieb:
>> Thanx BR.
>>
>> Could you pls tell me from where I can find info on usage for
>> opensipsdbctl? or some related documentation.
>>
>> Thanx,
>> Anurag
>>
>> Hi,
>>
>> Maybe you have forgotten to create the tables for opensips?
>>  opensipsdbctl create <db name or db_path, optional> .....(creates a new
>> database)
>>
>> opensips is missing the version table
>> BR
>>
> 
> 


-- 

kiste lat: 54.322684, lon: 10.13586