Thanks for the reactions. 

I started the installation all over again following the next steps.

Downloaded mysql-5.0.19-win32 AND installed MySQL.
Created database jbossportal.
Created user jboss with password portal
Assigned all priveleges to this user.

Downloaded jboss-4.0.4.CR2.zip
Extracted the zip file.
Tested whether AS is working.

Downloaded jboss-portal-2.2.1RC3.zip
Extracted the directory jboss-portal.sar into /server/deploy

Removed the portal-*-ds.xml files from the /deploy directory and created the 
portal-mysqld-ds.xml file in the /deploy directory.
 
<?xml version="1.0" encoding="UTF-8"?>

  <local-tx-datasource>
<!-- <jndi-name>DefaultDS</jndi-name> -->
    <jndi-name>DefaultDS</jndi-name>
    
<connection-url>jdbc:mysql://localhost:3306/jbossportal?useServerPrepStmts=false&amp;jdbcCompliantTruncation=false</connection-url>
    <driver-class>org.gjt.mm.mysql.Driver</driver-class>
    <user-name>jboss</user-name>
    portal
  </local-tx-datasource>


Changed the /bin/mysql.ini file and removed the line
# sql-mode="STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"

Downloaded the mysql-connector-java-3.1.12.zip.
Copied both the mysql-connector-java-3.1.12-bin-g.jar and the 
mysql-connector-java-3.1.12-bin.jar to the /deploy/lib directory. Cause it is 
not clear to me which one should be copied.

Check whether MySQL server is running.

Then start the jboss using /bin/run.bat.

I checkecd whether the Schema is created using the MySQL Administrator tool. No 
schema.

I went through the track files searching for errors and found these errors:


13:42:48,354 ERROR [LocaleUtils] Locale name null or empty, ignoring

13:43:00,244 WARN  [ServiceController] Problem starting service 

jboss:service=KeyGeneratorFactory,type=HiLo
org.jboss.deployment.DeploymentException: Error while checking if table aleady 
exists 

13:43:00,260 WARN  [ServiceController] Problem starting service 

jboss.mq:service=StateManager
org.jboss.mq.SpyJMSException: Error creating connection to the database.; - 
nested 

throwable: (org.jboss.util.NestedSQLException: Unexpected throwable while 
trying to create a 


I am stuck. Do I need to set references to Jboss in any environment variables 
like classpath, java_home, jboss_home, ... ?

regards,
Danny 


View the original post : 
http://www.jboss.com/index.html?module=bb&op=viewtopic&p=3935768#3935768

Reply to the post : 
http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=3935768


-------------------------------------------------------
This SF.Net email is sponsored by xPML, a groundbreaking scripting language
that extends applications into web and mobile media. Attend the live webcast
and join the prime developer group breaking into this new coding territory!
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=110944&bid=241720&dat=121642
_______________________________________________
JBoss-user mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/jboss-user

Reply via email to