[Serusers] SER + Mysql.so problem

Simon sermail at systemsrm.co.uk
Wed Sep 21 21:51:11 CEST 2005


Samuel,

My suggestion would be to test the remote working of mysql separately. Have
you tried running 'mysql --host "my.remoteserver.com" -u?? -p??" to check
basic connectivity.

If this works then it is definitely a config problem in ser.cfg.


Simon

-----Original Message-----
From: serusers-bounces at iptel.org [mailto:serusers-bounces at lists.iptel.org] On
Behalf Of smy at addm.com
Sent: 21 September 2005 20:33
To: Greger V. Teigre
Cc: serusers at lists.iptel.org
Subject: Re: [Serusers] SER + Mysql.so problem

Greger,

Thanks for suggesting the search..... yet I've read all these posts
previously
without a fix, at least not a clear answer on what to do.  The only thing
that
remotely resembles to an answer is setting up the MYSQL environment of which
I've also tried.

Is there something that I have to recompile with the "-make url" option 
of which
you've suggested in the search??

The ser.cfg has:
loadmodule "/usr/local/lib/ser/modules/mysql.so"
modparam("auth_db|permissions|uri_db|usrloc", "db_url",
?mysql://ser:heslo@xxx.xxx.xxx.xxx/ser")


Thanks

Best Regards,
Samuel Yeung




Quoting "Greger V. Teigre" <greger at teigre.com>:

>
http://www.google.com/search?hs=CDT&hl=en&lr=&client=opera&rls=en&q=site%3Am
ail.iptel.org+mysql+remote+-make+url&btnG=Search
>
> smy at addm.com wrote:
>> Hi all,
>>
>> I've been working with SER + Mysql for over a month without any
>> problems, yet all these (including the DB) are installed on the same
>> server (LocalHost).  I'm currently trying to centralize and securing
>> all Data, thus would like to move all data to a centralized DB
>> offsite.
>>
>> Now, I have SER DB migrated to this new DB server, and have changed
>> the SER.cfg so that all mysql related loadmodule would be pointing to
>> the proper server (ip address) instead of localhost.  This is where
>> the nightmare begins.
>>
>> The SER server can not seem to be connecting to the Mysql Server
>> properly.  Thus it took me over 3 days to debug and see if there were
>> any auth problems from a remote site to the Mysql server.
>> Apparently, remote auth & connect to the DB is working perfectly
>> since I've installed other application which can connect to this DB
>> server.
>>
>> So I've checked with the SER log + ngrep, of which to my amazement
>> that the SER never sent any signals to the DB server.  As soon as I
>> moved the DB back to localhost, everything worked!  My question is,
>> is there something I need to configure in the mysql module so that it
>> can work with a remote server????
>>
>> Any insight is greatly appreciated!!!
>>
>> Best Regards,
>> Samuel Yeung
>>
>> _______________________________________________
>> 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




More information about the sr-users mailing list