[asterisk-users] asterisk18 - realtime/mysql - take 3

[Hans Witvliet]

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 at 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