We are a small company looking for a simple and relatively easy to administer
document management system. In taking Nuxeo for a spin this looks like an
excellent fit for us. I have tried on two machines, my work XP laptop and
Fedora 8 at home, to point Nuxeo to MySQL. I have followed the instructions
specified in Chapter 32 to the letter. The common problem seems to be that the
MySQL database is not being setup. This is common between Windows and Linux.
I created a new empty schema in MySQL along with a new user and password. I
associated all the capabilities in that new schema to the new user. I tested
connectivity to the schema through the command line to verify the credentials.
The JDBC connector is in the directory specified. I also deleted the tmp and
data directories based on a thread that I read yesterday. The server logs in
both cases indicate the following common-type error:
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Access denied for
user 'nuxeo'@'localhost' to database 'nxaudit-logs')
I am certainly no expert in J2EE, so I have limited myself to following
instructions as provided. I also tried the "root" credentials for MySQL and
received the same errors. Somehow Nuxeo is not able to talk to the MySQL
database. I use MySQL a fair amount so I am reasonably sure that it is setup
correctly. Here is an except from the repository-config file:
<PersistenceManager
class="org.apache.jackrabbit.core.persistence.bundle.MySqlPersistenceManager">
<param name="driver" value="com.mysql.jdbc.Driver"/>
<param name="url" value="jdbc:mysql://localhost/nuxeo"/>
<param name="user" value="nuxeo"/>
<param name="password" value="nuxeo"/>
<param name="schema" value="nuxeo"/>
<param name="schemaObjectPrefix" value="jcr_${wsp.name}_"/>
<param name="externalBLOBs" value="true"/>
</PersistenceManager>
I am using a current version of MySQL and the connector as well as Java JDK 6.
Any advice would be appreciated.
Thank you.
Art
_______________________________________________
ECM mailing list
[email protected]
http://lists.nuxeo.com/mailman/listinfo/ecm
