From: Tomas G. <to...@pr...> - 2004-10-15 06:43:01
|
The error log indicates that you would still hava one entry that says "EjbcaDS" instead of "java:/EjbcaDS" somewhere. The server log (jboss_home/server/default/log/server.log) would probably give good notice exactly where it is. The error 'EjbcaDS not bound' means that ejbca tries to get a datasource called EjbcaDS from JBoss, but JBoss does not know of any datasource called EjbcaDS. Cheers, Tomas Peter Param wrote: > Thank you. I fixed that and now jboss loads without errors. However.... > > When I run install.sh from ejbca I still get an error when it attempts to > create > a CA. Logs as follows: > > <snip> > > You have entered the following data : > > CA short name : AdminCA1 > Distinguished Name CA : CN=AdminCA1,O=SVMHS,C=AU > Keysize of the CA : 2048 > Validity in days for the CA : 3650 > Policy id of the CA : 2.5.29.32.0 > Computer name of CA server : menelik.stvincents.com.au > Distinguished Name of the SSL server certificate : > CN=menelik.stvincents.com.au,O=SVMHS,C=AU > Password for the super administrators keystore :<password> > Is this correct ( Yes/No/Exit ) :Yes > > The installation will now start, please wait ..... > > > Initializing CA > Generating rootCA keystore: > DN: CN=AdminCA1,O=SVMHS,C=AU > Keysize: 2048 > Validity (days): 3650 > Policy ID: 2.5.29.32.0 > Initalizing Temporary Authorization Module. > Creating CA... > org.jboss.tm.JBossTransactionRolledbackException: null; CausedByException > is: > null; CausedByException is: > EjbcaDS not bound; CausedByException is: > null; CausedByException is: > EjbcaDS not bound; CausedByException is: > null; CausedByException is: > null; CausedByException is: > EjbcaDS not bound; CausedByException is: > null; CausedByException is: > EjbcaDS not bound; nested exception is: > javax.ejb.EJBException: null; CausedByException is: > null; CausedByException is: > EjbcaDS not bound; CausedByException is: > null; CausedByException is: > EjbcaDS not bound; - nested throwable: (javax.ejb.EJBException: null; > CausedByException is: > null; CausedByException is: > EjbcaDS not bound; CausedByException is: > null; CausedByException is: > EjbcaDS not bound) > > An error occurered when trying to initialize CA. > > </snip> > > any advise is greatly appreciated! > > cheers > > Peter > >>>>Tomas Gustavsson <to...@pr...> 10/14/04 04:53PM >>> > > > Did you do an 'ant deploy' after changing the references in XML-files? > Specifically src/ra/META-INF/jbosscmp-jdbc.xml must have the correct > datasource > and the correct database. I think you are using MySQL right? I think it tries > to > create the table in DefaultDS perhaps instead of in your MySQL. The > sql-command: > > CREATE TABLE ADMINPREFERENCESDATA (id VARCHAR(250) BINARY NOT NULL, data > LONGBLOB, CONSTRAINT PK_ADMINPREFERENCESDATA PRIMARY KEY (id)); > > executes nicely in my MySQL database without errors. > > Cheers, > Tomas > > Peter Param wrote: > >>>Hi, you error states that the datasource is not properly configured. >> >> >>>Did you perhaps enter only EjbcaDS instead of java:/EjbcaDS once? In that >> >>case you have >>to search all xml files for instances of EjbcaDS and change it to >>java:/EjbcaDS. >> >>I have ..but i still get errors running up the Jboss app. Its unable to >>create the table ADMINPREFERENCESDATA , the logs say the following: >> >>9:13:29,382 ERROR [EntityContainer] Starting failed >>jboss.j2ee:jndiName=local/EndEntityProfileData,service=EJB >>org.jboss.deployment.DeploymentException: Error while creating table >>ADMINPREFERENCESDATA; - nested throwable: (java.sql.SQLException: > > Unexpected > >>token: BINARY in statement [CREATE TABLE ADMINPREFERENCESDATA (id > > VARCHAR(250) > >>BINARY NOT NULL, data LONGBLOB, CONSTRAINT PK_ADMINPREFERENCESDATA PRIMARY > > KEY > >>(id))]) >> at >> > > org.jboss.ejb.plugins.cmp.jdbc.JDBCStartCommand.createTable(JDBCStartCommand.java:497) > >> at >> > > org.jboss.ejb.plugins.cmp.jdbc.JDBCStartCommand.execute(JDBCStartCommand.java:186) > >> at >> > > org.jboss.ejb.plugins.cmp.jdbc.JDBCStoreManager.startStoreManager(JDBCStoreManager.java:492) > >> at >> > > org.jboss.ejb.plugins.cmp.jdbc.JDBCStoreManager.start(JDBCStoreManager.java:396) > >> at >> > > org.jboss.ejb.plugins.CMPPersistenceManager.start(CMPPersistenceManager.java:147) > >> at >>org.jboss.ejb.EntityContainer.startService(EntityContainer.java:337) >> at >> > > org.jboss.system.ServiceMBeanSupport.jbossInternalStart(ServiceMBeanSupport.java:271) > >> ^ >> | >> | // many, many lines later! >> | >> v >>Caused by: java.sql.SQLException: Unexpected token: BINARY in statement >>[CREATE TABLE ADMINPREFERENCESDATA (id VARCHAR(250) BINARY NOT NULL, data >>LONGBLOB, CONSTRAINT PK_ADMINPREFERENCESDATA PRIMARY KEY (id))] >> at org.hsqldb.Trace.getError(Unknown Source) >> at org.hsqldb.jdbcResultSet.<init>(Unknown Source) >> at org.hsqldb.jdbcConnection.executeStandalone(Unknown Source) >> at org.hsqldb.jdbcConnection.execute(Unknown Source) >> at org.hsqldb.jdbcStatement.fetchResult(Unknown Source) >> at org.hsqldb.jdbcStatement.executeUpdate(Unknown Source) >> at >> > > org.jboss.resource.adapter.jdbc.WrappedStatement.executeUpdate(WrappedStatement.java:281) > >> at >> > > org.jboss.ejb.plugins.cmp.jdbc.JDBCStartCommand.createTable(JDBCStartCommand.java:484) > >> ... 123 more >> >>cheers >> >>Peter >> >> >> >>********************************************************************** >>This email and any files transmitted with it are confidential and >>intended solely for the use of the individual or entity to whom they >>are addressed. If you have received this email in error please notify >>the system manager. >> >>This footnote also confirms that this email message has been >>virus scanned and although no viruses were detected by the system, >>St Vincent's Hospital accepts no liability for any consequential >>damage resulting from email containing any computer viruses. >> >>********************************************************************** > > > > > ********************************************************************** > This email and any files transmitted with it are confidential and > intended solely for the use of the individual or entity to whom they > are addressed. If you have received this email in error please notify > the system manager. > > This footnote also confirms that this email message has been > virus scanned and although no viruses were detected by the system, > St Vincent's Hospital accepts no liability for any consequential > damage resulting from email containing any computer viruses. > > ********************************************************************** |