[luciddb-users] issue connecting in 0.9.3 with mysql 5.1

[Matt B. <mat...@ya...>]

hi guys,

playing with lucid db, i have an OLAP cube in mysql 5.1 on debian squeeze  x64 that i'm trying to connect to. 

bin/lucidDbServer starts up fine: 

# bin/lucidDbServer 
Server personality:  LucidDB
Loading database...
Starting network...
Server now listening for HTTP connections on port 8034; enter !quit to stop


bin/lucidDBClient starts up fine:
bin/sqllineClient 
Connecting to jdbc:luciddb:http://localhost
Connected to: LucidDB (version 0.9.3)
Driver: LucidDbJdbcDriver (version 0.9)
Autocommit status: true
Transaction isolation: TRANSACTION_REPEATABLE_READ
sqlline version 1.0.8-eb by Marc Prud'hommeaux
0: jdbc:luciddb:http://localhost>


when i try to connect to my foodmart db in mysql 5.1 (with correct password) it fails with incorrect password:
0: jdbc:luciddb:http://localhost> create or replace server mysql_test 
. . . . . . . . . . . . . . . . > foreign data wrapper sys_jdbc options( 
. . . . . . . . . . . . . . . . > driver_class 'com.mysql.jdbc.Driver', 
. . . . . . . . . . . . . . . . > login_timeout '10', 
. . . . . . . . . . . . . . . . > validation_query 'select 1', 
. . . . . . . . . . . . . . . . > url 'jdbc:mysql://localhost:3306/skynet', 
. . . . . . . . . . . . . . . . > user_name 'root', 
. . . . . . . . . . . . . . . . > password 'mypassword',
. . . . . . . . . . . . . . . . > fetch_size '-2147483648', 
. . . . . . . . . . . . . . . . > table_types 'TABLE', 
. . . . . . . . . . . . . . . . > schema_name 'DEFAULT');
Error: Access denied for user 'root'@'localhost' (using password: YES) (state=28000,code=1045)

I've tried this with two different mysql-java jar files, mysql-connector-java-5.0.7-bin.jar and mysql-connector-java-5.0.8-bin.jar (copied to lib directory, removed trace directory install/install.sh rerun, restarted lucidDbServer).

I'm not sure what to do now. Password is definitely correct.


portion from Trace.log for the above command:
Aug 19, 2011 2:46:56 PM net.sf.farrago.db.FarragoDbSession prepare
INFO: create or replace server mysql_test
foreign data wrapper sys_jdbc options(
driver_class 'com.mysql.jdbc.Driver',
login_timeout '10',
validation_query 'select 1',
url 'jdbc:mysql://localhost:3306/skynet',
user_name 'root',
password 'mypassword',
fetch_size '-2147483648',
table_types 'TABLE',
schema_name 'DEFAULT')
Aug 19, 2011 2:46:56 PM net.sf.farrago.db.FarragoDbSession commitImpl
INFO: commit
Aug 19, 2011 2:46:56 PM org.eigenbase.util.EigenbaseException <init>
SEVERE: org.eigenbase.util.EigenbaseException: Failed to initialize data server
Aug 19, 2011 2:46:56 PM org.eigenbase.util.EigenbaseException <init>
SEVERE: org.eigenbase.util.EigenbaseException: Failed to validate definition for data server "SYS_BOOT"."MYSQL_TEST"
Aug 19, 2011 2:46:56 PM net.sf.farrago.ddl.DdlValidator validate

INFO: Revalidate exception on MYSQL_TEST: org.eigenbase.util.EigenbaseException:  Failed to validate definition for data server "SYS_BOOT"."MYSQL_TEST"; org.eigenbase.util.EigenbaseException:  Failed to initialize data server; java.sql.SQLException:  Access denied for user 'root'@'localhost' (using password: YES)
Aug 19, 2011 2:46:56 PM net.sf.farrago.db.FarragoDbSession rollbackImpl
INFO: rollback
Aug 19, 2011 2:46:56 PM net.sf.farrago.jdbc.FarragoJdbcUtil newSqlException
SEVERE: Failed to validate definition for data server "SYS_BOOT"."MYSQL_TEST"
Aug 19, 2011 2:46:56 PM net.sf.farrago.jdbc.FarragoJdbcUtil newSqlException
SEVERE: Failed to initialize data server
Aug 19, 2011 2:46:56 PM net.sf.farrago.jdbc.FarragoJdbcUtil newSqlException
SEVERE: Access denied for user 'root'@'localhost' (using password: YES)


thanks,

Matt