[opencms-dev] Antwort: Re: Antwort: Re: Antwort: Re: Moving OpenCMS & Update --> need help
Frank Pertack
fpertack at vater-gruppe.de
Tue Jan 26 20:32:05 CET 2010
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:
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)
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
|------------>
| 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>
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.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://webmail.opencms.org/pipermail/opencms-dev/attachments/20100126/429a9e06/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/20100126/429a9e06/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/20100126/429a9e06/attachment-0001.gif>
More information about the opencms-dev
mailing list