[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