sqlrelay-discussion

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

[Christian V. <cv...@gm...>]

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

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

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

[Christian V. <cv...@gm...>]

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