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

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@addm.com [mailto:smy@addm.com] Sent: 22 September 2005 02:08 To: Simon Cc: 'Greger V. Teigre'; serusers@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@systemsrm.co.uk:

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

Hi all,

After I played with the config file, I may have discovered something that may cause the problem with remote DB.

Since I was following the onsip.org setup, I had a line in the config....

modparam("auth_db|permissions|uri_db|usrloc", "db_url", "mysql://ser:heslo@localhost/ser")

then I've decided to use ACC for accounting, there fore I have added acc related modparam, including.....

modparam("acc", "db_url", "mysql://ser:heslo@localhost/ser")

*******

Now, with localhost DB connection, everything worked out find. Once I switch the localhost to another IP, it didn't connect. So after playing with SER for a while, I have merged the acc to the first modparam line where it is now.....

modparam("acc|auth_db|permissions|uri_db|usrloc", "db_url", "mysql://ser:heslo@xxx.xxx.xxx.xxx/ser")

Then all of a sudden, it worked!!! I have not done anything else other than tweaking the config file. Thus I would like to know if the mysql.so can not support multiple modparam db_url entries if I were to use a remote DB??? or perhaps if this is a bug in the mysql.so???

This is only an elementary testing, thus I'm not even sure if I should be fixing the problem via this method. Perhaps all of you can give me some insights.

Thanks.

Best Regards, Samuel Yeung

Quoting "Greger V. Teigre" greger@teigre.com:

If you have recently (re)installed mysql libraries, you may also try to make ser again to be absolutely sure that the db modules have been linked correctly. g-)

Simon wrote:

...

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@addm.com [mailto:smy@addm.com] Sent: 22 September 2005 02:08 To: Simon Cc: 'Greger V. Teigre'; serusers@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@systemsrm.co.uk:

...

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