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

By: Pedro Quaresma

[ Reply | Forward ]

Still no luck :(

I uninstalled /usr/local/jboss-4.0.5.

I have now:

JBOSS_DIR=/usr/local/jboss-4.0.2
JDK_DIR=/usr/lib/jvm/java-6-sun-1.6.0.00
SQL_DIR=/usr/bin

mysql Ver 14.12 Distrib 5.0.24a, for pc-linux-gnu (i486) using readline 5.2

java version "1.6.0"
Java(TM) SE Runtime Environment (build 1.6.0-b105)
Java HotSpot(TM) Client VM (build 1.6.0-b105, mixed mode, sharing)

mysql Ver 14.12 Distrib 5.0.32, for pc-linux-gnu (i486) using readline 5.2

LAMS 2.0 - Learning Activity Management System (binary package)

I'm sending the Logs files.

Thank you for all your support.

Posted by Pedro Quaresma

By: Pedro Quaresma

[ Reply | Forward ]

Sorry I only send one of the attachements

Posted by Pedro Quaresma

By: Pedro Quaresma

[ Reply | Forward ]

It seems that we can only attach one file per message. Is this true or it is my inability to do otherwise?

Posted by Pedro Quaresma

By: Fiona Malikoff

[ Reply | Forward ]

Normally, yes it is one per post. But Ernie told me a trick once.

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

By: Pedro Quaresma

[ Reply | Forward ]

The problem was in the server name localhost against hilbert.mat.uc.pt.

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

By: Pedro Quaresma

[ Reply | Forward ]

The attachement fails to be sent, I will try again.

Posted by Pedro Quaresma

By: Pedro Quaresma

[ Reply | Forward ]

It is working now :)

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

By: Fiona Malikoff

[ Reply | Forward ]

Glad to hear it is working!

(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