http://www.google.com/search?hs=CDT&hl=en&lr=&client=opera&… smy(a)addm.com wrote:

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

Sam, Could you send your config file so that I can have a look at it. I can only assume there is a fault somewhere there - you have not defined a particular variable. Simon -----Original Message----- From: smy(a)addm.com [mailto:smy@addm.com] Sent: 22 September 2005 02:08 To: Simon Cc: 'Greger V. Teigre'; serusers(a)lists.iptel.org Subject: RE: [Serusers] SER + Mysql.so problem Simon, The connectivity from a remote source to the Mysql DB is working, since my other apps are connecting to the DB. Also, your command has been tried and succeeded, since I'd have to do a similar DB connect for those Apps which has to be connected to the DB server. Are you running a separate DB / SER installation??? If so, any insights are greatly appreciated. Best Regards, Samuel Yeung Quoting Simon <sermail(a)systemsrm.co.uk>uk>: 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