Hi, im trying to get an odbc connection to work. Its no problem if asterisk an mysl running on one machine. When i try to set up an external DB it won't connect. External connections to the db are possible (bind-address = 0.0.0.0 and the user asterisk is allowed to connect from each ip). The password in the config is the right one i already double checked it. Jul 23 12:31:54 WARNING[10380]: res_odbc.c:559 odbc_obj_connect: res_odbc: Error SQLConnect=-1 errno=1044 [unixODBC][MySQL][ODBC 3.51 Driver]Access denied for u ser 'asterisk'@'%' to database 'asterisk' Any suggestions? Thanks
are you trying to connect to localhost ? try 127.0.0.1 as well as the machines IP and or host name. ----- Original Message ----- From: "NicklasZ" <nicklasz at gmx.de> To: <asterisk-users at lists.digium.com> Sent: Monday, July 23, 2007 11:40 AM Subject: [asterisk-users] ODBC Connection failed> Hi, > > im trying to get an odbc connection to work. Its no problem if asterisk an > mysl running on one machine. When i try to set up an external DB it won't > connect. External connections to the db are possible (bind-address = > 0.0.0.0 and the user asterisk is allowed to connect from each ip). The > password in the config is the right one i already double checked it. > > Jul 23 12:31:54 WARNING[10380]: res_odbc.c:559 odbc_obj_connect: res_odbc: > Error SQLConnect=-1 errno=1044 > [unixODBC][MySQL][ODBC 3.51 Driver]Access denied for u ser 'asterisk'@'%' > to database 'asterisk' > > > Any suggestions? > > Thanks > > > _______________________________________________ > --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 >
ok problem solved. The user asterisk itself was allowed to connect from % but the privileges on the database asterisk was locked to local access. Andy ----- Original Message ----- From: "NicklasZ" <nicklasz at gmx.de> To: <asterisk-users at lists.digium.com> Sent: Monday, July 23, 2007 10:40 AM Subject: [asterisk-users] ODBC Connection failed> Hi, > > im trying to get an odbc connection to work. Its no problem if asterisk an > mysl running on one machine. When i try to set up an external DB it won't > connect. External connections to the db are possible (bind-address = > 0.0.0.0 and the user asterisk is allowed to connect from each ip). The > password in the config is the right one i already double checked it. > > Jul 23 12:31:54 WARNING[10380]: res_odbc.c:559 odbc_obj_connect: res_odbc: > Error SQLConnect=-1 errno=1044 > [unixODBC][MySQL][ODBC 3.51 Driver]Access denied for u ser 'asterisk'@'%' > to database 'asterisk' > > > Any suggestions? > > Thanks > > > _______________________________________________ > --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