Re: [Sqlrelay-discussion] "failed to connect to the database Couldn't log into database." error

[David M. <dav...@fi...>]

The only thing that stands out to me is the password='' part of the
string="sybase..." parameter.  I think that will end up literally
passing '' as the password.  Try just omitting the password part
altogether:

string="sybase=/etc/freetds/;user=sa;server=GOLDMINE;db=Goldmine;"

and see what you get.  Or, configure the DB to have a password :)

David Muse
dav...@fi...

On Thu, 2009-05-21 at 14:20 +0000, Christian Vielma wrote:
> Hi there!
> 
> I'm sorry to bother you because i always want to resolve the problem
> by my own, but i'm really stucked with this problem, and it had to be
> done three days ago :S
> 
> I want to configure sql-relay to connect a Plone site to a MS SQL
> Server. I have configured FreeTDS (and tested with isql that it
> works), and because of some problem with ubuntu and sql-relay packages
> (i guess) i decided to compile a fresh new Sql-relay 0.41 on my
> system. 
> 
> I have configured the compile like this: 
> ./configure --disable-oracle --disable-mysql --disable-postgresql
> --disable-sqlite --disable-sybase --disable-db2 --disable-firebird
> --disable-mdbtools --disable-perl
> --with-python-prefix="/usr/include/python2.4"
> 
> (also tried with all enabled)
> 
> The thing is that when i run:
> 
> sqlr-start -id mssql
> 
> It gives me the following output:
> Starting listener:
>   sqlr-listener -id mssql
> -config /usr/local/firstworks/etc/sqlrelay.conf -debug
> Debugging
> to: /usr/local/firstworks/var/sqlrelay/debug/sqlr-listener.12839
> 
> Starting 1 connections to db1 :
>   sqlr-connection-freetds -id mssql -connectionid db1
> -config /usr/local/firstworks/etc/sqlrelay.conf -debug
> 
> Starting scaler:
>   sqlr-scaler -id mssql -debug
> -config /usr/local/firstworks/etc/sqlrelay.conf
> 
> cache manager already running.
> 
> 
> Thanks to MP3.com for sponsoring: 
>     Clustered/Replicated database support.
>     Perl API.
> Thanks to FeedLounge for sponsoring: 
>     Query routing and filtering.
> failed to connect to the database
> Couldn't log into database.
> 
> 
> I have tried starting the daemon individually and still gives me the
> same error. I can't see the sqlr-connection debug because it fails
> before it shows me some debug...
> 
> I'm running Ubuntu 8.04, and these are my configuration files:
> 
> /etc/freetds/freetds.conf:
> --------
> # A typical Microsoft SQL Server 2000 configuration
> ;[GOLDMINE]
>     host = 192.168.1.12
>     port = 1433
>     tds version = 8.0
>     client charset = UTF-8
> ---------
> 
> 
> /usr/local/firstworks/etc/sqlrelay.conf:
> <?xml version="1.0"?>
> <!DOCTYPE instances SYSTEM "sqlrelay.dtd">
> 
> <instances>
>    <instance id="mssql" port="9000" socket="/tmp/examplesocket"
> dbase="freetds" connections="1" maxconnections="15" maxqueuelength="5"
> growby="1" ttl="60" endofsession="commit" sessiontimeout="600"
> runasuser="nobody" runasgroup="nobody" cursors="5" authtier="listener"
> handoff="pass" debug="listener_and_connection">
>       <users>
>          <user user="sa" password=""/>
>       </users>
>       <connections>
>          <connection connectionid="db1"
> string="sybase=/etc/freetds/;user=sa;password='';server=GOLDMINE;db=Goldmine;" metric="1"/>
>       </connections>
>    </instance>    
> </instances>
> 
> 
>     
> Do you have any idea what it could be? I ran out of ideas :S
> 
> Thanks in advance.
> 
> Greetings,
> 
> -- 
> Christian Vielma
> 
> "Somos lo que hacemos día a día.
> De modo que la excelencia no es un acto, sino un hábito" - Aristóteles
> ------------------------------------------------------------------------------
> Crystal Reports - New Free Runtime and 30 Day Trial
> Check out the new simplified licensing option that enables 
> unlimited royalty-free distribution of the report engine 
> for externally facing server and web deployment. 
> http://p.sf.net/sfu/businessobjects
> __________________________________________________
> D O T E A S Y - "Join the web hosting revolution!"
>              http://www.doteasy.com
> _______________________________________________ Sqlrelay-discussion mailing list Sql...@li... https://lists.sourceforge.net/lists/listinfo/sqlrelay-discussion __________________________________________________ D O T E A S Y - "Join the web hosting revolution!" http://www.doteasy.com


__________________________________________________
D O T E A S Y - "Join the web hosting revolution!"
             http://www.doteasy.com