Mailing list users (luciddb-users) can "claim" their threads in the archives by registering with the same account they used to post to the email list. NOTE: List threads are updated once every 24hrs.
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>
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
SEVERE: org.eigenbase.util.EigenbaseException: Failed to initialize data server
Aug 19, 2011 2:46:56 PM org.eigenbase.util.EigenbaseException
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)
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
> SEVERE: org.eigenbase.util.EigenbaseException: Failed to initialize data server
> Aug 19, 2011 2:46:56 PM org.eigenbase.util.EigenbaseException
> 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
> luciddb-users@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/luciddb-users
I verified these permissions existed in mysql, and also added and tried a few other users.
No dice.
We currently have mondrian (same server as luciddb) connecting to mysql using the root password, it's working fine.
Our mondrian connection in the jsp looks like this:
Select
{ [Measures].[Clicks], [Measures].[Impressions] } ON COLUMNS,
Crossjoin( { [Week].[25] } , { [Day of Week].[All Days of Week].Children } ) ON ROWS
From
[Analytics]
Where
([Year].[2011], [Asset Type].[Banner])
Test Query uses Mondrian OLAP
>>>
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
>SEVERE: org.eigenbase.util.EigenbaseException: Failed to initialize data server
>Aug 19, 2011 2:46:56 PM org.eigenbase.util.EigenbaseException
>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
>
>
figured it out.. i had two mysql daemons running, one on 3307 and one on 3306 :-) They each had different mysql root passwords i guess..
forgot about that.
Also I tested with the sqlline command line client from linux repositories (not the luciddb one) to narrow things down.
Everything's working now.
thanks,
Matt
>>>
Hi Nicholas,
I verified these permissions existed in mysql, and also added and tried a few other users.
No dice.
We currently have mondrian (same server as luciddb) connecting to mysql using the root password, it's working fine.
Our mondrian connection in the jsp looks like this:
...
Hey Matt. I usually make the schema_name option identical to the database
name at the end of the URL. What happens when you try that?
On Mon, Aug 22, 2011 at 10:02 AM, Matt Becker wrote:
> Hi Nicholas,
>
> I verified these permissions existed in mysql, and also added and tried a
> few other users.
> No dice.
> We currently have mondrian (same server as luciddb) connecting to mysql
> using the root password, it's working fine.
>
> Our mondrian connection in the jsp looks like this:
>
>
>
>
> jdbcUrl="jdbc:mysql://localhost/analytics_olap?user=root&password=mypassword"
> catalogUri="/WEB-INF/queries/analytics_schema.xml" jdbcUser="root"
> jdbcPassword="mypassword" connectionPooling="false">
> Select
> { [Measures].[Clicks], [Measures].[Impressions] } ON COLUMNS,
> Crossjoin( { [Week].[25] } , { [Day of Week].[All Days of
> Week].Children } ) ON ROWS
> From
> [Analytics]
> Where
> ([Year].[2011], [Asset Type].[Banner])
>
>
> Test Query uses Mondrian OLAP
>
>
> >>>
>
> 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
> SEVERE: org.eigenbase.util.EigenbaseException: Failed to initialize data
> server
> Aug 19, 2011 2:46:56 PM org.eigenbase.util.EigenbaseException
> 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
>
>
>
>
> ------------------------------------------------------------------------------
> uberSVN's rich system and user administration capabilities and model
> configuration take the hassle out of deploying and managing Subversion and
> the tools developers use with it. Learn more about uberSVN and get a free
> download at: http://p.sf.net/sfu/wandisco-dev2dev
>
> _______________________________________________
> luciddb-users mailing list
> luciddb-users@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/luciddb-users
>
>
