[Asterisk-Users] problem with asterisk-realtime-odbc

J Mauricio Mejia Vargas mmejia at gecko-soft.com
Fri Oct 28 13:52:22 MST 2005


hello:  I need guide with the following question.

I am trying to use asterisk - realtime using ODBC, and when I make a call to
number XXXX the CLI show the next error:

""Oct 28 15:17:34 WARNING[7034]: config.c:893 find_engine: Realtime mapping for
'sippeers' found to engine 'odbc', but the engine is not available
Oct 28 15:17:34 NOTICE[7034]: chan_sip.c:9835 handle_request_register:
Registration from '<sip:101 at 192.168.10.29>' failed for '192.168.10.109' - Wrong
password
Oct 28 15:17:36 WARNING[7034]: config.c:893 find_engine: Realtime mapping for
'sipusers' found to engine 'odbc', but the engine is not available
Oct 28 15:17:36 WARNING[7034]: config.c:893 find_engine: Realtime mapping for
'sippeers' found to engine 'odbc', but the engine is not available""

I make the next configuration:
(software) 
asterisk 1.2.0-beta1; asterisk ADDONS 1.2.0-beta1; UNIXodbc 2,2,11; UNIXodbc -
devel 2,2,11; Fedora 4; MySQL 4,1,11 FC4 

steps that have become.  
***********************************************

1.I created database with name "asterisk", inside this I make a table
"sip_buddies", a user of the database with name "asterisk" without password has
all the permissions.  
2. I have entered data to the database manually to the table "sip_buddies" 
3. I modified the files" ODBC.INI, ODBCINST.INI" located in /etc  with the next
information
**************************
file ODBC.INI:  
[MySQL-asterisk]
Description = MySQL Asterisk database
Trace       = Yes
TraceFile   = /var/log/odbc.log
Driver      = MySQL
SERVER      = localhost
USER        = asterisk
PASSWORD    =
#PORT        = 3306
DATABASE    = asterisk
Socket      = /var/lib/mysql/mysqld.sock
**********************
file ODBCINST.INI
[PostgreSQL]
Description     = ODBC for PostgreSQL
Driver          = /usr/lib/libodbcpsql.so
Setup           = /usr/lib/libodbcpsqlS.so
FileUsage       = 1
[MySQL]
Description     = ODBC for MySQL
Driver          = /usr/lib/libmyodbc.so
Setup           = /usr/lib/libodbcmyS.so
FileUsage       = 1
***************************************
4.  After that I modified the files "res_odbc.conf, res_mysql.conf" located in
/etc/asterisk.  
*********************************
file: res_odbc.conf
[general]
dbhost = 192.168.10.29
dbname = asterisk
dbuser = asterisk
dbpass = ""
dbport = 3306
dbsock = /tmp/mysql.sock
********************************
file: res_mysql.conf
;[asterisk]
;dsn => asterisk
;username => myuser
;password => mypass
;pre-connect => yes
[mysql1]
dsn => MySQL-asterisk
username => asterisk
;password => mypass
pre-connect => yes
*********************************
5. after that I setup one telephone GRANDSTREAM 102 using info from the
database. 
6. execute asterisk -vvvvrc
7. I look the error:
Oct 28 15:17:34 WARNING[7034]: config.c:893 find_engine: Realtime mapping for
'sippeers' found to engine 'odbc', but the engine is not available
Oct 28 15:17:34 NOTICE[7034]: chan_sip.c:9835 handle_request_register:
Registration from '<sip:101 at 192.168.10.29>' failed for '192.168.10.109' - Wrong
password
Oct 28 15:17:36 WARNING[7034]: config.c:893 find_engine: Realtime mapping for
'sipusers' found to engine 'odbc', but the engine is not available
Oct 28 15:17:36 WARNING[7034]: config.c:893 find_engine: Realtime mapping for
'sippeers' found to engine 'odbc', but the engine is not available

If you know where the problem is...please tell to me.


-- 
Atentamente

J Mauricio Mejia Vargas



More information about the asterisk-users mailing list