[opencms-dev] Antwort: Re: Antwort: Re: Antwort: Re: Moving OpenCMS & Update --> need help
Jessica Maas
yukarichan87 at googlemail.com
Wed Jan 27 10:42:29 CET 2010
I checked that and root has the password of the old opencms-installation and
the old mysql-server. So theoretically there should be no problem... I don't
understand that.
And root has got all privileges.
But now another problem appeared. I changed the setting you told me
(max_allowed_packet), I tried 32M, 16M, even 8M or 4M but nothing worked. I
mean I couldn't restart the mysql-server after changing this setting. So I
decided to change it back to 1M what it was before, but I still can't start
mysql now and I have no idea why. I didn't change anything else....
Something else: I tried another way on a second machine. I installed a new
version 7.5.1 (alone) without the old data. Then I replaced the original
database by the old database and made the update, because at the first try I
remembered that the database-update was successful but the following updates
not. So I thought if everything is already 7.5.1 but the database, maybe
that could work. And the update went through without problems. But sadly....
it still doesn't work.
When I try to start opencms now, I get this error:
HTTP Status 500 -
type Exception report
message
description The server encountered an internal error () that prevented it
from fulfilling this request.
exception
org.opencms.main.CmsInitException: Critical error during OpenCms
initialization: Unable to read the OpenCms XML configuration.
org.opencms.main.OpenCmsCore.getInstance(OpenCmsCore.java:289)
org.opencms.main.OpenCmsServlet.doGet(OpenCmsServlet.java:128)
javax.servlet.http.HttpServlet.service(HttpServlet.java:617)
javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
(Remember I'm testing now on two different machines, because I thought it
could be successful to try different things but the first machine is still
like I described it above.)
2010/1/26 Frank Pertack <fpertack at vater-gruppe.de>
> Hi Jessica,
>
> 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?
> 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.
> 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.
>
> I hope, this is the missing link for your problem. So you have to do the
> following with the mysql-DB:
>
> 1. In “/etc/my.cnf” unter „mysqld“ den Eintrag “max_allowed_packet”
> ändern auf (this allows you to transfer bigger data to the opencms Server):
> *
> *max_allowed_packet = 16M (32M falls erforderlich)
> 2. root-Password setzen auf: „*yourOpencmspassword*“:
> shell> mysqladmin –u root password *yourOpencmspassword*
> or:
> shell> mysql –u root mysql -p
> mysql> SET PASSWORD FOR 'root'@'localhost' = PASSWORD('*
> yourOpencmspassword*');
> 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!
>
> Be aware, it might be necessary, to grant privileges to the
> mysql-user 'root' es well with an instruction like the following:
> 1.
> - mysql> GRANT ALL PRIVILEGES ON root.* TO ‘root’@‘localhost‘
> IDENTIFIED BY ’yourOpencmspassword‘;
>
> I hope your are successful this time. Have a nice Evening ;-)
>
> Best regards
>
> Frank
>
>
> [image: Inactive hide details for Jessica Maas ---26.01.2010
> 16:16:04---Isn't the database-user and password saved in the opencms.prope]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
>
>
> Von:
> Jessica Maas <yukarichan87 at googlemail.com>
> An:
> The OpenCms mailing list <opencms-dev at opencms.org>
> Datum:
> 26.01.2010 16:16
> Betreff:
> Re: [opencms-dev] Antwort: Re: Antwort: Re: Moving OpenCMS & Update -->
> need help
>
> Gesendet von:
> opencms-dev-bounces at opencms.org
> ------------------------------
>
>
>
> 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.
>
> 2010/1/26 Frank Pertack <*fpertack at vater-gruppe.de*<fpertack at vater-gruppe.de>
> >
>
> Hi Jessica,
>
> 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!
>
> Try that out (take the old mysql opencms-user and password and it
> might work!)
>
> Best regards
>
>
> Frank
>
>
> -----*opencms-dev-bounces at opencms.org*<opencms-dev-bounces at opencms.org> schrieb:
> -----
>
>
> An: The OpenCms mailing list <*opencms-dev at opencms.org*<opencms-dev at opencms.org>
> >
> Von: Jessica Maas <*yukarichan87 at googlemail.com*<yukarichan87 at googlemail.com>
> >
> Gesendet von: *opencms-dev-bounces at opencms.org*<opencms-dev-bounces at opencms.org>
> Datum: 26.01.2010 03:51PM
> Betreff: Re: [opencms-dev] Antwort: Re: Moving OpenCMS & Update -->
> need help
>
>
>
> 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.
>
>
> The readme sais " Instructions for updating OpenCms 6.x/7.x to
> OpenCms 7.5.1"
>
>
> 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.
>
> 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:
>
> HTTP Status 500 -
>
> type Exception report
>
> message
>
> description The server encountered an internal error () that
> prevented it from fulfilling this request.
>
> exception
>
> org.opencms.main.CmsInitException: Critical error during OpenCms
> initialization: Unable to initialize connection pool "default". Is the
> database up and running?
> org.opencms.main.OpenCmsCore.getInstance(OpenCmsCore.java:265)
> org.opencms.main.OpenCmsServlet.doGet(OpenCmsServlet.java:127)
> javax.servlet.http.HttpServlet.service(HttpServlet.java:617)
> javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
>
> note The full stack trace of the root cause is available in the
> Apache Tomcat/6.0-snapshot logs.
>
> And yes, the database is up and running.
>
>
>
> 2010/1/26 Frank Pertack < *fpertack at vater-gruppe.de*<fpertack at vater-gruppe.de>
> >
>
>
> Hello Jessica,
>
> 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.
>
> 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".
>
> Did you check, whether OpenCms is running after the copy onto the
> new machine before updating it?
>
> Good luck
>
> Frank
>
>
> ----- *opencms-dev-bounces at opencms.org*<opencms-dev-bounces at opencms.org> schrieb:
> -----
>
>
> An: The OpenCms mailing list < *opencms-dev at opencms.org*<opencms-dev at opencms.org>
> >
> Von: Jessica Maas < *yukarichan87 at googlemail.com*<yukarichan87 at googlemail.com>
> >
> Gesendet von: *opencms-dev-bounces at opencms.org*<opencms-dev-bounces at opencms.org>
> Datum: 26.01.2010 01:40PM
> Betreff: Re: [opencms-dev] Moving OpenCMS & Update --> need help
>
>
> 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?
> b) Windows Server 2003 Enterprise R2
> c) MySQL
> 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.
>
> Thanks for the link. I will give it a try.
>
>
> 2010/1/26 Eska < *sven.kiesow at interone.de* <sven.kiesow at interone.de>
> >
>
>
> Hi,
>
> there is a lot of Information missing to even think about helping
> you.
>
> For example
>
> a) what is the OpenCms Version you have to update
> b) on what os is it running?
> c) what is your database
> d) any log file showing something unusual?
>
> and so on...
>
> Did you read e.g.*
> **
> http://old.nabble.com/Update-from-7.05-to-7.52-results-in-%22Resource-%28%29-is-not-available%22-td27283167.html
> *<http://old.nabble.com/Update-from-7.05-to-7.52-results-in-%22Resource-%28%29-is-not-available%22-td27283167.html>
> *
> **
> http://old.nabble.com/Update-from-7.05-to-7.52-results-in-%22Resource-%28%29-is-not-available%22-td27283167.html
> *<http://old.nabble.com/Update-from-7.05-to-7.52-results-in-%22Resource-%28%29-is-not-available%22-td27283167.html>
> , perhaps you have the same problem.
>
> Eska
>
>
>
> Jessica Maas wrote:
> >
> > Hi,
> >
> > I was told to move a current OpenCMS version to another server and
> then
> > update it.
> > This is what I did:
> >
> > I copied the whole "webapps"-folder of Tomcat and moved it into
> the
> > Tomcat-Folder of the new server. Then I copied the old
> opencms-database
> > and
> > moved it to the new server, too. I downloaded the upgrade wizard
> to 7.5.1
> > and followed the steps in the readme. It seems to update the
> database but
> > after the next step the update fails and shows me the following
> error,
> > appearing at: *
> http://localhost:8080/opencms/update/step_3_xmlupdate.jsp*<http://localhost:8080/opencms/update/step_3_xmlupdate.jsp>
> >
> > HTTP Status 500
> > OpenCms is not properly initialized!
> > Please make sure that the OpenCms setup wizard has been run once
> and is
> > disabled now.
> >
> > If I follow the message (disable the wizard) and reload the page,
> I get
> > another error:
> > *http://img5.imagebanana.com/view/3642uiig/ocms.jpg*<http://img5.imagebanana.com/view/3642uiig/ocms.jpg>
> >
> > And it stays even if I enable the wizard again.
> >
> > I tried it a second time, but it didn't work either and because
> the
> > database-update takes very long at each try this is very annoying.
> > What could I have done wrong?
> >
> > Thanks in advance,
> > Jessica
> >
> >
>
> > _______________________________________________
> > This mail is sent to you from the opencms-dev mailing list
> > To change your list options, or to unsubscribe from the list,
> please visit
> > *http://lists.opencms.org/mailman/listinfo/opencms-dev*<http://lists.opencms.org/mailman/listinfo/opencms-dev>
> >
>
> --
> View this message in context: *
> http://old.nabble.com/Moving-OpenCMS---Update---%3E-need-help-tp27321409p27321556.html
> *<http://old.nabble.com/Moving-OpenCMS---Update---%3E-need-help-tp27321409p27321556.html>
> Sent from the OpenCMS - Dev mailing list archive at Nabble.com.
>
>
> _______________________________________________
> This mail is sent to you from the opencms-dev mailing list
> To change your list options, or to unsubscribe from the list, please
> visit*
> **http://lists.opencms.org/mailman/listinfo/opencms-dev*<http://lists.opencms.org/mailman/listinfo/opencms-dev>
>
>
>
> _______________________________________________
> This mail is sent to you from the opencms-dev mailing list
> To change your list options, or to unsubscribe from the list, please
> visit*
> **http://lists.opencms.org/mailman/listinfo/opencms-dev*<http://lists.opencms.org/mailman/listinfo/opencms-dev>
>
>
> Frank Pertack
>
>
> Vater Solution GmbH
> Liebigstraße 26
> 24145 Kiel
>
> Telefon: +49 431 20084-210
> Telefax: +49 431 20084-222
> Mobil: +49 151 16353519
> mailto: *fpertack at vater-gruppe.de* <fpertack at vater-gruppe.de>*
> **http://www.vater-gruppe.de* <http://www.vater-gruppe.de/>
>
>
>
> Amtsgericht Kiel, HRB 6403
> Geschäftsführer:
> Klaus-Hinrich Vater
> Michael Wiese
> -----
> 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.
>
>
>
> _______________________________________________
> This mail is sent to you from the opencms-dev mailing list
> To change your list options, or to unsubscribe from the list, please
> visit*
> **http://lists.opencms.org/mailman/listinfo/opencms-dev*<http://lists.opencms.org/mailman/listinfo/opencms-dev>
>
>
>
> _______________________________________________
> This mail is sent to you from the opencms-dev mailing list
> To change your list options, or to unsubscribe from the list, please
> visit*
> **http://lists.opencms.org/mailman/listinfo/opencms-dev*<http://lists.opencms.org/mailman/listinfo/opencms-dev>
>
> Frank Pertack
>
>
> Vater Solution GmbH
> Liebigstraße 26
> 24145 Kiel
>
> Telefon: +49 431 20084-210
> Telefax: +49 431 20084-222
> Mobil: +49 151 16353519
> mailto: *fpertack at vater-gruppe.de* <fpertack at vater-gruppe.de>*
> **http://www.vater-gruppe.de* <http://www.vater-gruppe.de/>
>
>
>
> Amtsgericht Kiel, HRB 6403
> Geschäftsführer:
> Klaus-Hinrich Vater
> Michael Wiese
> -----
> 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.
>
>
> _______________________________________________
> This mail is sent to you from the opencms-dev mailing list
> To change your list options, or to unsubscribe from the list, please
> visit*
> **http://lists.opencms.org/mailman/listinfo/opencms-dev*<http://lists.opencms.org/mailman/listinfo/opencms-dev>
>
>
> _______________________________________________
> This mail is sent to you from the opencms-dev mailing list
> To change your list options, or to unsubscribe from the list, please visit
> http://lists.opencms.org/mailman/listinfo/opencms-dev
>
>
> Frank Pertack
>
>
> Vater Solution GmbH
> Liebigstraße 26
> 24145 Kiel
>
> Telefon: +49 431 20084-210
> Telefax: +49 431 20084-222
> Mobil: +49 151 16353519
> mailto: fpertack at vater-gruppe.de
> http://www.vater-gruppe.de
>
>
>
> Amtsgericht Kiel, HRB 6403
> Geschäftsführer:
> Klaus-Hinrich Vater
> Michael Wiese
> -----
> 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.
>
>
> _______________________________________________
> This mail is sent to you from the opencms-dev mailing list
> To change your list options, or to unsubscribe from the list, please visit
> http://lists.opencms.org/mailman/listinfo/opencms-dev
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://webmail.opencms.org/pipermail/opencms-dev/attachments/20100127/48037356/attachment.htm>
More information about the opencms-dev
mailing list