<html><body>
<p>Hi Jessica,<br>
<br>
yes, in opencms-properties it is used for opencms to contact the DB. but the DB needs the data as well to check, whether the the request can be accepted, right?<br>
And since I understood, that you have set up the mysql-DB on the new machine vanilla-style, the root-user of the mysql-server has no pw assigned yet. <br>
All you did, is copy the Opencms-DB to the server, but you did not tell him that opencms will log in with the respective credentials.<br>
<br>
I hope, this is the missing link for your problem. So you have to do the following with the mysql-DB:
<ul>
<ul>
<ul>
<ul>
<ol type="1">
<li>In “/etc/my.cnf” unter „mysqld“ den Eintrag “max_allowed_packet” ändern auf (this allows you to transfer bigger data to the opencms Server):<b><br>
</b><font color="#0082BF">max_allowed_packet = 16M (32M falls erforderlich)</font>
<li>root-Password setzen auf: „<b>yourOpencmspassword</b>“: <font color="#FF0000"><br>
</font><font color="#0082BF">shell> mysqladmin –u root password </font><b><font color="#0062E1">yourOpencmspassword</font></b></ol>
<ul>or:<font color="#0082BF"><br>
shell> mysql –u root mysql -p<br>
mysql> SET PASSWORD FOR 'root'@'localhost' = PASSWORD('</font><b><font color="#0062E1">yourOpencmspassword</font></b><font color="#0082BF">');</font><br>
</ul>
</ul>
<ul>So this is the way, you have to configure mysql in Linux, please have a look at MySql-Website for the equivalent procedures in Windows!<br>
<br>
Be aware, it might be necessary, to grant privileges to the mysql-user 'root' es well with an instruction like the following:
<ol type="1">
<li></ol>
<ul type="disc">
<li><font color="#0082BF">mysql> GRANT ALL PRIVILEGES ON root.* TO ‘root’@‘localhost‘ IDENTIFIED BY ’yourOpencmspassword‘;</font></ul>
</ul>
</ul>
</ul>
</ul>
I hope your are successful this time. Have a nice Evening ;-)<br>
<br>
Best regards<br>
<br>
Frank<br>
<br>
<br>
<img width="16" height="16" src="cid:1__=4EBBFC24DFFAC9338f9e8a93@vater-gruppe.de" border="0" alt="Inactive hide details for Jessica Maas ---26.01.2010 16:16:04---Isn't the database-user and password saved in the opencms.prope"><font color="#424282">Jessica Maas ---26.01.2010 16:16:04---Isn't the database-user and password saved in the opencms.properties file? If yes, then the user and</font><br>
<br>
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr valign="top"><td width="1%"><img width="96" height="1" src="cid:2__=4EBBFC24DFFAC9338f9e8a93@vater-gruppe.de" border="0" alt=""><br>
<font size="2" color="#5F5F5F">Von:</font></td><td width="100%"><img width="1" height="1" src="cid:2__=4EBBFC24DFFAC9338f9e8a93@vater-gruppe.de" border="0" alt=""><br>
<font size="2">Jessica Maas <yukarichan87@googlemail.com></font></td></tr>
<tr valign="top"><td width="1%"><img width="96" height="1" src="cid:2__=4EBBFC24DFFAC9338f9e8a93@vater-gruppe.de" border="0" alt=""><br>
<font size="2" color="#5F5F5F">An:</font></td><td width="100%"><img width="1" height="1" src="cid:2__=4EBBFC24DFFAC9338f9e8a93@vater-gruppe.de" border="0" alt=""><br>
<font size="2">The OpenCms mailing list <opencms-dev@opencms.org></font></td></tr>
<tr valign="top"><td width="1%"><img width="96" height="1" src="cid:2__=4EBBFC24DFFAC9338f9e8a93@vater-gruppe.de" border="0" alt=""><br>
<font size="2" color="#5F5F5F">Datum:</font></td><td width="100%"><img width="1" height="1" src="cid:2__=4EBBFC24DFFAC9338f9e8a93@vater-gruppe.de" border="0" alt=""><br>
<font size="2">26.01.2010 16:16</font></td></tr>
<tr valign="top"><td width="1%"><img width="96" height="1" src="cid:2__=4EBBFC24DFFAC9338f9e8a93@vater-gruppe.de" border="0" alt=""><br>
<font size="2" color="#5F5F5F">Betreff:</font></td><td width="100%"><img width="1" height="1" src="cid:2__=4EBBFC24DFFAC9338f9e8a93@vater-gruppe.de" border="0" alt=""><br>
<font size="2">Re: [opencms-dev] Antwort: Re: Antwort: Re: Moving OpenCMS & Update --> need help</font></td></tr>
<tr valign="top"><td width="1%"><img width="96" height="1" src="cid:2__=4EBBFC24DFFAC9338f9e8a93@vater-gruppe.de" border="0" alt=""><br>
<font size="2" color="#5F5F5F">Gesendet von:</font></td><td width="100%"><img width="1" height="1" src="cid:2__=4EBBFC24DFFAC9338f9e8a93@vater-gruppe.de" border="0" alt=""><br>
<font size="2">opencms-dev-bounces@opencms.org</font></td></tr>
</table>
<hr width="100%" size="2" align="left" noshade style="color:#8091A5; "><br>
<br>
<br>
<font size="4">Isn't the database-user and password saved in the opencms.properties file? If yes, then the user and password on the old and the new server are the same. The user is root and the passwords are equal.<br>
</font><br>
<font size="4">2010/1/26 Frank Pertack <</font><a href="mailto:fpertack@vater-gruppe.de"><u><font size="4" color="#0000FF">fpertack@vater-gruppe.de</font></u></a><font size="4">></font>
<ul>
<ul><tt><font size="4">Hi Jessica,</font></tt><font size="4"><br>
</font><tt><font size="4"><br>
maybe you have to install a localhost-user with the same username and password, as you had it in your old mysql-installation. I think your webserver wants to access the database, but it does not succeed due to missing / wrong credentials!</font></tt><font size="4"><br>
</font><tt><font size="4"><br>
Try that out (take the old mysql opencms-user and password and it might work!)</font></tt><font size="4"><br>
</font><tt><font size="4"><br>
Best regards</font></tt>
<p><tt><font size="4"><br>
Frank</font></tt><font size="4"><br>
<br>
</font><tt><font size="4"><br>
-----</font></tt><a href="mailto:opencms-dev-bounces@opencms.org" target="_blank"><tt><u><font size="4" color="#0000FF">opencms-dev-bounces@opencms.org</font></u></tt></a><tt><font size="4"> schrieb: -----</font></tt><font size="4"><br>
<br>
</font><tt><font size="4"><br>
An: The OpenCms mailing list <</font></tt><a href="mailto:opencms-dev@opencms.org" target="_blank"><tt><u><font size="4" color="#0000FF">opencms-dev@opencms.org</font></u></tt></a><tt><font size="4">><br>
Von: Jessica Maas <</font></tt><a href="mailto:yukarichan87@googlemail.com" target="_blank"><tt><u><font size="4" color="#0000FF">yukarichan87@googlemail.com</font></u></tt></a><tt><font size="4">><br>
Gesendet von: </font></tt><a href="mailto:opencms-dev-bounces@opencms.org" target="_blank"><tt><u><font size="4" color="#0000FF">opencms-dev-bounces@opencms.org</font></u></tt></a><br>
<tt><font size="4">Datum: 26.01.2010 03:51PM<br>
Betreff: Re: [opencms-dev] Antwort: Re: Moving OpenCMS & Update --> need help</font></tt><br>
<font size="4"><br>
<br>
</font><tt><font size="4"><br>
Actually I only copied them into the opencms-folder and said "yes" for "overwrite all" so all new files should be in there and double replaced by the update-files.</font></tt><font size="4"><br>
<br>
</font><tt><font size="4"><br>
The readme sais " Instructions for updating OpenCms 6.x/7.x to OpenCms 7.5.1"</font></tt><font size="4"><br>
<br>
</font><tt><font size="4"><br>
No, it wasn't but I had a similar problem with another application where the update then fixed the problem. That's why I wanted to try it here, too. But it obviously didn't work, so I maybe should first get the old version running.</font></tt><font size="4"><br>
</font><tt><font size="4"><br>
If I copy the full webapps folder to tomcat and the database into mysql, start tomcat and try to call opencms, I get this error now:</font></tt><font size="4"><br>
</font><tt><font size="4"><br>
HTTP Status 500 -</font></tt><font size="4"><br>
</font><tt><font size="4"><br>
type Exception report</font></tt><font size="4"><br>
</font><tt><font size="4"><br>
message</font></tt><font size="4"><br>
</font><tt><font size="4"><br>
description The server encountered an internal error () that prevented it from fulfilling this request.</font></tt><font size="4"><br>
</font><tt><font size="4"><br>
exception</font></tt><font size="4"><br>
</font><tt><font size="4"><br>
org.opencms.main.CmsInitException: Critical error during OpenCms initialization: Unable to initialize connection pool "default". Is the database up and running?<br>
org.opencms.main.OpenCmsCore.getInstance(OpenCmsCore.java:265)<br>
org.opencms.main.OpenCmsServlet.doGet(OpenCmsServlet.java:127)<br>
javax.servlet.http.HttpServlet.service(HttpServlet.java:617)<br>
javax.servlet.http.HttpServlet.service(HttpServlet.java:717)</font></tt><font size="4"><br>
</font><tt><font size="4"><br>
note The full stack trace of the root cause is available in the Apache Tomcat/6.0-snapshot logs.</font></tt><font size="4"><br>
</font><tt><font size="4"><br>
And yes, the database is up and running.</font></tt><font size="4"><br>
<br>
<br>
</font><tt><font size="4"><br>
2010/1/26 Frank Pertack < </font></tt><a href="mailto:fpertack@vater-gruppe.de" target="_blank"><tt><u><font size="4" color="#0000FF">fpertack@vater-gruppe.de</font></u></tt></a><tt><font size="4"> ></font></tt><font size="4"><br>
<br>
</font><tt><font size="4"><br>
Hello Jessica,</font></tt><font size="4"><br>
</font><tt><font size="4"><br>
did you make sure, that both, the update- AND the WEB_INF-directory of the update-Package is completely copied into the opencms-Folder? I had a similar problem where the WEB_INF didnt have set the correct ownership/permissions on a Linux-machine, so the Update could not use all the files of the WEB_INF of the update.</font></tt><font size="4"><br>
</font><tt><font size="4"><br>
Did you check, whether your OpenCms-Version is suitable for a one-hop update to 7.52 (I think the name of the update-file contains the allowed "from-version".</font></tt><font size="4"><br>
</font><tt><font size="4"><br>
Did you check, whether OpenCms is running after the copy onto the new machine before updating it?</font></tt><font size="4"><br>
</font><tt><font size="4"><br>
Good luck</font></tt><font size="4"><br>
</font><tt><font size="4"><br>
Frank</font></tt><font size="4"><br>
<br>
</font><tt><font size="4"><br>
----- </font></tt><a href="mailto:opencms-dev-bounces@opencms.org" target="_blank"><tt><u><font size="4" color="#0000FF">opencms-dev-bounces@opencms.org</font></u></tt></a><tt><font size="4"> schrieb: -----</font></tt><font size="4"><br>
<br>
</font><tt><font size="4"><br>
An: The OpenCms mailing list < </font></tt><a href="mailto:opencms-dev@opencms.org" target="_blank"><tt><u><font size="4" color="#0000FF">opencms-dev@opencms.org</font></u></tt></a><tt><font size="4"> ><br>
Von: Jessica Maas < </font></tt><a href="mailto:yukarichan87@googlemail.com" target="_blank"><tt><u><font size="4" color="#0000FF">yukarichan87@googlemail.com</font></u></tt></a><tt><font size="4"> ><br>
Gesendet von: </font></tt><a href="mailto:opencms-dev-bounces@opencms.org" target="_blank"><tt><u><font size="4" color="#0000FF">opencms-dev-bounces@opencms.org</font></u></tt></a><tt><font size="4"><br>
Datum: 26.01.2010 01:40PM<br>
Betreff: Re: [opencms-dev] Moving OpenCMS & Update --> need help</font></tt><font size="4"><br>
<br>
</font><tt><font size="4"><br>
a) It's a Version 6 as far as I know. I currently only have the full backup of the webapps folder and the database. Is there a way to find that out over the file-system?<br>
b) Windows Server 2003 Enterprise R2<br>
c) MySQL<br>
d) I tried something else meanwhile and forgot to save the log-files... but I will post them when I repeat the first try if this one fails again.</font></tt><font size="4"><br>
</font><tt><font size="4"><br>
Thanks for the link. I will give it a try.</font></tt><font size="4"><br>
<br>
</font><tt><font size="4"><br>
2010/1/26 Eska < </font></tt><a href="mailto:sven.kiesow@interone.de" target="_blank"><tt><u><font size="4" color="#0000FF">sven.kiesow@interone.de</font></u></tt></a><tt><font size="4"> ></font></tt><font size="4"><br>
<br>
</font><tt><font size="4"><br>
Hi,</font></tt><font size="4"><br>
</font><tt><font size="4"><br>
there is a lot of Information missing to even think about helping you.</font></tt><font size="4"><br>
</font><tt><font size="4"><br>
For example</font></tt><font size="4"><br>
</font><tt><font size="4"><br>
a) what is the OpenCms Version you have to update<br>
b) on what os is it running?<br>
c) what is your database<br>
d) any log file showing something unusual?</font></tt><font size="4"><br>
</font><tt><font size="4"><br>
and so on...</font></tt><font size="4"><br>
</font><tt><font size="4"><br>
Did you read e.g.</font></tt><tt><u><font size="4" color="#0000FF"><br>
</font></u></tt><a href="http://old.nabble.com/Update-from-7.05-to-7.52-results-in-%22Resource-%28%29-is-not-available%22-td27283167.html" target="_blank"><tt><u><font size="4" color="#0000FF">http://old.nabble.com/Update-from-7.05-to-7.52-results-in-%22Resource-%28%29-is-not-available%22-td27283167.html</font></u></tt></a><tt><u><font size="4" color="#0000FF"><br>
</font></u></tt><a href="http://old.nabble.com/Update-from-7.05-to-7.52-results-in-%22Resource-%28%29-is-not-available%22-td27283167.html" target="_blank"><tt><u><font size="4" color="#0000FF">http://old.nabble.com/Update-from-7.05-to-7.52-results-in-%22Resource-%28%29-is-not-available%22-td27283167.html</font></u></tt></a><tt><font size="4"><br>
, perhaps you have the same problem.</font></tt><font size="4"><br>
</font><tt><font size="4"><br>
Eska</font></tt><font size="4"><br>
<br>
<br>
</font><tt><font size="4"><br>
Jessica Maas wrote:<br>
><br>
> Hi,<br>
><br>
> I was told to move a current OpenCMS version to another server and then<br>
> update it.<br>
> This is what I did:<br>
><br>
> I copied the whole "webapps"-folder of Tomcat and moved it into the<br>
> Tomcat-Folder of the new server. Then I copied the old opencms-database<br>
> and<br>
> moved it to the new server, too. I downloaded the upgrade wizard to 7.5.1<br>
> and followed the steps in the readme. It seems to update the database but<br>
> after the next step the update fails and shows me the following error,<br>
> appearing at: </font></tt><a href="http://localhost:8080/opencms/update/step_3_xmlupdate.jsp" target="_blank"><tt><u><font size="4" color="#0000FF">http://localhost:8080/opencms/update/step_3_xmlupdate.jsp</font></u></tt></a><tt><font size="4"><br>
><br>
> HTTP Status 500<br>
> OpenCms is not properly initialized!<br>
> Please make sure that the OpenCms setup wizard has been run once and is<br>
> disabled now.<br>
><br>
> If I follow the message (disable the wizard) and reload the page, I get<br>
> another error:<br>
> </font></tt><a href="http://img5.imagebanana.com/view/3642uiig/ocms.jpg" target="_blank"><tt><u><font size="4" color="#0000FF">http://img5.imagebanana.com/view/3642uiig/ocms.jpg</font></u></tt></a><tt><font size="4"><br>
><br>
> And it stays even if I enable the wizard again.<br>
><br>
> I tried it a second time, but it didn't work either and because the<br>
> database-update takes very long at each try this is very annoying.<br>
> What could I have done wrong?<br>
><br>
> Thanks in advance,<br>
> Jessica<br>
><br>
></font></tt><font size="4"><br>
</font><tt><font size="4"><br>
> _______________________________________________<br>
> This mail is sent to you from the opencms-dev mailing list<br>
> To change your list options, or to unsubscribe from the list, please visit<br>
> </font></tt><a href="http://lists.opencms.org/mailman/listinfo/opencms-dev" target="_blank"><tt><u><font size="4" color="#0000FF">http://lists.opencms.org/mailman/listinfo/opencms-dev</font></u></tt></a><tt><font size="4"><br>
></font></tt><font size="4"><br>
</font><tt><font size="4"><br>
--<br>
View this message in context: </font></tt><a href="http://old.nabble.com/Moving-OpenCMS---Update---%3E-need-help-tp27321409p27321556.html" target="_blank"><tt><u><font size="4" color="#0000FF">http://old.nabble.com/Moving-OpenCMS---Update---%3E-need-help-tp27321409p27321556.html</font></u></tt></a><tt><font size="4"><br>
Sent from the OpenCMS - Dev mailing list archive at Nabble.com.</font></tt><font size="4"><br>
<br>
</font><tt><font size="4"><br>
_______________________________________________<br>
This mail is sent to you from the opencms-dev mailing list<br>
To change your list options, or to unsubscribe from the list, please visit</font></tt><tt><u><font size="4" color="#0000FF"><br>
</font></u></tt><a href="http://lists.opencms.org/mailman/listinfo/opencms-dev" target="_blank"><tt><u><font size="4" color="#0000FF">http://lists.opencms.org/mailman/listinfo/opencms-dev</font></u></tt></a><font size="4"><br>
<br>
<br>
</font><tt><font size="4"><br>
_______________________________________________<br>
This mail is sent to you from the opencms-dev mailing list<br>
To change your list options, or to unsubscribe from the list, please visit</font></tt><tt><u><font size="4" color="#0000FF"><br>
</font></u></tt><a href="http://lists.opencms.org/mailman/listinfo/opencms-dev" target="_blank"><tt><u><font size="4" color="#0000FF">http://lists.opencms.org/mailman/listinfo/opencms-dev</font></u></tt></a><font size="4"><br>
<br>
</font><tt><font size="4"><br>
Frank Pertack</font></tt><font size="4"><br>
<br>
</font><tt><font size="4"><br>
Vater Solution GmbH<br>
Liebigstraße 26<br>
24145 Kiel</font></tt><font size="4"><br>
</font><tt><font size="4"><br>
Telefon: +49 431 20084-210<br>
Telefax: +49 431 20084-222<br>
Mobil: +49 151 16353519<br>
mailto: </font></tt><a href="mailto:fpertack@vater-gruppe.de" target="_blank"><tt><u><font size="4" color="#0000FF">fpertack@vater-gruppe.de</font></u></tt></a><tt><u><font size="4" color="#0000FF"><br>
</font></u></tt><a href="http://www.vater-gruppe.de/" target="_blank"><tt><u><font size="4" color="#0000FF">http://www.vater-gruppe.de</font></u></tt></a><font size="4"><br>
<br>
<br>
</font><tt><font size="4"><br>
Amtsgericht Kiel, HRB 6403<br>
Geschäftsführer:<br>
Klaus-Hinrich Vater<br>
Michael Wiese<br>
-----<br>
Diese Email enthält ggfs. vertrauliche und/oder rechtlich geschützte Informationen. Wenn Sie nicht der richtige Adressat sind oder diese Email irrtümlich erhalten haben, informieren Sie bitte sofort den Absender und vernichten Sie diese Email. Das unerlaubte Kopieren sowie die unbefugte Weitergabe dieser Email sind nicht gestattet.</font></tt><font size="4"><br>
<br>
<br>
</font><tt><font size="4"><br>
_______________________________________________<br>
This mail is sent to you from the opencms-dev mailing list<br>
To change your list options, or to unsubscribe from the list, please visit</font></tt><tt><u><font size="4" color="#0000FF"><br>
</font></u></tt><a href="http://lists.opencms.org/mailman/listinfo/opencms-dev" target="_blank"><tt><u><font size="4" color="#0000FF">http://lists.opencms.org/mailman/listinfo/opencms-dev</font></u></tt></a><font size="4"><br>
<br>
<br>
</font><tt><font size="4"><br>
_______________________________________________<br>
This mail is sent to you from the opencms-dev mailing list<br>
To change your list options, or to unsubscribe from the list, please visit</font></tt><tt><u><font size="4" color="#0000FF"><br>
</font></u></tt><a href="http://lists.opencms.org/mailman/listinfo/opencms-dev" target="_blank"><tt><u><font size="4" color="#0000FF">http://lists.opencms.org/mailman/listinfo/opencms-dev</font></u></tt></a><font size="4"><br>
<br>
Frank Pertack<br>
<br>
<br>
Vater Solution GmbH<br>
Liebigstraße 26<br>
24145 Kiel<br>
<br>
Telefon: +49 431 20084-210<br>
Telefax: +49 431 20084-222<br>
Mobil: +49 151 16353519<br>
mailto: </font><a href="mailto:fpertack@vater-gruppe.de" target="_blank"><u><font size="4" color="#0000FF">fpertack@vater-gruppe.de</font></u></a><u><font size="4" color="#0000FF"><br>
</font></u><a href="http://www.vater-gruppe.de/" target="_blank"><u><font size="4" color="#0000FF">http://www.vater-gruppe.de</font></u></a><font size="4"><br>
<br>
<br>
<br>
Amtsgericht Kiel, HRB 6403 <br>
Geschäftsführer:<br>
Klaus-Hinrich Vater<br>
Michael Wiese<br>
-----<br>
Diese Email enthält ggfs. vertrauliche und/oder rechtlich geschützte Informationen. Wenn Sie nicht der richtige Adressat sind oder diese Email irrtümlich erhalten haben, informieren Sie bitte sofort den Absender und vernichten Sie diese Email. Das unerlaubte Kopieren sowie die unbefugte Weitergabe dieser Email sind nicht gestattet.</font><br>
<font size="4"><br>
<br>
_______________________________________________<br>
This mail is sent to you from the opencms-dev mailing list<br>
To change your list options, or to unsubscribe from the list, please visit</font><u><font size="4" color="#0000FF"><br>
</font></u><a href="http://lists.opencms.org/mailman/listinfo/opencms-dev" target="_blank"><u><font size="4" color="#0000FF">http://lists.opencms.org/mailman/listinfo/opencms-dev</font></u></a></ul>
</ul>
<tt><br>
_______________________________________________<br>
This mail is sent to you from the opencms-dev mailing list<br>
To change your list options, or to unsubscribe from the list, please visit<br>
</tt><tt><a href="http://lists.opencms.org/mailman/listinfo/opencms-dev">http://lists.opencms.org/mailman/listinfo/opencms-dev</a></tt><br>
<br>
<br>
Frank Pertack<br>
<br>
<br>
Vater Solution GmbH<br>
Liebigstraße 26<br>
24145 Kiel<br>
<br>
Telefon: +49 431 20084-210<br>
Telefax: +49 431 20084-222<br>
Mobil: +49 151 16353519<br>
mailto: fpertack@vater-gruppe.de<br>
<a href="http://www.vater-gruppe.de">http://www.vater-gruppe.de</a><br>
<br>
<br>
<br>
Amtsgericht Kiel, HRB 6403 <br>
Geschäftsführer:<br>
Klaus-Hinrich Vater<br>
Michael Wiese<br>
-----<br>
Diese Email enthält ggfs. vertrauliche und/oder rechtlich geschützte Informationen. Wenn Sie nicht der richtige Adressat sind oder diese Email irrtümlich erhalten haben, informieren Sie bitte sofort den Absender und vernichten Sie diese Email. Das unerlaubte Kopieren sowie die unbefugte Weitergabe dieser Email sind nicht gestattet.<br>
<font size="2" face="Arial"> </font></body></html>