JBoss Portal + JBoss AS 4.0.3SP1 question regarding MySQL

[mathuran]

Before I ask the main question, all I need to do with this bundle is unzip and place in the desired folder, correct?

OK, I also downloaded JBoss Portal Forums, unzipped and placed the portal-forums.ear folder under the /server/default/deploy directory. Now where do I need to be placing the MySQL JDBC connector? Or is it already apprpriately placed in this bundle? Also, do I need to place the datasource file under /server/default/deploy...?

I start the server via a terminal with the command sh run.sh and 2 min later I have the JBoss AS up and running....

Once I log into the Portal and start creating user IDs, where is all this information stored? The MySQL database is not being populated at all!! I don't know what is going on and how I can import users from my old database to the new one for the forums....

Please help!

[bdaw]

Did you check docs for the information you are looking for?

http://docs.jboss.com/jbportal/v2.2/user-guide/en/html/installation.html
http://www.jboss.com/products/jbossportal/docs

There is a migration tool under developement but already usable:
http://wiki.jboss.org/wiki/Wiki.jsp?page=MigrationFromPortal20ToPortal22
Any feedback on this will be valuable.

Forums Portlet DB schema should be the same in 2.0 and 2.2 so migration doesn't cover it. You should simply move forums tables ("jbp_forums_*") into 2.2 database. Just remember to backup your DB before playing with this.

[mathuran]

I will be migrating from Novell exteNd to JBoss, so I need to migrate my database created under that environment to the JBoss one. How do I do that?

[mjohnpeter]

you have to do two steps

1 copy msql-ds.xml from(C:\jboss-4.0.3SP1\docs\examples\jca\)
and past it in to deploy dir..
you have to spcifie the databse propertices
example

<?xml version="1.0" encoding="UTF-8"?>

<!-- $Id: mysql-ds.xml,v 1.3.2.1 2004/12/01 11:46:00 schrouf Exp $ -->
<!-- Datasource config for MySQL using 3.0.9 available from:
http://www.mysql.com/downloads/api-jdbc-stable.html
-->


<local-tx-datasource>
<jndi-name>PortalDS</jndi-name>
<connection-url>jdbc:mysql://localhost:3306/jbossportal</connection-url>
<driver-class>com.mysql.jdbc.Driver</driver-class>
<user-name>root</user-name>
*
<exception-sorter-class-name>org.jboss.resource.adapter.jdbc.vendor.MySQLExceptionSorter</exception-sorter-class-name>
<!-- sql to call when connection is created
<new-connection-sql>some arbitrary sql</new-connection-sql>
-->
<!-- sql to call on an existing pooled connection when it is obtained from pool
<check-valid-connection-sql>some arbitrary sql</check-valid-connection-sql>
-->

<!-- corresponding type-mapping in the standardjbosscmp-jdbc.xml (optional) -->

<type-mapping>mySQL</type-mapping>

</local-tx-datasource>




2 you have to make two chaneges in (C:\jboss-4.0.3SP1\server\default\conf)
standardjbosscmp-jdbc.xml

1)

<datasource-mapping>java:/MySqlDS</datasource-mapping>




2)


</type-mapping>

<type-mapping>
mySQL


regards
Peter