auth_db unable to connect to mysql

classic Classic list List threaded Threaded
4 messages Options
Reply | Threaded
Open this post in threaded view
|

auth_db unable to connect to mysql

k1028
I discovered that my openser givign me a ERROR:mysql:db_mysql_submit_query: driver error: there is no ''@'192.168.x.x' registered. This happen with multiple servers with the same error message and source IP. Some reason the db_mysql sending no user name and wrong source IP ''@'192.168.x.x' to authenticate with mysql server.

Jun 10 20:53:22 STGPROXY01 /usr/local/sbin/openser[10335]: ERROR:mysql:db_mysql_submit_query: driver error: There is no ''@'192.168.x.x' registered
Jun 10 20:53:22 STGPROXY01 /usr/local/sbin/openser[10335]: ERROR:mysql:db_mysql_query: error while submitting query
Jun 10 20:53:22 STGPROXY01 /usr/local/sbin/openser[10335]: ERROR:auth_db:get_ha1: failed to query database

version: openser 1.3.2-notls (x86_64/linux)

loadmodule "auth_db.so"
modparam("auth_db", "db_url", "mysql://xxx@192.168.x.x/xxxx")

Reply | Threaded
Open this post in threaded view
|

Re: auth_db unable to connect to mysql

Saúl Ibarra Corretgé-2
Did you specify the MySQL password? Maybe the option is not parsed correctly...


On Wed, Jun 10, 2009 at 11:03 PM, k1028<[hidden email]> wrote:

>
> I discovered that my openser givign me a ERROR:mysql:db_mysql_submit_query:
> driver error: there is no ''@'192.168.x.x' registered. This happen with
> multiple servers with the same error message and source IP. Some reason the
> db_mysql sending no user name and wrong source IP ''@'192.168.x.x' to
> authenticate with mysql server.
>
> Jun 10 20:53:22 STGPROXY01 /usr/local/sbin/openser[10335]:
> ERROR:mysql:db_mysql_submit_query: driver error: There is no
> ''@'192.168.x.x' registered
> Jun 10 20:53:22 STGPROXY01 /usr/local/sbin/openser[10335]:
> ERROR:mysql:db_mysql_query: error while submitting query
> Jun 10 20:53:22 STGPROXY01 /usr/local/sbin/openser[10335]:
> ERROR:auth_db:get_ha1: failed to query database
>
> version: openser 1.3.2-notls (x86_64/linux)
>
> loadmodule "auth_db.so"
> modparam("auth_db", "db_url", "mysql://[hidden email]/xxxx")
>
>
> --
> View this message in context: http://n2.nabble.com/auth_db-unable-to-connect-to-mysql-tp3058344p3058344.html
> Sent from the OpenSIPS - Users mailing list archive at Nabble.com.
>
>
> _______________________________________________
> Users mailing list
> [hidden email]
> http://lists.opensips.org/cgi-bin/mailman/listinfo/users
>



--
Saúl -- "Nunca subestimes el ancho de banda de un camión lleno de disketes."
----------------------------------------------------------------
http://www.saghul.net/

_______________________________________________
Users mailing list
[hidden email]
http://lists.opensips.org/cgi-bin/mailman/listinfo/users
Reply | Threaded
Open this post in threaded view
|

Re: auth_db unable to connect to mysql

k1028
I did. all other module work that require mysql but auth_db. I triple checked the db_url for auth_db..

Saúl Ibarra wrote
Did you specify the MySQL password? Maybe the option is not parsed correctly...


On Wed, Jun 10, 2009 at 11:03 PM, k1028<mrprotocols@gmail.com> wrote:
>
> I discovered that my openser givign me a ERROR:mysql:db_mysql_submit_query:
> driver error: there is no ''@'192.168.x.x' registered. This happen with
> multiple servers with the same error message and source IP. Some reason the
> db_mysql sending no user name and wrong source IP ''@'192.168.x.x' to
> authenticate with mysql server.
>
> Jun 10 20:53:22 STGPROXY01 /usr/local/sbin/openser[10335]:
> ERROR:mysql:db_mysql_submit_query: driver error: There is no
> ''@'192.168.x.x' registered
> Jun 10 20:53:22 STGPROXY01 /usr/local/sbin/openser[10335]:
> ERROR:mysql:db_mysql_query: error while submitting query
> Jun 10 20:53:22 STGPROXY01 /usr/local/sbin/openser[10335]:
> ERROR:auth_db:get_ha1: failed to query database
>
> version: openser 1.3.2-notls (x86_64/linux)
>
> loadmodule "auth_db.so"
> modparam("auth_db", "db_url", "mysql://xxx@192.168.x.x/xxxx")
>
>
> --
> View this message in context: http://n2.nabble.com/auth_db-unable-to-connect-to-mysql-tp3058344p3058344.html
> Sent from the OpenSIPS - Users mailing list archive at Nabble.com.
>
>
> _______________________________________________
> Users mailing list
> Users@lists.opensips.org
> http://lists.opensips.org/cgi-bin/mailman/listinfo/users
>



--
Saúl -- "Nunca subestimes el ancho de banda de un camión lleno de disketes."
----------------------------------------------------------------
http://www.saghul.net/

_______________________________________________
Users mailing list
Users@lists.opensips.org
http://lists.opensips.org/cgi-bin/mailman/listinfo/users
Reply | Threaded
Open this post in threaded view
|

Re: auth_db unable to connect to mysql

Bogdan-Andrei Iancu
Hi,

But OpenSIPS starts, right ? I just checking if the initial connection
to DB server (at stratup time) is successful or not.

Anyhow, you should upgrade the OpenSIPS 1.5 as 1.3 is old and
unsupported (no more fixes on that branch).

Regards,
Bogdan

k1028 wrote:

> I did. all other module work that require mysql but auth_db. I triple checked
> the db_url for auth_db..
>
>
> Saúl Ibarra wrote:
>  
>> Did you specify the MySQL password? Maybe the option is not parsed
>> correctly...
>>
>>
>> On Wed, Jun 10, 2009 at 11:03 PM, k1028<[hidden email]> wrote:
>>    
>>> I discovered that my openser givign me a
>>> ERROR:mysql:db_mysql_submit_query:
>>> driver error: there is no ''@'192.168.x.x' registered. This happen with
>>> multiple servers with the same error message and source IP. Some reason
>>> the
>>> db_mysql sending no user name and wrong source IP ''@'192.168.x.x' to
>>> authenticate with mysql server.
>>>
>>> Jun 10 20:53:22 STGPROXY01 /usr/local/sbin/openser[10335]:
>>> ERROR:mysql:db_mysql_submit_query: driver error: There is no
>>> ''@'192.168.x.x' registered
>>> Jun 10 20:53:22 STGPROXY01 /usr/local/sbin/openser[10335]:
>>> ERROR:mysql:db_mysql_query: error while submitting query
>>> Jun 10 20:53:22 STGPROXY01 /usr/local/sbin/openser[10335]:
>>> ERROR:auth_db:get_ha1: failed to query database
>>>
>>> version: openser 1.3.2-notls (x86_64/linux)
>>>
>>> loadmodule "auth_db.so"
>>> modparam("auth_db", "db_url", "mysql://[hidden email]/xxxx")
>>>
>>>
>>> --
>>> View this message in context:
>>> http://n2.nabble.com/auth_db-unable-to-connect-to-mysql-tp3058344p3058344.html
>>> Sent from the OpenSIPS - Users mailing list archive at Nabble.com.
>>>
>>>
>>> _______________________________________________
>>> Users mailing list
>>> [hidden email]
>>> http://lists.opensips.org/cgi-bin/mailman/listinfo/users
>>>
>>>      
>>
>> --
>> Saúl -- "Nunca subestimes el ancho de banda de un camión lleno de
>> disketes."
>> ----------------------------------------------------------------
>> http://www.saghul.net/
>>
>> _______________________________________________
>> Users mailing list
>> [hidden email]
>> http://lists.opensips.org/cgi-bin/mailman/listinfo/users
>>
>>
>>    
>
>  


_______________________________________________
Users mailing list
[hidden email]
http://lists.opensips.org/cgi-bin/mailman/listinfo/users