[opencms-dev] Antwort: Re: Moving OpenCMS & Update --> need help
Frank Pertack
fpertack at vater-gruppe.de
Wed Jan 27 12:48:05 CET 2010
Hi Jessica,
ok, maybe there is something wrong in the WEB_INF as well as Achim told
you, but your Problem with the mysql Server is really strange:
The setting-change in the my.cnf (max_allowed_packed size) is recommended
by OpenCms, Doing so will enable you to transfer large files to the DB (is
important for transferring Pictures or importing modules as well).
I do not know, why your Sql-Server won't start. Please take a look into the
sql-logs to get more information.
When you 've got it running again, check in the "mysql"-database the table
"user". There must be the user root for localhost WITH password. Normally
this is done during the opencms-installation I guess, but since you copied
your opencms to that machine and made an update, I think you have to adjust
the localhost root-password in mysql manually.
Best regards
Frank
Von: Jessica Maas <yukarichan87 at googlemail.com>
An: The OpenCms mailing list <opencms-dev at opencms.org>
Datum: 27.01.2010 10:41
Betreff: Re: [opencms-dev] Antwort: Re: Antwort: Re: Antwort: Re: Moving OpenCMS & Update --> need help
Gesendet opencms-dev-bounces at opencms.org
von:
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:
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
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 opencms-dev-bounces at opencms.org
von:
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>
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 schrieb: -----
An: The OpenCms mailing list <opencms-dev at opencms.org>
Von: Jessica Maas <yukarichan87 at googlemail.com>
Gesendet von: 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 >
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 schrieb: -----
An: The OpenCms mailing list < opencms-dev at opencms.org >
Von: Jessica Maas < yukarichan87 at googlemail.com >
Gesendet von: 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 >
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
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
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
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
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.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://webmail.opencms.org/pipermail/opencms-dev/attachments/20100127/4477549f/attachment.htm>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: graycol.gif
Type: image/gif
Size: 105 bytes
Desc: not available
URL: <https://webmail.opencms.org/pipermail/opencms-dev/attachments/20100127/4477549f/attachment.gif>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: ecblank.gif
Type: image/gif
Size: 45 bytes
Desc: not available
URL: <https://webmail.opencms.org/pipermail/opencms-dev/attachments/20100127/4477549f/attachment-0001.gif>
More information about the opencms-dev
mailing list