I have installed the UA with the user received by the MySQL DBA.

During installation, connection OK, tables creation OK, but when I
start jboss, I can connect the MySQL server:

Error with the user table !! which user table?

2010-04-28 17:06:07,952 INFO
[org.jboss.resource.deployers.RARDeployment] (main) Required license
terms exist, view
vfszip:/opt/novell/idm/jboss/server/IDMProv/deploy/jboss-local-jdbc.rar/META-INF/ra.xml
2010-04-28 17:06:07,968 INFO
[org.jboss.resource.deployers.RARDeployment] (main) Required license
terms exist, view
vfszip:/opt/novell/idm/jboss/server/IDMProv/deploy/jboss-xa-jdbc.rar/META-INF/ra.xml
2010-04-28 17:06:07,993 INFO
[org.jboss.resource.deployers.RARDeployment] (main) Required license
terms exist, view
vfszip:/opt/novell/idm/jboss/server/IDMProv/deploy/jms-ra.rar/META-INF/ra.xml
2010-04-28 17:06:08,008 INFO
[org.jboss.resource.deployers.RARDeployment] (main) Required license
terms exist, view
vfszip:/opt/novell/idm/jboss/server/IDMProv/deploy/mail-ra.rar/META-INF/ra.xml
2010-04-28 17:06:08,028 INFO
[org.jboss.resource.deployers.RARDeployment] (main) Required license
terms exist, view
vfszip:/opt/novell/idm/jboss/server/IDMProv/deploy/quartz-ra.rar/META-INF/ra.xml
2010-04-28 17:06:08,086 INFO [org.quartz.simpl.SimpleThreadPool]
(main) Job execution threads will use class loader of thread: main
2010-04-28 17:06:08,107 INFO [org.quartz.core.QuartzScheduler] (main)
Quartz Scheduler v.1.5.2 created.
2010-04-28 17:06:08,109 INFO [org.quartz.simpl.RAMJobStore] (main)
RAMJobStore initialized.
2010-04-28 17:06:08,109 INFO [org.quartz.impl.StdSchedulerFactory]
(main) Quartz scheduler 'DefaultQuartzScheduler' initialized from
default resource file in Quartz package: 'quartz.properties'
2010-04-28 17:06:08,110 INFO [org.quartz.impl.StdSchedulerFactory]
(main) Quartz scheduler version: 1.5.2
2010-04-28 17:06:08,110 INFO [org.quartz.core.QuartzScheduler] (main)
Scheduler DefaultQuartzScheduler_$_NON_CLUSTERED started.
2010-04-28 17:06:08,280 INFO
[org.jboss.resource.connectionmanager.ConnectionFac toryBindingService]
(main) Bound ConnectionManager
'jboss.jca:service=DataSourceBinding,name=IDMUADat aSource' to JNDI name
'java:IDMUADataSource'
2010-04-28 17:06:09,249 WARN
[org.jboss.resource.connectionmanager.JBossManagedC onnectionPool] (main)
Throwable while attempting to get a new connection: null
org.jboss.resource.JBossResourceException: Could not create connection;
- nested throwable:
(com.mysql.jdbc.exceptions.MySQLSyntaxErrorExcepti on: SELECT command
denied to user 'cerbere'@'193.190.100.107' for table 'user')
at
org.jboss.resource.adapter.jdbc.local.LocalManaged ConnectionFactory.getLoc
org.jboss.system.server.profileservice.ProfileServ iceBootstrap.loadProfile(ProfileServiceBootstrap.j ava:304)
at
org.jboss.system.server.profileservice.ProfileServ iceBootstrap.start(ProfileServiceBootstrap.java:20 5)
at
org.jboss.bootstrap.AbstractServerImpl.start(Abstr actServerImpl.java:405)
at org.jboss.Main.boot(Main.java:209)
at org.jboss.Main$1.run(Main.java:547)
at java.lang.Thread.run(Thread.java:619)
Caused by: com.mysql.jdbc.exceptions.MySQLSyntaxErrorExceptio n: SELECT
command denied to user 'cerbere'@'193.190.100.107' for table 'user'
at com.mysql.jdbc.SQLError.createSQLException(SQLErro r.java:936)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.ja va:2985)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:16 31)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java :1723)
at com.mysql.jdbc.Connection.execSQL(Connection.java: 3277)
at com.mysql.jdbc.Connection.execSQL(Connection.java: 3206)
at com.mysql.jdbc.Statement.execute(Statement.java:72 7)
at
org.jboss.resource.adapter.jdbc.BaseWrapperManaged Connection.<init>(BaseWrapperManagedConnection.jav a:158)
at
org.jboss.resource.adapter.jdbc.local.LocalManaged Connection.<init>(LocalManagedConnection.java:47)
at
org.jboss.resource.adapter.jdbc.local.LocalManaged ConnectionFactory.getLocalManagedConnection(LocalM anagedConnectionFactory.java:211)
... 69 more
2010-04-28 17:06:09,266 ERROR [org.jboss.messaging.util.ExceptionUtil]
(main) org.jboss.jms.server.plugin.JDBCJMSUserManagerServ ice@100a552
startService
org.jboss.util.NestedSQLException: Could not create connection; -
nested throwable: (com.mysql.jdbc.exceptions.MySQLSyntaxErrorExcepti on:
SELECT command denied to user 'cerbere'@'193.190.100.107' for table
'user'); - nested throwable: (org.jboss.resource.JBossResourceException:
Could not create connection; - nested throwable:
(com.mysql.jdbc.exceptions.MySQLSyntaxErrorExcepti on: SELECT command
denied to user 'cerbere'@'193.190.100.107' for table 'user'))


--
TellierS
------------------------------------------------------------------------
TellierS's Profile: http://forums.novell.com/member.php?userid=7701
View this thread: http://forums.novell.com/showthread.php?t=409014