Forum Problems Installing LAMS: Upgrading LAMS 2.3.1 from 2.3 using the Windows patch release installer - mysql connection refused

By: Ernie Ghiglione

[ Reply | Forward ]

Hi Katie,

The upgrader gets the username and passwd for MySQL from the Windows Registry.

These entries get stored in the registry when you first installed LAMS. So if you changed the password for MySQL since then, go into the registry and change the password there as well.

Thanks,

Ernie

Posted by Ernie Ghiglione

By: Ernie Ghiglione

[ Reply | Forward ]

To change the registry entry have a look at the instructions here:

http://is.gd/8x6T4

See the "Update Registry: Windows only" section

Thanks,

Ernie

Posted by Ernie Ghiglione

By: Katie Selvaraj

[ Reply | Forward ]

Thank you for your reply, Ernie.

I checked the registry; the username and password are the correct. In fact, it has not changed since the first install of LAMS.

The only difference is Mysql is listening in port 3307. But, the windows installer is picking up the correct mysql host and port number (3307). I have been able to work with LAMS 2.3 successfully with mysql listening at port 3307.

Any pointers would be helpful.

Thank you,
Katie

Posted by Katie Selvaraj

By: Luke Foxton

[ Reply | Forward ]

Hi Katie,

In jboss-4.0.2/server/default/deploy/ you will find a file called mysql-ds.xml. This file holds the connection properties lams uses to connect to the db.

In here you should find a couple of nodes like this:

<connection-url>jdbc:mysql://localhost:3306/lams</connection-url>

This is the mysql url, make sure the port/host and db are correct here, if not change them.

Also, there are rows like this

<user-name>lams</user-name>
<password>lamsdemo</password>

Also make sure these are correct to connect to your db.

If they are correct then lams should be connecting to the database through jdbc.

Luke

Posted by Luke Foxton

By: Katie Selvaraj

[ Reply | Forward ]

Hi Luke,
I am upgrading from 2.3 to 2.3.1 using the patch release Windows installer.

LAMS 2.3 works perfectly with the mysql user name and password specified in the mysql-ds.xml.

It is the installer which gives the Connection refused error (attached is the word document with the error). The windows registry and the installer.properties has the correct username and password.

TEMP=C:/DOCUME~1/ADMINI~1.SYS/LOCALS~1/Temp/2
URL=http://localhost:8080/lams/
INSTDIR=C:/lams/
TEMPDIR=C:/lams/temp
DUMPDIR=C:/lams/dump
EARDIR=C:/lams/jboss-4.0.2/server/default/deploy/lams.ear
DEPLOYDIR=C:/lams/jboss-4.0.2/server/default/deploy
TOMCATDIR=C:/lams/jboss-4.0.2/server/default/deploy/jbossweb-tomcat55.sar
BINDIR=C:/lams/jboss-4.0.2/bin
JDK_DIR_UNIX_SLASH=C:/Program Files/Java/jdk1.5.0_09
REPOSITORYDIR=C:/lams/repository
LOCALE=en_AU
LOCALE_DIRECTION=LTR
WILDFIRE_DOMAIN=localhost
WILDFIRE_CONFERENCE=conference.localhost
WILDFIRE_USER=katie_selvaraj
WILDFIRE_PASS=wash$2007
MYSQL_HOST=localhost
MYSQL_PORT=3307
DB_NAME=lams2
DB_USER=lams2
DB_PASS=vine@2009
DICTIONARY_DATE=2008-12-05
SERVER_VERSION=2.2.0.200812050000
LAMS_VERSION=2.3
LAMS_PORT=8080
LAMS_USER=sysadmin
LAMS_PASS=sysadmin

Please help.

Thank you,
Katie

Posted by Katie Selvaraj

By: Katie Selvaraj

[ Reply | Forward ]

Got it working.

Uninstalled LAMS and installed version 2.3 and applied the patch releases 2.3.1, 2.3.2 and 2.3.3

Also changed the mysql port to the default port 3306. Not sure which got it working.

Thank you for your support. LAMS is a great product.

Thank you.

Regards,
Katie

Posted by Katie Selvaraj