Hi..
I´m using unixodbc driver to connect with firebird SGDB. The problem is that the unixodbc driver not connect... ERROR:unixodbc:new_connection: failed to connect Jan 15 14:19:06 xsip openser[4577]: unixodbc:SQLDriverConnect=08004:1:-904:[unixODBC][ODBC Firebird Driver]Unable to connect to data source: library 'libfbclient.so' failed to load Jan 15 14:19:06 xsip openser[4577]: ERROR: group_db_bind: unable to connect to the database Jan 15 14:19:06 xsip openser[4577]: ERROR:group:mod_init: unable to open database connection
On Tuesday 15 January 2008, Alcindo Schleder wrote:
I´m using unixodbc driver to connect with firebird SGDB. The problem is that the unixodbc driver not connect... ERROR:unixodbc:new_connection: failed to connect Jan 15 14:19:06 xsip openser[4577]: unixodbc:SQLDriverConnect=08004:1:-904:[unixODBC][ODBC Firebird Driver]Unable to connect to data source: library 'libfbclient.so' failed to load
Hi Alcindo,
the error message quoted above comes from the unixodbc driver, it could not load the library. It seems that this is not an error from the OpenSER code, but from the unixodbc driver you use.
Cheers,
Henning
Hi Henning,
I thought this too ... But I connect with isql normally. See my DSN setup: [FBSipServer] Description = Firebird SipServer Driver = Firebird Dbname = localhost:/usr/local/database/FBSipServer.fdb Client = libfbclient.so User = SYSDBA Password = F60dA58 Role = CharacterSet = WIN1252 ReadOnly = No NoWait = No Dialect = 3 QuotedIdentifier = Yes SensitiveIdentifier = No AutoQuotedIdentifier = No
modparam("acc|usrloc|group|avpops|permissions|domain", "db_url", "unixodbc://SYSDBA:F60dA58@localhost/FBSipServer")
-----Mensagem original----- De: Henning Westerholt [mailto:henning.westerholt@1und1.de] Enviada em: quarta-feira, 16 de janeiro de 2008 07:52 Para: users@lists.openser.org Cc: Alcindo Schleder Assunto: Re: [OpenSER-Users] Problems with unixodbc driver
-----Mensagem original----- De: Henning Westerholt [mailto:henning.westerholt@1und1.de] Enviada em: quarta-feira, 16 de janeiro de 2008 07:52 Para: users@lists.openser.org Cc: Alcindo Schleder Assunto: Re: [OpenSER-Users] Problems with unixodbc driver
On Tuesday 15 January 2008, Alcindo Schleder wrote:
Im using unixodbc driver to connect with firebird SGDB. The problem is that the unixodbc driver not connect... ERROR:unixodbc:new_connection: failed to connect Jan 15 14:19:06 xsip openser[4577]: unixodbc:SQLDriverConnect=08004:1:-904:[unixODBC][ODBC Firebird Driver]Unable to connect to data source: library 'libfbclient.so' failed to load
Hi Alcindo,
the error message quoted above comes from the unixodbc driver, it could not load the library. It seems that this is not an error from the OpenSER code, but from the unixodbc driver you use.
Cheers,
Henning
On Wednesday 16 January 2008, Alcindo Schleder wrote:
Hi Henning,
I thought this too ... But I connect with isql normally. See my DSN setup: [FBSipServer] Description = Firebird SipServer Driver = Firebird Dbname = localhost:/usr/local/database/FBSipServer.fdb Client = libfbclient.so User = SYSDBA Password = F60dA58 Role = CharacterSet = WIN1252 ReadOnly = No NoWait = No Dialect = 3 QuotedIdentifier = Yes SensitiveIdentifier = No AutoQuotedIdentifier = No
modparam("acc|usrloc|group|avpops|permissions|domain", "db_url", "unixodbc://SYSDBA:F60dA58@localhost/FBSipServer")
Please increase the debug level in the server config to 9, and try again. The connection string should be logged, perhaps there is something wrong with setup, or the driver?
Does your unixodbc driver links against the 'libfbclient.so' library? Could you check this with the 'ldd' command? Perhaps there is an error in the installation on your system?
I'm not an ODBC expert, but it is ok that the DBname in the DSN setup differs from the name in the openser config?
Cheers,
Henning
Hi..
I think that may not be so, because when used in the Linux prompt the isql, the driver unixODBC usually connects and I can generate queries within them. So can not be an error in the driver. This seems to be something with the module unixodbc.so of OpenSER. But I will look for more about it on the Internet today, if not find, return to the trivial MySQL.
Thanks.
-----Mensagem original----- De: Henning Westerholt [mailto:henning.westerholt@1und1.de] Enviada em: quarta-feira, 16 de janeiro de 2008 12:01 Para: users@lists.openser.org Cc: Alcindo Schleder Assunto: Re: [OpenSER-Users] RES: Problems with unixodbc driver
On Wednesday 16 January 2008, Alcindo Schleder wrote:
Hi Henning,
I thought this too ... But I connect with isql normally. See my DSN setup: [FBSipServer] Description = Firebird SipServer Driver = Firebird Dbname = localhost:/usr/local/database/FBSipServer.fdb Client = libfbclient.so User = SYSDBA Password = F60dA58 Role = CharacterSet = WIN1252 ReadOnly = No NoWait = No Dialect = 3 QuotedIdentifier = Yes SensitiveIdentifier = No AutoQuotedIdentifier = No
modparam("acc|usrloc|group|avpops|permissions|domain", "db_url", "unixodbc://SYSDBA:F60dA58@localhost/FBSipServer")
Please increase the debug level in the server config to 9, and try again. The connection string should be logged, perhaps there is something wrong with setup, or the driver?
Does your unixodbc driver links against the 'libfbclient.so' library? Could you check this with the 'ldd' command? Perhaps there is an error in the installation on your system?
I'm not an ODBC expert, but it is ok that the DBname in the DSN setup differs from the name in the openser config?
Cheers,
Henning
-
Alcindo Schleder -
Henning Westerholt