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

[Kevin S. <kse...@dy...>]

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 <mat...@ya...>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:
> <%@ page session="true" contentType="text/html; charset=ISO-8859-1" %>
> <%@ taglib uri="http://www.tonbeller.com/jpivot" prefix="jp" %>
> <%@ taglib prefix="c" uri="http://java.sun.com/jstl/core" %>
>
> <jp:mondrianQuery id="query01" jdbcDriver="com.mysql.jdbc.Driver"
> 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])
> </jp:mondrianQuery>
>
> <c:set var="title01" scope="session">Test Query uses Mondrian OLAP</c:set>
>
>
> >>>
>
> 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
>
>
>
>
> ------------------------------------------------------------------------------
> 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
> luc...@li...
> https://lists.sourceforge.net/lists/listinfo/luciddb-users
>
>