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

[Nicholas G. <ngo...@dy...>]

Matt,

Are you able to connect, via Squirrel (or Pentaho Reporting)?

Remember, MySQL has different usernames for root@'localhost' vs root (via non IP sockets) vs 'root'@'%' etc.

You can also try adding additional root passwords 
grant all on *.* to 'root'@'%' identified by 'password';
grant all on *.* to 'root'@'locahost' identified by 'password';



On Aug 19, 2011, at 1:04 PM, Matt Becker wrote:

> 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
> ------------------------------------------------------------------------------
> Get a FREE DOWNLOAD! and learn more about uberSVN rich system, 
> user administration capabilities and model configuration. Take 
> the hassle out of deploying and managing Subversion and the 
> tools developers use with it. http://p.sf.net/sfu/wandisco-d2d-2_______________________________________________
> luciddb-users mailing list
> luc...@li...
> https://lists.sourceforge.net/lists/listinfo/luciddb-users