[SerUsers]: Mysql DB at different machine

[Kamal.Mann at t-systems.com]

Hi
Yes it is taking localhost for DB connection. I know one of them is for
serctl serro user. Please find ser.cfg enclosed if it helps.

Regards
Kamal Mann
-----Original Message-----
From: serusers-bounces at lists.iptel.org
[mailto:serusers-bounces at lists.iptel.org] On Behalf Of samuel
Sent: Friday, November 10, 2006 3:28 PM
To: Mann, Kamal
Cc: serusers at lists.iptel.org
Subject: Re: [SerUsers]: Mysql DB at different machine

Probably there's a module which requires DB backend missing in your
modparam("auth_db|permissions|uri_db|usrloc","db_url",
"mysql://ser:heslo@10.25.117.86/ser")
and it takes the default value: localhost.

When does the mysql error appears in the log? Which module is being
loaded??

Which is your list of modules in ser.cfg and which are your db_url
statements in the config file?
Samuel.

2006/11/10, Kamal.Mann at t-systems.com <Kamal.Mann at t-systems.com>:
>
>
>
>
> Hi All
>
> I am trying to implement ser database (mysql part) on different
machine. Ser
> is installed on machine say 'A' and Mysql DB is on 'B'. In ser.cfg I
changed
> url to connect to database everywhere in ser.cfg file with machine B's
ip
> (eg. modparam("auth_db|permissions|uri_db|usrloc","db_url",
> "mysql://ser:heslo@10.25.117.86/ser") n in rest too). But I am getting
the
> following error when I checked ser logs:
>
>
>
> Nov 10 14:12:40 vm01 /usr/sbin/ser[12979]: get_connection():
Connection not
> found in the pool
>
> Nov 10 14:12:40 vm01 /usr/sbin/ser[12979]: new_connection(): Can't
connect
> to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
>
>
>
>
>
> Why it tries for local Mysql sock??
>
>
>
> Regards
>
> Kamal Mann
>
>
> _______________________________________________
> Serusers mailing list
> Serusers at lists.iptel.org
> http://lists.iptel.org/mailman/listinfo/serusers
>
>
>
_______________________________________________
Serusers mailing list
Serusers at lists.iptel.org
http://lists.iptel.org/mailman/listinfo/serusers
-------------- next part --------------
A non-text attachment was scrubbed...
Name: ser1.cfg
Type: application/octet-stream
Size: 13271 bytes
Desc: ser1.cfg
URL: <http://lists.sip-router.org/pipermail/sr-users/attachments/20061110/04da6cec/attachment.obj>