|
»
»
»
UPortal configuration problem with MySQL
|
View:
New views
12 Messages
—
Rating Filter:
Alert me
|
 |
UPortal configuration problem with MySQL
by Ahsun Ali
::
Rate this Message:
hello,
I have installed jdk 1.5 , tomcat 5.5 with pluto capability, and mysql server 5.0.37 on linux fedora for uportal 3.0.1 . i have done evry thing right except the following. when i run ant initportal every thing went right except the initiallizing database step. I encouter the following error there. can any body help me to get rid of this. Thanks WARN [main] cfg.SettingsFactory Jul/22 18:33:59.951 - Could not obtain connection metadata [java] org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (Unknown database 'portal') [java] at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:855) [java] at org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:540) [java] at org.hibernate.ejb.connection.InjectedDataSourceConnectionProvider.getConnection(InjectedDataSourceConnectionProvider.java:47) [java] at org.hibernate.cfg.SettingsFactory.buildSettings(SettingsFactory.java:84) [java] at org.hibernate.cfg.Configuration.buildSettings(Configuration.java:2073) [java] at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1298) [java] at org.hibernate.cfg.AnnotationConfiguration.buildSessionFactory(AnnotationConfiguration.java:859) [java] at org.hibernate.ejb.Ejb3Configuration.buildEntityManagerFactory(Ejb3Configuration.java:669) [java] at org.hibernate.ejb.HibernatePersistence.createContainerEntityManagerFactory(HibernatePersistence.java:132) [java] at org.springframework.orm.jpa.LocalContainerEntityManagerFactoryBean.createNativeEntityManagerFactory(LocalContainerEntityManagerFactoryBean.java:221) Down the exception .... [java] Caused by: com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Unknown database 'PortalDb' [java] at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:936) [java] at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2985) [java] at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:885) [java] at com.mysql.jdbc.MysqlIO.secureAuth411(MysqlIO.java:3436) [java] at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1247) [java] at com.mysql.jdbc.Connection.createNewIO(Connection.java:2775) [java] at com.mysql.jdbc.Connection.<init>(Connection.java:1555) [java] at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:285) [java] at org.apache.commons.dbcp.DriverConnectionFactory.createConnection(DriverConnectionFactory.java:37) [java] at org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:290) [java] at org.apache.commons.dbcp.BasicDataSource.validateConnectionFactory(BasicDataSource.java:877) [java] at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:851) [java] ... 79 more Regards Ahsun -- |
|
|
Re: UPortal configuration problem with MySQL
by Julien Gribonvald
::
Rate this Message:
Hello,
So you made a bad configuration of your database name, one error show that : "Unknown database 'portal'" and the second error show that : "Unknown database 'PortalDb'" On your database server you need to create one database, after in the configuration files you give your database name ... Also don't forget right access of the database. Ahsun Ali a écrit : > hello, > > I have installed jdk 1.5 , tomcat 5.5 with pluto capability, and mysql > server 5.0.37 on linux fedora for uportal 3.0.1 . > > i have done evry thing right except the following. when i run *ant > initportal > every thing went right except the initiallizing database step. I > encouter the following error there. can any body help me to get rid of > this. > Thanks > > * WARN [main] cfg.SettingsFactory Jul/22 18:33:59.951 - Could not > obtain connection metadata > [java] org.apache.commons.dbcp.SQLNestedException: Cannot create > PoolableConnectionFactory (Unknown database 'portal') > [java] at > org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:855) > [java] at > org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:540) > [java] at > org.hibernate.ejb.connection.InjectedDataSourceConnectionProvider.getConnection(InjectedDataSourceConnectionProvider.java:47) > [java] at > org.hibernate.cfg.SettingsFactory.buildSettings(SettingsFactory.java:84) > [java] at > org.hibernate.cfg.Configuration.buildSettings(Configuration.java:2073) > [java] at > org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1298) > [java] at > org.hibernate.cfg.AnnotationConfiguration.buildSessionFactory(AnnotationConfiguration.java:859) > [java] at > org.hibernate.ejb.Ejb3Configuration.buildEntityManagerFactory(Ejb3Configuration.java:669) > [java] at > org.hibernate.ejb.HibernatePersistence.createContainerEntityManagerFactory(HibernatePersistence.java:132) > [java] at > org.springframework.orm.jpa.LocalContainerEntityManagerFactoryBean.createNativeEntityManagerFactory(LocalContainerEntityManagerFactoryBean.java:221) > * > Down the exception .... > * > [java] Caused by: > com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Unknown database > 'PortalDb' > [java] at > com.mysql.jdbc.SQLError.createSQLException(SQLError.java:936) > [java] at > com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2985) > [java] at > com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:885) > [java] at com.mysql.jdbc.MysqlIO.secureAuth411(MysqlIO.java:3436) > [java] at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1247) > [java] at > com.mysql.jdbc.Connection.createNewIO(Connection.java:2775) > [java] at com.mysql.jdbc.Connection.<init>(Connection.java:1555) > [java] at > com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:285) > [java] at > org.apache.commons.dbcp.DriverConnectionFactory.createConnection(DriverConnectionFactory.java:37) > [java] at > org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:290) > [java] at > org.apache.commons.dbcp.BasicDataSource.validateConnectionFactory(BasicDataSource.java:877) > [java] at > org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:851) > [java] ... 79 more > > > Regards > Ahsun > > * > > * > -- > > You are currently subscribed to uportal-user@... as: julien.gribonvald@... > To unsubscribe, change settings or access archives, see http://www.ja-sig.org/wiki/display/JSG/uportal-user --- You are currently subscribed to uportal-user@... as: lists@... To unsubscribe, change settings or access archives, see http://www.ja-sig.org/wiki/display/JSG/uportal-user |
|
|
Re: UPortal configuration problem with MySQL
by Ahsun Ali
::
Rate this Message:
Thanks julien
sorry , i copy the wrong exception its Down the exception .... [java] Caused by: com.mysql.jdbc.exceptions. MySQLSyntaxErrorException: Unknown database 'portal' ...................................................................... My rdbm.properties file have the following settings with root user name that have complete access to write. hibernate.connection.driver_class=com.mysql.jdbc.Driver hibernate.connection.url=jdbc:mysql://127.0.0.1:3306/portal hibernate.connection.username=root hibernate.connection.password= hibernate.dialect=org.hibernate.dialect.MySQLDialect I donot know whats the exact reason is. Regards, Ahsun On Tue, Jul 22, 2008 at 6:08 PM, Julien Gribonvald <julien.gribonvald@...> wrote: Hello, -- |
|
|
Re: UPortal configuration problem with MySQL
by Julien Gribonvald
::
Rate this Message:
I see only three possibles problems :
- you didn't created the database with name "portal" on your mysql server - you created it and it's not configured for access and write to root on the adress 127.0.0.1 - your localhost access isn't accessible like that, check on your mysql configuration. An other solution is to try to delete the port access from the url, it's not necessary needed with some configurations. Ahsun Ali a écrit : > Thanks julien > > sorry , i copy the wrong exception its > Down the exception .... > [java] Caused by: com.mysql.jdbc.exceptions. > MySQLSyntaxErrorException: Unknown database 'portal' > ...................................................................... > > My *rdbm.properties* file have the following settings with root user > name that have complete access to write. > > hibernate.connection.driver_class=com.mysql.jdbc.Driver > hibernate.connection.url=jdbc:mysql://127.0.0.1:3306/portal > <http://127.0.0.1:3306/portal> > hibernate.connection.username=root > hibernate.connection.password= > hibernate.dialect=org.hibernate.dialect.MySQLDialect > > I donot know whats the exact reason is. > > Regards, > Ahsun > > > On Tue, Jul 22, 2008 at 6:08 PM, Julien Gribonvald > <julien.gribonvald@... <mailto:julien.gribonvald@...>> wrote: > > Hello, > > So you made a bad configuration of your database name, one error > show that : "Unknown database 'portal'" > and the second error show that : "Unknown database 'PortalDb'" > > On your database server you need to create one database, after in > the configuration files you give your database name ... > Also don't forget right access of the database. > > > Ahsun Ali a écrit : > > hello, > > I have installed jdk 1.5 , tomcat 5.5 with pluto capability, > and mysql server 5.0.37 on linux fedora for uportal 3.0.1 . > > i have done evry thing right except the following. when i run > *ant initportal > every thing went right except the initiallizing database step. > I encouter the following error there. can any body help me to > get rid of this. > Thanks > > * WARN [main] cfg.SettingsFactory Jul/22 18:33:59.951 - Could > not obtain connection metadata > [java] org.apache.commons.dbcp.SQLNestedException: Cannot > create PoolableConnectionFactory (Unknown database 'portal') > [java] at > org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:855) > [java] at > org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:540) > [java] at > org.hibernate.ejb.connection.InjectedDataSourceConnectionProvider.getConnection(InjectedDataSourceConnectionProvider.java:47) > [java] at > org.hibernate.cfg.SettingsFactory.buildSettings(SettingsFactory.java:84) > [java] at > org.hibernate.cfg.Configuration.buildSettings(Configuration.java:2073) > [java] at > org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1298) > [java] at > org.hibernate.cfg.AnnotationConfiguration.buildSessionFactory(AnnotationConfiguration.java:859) > [java] at > org.hibernate.ejb.Ejb3Configuration.buildEntityManagerFactory(Ejb3Configuration.java:669) > [java] at > org.hibernate.ejb.HibernatePersistence.createContainerEntityManagerFactory(HibernatePersistence.java:132) > [java] at > org.springframework.orm.jpa.LocalContainerEntityManagerFactoryBean.createNativeEntityManagerFactory(LocalContainerEntityManagerFactoryBean.java:221) > * > Down the exception .... > * > [java] Caused by: > com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Unknown > database 'PortalDb' > [java] at > com.mysql.jdbc.SQLError.createSQLException(SQLError.java:936) > [java] at > com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2985) > [java] at > com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:885) > [java] at > com.mysql.jdbc.MysqlIO.secureAuth411(MysqlIO.java:3436) > [java] at > com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1247) > [java] at > com.mysql.jdbc.Connection.createNewIO(Connection.java:2775) > [java] at > com.mysql.jdbc.Connection.<init>(Connection.java:1555) > [java] at > com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:285) > [java] at > org.apache.commons.dbcp.DriverConnectionFactory.createConnection(DriverConnectionFactory.java:37) > [java] at > org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:290) > [java] at > org.apache.commons.dbcp.BasicDataSource.validateConnectionFactory(BasicDataSource.java:877) > [java] at > org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:851) > [java] ... 79 more > > > Regards > Ahsun > > * > > * > -- > > You are currently subscribed to uportal-user@... > <mailto:uportal-user@...> as: > julien.gribonvald@... <mailto:julien.gribonvald@...> > To unsubscribe, change settings or access archives, see > http://www.ja-sig.org/wiki/display/JSG/uportal-user > > > > --- You are currently subscribed to uportal-user@... > <mailto:uportal-user@...> as: m.ahsun.ali@... > <mailto:m.ahsun.ali@...> > To unsubscribe, change settings or access archives, see > http://www.ja-sig.org/wiki/display/JSG/uportal-user > > > -- > > You are currently subscribed to uportal-user@... as: julien.gribonvald@... > To unsubscribe, change settings or access archives, see http://www.ja-sig.org/wiki/display/JSG/uportal-user --- You are currently subscribed to uportal-user@... as: lists@... To unsubscribe, change settings or access archives, see http://www.ja-sig.org/wiki/display/JSG/uportal-user |
|
|
Re: UPortal configuration problem with MySQL
by Ahsun Ali
::
Rate this Message:
Thanks a lot Julien.
You have an excellent eye on the bugs cause. I delete the port access from the url, as u just told me. //127.0.0.1/portal. Its now creating the tables in DB and all others. But when i start tomcat and try to access uportal http://localhost:8080/uPortal Its neither producing any exception on the page not its displaying home page rather continously loading the page from localhost. Just Hang Up Do you have any idea what may the problem NOW Regards Ahsun On Tue, Jul 22, 2008 at 6:33 PM, Julien Gribonvald <julien.gribonvald@...> wrote: I see only three possibles problems : -- |
|
|
Re: UPortal configuration problem with MySQL
by Julien Gribonvald
::
Rate this Message:
For this problem there are many possibilities.
Could you check on TOMCAT_PATH/log/catalina.out file ? you should find their all init error messages from the apps launched by tomcat. Also if you can go on the admin tomcat page you could see if the application of the portal is launched or not... if it's not launched you will have errors on catalina.out. Mainly it's the file uPortal.xml in TOMCAT_PATH/conf/Catalina/localhost/ wich should have a bad configuration... But watch on tomcat log files... Ahsun Ali a écrit : > Thanks a lot Julien. > > You have an excellent eye on the bugs cause. > I delete the port access from the url, as u just told me. > //127.0.0.1/portal <http://127.0.0.1/portal>. > Its now creating the tables in DB and all others. > But when i start tomcat and try to access uportal > http://localhost:8080/uPortal > Its neither producing any exception on the page not its displaying > home page rather continously loading the page from localhost. Just Hang Up > > Do you have any idea what may the problem NOW > > > Regards > Ahsun > > On Tue, Jul 22, 2008 at 6:33 PM, Julien Gribonvald > <julien.gribonvald@... <mailto:julien.gribonvald@...>> wrote: > > I see only three possibles problems : > - you didn't created the database with name "portal" on your mysql > server > - you created it and it's not configured for access and write to > root on the adress 127.0.0.1 <http://127.0.0.1> > - your localhost access isn't accessible like that, check on your > mysql configuration. > An other solution is to try to delete the port access from the > url, it's not necessary needed with some configurations. > > Ahsun Ali a écrit : > > Thanks julien > > sorry , i copy the wrong exception its > Down the exception .... > [java] Caused by: com.mysql.jdbc.exceptions. > MySQLSyntaxErrorException: Unknown database 'portal' > ...................................................................... > > My *rdbm.properties* file have the following settings with > root user name that have complete access to write. > > hibernate.connection.driver_class=com.mysql.jdbc.Driver > hibernate.connection.url=jdbc:mysql://127.0.0.1:3306/portal > <http://127.0.0.1:3306/portal> <http://127.0.0.1:3306/portal> > > hibernate.connection.username=root > hibernate.connection.password= > hibernate.dialect=org.hibernate.dialect.MySQLDialect > > I donot know whats the exact reason is. > > Regards, > Ahsun > > > On Tue, Jul 22, 2008 at 6:08 PM, Julien Gribonvald > <julien.gribonvald@... > <mailto:julien.gribonvald@...> > <mailto:julien.gribonvald@... > <mailto:julien.gribonvald@...>>> wrote: > > Hello, > > So you made a bad configuration of your database name, one > error > show that : "Unknown database 'portal'" > and the second error show that : "Unknown database 'PortalDb'" > > On your database server you need to create one database, > after in > the configuration files you give your database name ... > Also don't forget right access of the database. > > > Ahsun Ali a écrit : > > hello, > > I have installed jdk 1.5 , tomcat 5.5 with pluto > capability, > and mysql server 5.0.37 on linux fedora for uportal 3.0.1 . > > i have done evry thing right except the following. when > i run > *ant initportal > every thing went right except the initiallizing > database step. > I encouter the following error there. can any body help > me to > get rid of this. > Thanks > > * WARN [main] cfg.SettingsFactory Jul/22 18:33:59.951 - > Could > not obtain connection metadata > [java] org.apache.commons.dbcp.SQLNestedException: > Cannot > create PoolableConnectionFactory (Unknown database > 'portal') > [java] at > > org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:855) > [java] at > > org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:540) > [java] at > > org.hibernate.ejb.connection.InjectedDataSourceConnectionProvider.getConnection(InjectedDataSourceConnectionProvider.java:47) > [java] at > > org.hibernate.cfg.SettingsFactory.buildSettings(SettingsFactory.java:84) > [java] at > > org.hibernate.cfg.Configuration.buildSettings(Configuration.java:2073) > [java] at > > org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1298) > [java] at > > org.hibernate.cfg.AnnotationConfiguration.buildSessionFactory(AnnotationConfiguration.java:859) > [java] at > > org.hibernate.ejb.Ejb3Configuration.buildEntityManagerFactory(Ejb3Configuration.java:669) > [java] at > > org.hibernate.ejb.HibernatePersistence.createContainerEntityManagerFactory(HibernatePersistence.java:132) > [java] at > > org.springframework.orm.jpa.LocalContainerEntityManagerFactoryBean.createNativeEntityManagerFactory(LocalContainerEntityManagerFactoryBean.java:221) > * > Down the exception .... > * > [java] Caused by: > com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: > Unknown > database 'PortalDb' > [java] at > > com.mysql.jdbc.SQLError.createSQLException(SQLError.java:936) > [java] at > com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2985) > [java] at > com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:885) > [java] at > com.mysql.jdbc.MysqlIO.secureAuth411(MysqlIO.java:3436) > [java] at > com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1247) > [java] at > com.mysql.jdbc.Connection.createNewIO(Connection.java:2775) > [java] at > com.mysql.jdbc.Connection.<init>(Connection.java:1555) > [java] at > > com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:285) > [java] at > > org.apache.commons.dbcp.DriverConnectionFactory.createConnection(DriverConnectionFactory.java:37) > [java] at > > org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:290) > [java] at > > org.apache.commons.dbcp.BasicDataSource.validateConnectionFactory(BasicDataSource.java:877) > [java] at > > org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:851) > [java] ... 79 more > > > Regards > Ahsun > > * > > * > -- > You are currently subscribed to > uportal-user@... > <mailto:uportal-user@...> > <mailto:uportal-user@... > <mailto:uportal-user@...>> as: > julien.gribonvald@... > <mailto:julien.gribonvald@...> > <mailto:julien.gribonvald@... > <mailto:julien.gribonvald@...>> > > To unsubscribe, change settings or access archives, see > http://www.ja-sig.org/wiki/display/JSG/uportal-user > > > > --- You are currently subscribed to > uportal-user@... > <mailto:uportal-user@...> > <mailto:uportal-user@... > <mailto:uportal-user@...>> as: > m.ahsun.ali@... <mailto:m.ahsun.ali@...> > <mailto:m.ahsun.ali@... <mailto:m.ahsun.ali@...>> > > To unsubscribe, change settings or access archives, see > http://www.ja-sig.org/wiki/display/JSG/uportal-user > > > -- > > You are currently subscribed to uportal-user@... > <mailto:uportal-user@...> as: > julien.gribonvald@... <mailto:julien.gribonvald@...> > To unsubscribe, change settings or access archives, see > http://www.ja-sig.org/wiki/display/JSG/uportal-user > > > > --- You are currently subscribed to uportal-user@... > <mailto:uportal-user@...> as: m.ahsun.ali@... > <mailto:m.ahsun.ali@...> > To unsubscribe, change settings or access archives, see > http://www.ja-sig.org/wiki/display/JSG/uportal-user > > > -- > > You are currently subscribed to uportal-user@... as: julien.gribonvald@... > To unsubscribe, change settings or access archives, see http://www.ja-sig.org/wiki/display/JSG/uportal-user --- You are currently subscribed to uportal-user@... as: lists@... To unsubscribe, change settings or access archives, see http://www.ja-sig.org/wiki/display/JSG/uportal-user |
|
|
Re: UPortal configuration problem with MySQL
by Ahsun Ali
::
Rate this Message:
Hello,
I have seen the catalina.out file Its showing the following Exception. Please help me to find out where the problem lies. Exception in thread "DLM Fragment Activator" java.lang.NoSuchMethodError: org.w3c.dom.Element.setIdAttribute(Ljava/lang/String;Z)V at org.jasig.portal.layout.dlm.RDBMDistributedLayoutStore.getStructure(RDBMDistributedLayoutStore.java:1828) at org.jasig.portal.layout.simple.RDBMUserLayoutStore.createLayout(RDBMUserLayoutStore.java:494) at org.jasig.portal.layout.simple.RDBMUserLayoutStore.getUserLayout(RDBMUserLayoutStore.java:1843) at org.jasig.portal.layout.dlm.RDBMDistributedLayoutStore._safeGetUserLayout(RDBMDistributedLayoutStore.java:529) at org.jasig.portal.layout.dlm.RDBMDistributedLayoutStore.getFragmentLayout(RDBMDistributedLayoutStore.java:607) at org.jasig.portal.layout.dlm.FragmentActivator.loadLayout(FragmentActivator.java:314) at org.jasig.portal.layout.dlm.FragmentActivator.activateFragments(FragmentActivator.java:107) at org.jasig.portal.layout.dlm.RDBMDistributedLayoutStore$1.run(RDBMDistributedLayoutStore.java:199) Even the method exists. Regards Ahsun On Tue, Jul 22, 2008 at 8:20 PM, Julien Gribonvald <julien.gribonvald@...> wrote: For this problem there are many possibilities.
-- |
