RE: [Serusers] SER + Mysql.so problem

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