Still a couple of questions...... I did configure extconfig.conf ... ;iaxusers => odbc,asterisk ;iaxpeers => odbc,asterisk ;sipusers => odbc,asterisk sipusers => mysql,asterisk,sip_devices sippeers => mysql,asterisk,sip_devices ;sippeers => odbc,asterisk ;sipregs => odbc,asterisk ;voicemail => odbc,asterisk ;extensions => odbc,asterisk ;meetme => mysql,general ;queues => odbc,asterisk ;queue_members => odbc,asterisk ;musiconhold => mysql,general ;queue_log => mysql,general .... So only defining sipusers & sippeers for mysql
And noticed two files for configuring mysql-stuff: file: res_config_mysql.conf database access config: host, user, pwd file: res_odbc.conf in section [mysql2]: mysql database config: host, user, pwd So, i configured them both... Quick check:kc3054*CLI> sip show users Username Secret Accountcode Def.Context ACL ForcerPort j.witvliet geheim default No Yes 00000277611 25b06d3a0b5ef73 default No Yes kc3054*CLI> kc3054*CLI> sip show peers Name/username Host Dyn Forcerport ACL Port Status Realtime 00000277611 (Unspecified) D N 0 Unmonitored j.witvliet (Unspecified) D N 0 Unmonitored 2 sip peers [Monitored: 0 online, 0 offline Unmonitored: 0 online, 2 offline] kc3054*CLI> Here i see at for both users and peers ONLY the statis entries from sip.conf file, nothing from mysql... kc3054*CLI> realtime mysql status general connected to asterisk@127.0.0.1, port 3306 with username voipadmin for 5 seconds. kc3054*CLI> =>No warnings/errors but nothing else either... kc3054*CLI> kc3054*CLI> realtime mysql cache kc3054*CLI> =>No warnings/errors but nothing else either... the module res_config_mysql.so is loaded, Try todo something else: kc3054*CLI> realtime update sipusers set SET port = 4343 WHERE name = 00000277611 Failed to update. Check the debug log for possible SQL related entries. Command 'realtime update sipusers set SET port = 4343 WHERE name = 00000277611' failed. [May 18 18:47:16] WARNING[16718]: res_config_mysql.c:559 update_mysql: MySQL RealTime: Invalid database specified: 'asterisk' (check res_mysql.conf) kc3054*CLI> ==> here the system talkes about _another_ config file! <== So which file should i configure: A) res_config_mysql.conf B) res_odbc.conf C) res_mysql.conf But even when i put my credentials in all three of them, still no show! DB check: mysql -h localhost -u voipadmin -p Enter password: Server version: 5.0.67 SUSE MySQL RPM mysql> use asterisk; select name,username,secret,host,nat from sip_devices; Database changed +-------------+-------------+--------+---------+-----+ | name | username | secret | host | nat | +-------------+-------------+--------+---------+-----+ | 00000031756 | 00000031756 | geheim | dynamic | Yes | +-------------+-------------+--------+---------+-----+ 1 row in set (0.00 sec) mysql> According to *,TDG, page 349: Also filled the file /etc/unixODBC/odbcinst.ini, and the command odbcinst -q -d produced the required result: "[MySQL]" I presume i made a silly mistake/omission, but i fail to see how i can detect that, or other steps to test the correct configuration of ARA. So it looks that i'm stuck. Can not imagine that i'm the first here! But even from "the definitive guide", chapter 16 and onwards, it isn't clear if you should use the mysql-stuff directly of through the odbc-routines.... Kind regards, Hans -- _____________________________________________________________________ -- Bandwidth and Colocation Provided by http://www.api-digital.com -- New to Asterisk? Join us for a live introductory webinar every Thurs: http://www.asterisk.org/hello asterisk-users mailing list To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users
