Forum Problems Installing LAMS: Re: problems with "ant deploy-tools" and deploy Lams


 
Search: 

10: Re: problems with "ant deploy-tools" and deploy Lams
In response to 8 03/02/13 03:43 AM
[ Reply | Forward ]
I am happy to hear you made it run!

Still, if database is UTF8 and the file is UTF8, you should not need to change the description field - it should just load the way it was. If there is something wrong with DB encoding, you may (or may not) encounter problems with further work with LAMS.
Can you still send the output of
SHOW VARIABLES
command while using "lams" database?


There is no JBoss log attached, though you mentioned it.
The MySQL error file says there are some problems with databases, but it is difficult for me to figure out what exactly...
On one hand all shut downs seem to be from normal causes, not failures, but there are reports of corrupted files, InnoDB engine issues etc.
Is it possible for you to drop everything there, ideally reinstall MySQL from a scratch?
Are you using default or custom settings file? Can you post it? Did you add these entries:
http://wiki.lamsfoundation.org/display/lamsdocs/Installing+MySQL+on+Windows+for+LAMS


Now, I am not sure if I am answering exactly the question you asked, but:
In LAMS we have got an automatic patching system
http://wiki.lamsfoundation.org/display/lams/Autopatch
When LAMS is build via Ant, basic DB structure is created.
When JBoss starts up, it checks what SQL patch files exist and whether they have been already installed. So it goes for example:
- I see patch patch02040008.sql. Has it been already installed? Yes. Carry on.
- I see patch patch02040009.sql. Has it been already installed? No. Apply!
- I see patch patch02040010.sql. Has it been already installed? No. Apply!
etc.
Naming of patch files is very important here.
At the end of this process, DB has the structure LAMS can work with.
For example, compare lams_lesson table from create_lams_11_tables.sql and what is happening with it in patch02040010.sql. The original table structure was altered, because new LAMS code uses these new columns.

This mechanism is very good for distributing new versions of LAMS. Users do not have to alter DB tables manually. They just receive new JARs, including lams.jar, which contains SQL patch files and whole update process is done automatically during JBoss start up.

On the other hand, patch files should not exist for major release versions like 2.4.0. We should have merged them with the basic create_lams_11_tables.sql file and add patch files as development goes. This must have been overlooked and we will pay more attention to this when next release is done (hopefully soon!)

Posted by Marcin Cieslak

11: Re: Re: problems with "ant deploy-tools" and deploy Lams
In response to 10 03/05/13 08:45 PM
[ Reply | Forward ]
I'm sorry,but the system failed to upload the jboss log file when i tried to.The output of SHOW VARIABLES using lams database are as follows:
Variable_name value
character_set_connection utf8
character_set_client utf8
character_set_database utf8
character_set_filesystem binary
character_set_results utf8
character_set_server utf8
character_set_system utf8
......

I'm sorry to reply to you so late,because of my personal affairs.Thanks for your attention!

Posted by willam smith

12: Re: problems with "ant deploy-tools" and deploy Lams
In response to 11 03/08/13 10:18 AM
[ Reply | Forward ]
This time I am sorry for replying so late...
Do you still have problems with MySQL stopping by itself?
Have you encountered any other encoding-related issues while working with LAMS?

Posted by Marcin Cieslak

13: Re: Re: Re: problems with "ant deploy-tools" and deploy Lams
In response to 11 03/11/13 02:32 PM
[ Reply | Forward ]
Have you tried creating the database as follows?


CREATE DATABASE lams DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci;

Posted by Ernie Ghiglione

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