[OpenSER-Users] RES: RES: Problems with unixodbc driver

[Alcindo Schleder]

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 at 1und1.de] 
Enviada em: quarta-feira, 16 de janeiro de 2008 12:01
Para: users at 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
-------------- next part --------------
A non-text attachment was scrubbed...
Name: Alcindo Schleder.vcf
Type: application/octet-stream
Size: 4480 bytes
Desc: not available
Url : http://lists.kamailio.org/pipermail/users/attachments/20080116/ddc7199b/attachment.obj