Hi John, this is getting quite strange, and i'm becoming quite curios why it's not working :)
Could you try first setting up realtime for SIP or queues? This should work out-of-the-box on 1.4. http://www.voip-info.org/wiki/view/Asterisk+RealTime+Sip http://www.voip-info.org/wiki/view/Asterisk+RealTime+Queue For beginning you can just add queues=>.. in extconfig.conf to see that SQLs go trough and return errors. You should see SELECT's in your log whenever accessing. For example, entering into CLI: ast-dev14*CLI> queue show myqueue would write into log: [Oct 15 04:04:09] DEBUG[9935] res_config_mysql.c: MySQL RealTime: Everything is fine. [Oct 15 04:04:09] DEBUG[9935] res_config_mysql.c: MySQL RealTime: Retrieve SQL: SELECT * FROM queue_table WHERE name = 'myqueue' Also i would suggest enabling full log, as it's one place you can see everything. Then use grep to search for realtime messages. Your logger.conf should already have commented line: full => notice,warning,error,debug,verbose Then you can do: # tail -fn0 /var/log/asterisk/full | grep -F "res_config_mysql" to see every message about realtime driver. After this you can unload and load module or restart asterisk completely (if restarting, make sure it's started with "-vvvd"). To reload module, use: ast-dev14*CLI> module unload res_config_mysql.so MySQL RealTime unloaded. ast-dev14*CLI> module load res_config_mysql.so == Parsing '/etc/asterisk/res_mysql.conf': Found MySQL RealTime driver loaded. Loaded res_config_mysql.so => (MySQL RealTime Configuration Driver) On Wed, Oct 15, 2008 at 9:05 AM, Lee, John (Sydney) <[EMAIL PROTECTED]> wrote: > Hi Atis, > >> queue_log => mysql,asteriskcdrdb,queue_log >> that is <engine>,<database>,<table> >> If it's wrong, you should see some warnings when asterisk is starting > up. >> > Thanks for the suggestion. I did not put in queue_log for <table> and > it has just taken the default which is queue_log. > In the console startup, you can see below that it has successfully bound > queue_log to /mysql/db1/queue_log. > > # asterisk -rvvv > Asterisk 1.4.21.2, Copyright (C) 1999 - 2008 Digium, Inc. and others. > [...] > == Parsing '/etc/asterisk/extconfig.conf': Found > == Binding queue_log to mysql/db1/queue_log > Connected to Asterisk 1.4.21.2 currently running on machine > Verbosity is at least 3 This seems somehow strange. If you connect to running asterisk with -r, you shouldn't see "parsing extconfig.conf", as it should be parsed on startup time. You could also add -d to enable "debug 1". > > In /var/log/asterisk/messages, I saw: > [Oct 15 15:31:48] NOTICE[20941] config.c: Registered Config Engine mysql > >> Another idea that came into my mind is, that (if this config doesn't >> still work) you might have to do "make dist-clean" within >> asterisk-addons after reinstalling asterisk, and then configure, make, >> make install. It's because addons do use headers from installed >> version of asterisk, and they might not have correct declarations. >> > > Basically, I did: > -> Asterisk-1.4.21.2 > "make clean" > "./configure" > "make" > "make install" > > -> Asterisk-addons-1.4.7 > "make dist-clean" > "./configure" > "make" > "make install" Yes, this is completely correct (assuming you restarted asterisk after :) > >> Also, you mentioned that you checked /var/log/asterisk/messages, >> however i think debug is written into file called "debug". Anyway you >> can enable "full" in logger.conf and get everything there. To debug >> this you shouldn't need more than "core set verbose 3" and "core set >> debug 1". > > I turned on debug mode and tried an agent login and logoff. > However, when I looked into debug and messages, there are lots of > chan_sip.c and a few cdr_addon_mysql.c but no occurrence at all of > res_config_mysql.c > > What is happening? Do I have to explicitly load it? > > *CLI> module show like res_config_mysql > Module Description Use > Count > res_config_mysql.so MySQL RealTime Configuration Driver 0 > 1 modules loaded This should also be fine. You could also try catching me on irc, just look for atis_work or atis_home in #asterisk. Regards, Atis -- Atis Lezdins, VoIP Project Manager / Developer, [EMAIL PROTECTED] Skype: atis.lezdins Cell Phone: +371 28806004 Cell Phone: +1 800 7300689 Work phone: +1 800 7502835 _______________________________________________ -- 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
