What does "show config mappings" show ? Julian
Stuart Ford wrote: > Dear all > > I'm writing to the list for help as a last resort. I've exhausted all > other options, so please forgive me. I've lurked here for years but > never actually posted. > > I'm trying to get Asterisk Realtime SIP configuration working, but it > refuses to do so. I have all the necessary configuration in place, > Asterisk makes a connection to the database, which can be verified with > "realtime mysql status", but it WILL NOT query the database to find SIP > accounts ([general] SIP configuration is still in the normal > configuration file). > > I'm tailing the MySQL query log and there simply aren't ANY queries on > the table containing my SIP users. Here's my config: > > -- res_mysql.conf > [general] > dbhost = 127.0.0.1 > dbname = <valid name> > dbuser = <valid user> > dbpass = <valid pass> > dbport = 3306 > dbsock = /var/lib/mysql/mysql.sock > > -- extconfig.conf > [global] > sipusers => mysql,<valid db>,telephones > sippeers => mysql,<valid db>,telephones > > (combinations of removing sipusers and sippeers lines make no difference) > > Asterisk is *definitely* connecting successfully, and I've verified that > the user it's using has all the relevant DB and table access within > MySQL. But here's the funny thing: > > When I issue "realtime mysql status", the following appears on the end > of the MySQL query log: > > 080307 10:11:09 9 Init DB <db name> > > This happens reliably, I can up-arrow and enter as many times as I like > and for each time a line like this will appear. This is how I know that > Asterisk is definitely connecting to MySQL. But if I run "realtime load > telephones name sip_1_002" I get (on the * console): > > "No rows found matching search criteria." > > ... but NOTHING in the MySQL query log. It *IS NOT* querying the > database, it's not even trying. > > Why is it not doing this? Any ideas? I've lost significant brain cells > to this and I'm out of options. I can't find a single other instance of > someone having this problem. > > Background information: Asterisk 1.4.14 running on its own (i.e. no > external telephony). MySQL 5.0.22. > > Many thanks! > > Stu > _______________________________________________ -- Bandwidth and Colocation Provided by http://www.api-digital.com -- asterisk-users mailing list To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users
