Hello,

i'm trying to upgrade Liferay from 605 to 606 in local replicating the production environment. I have installed MySQL as database and when I copy the liferay 605 folder into my computer with the correct portal-ext.properties but it seems not connecting with the database because i see the default content when liferay is installed.

Happens the same with 606 version , I've downloaded 606 bundled and here are the steps i m followin.

1. Decompress the folder.
2. Copy data folder from 605 to 606.
3. Copy personal content from webapps (hooks, themes, plugins, etc) to 606 webapps folder.
4. Copy portal-ext.properties, the same existing in 605 version.
5. Run 606 tomcat

When i do that it seems not loading data from the mysql database because i cant see my organizations, neither the users, but what is more, i cant login with default users neither with my administrator user.

What am i doing wrong? Thx!

Juan,
looks like db connection url is the problem

please post database connection properties from your portal-ext.properties


Cheers
Suresh Nimmakayala

Hey Juan,

Seams it is a problem with your database connection, please provide settings you have in portal-ext.properties.
Also, it may be the the the lower_case_table_names setting in your MySQL server. It may be that you are using a case sensitive table names on your local PC and on production it was case insensitive. In this case, you should be see in your database duplicated tables (like Account_ and account). To solve this set lower_case_table_names=1 in your MySQL and restart the server.
If this is not the issue, then please provide the log of your server.

Iulian

Thx for your answers

I see the database tables in lower case, for more information i've just exported the server database and imported it to my localhost database (MySQL both), it is curious what it does.

When i acces the home page it loads the default page (first Liferay installation) but i can acces the different organizations throught the URL, and voila! when i push the logo from others organizations it loads my home page.

But there is a but, when i shutdown and restart the servers happens the same again. Another thing that i,m observating is that all the document library documents are unavailabe for download. I can clic the link but it says that the document doesn't exist, i have copied the data folder too.

My connection settings are:

# Liferay will automatically detect the database type by initializing
# DBUtil. You can override the value here if needed. Expected values are:
# db2, derby, firebird, hypersonic, informix, ingres, interbase, jdatastore,
# mysql, oracle, postgresql, sap, sqlserver, and sybase.
#
jpa.database.type=mysql

#
# MySQL
#
jdbc.default.driverClassName=com.mysql.jdbc.Driver
jdbc.default.url=jdbc:mysql://localhost/lportal?useUnicode=true&characterEncoding=UTF-8&useFastDateParsing=false
jdbc.default.username=myusername
jdbc.default.password=mypassword

Thx

Try remove the 7cogs portlets before starting liferay with imported database.