How to use Mysql 5 as jboss-portal-2.6.4-bundled database?

[maxi0361]

I followed this guide http://docs.jboss.org/jbportal/v2.0RC/user-guide/en/html/installation.html
I tried using mysql-ds.xml and putting its library but didn't work.
I have deleted hsql-ds.xml.

Is the configuration different if I am using bundled version?

[porcho]

Well, I'm new to JBoss Portal...but, AFAIK, you should've deleted portal-hsqldb-ds.xml.

Those who know JBP better correct me if I wrong, please! :-)

[maxi0361]

That means I should keep hsql-ds.xml, remove portal-hsql-ds.xml.
and then add mysql-ds.xml??

[peterj]

Yes.

[peterj]

By the way, the reference guide contains detailed instructions on configuring the portal to use mysql.

[soumakchatterjee]

I used the reference guide to configure mysql as the portal database and also removed the portal-hsqldb-ds.xml file.

Checking in the MySQL DB the tables have been created.

On trying to access the Portal URL it throws a 'null pointer exception' -- any hints on where I should look at?

The Portal is running perfectly with the HSQLDB.

Soumak

[soumakchatterjee]

I restarted the servers, checked my MySQL, created a new database with all access privileges again. This time there is no 'Null pointer exception' but the home page only shows the top panel and the three tabs. Also, I cannot login.

My environment -

JBoss Portal Version - 2.6.4
Did you get Portal from CVS? - Downloaded the AS + Portal Bundle
Database Vendor and Version - MySQL 5
OS Platform - Windows XP 5.1 x86

Any help?

[peterj]

First, you should have started a new post and not appended to an existing post.

From what you are describing, it would appear that the access control is set up such that you do not have access to any of the portlets. Is the login link visible? If you login as admin do the portlets show up?

What commands did you use to create the database and user in the database? When you wiped out the database, did you also remove the server/xxx/tmp, server/xxx/data and server/xxx/work directories? Are there any exceptions showing up in the log when you access the portal's home page?

[maxi0361]

"PeterJ" wrote:
By the way, the reference guide contains detailed instructions on configuring the portal to use mysql.

I want to know where is the reference guide.
maybe I am too blind to find it. please tell me.
Thank you so much

[maxi0361]

"maxi0361" wrote:

"PeterJ" wrote:
By the way, the reference guide contains detailed instructions on configuring the portal to use mysql.

I want to know where is the reference guide.
maybe I am too blind to find it. please tell me.
Thank you so much

I just find it. Thank you ^^

[maxi0361]

"maxi0361" wrote:
That means I should keep hsql-ds.xml, remove portal-hsql-ds.xml.
and then add mysql-ds.xml??

does this means JBoss portal is running on mysql, but JBoss AS is still running on Hsql?
Can I set both JNDI to use Mysql?

[peterj]

There are several services within JBossAS that use a database - messaging, uuid generation, etc. If you want, you can change all of those services to use MySQL. But unless you are actually making use of those services, it is usually easier to just leave them using Hypersonic.

JNDI does not use a database.