[opencms-dev] Antwort: Re: Antwort: Re: Antwort: Re: Moving OpenCMS & Update --> need help
Achim Westermann
achim.westermann at questico.de
Wed Jan 27 11:32:16 CET 2010
Hi Jessica,
I think it's time to send your opencms.log from /WEB-INF/logs/. Your configuration under /WEB-INF/config/ somewhere is broken or refers to
mmissing classes. The log file will tell. You should look for the first exception at start up. Many others follow but those won't help (only
refer to "Unable to read XML configuration".
kind regards,
Achim
Jessica Maas wrote:
> 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
> <mailto: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
>
>
> Inactive hide details for Jessica Maas ---26.01.2010
> 16:16:04---Isn't the database-user and password saved in the
> opencms.propeJessica 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
> <mailto:yukarichan87 at googlemail.com>>
>
> An:
> The OpenCms mailing list <opencms-dev at opencms.org
> <mailto: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 <mailto: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_
> <mailto: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_
> <mailto:opencms-dev-bounces at opencms.org> schrieb: -----
>
>
> An: The OpenCms mailing list <_opencms-dev at opencms.org_
> <mailto:opencms-dev at opencms.org>>
> Von: Jessica Maas <_yukarichan87 at googlemail.com_
> <mailto:yukarichan87 at googlemail.com>>
> Gesendet von: _opencms-dev-bounces at opencms.org_
> <mailto: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_
> <mailto: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_
> <mailto:opencms-dev-bounces at opencms.org> schrieb: -----
>
>
> An: The OpenCms mailing list < _opencms-dev at opencms.org_
> <mailto:opencms-dev at opencms.org> >
> Von: Jessica Maas < _yukarichan87 at googlemail.com_
> <mailto:yukarichan87 at googlemail.com> >
> Gesendet von: _opencms-dev-bounces at opencms.org_
> <mailto: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_
> <mailto: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_
> , 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 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_
> >
> > 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_
> >
>
> --
> View this message in context:
> _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_
>
>
>
> _______________________________________________
> 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_
> <mailto: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_
>
>
>
> _______________________________________________
> 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_
> <mailto: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_
>
>
> _______________________________________________
> 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 <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
>
>
>
> ------------------------------------------------------------------------
>
>
> _______________________________________________
> 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
More information about the opencms-dev
mailing list