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

SourceForge Headquarters 1320 Columbia Street Suite 310 San Diego, CA 92101 +1 (858) 422-6466

Thanks!

Already solved this problem. This last thing was a non-deleted comment on
the freetds.conf file :S

Soon i will post a complete update and short guide to install it in ubuntu.

Greetings,

On Fri, May 29, 2009 at 11:14 AM, David Muse <dav...@fi...>wrote:

> 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
>
>
> ------------------------------------------------------------------------------
> Register Now for Creativity and Technology (CaT), June 3rd, NYC. CaT
> is a gathering of tech-side developers & brand creativity professionals.
> Meet
> the minds behind Google Creative Lab, Visual Complexity, Processing, &
> iPhoneDevCamp as they present alongside digital heavyweights like Barbarian
> Group, R/GA, & Big Spaceship. http://p.sf.net/sfu/creativitycat-com
> _______________________________________________
> Sqlrelay-discussion mailing list
> Sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sqlrelay-discussion
>

-- 
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