[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