[OpenSIPS-Devel] [ opensips-Bugs-2194571 ] Presence examples can cause database permissions problem

[SourceForge.net]

Bugs item #2194571, was opened at 2008-10-25 15:59
Message generated for change (Tracker Item Submitted) made by Item Submitter
You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=1086410&aid=2194571&group_id=232389

Please note that this message will contain a full copy of the comment thread,
including the initial issue submission, for this request,
not just the latest update.
Category: docs
Group: trunk
Status: Open
Resolution: None
Priority: 5
Private: No
Submitted By: Norm Brandinger (norm_brandinger)
Assigned to: Nobody/Anonymous (nobody)
Summary: Presence examples can cause database permissions problem

Initial Comment:
The following Presence examples will cause a database permissions problem if the OpenSIPS username/password has been changed from the default value

http://opensips.org/index.php?n=Resources.SimplePresConfig

http://opensips.org/index.php?n=Resources.PuaUsrlocConfig

http://opensips.org/index.php?n=Resources.PuaXmppConfig

http://opensips.org/index.php?n=Resources.PuaBlaConfig

http://opensips.org/index.php?n=Resources.RlsConfig

Adding the following line to the examples should resolve this problem:

modparam("presence_xml", "db_url", "mysql://opensips:opensipsrw@127.0.0.1/opensips")

Most people change the default username and/or password for access to the OpenSIPS database.

The example shows where the db_url's need to be changed, except for presence_xml.  Without the above line being changed, the default OpenSIPS username/password will be used and a failure during startup will happen.

Adding the above line will clearly show the users of the examples what db_url's need to be modified.

Regards,
Norm


----------------------------------------------------------------------

You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=1086410&aid=2194571&group_id=232389