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


 
Search: 

4: Re: Upgrading LAMS 2.3.1 from 2.3 using the Windows patch release installer - mysql connection refused
In response to 1 02/17/10 06:30 AM
[ 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

5: Re: Re: Upgrading LAMS 2.3.1 from 2.3 using the Windows patch release installer - mysql connection refused
In response to 4 02/17/10 05:14 PM
[ 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

6: Re: Re: Re: Upgrading LAMS 2.3.1 from 2.3 using the Windows patch release installer - mysql connection refused
In response to 5 02/18/10 01:40 AM
[ 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

Attachments:
7: Re: Re: Re: Re: Upgrading LAMS 2.3.1 from 2.3 using the Windows patch release installer - mysql connection refused
In response to 6 02/20/10 10:19 AM
[ 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

Reply to first post on this page
Back to Problems Installing LAMS