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@iptel.org [mailto:serusers-bounces@lists.iptel.org] On Behalf Of smy@addm.com Sent: 21 September 2005 20:33 To: Greger V. Teigre Cc: serusers@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@teigre.com:
http://www.google.com/search?hs=CDT&hl=en&lr=&client=opera&r... ail.iptel.org+mysql+remote+-make+url&btnG=Search
smy@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@lists.iptel.org http://lists.iptel.org/mailman/listinfo/serusers
_______________________________________________ Serusers mailing list serusers@lists.iptel.org http://lists.iptel.org/mailman/listinfo/serusers