Forum Problems Installing LAMS: Re: Re: Re: Re: Re: Re: Re: Re: Re: Lams URL

Write your message and turn on the Attach radio button. Click post and when it asks you for the attachment, upload your file as usual. When you get to the screen after the attachment screen (ie once the file is uploaded), click the back button in your browser. You should be able to upload another file. You can keep attaching and hitting back multiple times.

I've never tried it, but Ernie tells me it works!


I've had a look at the server log, and there is a problem with JBoss communicating with MySQL.

Can you check that your MySQL server is running?

Have a look at your /usr/local/jboss-4.0.2/server/default/deploy/mysql-ds.xml file. In this file is the definition of the database connection. Do you have this file?

In file is the username and password that is used to connect to the database. This is the username and password for the database, rather than a LAMS login.

Try running the mysql command line client and log in as that user. Then switch to the lams2 database and try selecting data from the lams_configuration table. Does this work?

Fiona

To run the command line client, you should get something like this:

fiona-malikoffs-computer:~ fiona$ mysql -u lams2 -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 73 to server version: 5.0.27-standard

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> use lams2;
Reading table information for completion of table and column Database changed

mysql> select * from lams_configuration;
+-----------------------------+----------------------------------------------------------------------+
| config_key | config_value |
+-----------------------------+----------------------------------------------------------------------+
| ServerURL | http://localhost:8080/lams/ |
| Version | 2.0 |
| TempDir | /var/opt/lams/temp |
| DumpDir | /var/opt/lams/dump |
| EARDir | /usr/local/jboss-4.0.2/server/default/deploy/lams.ear |
| SMTPServer | mail.lib.mq.edu.au |
| LamsSupportEmail | lams_support@melcoe.mq.edu.au |
| ContentRepositoryPath | /var/opt/lams/repository |
| UploadFileMaxSize | 1048576 |
| UploadLargeFileMaxSize | 10485760 |
| UploadFileMaxMemorySize | 4096 |
| ExecutableExtensions | .bat,.bin,.com,.cmd,.exe,.msi,.msp,.ocx,.pif,.scr,.sct,.sh,.shs,.vbs |
| UserInactiveTimeout | 86400 |
| UseCacheDebugListener | false |
| CleanupPreviewOlderThanDays | 7 |
| AuthoringActivitiesColour | true |
| AuthoringClientVersion | 2.0.200703151612 |
| MonitorClientVersion | 2.0.200703151612 |
| LearnerClientVersion | 2.0.200703151612 |
| ServerVersionNumber | 2.0.200703151612 |
| ServerLanguage | en_AU |
| ServerPageDirection | LTR |
| DictionaryDateCreated | 2006-12-08 |
| HelpURL | http://wiki.lamsfoundation.org/display/lamsdocs/ |
| XmppDomain | shaun.melcoe.mq.edu.au |
| XmppConference | conference.shaun.melcoe.mq.edu.au |
| XmppAdmin | admin |
| XmppPassword | wildfire |
| DefaultFlashTheme | default |
| DefaultHTMLTheme | defaultHTML |
| AllowDirectLessonLaunch | false |
| LAMS_Community_enable | false |
+-----------------------------+----------------------------------------------------------------------+
32 rows in set (0.10 sec)

mysql>

Posted by Fiona Malikoff

Now I have:

---In "lams.properties---

# The port through which you want jboss to run
LAMS_PORT=8080

# The url you intend to use to run LAMS
# NOTE: Make sure the URL ends with a "/" or you will have problems running LAMS
SERVER_URL=http://localhost:8080/lams/


# The home directory of jboss-4.0.2
JBOSS_DIR=/usr/local/jboss-4.0.2

# The directory that contains your JDK. (Must be 1.5 or higher)
JDK_DIR=/usr/lib/jvm/java-6-sun-1.6.0.00

# The location of your mysql executable (Must be 5.0 or higher)
SQL_DIR=/usr/bin

# The URL that you jdbc driver will be running through
SQL_URL=jdbc:mysql://hilbert.mat.uc.pt/${DB_NAME}?characterEncoding=utf8

--- in mysql-ds.xml ---

connection-url
jdbc:mysql://hilbert.mat.uc.pt:3306/lams2
connection-url

And now LAMS is (!?) installed sucesfully ... not quite :(

"java.lang.OutOfMemoryError: GC overhead limit exceeded"

And the JBOSS server is out

My system is a Linux/Debian 2.6.18-3-686-bigmem #1 SMP, box with a Pentium 4, 3Ghz, 2GB RAM.

In attachment the new server.log

Posted by Pedro Quaresma

Posted by Pedro Quaresma

I forgot to modify the memory settings when I (re)installed the JBOSS 4.0.2 (after uninstalling JBOSS 4.0.5).

Let me ask two other things:

The localhost:8080 setting in lams.properties affects in any way the server capability? I want to link LAMS and Moodle, and I want the the Moodle server be available from other computers.

The setting (in lams_configuration)

SMTPServer | mail.lib.mq.edu.au

shouldn't be changed to a local smtpserver?


Many (many, many, many :) thanks for all your help.

Posted by Pedro Quaresma

(1) The localhost:8080 in lams.properties: you should change that to use your "real" server name ie hilbert.mat.uc.pt

The lams.properties file is only used by the install - it isn't used while LAMS is running. So changing it in the lams.properties file now won't change how LAMS behaves. But you should change it so that you have a lams.properties files that is correct, should you ever have to re-install LAMS.

As you have already discovered, the configuration details used when LAMS is running is kept in the lams_configuration table in the database and can be updated via the sysadmin menu. You need to make sure that the setting there for the ServerURL is correct. This will need to be the same address that you put into the Moodle module to integrate the two systems, so you are right - localhost:8080 won't work!

The instructions for changing the serverURL setting are on the page Changing Server Ports for LAMS. I wrote this page yesterday to summarise all the advice we have been giving about changing the port that LAMS runs on - given the number of postings on this subject!

(2) The setting in the SMTPServer field should be your own smtpserver, or blank. We don't actually use it at the moment but we have plans to use it in the future.

(3) The instructions for linking LAMS and Moodle are available on LAMS v2.0 Integration Setup Step-by-Step Guide. The screendumps on this page say localhost, but that is only because they were done on my laptop and no one ever accesses that from another machine! In your case, it would be hilbert.mat.uc.pt and whatever servername you use for Moodle.

Fiona

Posted by Fiona Malikoff