Displaying 3 results from an estimated 3 matches for "kc3054".
2011 May 19
2
[Fwd: FW: realtime mysql - p4]
...created mysqluser
[in this case: voipadmin]
Other wild idea, is there a minimum number of fields that haved to be filled?
And why is asterisk complaining about not being able to find the databse, when trying to fill it from the asterisk-CLI?
My database _is_ named "asterisk"......
> 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[1...
2011 May 18
1
asterisk18 - realtime/mysql - take 3
.....
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...
2011 May 12
2
Realtime - ara180
...2585] config.c: Realtime mapping for
'sippeers' found to engine 'mysql', but the engine is not available
[May 12 14:05:55] WARNING[2630] config.c: Realtime mapping for
'sippeers' found to engine 'mysql', but the engine is not available
And on the asterisk console:
kc3054*CLI> sip show peers
Name/username Host Dyn Forcerport ACL Port Status
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] [May 12 14:17...