RE: Problems encountered when moving database...

266783, modified 17 Years ago.

Problems encountered when moving database...

New Member Posts: 11 Join Date: 11/12/07 Recent Posts

Hello,

I am attempting to move the mysql database for my Liferay 4.2.1 install from a Windows 2003 Server to a linux based mysql server. I have tried a couple different methods of moving the database (mysql dump and import; zipping and moving the mysql raw data and schema), but each time I enounter the same problem. The problem is that the first time I attempt to start Liferay/tomcat after moving the database (and pointing to it in ROOT.xml), I see the following:

12:53:40,109 WARN [ReleaseLocalServiceImpl:84] Table 'lportal.Release_' doesn't exist
12:53:40,109 INFO [ReleaseLocalServiceImpl:97] Create tables and populate with default data
12:53:53,359 INFO [StartupAction:206] Running verification com.liferay.portal.verify.VerifyProcessS
uite

It will continue after this, but nothing is the same after it finishes starting (ie. the logon screen looks different and I am unable to login with a valid account). Anybody have any idea what I am doing wrong? Any help is greatly appreciated!

Thanks,

Scott

23696, modified 17 Years ago.

RE: Problems encountered when moving database...

Junior Member Posts: 63 Join Date: 5/31/06 Recent Posts

document all the steps you took and post here, otherwise we would be just guessing.

Scott Murray:

Hello,

I am attempting to move the mysql database for my Liferay 4.2.1 install from a Windows 2003 Server to a linux based mysql server. I have tried a couple different methods of moving the database (mysql dump and import; zipping and moving the mysql raw data and schema), but each time I enounter the same problem. The problem is that the first time I attempt to start Liferay/tomcat after moving the database (and pointing to it in ROOT.xml), I see the following:

12:53:40,109 WARN [ReleaseLocalServiceImpl:84] Table 'lportal.Release_' doesn't exist
12:53:40,109 INFO [ReleaseLocalServiceImpl:97] Create tables and populate with default data
12:53:53,359 INFO [StartupAction:206] Running verification com.liferay.portal.verify.VerifyProcessS
uite

It will continue after this, but nothing is the same after it finishes starting (ie. the logon screen looks different and I am unable to login with a valid account). Anybody have any idea what I am doing wrong? Any help is greatly appreciated!

Thanks,

Scott

266783, modified 17 Years ago.

RE: Problems encountered when moving database...

New Member Posts: 11 Join Date: 11/12/07 Recent Posts

Here are the steps I take to move the database...

1. Shut down Tomcat/Liferay.
2. Modify D:\apps\liferay-portal-tomcat\conf\Catalina\localhost\ROOT.xml and change localhost to the IP address of the new linux database server.
3. On the Liferay Server, from a command prompt, run mysqldump on the lportal database. Now transfer this file to some location on the new db server.
4. On the new db server, run the command mysql. From the mysql> prompt, run source filename.sql.
5. After it’s finished, create a new user and assign it a password (use the ones from the files in steps 2 above). Give this user all permissions.
6. Start Tomcat/Liferay and test.

23696, modified 17 Years ago.

RE: Problems encountered when moving database...

Junior Member Posts: 63 Join Date: 5/31/06 Recent Posts

Can you give the full log of the first runup of liferay

Scott Murray:

Here are the steps I take to move the database...

1. Shut down Tomcat/Liferay.
2. Modify D:\apps\liferay-portal-tomcat\conf\Catalina\localhost\ROOT.xml and change localhost to the IP address of the new linux database server.
3. On the Liferay Server, from a command prompt, run mysqldump on the lportal database. Now transfer this file to some location on the new db server.
4. On the new db server, run the command mysql. From the mysql> prompt, run source filename.sql.
5. After it’s finished, create a new user and assign it a password (use the ones from the files in steps 2 above). Give this user all permissions.
6. Start Tomcat/Liferay and test.

266783, modified 17 Years ago.

RE: Problems encountered when moving database...

New Member Posts: 11 Join Date: 11/12/07 Recent Posts

Paul Hussein:

Can you give the full log of the first runup of liferay

Aug 14, 2008 1:24:01 PM org.apache.catalina.core.AprLifecycleListener lifecycleEvent
INFO: The Apache Tomcat Native library which allows optimal performance in production environments w
as not found on the java.library.path: D:\apps\java\jdk1.5.0_11\bin;.;C:\WINDOWS\system32;C:\WINDOWS
;C:\Perl\site\bin;C:\Perl\bin;C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\System32\Wbem;D:\apps\mySQL\
bin;D:\apps\java\jikes-1.22\bin;D:\apps\java\apache-ant-1.7.0\bin
Aug 14, 2008 1:24:01 PM org.apache.coyote.http11.Http11BaseProtocol init
INFO: Initializing Coyote HTTP/1.1 on http-8080
Aug 14, 2008 1:24:01 PM org.apache.catalina.startup.Catalina load
INFO: Initialization processed in 937 ms
Aug 14, 2008 1:24:01 PM org.apache.catalina.core.StandardService start
INFO: Starting service Catalina
Aug 14, 2008 1:24:01 PM org.apache.catalina.core.StandardEngine start
INFO: Starting Servlet Engine: Apache Tomcat/5.5.23
Aug 14, 2008 1:24:01 PM org.apache.catalina.core.StandardHost start
INFO: XML validation disabled
Aug 14, 2008 1:24:02 PM org.apache.catalina.realm.JAASRealm setUseContextClassLoader
INFO: Setting useContextClassLoader = false
Loading jar:file:/D:/apps/liferay-portal-tomcat/webapps/ROOT/WEB-INF/lib/portal-impl.jar!/system.pro
perties
Loading file:/D:/apps/liferay-portal-tomcat/webapps/ROOT/WEB-INF/classes/system-ext.properties
Loading jar:file:/D:/apps/liferay-portal-tomcat/webapps/ROOT/WEB-INF/lib/portal-impl.jar!/portal.pro
perties
Loading file:/D:/apps/liferay-portal-tomcat/webapps/ROOT/WEB-INF/classes/portal-ext.properties
Starting Liferay Enterprise Portal 4.3.6 (Owen / Build 4306 / January 9, 2008)
13:24:11,593 INFO [DynamicDialect:79] Determining dialect for MySQL 5
13:24:11,609 INFO [DynamicDialect:102] Using dialect org.hibernate.dialect.MySQLDialect
13:24:13,921 WARN [ReleaseLocalServiceImpl:84] Table 'lportal.Release_' doesn't exist
13:24:13,921 INFO [ReleaseLocalServiceImpl:97] Create tables and populate with default data
13:24:24,390 INFO [StartupAction:206] Running verification com.liferay.portal.verify.VerifyProcessS
uite
13:24:24,390 INFO [VerifyProcessSuite:37] Verifying integrity
13:24:24,390 INFO [VerifyBlogs:42] Verifying integrity
13:24:24,484 INFO [CustomSQLUtil:110] Database name MySQL
13:24:24,484 INFO [CustomSQLUtil:138] Detected MySQL with database name MySQL
13:24:24,546 INFO [PortalUtil:2017] Portal lib url file:/D:/apps/liferay-portal-tomcat/webapps/ROOT
/WEB-INF/lib/portal-impl.jar!/com/liferay/portal/util/PortalUtil.class
13:24:24,546 INFO [PortalUtil:2042] Portal lib directory /D:/apps/liferay-portal-tomcat/webapps/ROO
T/WEB-INF/lib/
13:24:24,750 INFO [VerifyBookmarks:42] Verifying integrity
13:24:24,781 INFO [VerifyDocumentLibrary:42] Verifying integrity
13:24:24,828 INFO [VerifyImageGallery:42] Verifying integrity
13:24:24,859 INFO [VerifyJournal:49] Verifying integrity
13:24:25,078 INFO [StartupAction:213] Finished verification com.liferay.portal.verify.VerifyProcess
Suite
13:24:25,500 INFO [PluginPackageHotDeployListener:71] Reading plugin package for the root context
13:24:25,890 INFO [HotDeployUtil:76] Initializing hot deploy manager 16942552
13:24:26,000 INFO [ServerDetector:76] Detected server tomcat
13:24:26,234 INFO [AutoDeployDir:76] Auto deploy scanner started for C:\Documents and Settings\Admi
nistrator\liferay\deploy
Loading jar:file:/D:/apps/liferay-portal-tomcat/webapps/ROOT/WEB-INF/lib/portal-impl.jar!/portal.pro
perties for {companyId=10095, webId=liferay.com}
Loading file:/D:/apps/liferay-portal-tomcat/webapps/ROOT/WEB-INF/classes/portal-ext.properties for {
companyId=10095, webId=liferay.com}
Aug 14, 2008 1:24:29 PM org.apache.catalina.startup.HostConfig deployWAR
INFO: Deploying web application archive cas-web.war
2008-08-14 13:24:30,515 INFO [org.jasig.cas.authentication.handler.support.SimpleTestUsernamePasswor
dAuthenticationHandler] - <No PasswordEncoder set. Using default: org.jasig.cas.authentication.hand
ler.PlainTextPasswordEncoder>
2008-08-14 13:24:30,515 INFO [org.jasig.cas.authentication.handler.support.SimpleTestUsernamePasswor
dAuthenticationHandler] - <No Class to Support set. Using default: org.jasig.cas.authentication.pri
ncipal.UsernamePasswordCredentials>
2008-08-14 13:24:30,515 WARN [org.jasig.cas.authentication.handler.support.SimpleTestUsernamePasswor
dAuthenticationHandler] - <org.jasig.cas.authentication.handler.support.SimpleTestUsernamePasswordAu
thenticationHandler is only to be used in a testing environment. NEVER enable this in a production
environment.>
2008-08-14 13:24:30,531 INFO [org.jasig.cas.ticket.proxy.support.Cas20ProxyHandler] - <No UniqueTick
etIdGenerator specified for org.jasig.cas.ticket.proxy.support.Cas20ProxyHandler. Using org.jasig.c
as.util.DefaultUniqueTicketIdGenerator>
2008-08-14 13:24:31,015 INFO [org.jasig.cas.web.ServiceValidateController] - <No successView specifi
ed. Using default of casServiceSuccessView>
2008-08-14 13:24:31,015 INFO [org.jasig.cas.web.ServiceValidateController] - <No failureView specifi
ed. Using default of casServiceFailureView>
2008-08-14 13:24:31,015 INFO [org.jasig.cas.web.ServiceValidateController] - <No authentication spec
ification class set. Defaulting to org.jasig.cas.validation.Cas20ProtocolValidationSpecification>
2008-08-14 13:24:31,015 INFO [org.jasig.cas.web.ServiceValidateController] - <No successView specifi
ed. Using default of casServiceSuccessView>
2008-08-14 13:24:31,015 INFO [org.jasig.cas.web.ServiceValidateController] - <No failureView specifi
ed. Using default of casServiceFailureView>
2008-08-14 13:24:31,078 INFO [org.jasig.cas.web.flow.AuthenticationViaFormAction] - <FormObjectClass
not set. Using default class of org.jasig.cas.authentication.principal.UsernamePasswordCredentials
with formObjectName credentials and validator org.jasig.cas.validation.UsernamePasswordCredentialsV
alidator.>
13:24:32,359 INFO [PluginPackageHotDeployListener:74] Reading plugin package for alfresco
13:24:32,375 WARN [PluginPackageHotDeployListener:123] Plugin package on context alfresco cannot be
tracked because this WAR does not contain a liferay-plugin-package.xml file
13:24:32,578 INFO [PluginPackageHotDeployListener:187] Plugin package alfresco/alfresco/unknown/war
registered successfully
13:24:32,578 INFO [PortletHotDeployListener:130] Registering portlets for alfresco
13:24:32,671 INFO [PortletHotDeployListener:393] Portlets for alfresco registered successfully
13:24:40,500 ERROR [transform.magick.AbstractImageMagickContentTransformer] ImageMagickContentTransf
ormer not available: Failed to execute command: imconvert "D:\apps\liferay-portal-tomcat\temp\Alfres
co\ImageMagickContentTransformer_init_source_45758.gif" "D:\apps\liferay-portal-tomcat\temp\Alfresc
o\ImageMagickContentTransformer_init_target_45759.png"
13:24:42,625 WARN [remoting.rmi.RmiRegistryFactoryBean] Could not detect RMI registry - creating ne
w one
13:24:45,125 WARN [alfresco.util.OpenOfficeConnectionTester] A connection to OpenOffice could not b
e established.
13:24:50,031 WARN [repo.admin.ConfigurationChecker] The Alfresco 'dir.root' property is set to a re
lative path './alf_data'. 'dir.root' should be overridden to point to a specific folder.
13:24:50,046 INFO [repo.admin.ConfigurationChecker] The Alfresco root data directory ('dir.root') i
s: .\alf_data
13:24:50,453 INFO [admin.patch.PatchExecuter] Checking for patches to apply ...
13:24:50,484 INFO [admin.patch.PatchExecuter] No patches were required.
13:24:50,484 INFO [repo.module.ModuleServiceImpl] Found 0 module(s).
13:24:50,562 DEBUG [alfresco.smb.protocol] Added desktop action CheckInOut
13:24:50,578 DEBUG [alfresco.smb.protocol] Added desktop action JavaScriptURL
2008-08-14 13:24:50,593 INFO [org.jasig.cas.ticket.registry.support.DefaultTicketRegistryCleaner] -
<Starting cleaning of expired tickets from ticket registry at [Thu Aug 14 13:24:50 GMT 2008]>
2008-08-14 13:24:50,609 INFO [org.jasig.cas.ticket.registry.support.DefaultTicketRegistryCleaner] -
<0 found to be removed. Removing now.>
2008-08-14 13:24:50,609 INFO [org.jasig.cas.ticket.registry.support.DefaultTicketRegistryCleaner] -
<Finished cleaning of expired tickets from ticket registry at [Thu Aug 14 13:24:50 GMT 2008]>
13:24:50,984 DEBUG [smb.protocol.auth] Added passthru server [DS2:192.168.126.154 emoticon

ffline:0,0]
13:24:50,984 INFO [alfresco.smb.protocol] CIFS server started
13:24:50,984 INFO [alfresco.smb.protocol] FTP server started
13:24:51,000 INFO [alfresco.smb.protocol] NFS server NOT started
13:24:51,015 INFO [service.descriptor.DescriptorService] Alfresco JVM - v1.5.0_11-b03; maximum heap
size 1016.125MB
13:24:51,015 INFO [service.descriptor.DescriptorService] Alfresco license: Enterprise Network grant
ed to Customer (does not expire)
13:24:51,015 INFO [service.descriptor.DescriptorService] Alfresco started (Enterprise Network): Cur
rent version 2.0.0 (build-23) schema 38 - Installed version 2.0.0 (build-23) schema 38
13:24:51,046 INFO [alfresco.smb.protocol] SMB Server W2K3PORTAL01_A starting
13:24:51,046 INFO [alfresco.smb.protocol] GUID 52c31d14-76bb-33db-90a9-72da7c31f35b
13:24:51,046 INFO [alfresco.smb.protocol] Using authenticator org.alfresco.filesys.server.auth.pass
thru.PassthruAuthenticator
13:24:51,062 INFO [alfresco.smb.protocol] Server timezone GMT, offset from UTC = 0hrs
13:24:51,062 INFO [alfresco.smb.protocol] Shares:
13:24:51,062 INFO [alfresco.smb.protocol] [Alfresco,DISK,,[Alfresco,workspace://SpacesStore/445183
83-e2f1-11db-ae7f-0b0d82a9a19f]] [Alfresco,workspace://SpacesStore/44518383-e2f1-11db-ae7f-0b0d82a9a
19f]
13:24:51,078 INFO [alfresco.smb.protocol] [AVM,DISK,,[AVM,VirtualView]] [AVM,VirtualView]
13:24:51,078 INFO [alfresco.smb.protocol] Add Share [IPC$,IPC$,,Admin,Hidden] : true
13:24:51,078 DEBUG [smb.protocol.auth] New auth session from w2k3portal01_1 to \\192.168.126.154\IPC
$\
13:24:51,171 DEBUG [smb.protocol.auth] Trying address 192.168.126.154
13:24:51,609 DEBUG [smb.protocol.auth] Connected to address 192.168.126.154
13:24:51,609 DEBUG [smb.protocol.auth] Connected session, protocol : TCP/IP NetBIOS
13:24:51,625 DEBUG [smb.protocol.auth] SessionFactory: Negotiated SMB dialect NT LANMAN 1.0
13:24:51,640 DEBUG [smb.protocol.auth] Passthru server online, [DS2:192.168.126.154 emoticon

nline:0,0]
13:24:52,046 DEBUG [alfresco.smb.protocol] Win32 NetBIOS Available LANAs: 0
13:24:52,093 DEBUG [alfresco.smb.protocol] Win32 NetBIOS server W2K3PORTAL01_A (using Winsock)
13:24:52,671 INFO [PluginPackageHotDeployListener:74] Reading plugin package for liferay-noir-theme

13:24:52,765 INFO [PluginPackageHotDeployListener:187] Plugin package liferay/liferay-noir-theme/4.
3.6.1/war registered successfully
13:24:52,781 INFO [ThemeHotDeployListener:77] Registering themes for liferay-noir-theme
13:24:52,781 INFO [ThemeHotDeployListener:89] Themes for liferay-noir-theme registered successfully

13:24:53,109 INFO [PluginPackageHotDeployListener:74] Reading plugin package for MyCompello-theme
13:24:53,156 INFO [PluginPackageHotDeployListener:187] Plugin package liferay/MyCompello-theme/4.3.
1.1/war registered successfully
13:24:53,156 INFO [ThemeHotDeployListener:77] Registering themes for MyCompello-theme
13:24:53,156 INFO [ThemeHotDeployListener:89] Themes for MyCompello-theme registered successfully
Aug 14, 2008 1:24:53 PM org.apache.catalina.realm.JAASRealm setUseContextClassLoader
INFO: Setting useContextClassLoader = false
13:24:53,843 INFO [[/tunnel-web]:647] Initializing Spring root WebApplicationContext
13:24:55,640 INFO [[/tunnel-web]:647] Initializing Spring FrameworkServlet 'SpringServlet'
Aug 14, 2008 1:24:57 PM org.apache.coyote.http11.Http11BaseProtocol start
INFO: Starting Coyote HTTP/1.1 on http-8080
Aug 14, 2008 1:24:57 PM org.apache.jk.common.ChannelSocket init
INFO: JK: ajp13 listening on /0.0.0.0:8009
Aug 14, 2008 1:24:57 PM org.apache.jk.server.JkMain start
INFO: Jk running ID=0 time=0/16 config=null
Aug 14, 2008 1:24:57 PM org.apache.catalina.storeconfig.StoreLoader load
INFO: Find registry server-registry.xml at classpath resource
Aug 14, 2008 1:24:57 PM org.apache.catalina.startup.Catalina start
INFO: Server startup in 55563 ms

23696, modified 17 Years ago.

RE: Problems encountered when moving database...

Junior Member Posts: 63 Join Date: 5/31/06 Recent Posts

Something looks fishy here

you say Liferay 4.2.1

your runup says 4.3.6, and there is an alfresco startup mixed in there.

runup the older version connected to the old db and check the startup log. Is it 4.2.1 or 4.3.6 ????

post the old startup log also

1439403, modified 17 Years ago.

RE: Problems encountered when moving database...

New Member Posts: 3 Join Date: 10/15/08 Recent Posts

I have just solved the problem in my case.
Liferay looks for table like "Release_" in mysql. But there is no such table in mysql linux. Instead there is "release_" . Since linux is a case sensitive OS so it's return false when comparing with "Release_" with "release_" .

To solve this make linux mysql incasesensetive.
To do so u may follow the steps from
http://cosminswiki.com/index.php/MySQL_case_insensitive_table_and_column_names

Community

Company

Feedback

Ask Questions and Find Answers

Important:

Ask is now read-only. You can review any existing questions and answers, but not add anything new.

But - don't panic! While ask is no more, we've replaced it with discuss - the new Liferay Discussion Forum! Read more here here or just visit the site here:

discuss.liferay.com

RE: Problems encountered when moving database...