<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<meta http-equiv=Content-Type content="text/html; charset=us-ascii">
<meta name=Generator content="Microsoft Word 12 (filtered medium)">
<style>
<!--
/* Font Definitions */
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:Consolas;
panose-1:2 11 6 9 2 2 4 3 2 4;}
@font-face
{font-family:Verdana;
panose-1:2 11 6 4 3 5 4 4 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman","serif";}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
code
{mso-style-priority:99;
font-family:"Courier New";}
pre
{mso-style-priority:99;
mso-style-link:"HTML Vorformatiert Zchn";
margin:0cm;
margin-bottom:.0001pt;
font-size:10.0pt;
font-family:"Courier New";}
p.MsoListParagraph, li.MsoListParagraph, div.MsoListParagraph
{mso-style-priority:34;
margin-top:0cm;
margin-right:0cm;
margin-bottom:0cm;
margin-left:36.0pt;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman","serif";}
span.HTMLVorformatiertZchn
{mso-style-name:"HTML Vorformatiert Zchn";
mso-style-priority:99;
mso-style-link:"HTML Vorformatiert";
font-family:Consolas;}
span.htmlvorformatiertzchn0
{mso-style-name:htmlvorformatiertzchn;
mso-style-priority:99;
font-family:"Courier New";}
span.E-MailFormatvorlage22
{mso-style-type:personal;
font-family:"Verdana","sans-serif";
color:windowtext;
font-weight:normal;
font-style:normal;
text-decoration:none none;}
span.E-MailFormatvorlage23
{mso-style-type:personal;
font-family:"Calibri","sans-serif";
color:#1F497D;}
span.E-MailFormatvorlage24
{mso-style-type:personal;
font-family:"Verdana","sans-serif";
color:blue;
font-weight:normal;
font-style:normal;
text-decoration:none none;}
span.E-MailFormatvorlage25
{mso-style-type:personal;
font-family:"Calibri","sans-serif";
color:#1F497D;}
span.E-MailFormatvorlage26
{mso-style-type:personal;
font-family:"Verdana","sans-serif";
color:blue;
font-weight:normal;
font-style:normal;
text-decoration:none none;}
span.E-MailFormatvorlage27
{mso-style-type:personal-reply;
font-family:"Calibri","sans-serif";
color:#1F497D;}
.MsoChpDefault
{mso-style-type:export-only;
font-size:10.0pt;}
@page Section1
{size:595.3pt 841.9pt;
margin:70.85pt 70.85pt 2.0cm 70.85pt;}
div.Section1
{page:Section1;}
/* List Definitions */
@list l0
{mso-list-id:1083645560;
mso-list-type:hybrid;
mso-list-template-ids:390335426 67567631 67567641 67567643 67567631 67567641 67567643 67567631 67567641 67567643;}
@list l0:level1
{mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-18.0pt;}
@list l0:level2
{mso-level-tab-stop:72.0pt;
mso-level-number-position:left;
text-indent:-18.0pt;}
@list l0:level3
{mso-level-tab-stop:108.0pt;
mso-level-number-position:left;
text-indent:-18.0pt;}
@list l0:level4
{mso-level-tab-stop:144.0pt;
mso-level-number-position:left;
text-indent:-18.0pt;}
@list l0:level5
{mso-level-tab-stop:180.0pt;
mso-level-number-position:left;
text-indent:-18.0pt;}
@list l0:level6
{mso-level-tab-stop:216.0pt;
mso-level-number-position:left;
text-indent:-18.0pt;}
@list l0:level7
{mso-level-tab-stop:252.0pt;
mso-level-number-position:left;
text-indent:-18.0pt;}
@list l0:level8
{mso-level-tab-stop:288.0pt;
mso-level-number-position:left;
text-indent:-18.0pt;}
@list l0:level9
{mso-level-tab-stop:324.0pt;
mso-level-number-position:left;
text-indent:-18.0pt;}
ol
{margin-bottom:0cm;}
ul
{margin-bottom:0cm;}
-->
</style>
<!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
</head>
<body lang=DE link=blue vlink=purple>
<div class=Section1>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'>Hi Jane,<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'>…<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'> <span lang=EN-GB>Copy the opencms database from your old
database directory to the new servers database directory. (The safer way would
be to do this via mysqldump) <o:p></o:p></span></span></p>
<p class=MsoListParagraph style='margin-left:0cm'><span lang=EN-GB
style='font-size:10.0pt;font-family:"Verdana","sans-serif";color:blue'>[SJS] In
the root-directory I just typed “mysqldump --opt -p --all-databases >
datensicherung.sql”. That’s the right approach, right?<o:p></o:p></span></p>
<pre><span lang=EN-GB style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'>[KS] It would be good to just dump the OpenCms database. The syntax is similar: </span><b><span
lang=EN-GB>mysqldump --opt <i>db_name</i> > <i>backup-file.sql<o:p></o:p></i></span></b></pre><pre><span
lang=EN-GB style='font-family:"Verdana","sans-serif";color:#993366'>[SJS] mysqldump --opt -p opencms > backup-file.sql done. Just out of curiosity and that I know it next time: why is it better not to copy all databases at once?<o:p></o:p></span></pre>
<p class=MsoListParagraph style='margin-left:0cm'><span lang=EN-GB
style='font-size:10.0pt;font-family:"Verdana","sans-serif";color:#1F497D'>[KS2]
That’s because for copying the opencms database from one server to the
other, you just have to copy the opencms database. You don’t need the
other ones. And if you copy all databases with one script to another server you
might accidently overwrite an existing database.<o:p></o:p></span></p>
<p class=MsoListParagraph style='margin-left:0cm'><span lang=EN-GB
style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoListParagraph style='text-indent:-18.0pt;mso-list:l0 level1 lfo2'><![if !supportLists]><span
lang=EN-GB style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'><span style='mso-list:Ignore'>1.<span style='font:7.0pt "Times New Roman"'>
</span></span></span><![endif]><span lang=EN-GB style='font-size:11.0pt;
font-family:"Calibri","sans-serif";color:#1F497D'>Change the db connection in
the opencms.properties file. It is located in the WEB-INF/config directory of
your opencms webapp.<o:p></o:p></span></p>
<p class=MsoListParagraph style='margin-left:0cm'><span lang=EN-GB
style='font-size:10.0pt;font-family:"Verdana","sans-serif";color:blue'>[SJS] I
cannot find a “db connection” in that file, but a lot of entries
that start with “db.pool.default” Or did you mean those entries:<o:p></o:p></span></p>
<p class=MsoListParagraph><span lang=EN-GB style='font-size:10.0pt;font-family:
"Verdana","sans-serif";color:blue'>server.ethernet.address=…<o:p></o:p></span></p>
<p class=MsoListParagraph><span lang=EN-GB style='font-size:10.0pt;font-family:
"Verdana","sans-serif";color:blue'>server.name=OpenCmsServer<o:p></o:p></span></p>
<p class=MsoListParagraph><span lang=EN-GB style='font-size:10.0pt;font-family:
"Verdana","sans-serif";color:blue'>?<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-GB style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'>[KS] Have a look for the following lines: <o:p></o:p></span></p>
<p class=MsoListParagraph><span lang=EN-GB style='font-size:11.0pt;font-family:
"Calibri","sans-serif";color:#1F497D'># URL of the JDBC driver<o:p></o:p></span></p>
<p class=MsoListParagraph><span lang=EN-GB style='font-size:11.0pt;font-family:
"Calibri","sans-serif";color:#1F497D'>db.pool.default.jdbcUrl=jdbc:mysql://<b>SERVERNAME</b>:3306/<b>DB_NAME</b><o:p></o:p></span></p>
<p class=MsoListParagraph><span lang=EN-GB style='font-size:11.0pt;font-family:
"Calibri","sans-serif";color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoListParagraph><span lang=EN-GB style='font-size:11.0pt;font-family:
"Calibri","sans-serif";color:#1F497D'>...<o:p></o:p></span></p>
<p class=MsoListParagraph><span lang=EN-GB style='font-size:11.0pt;font-family:
"Calibri","sans-serif";color:#1F497D'>...<o:p></o:p></span></p>
<p class=MsoListParagraph><span lang=EN-GB style='font-size:11.0pt;font-family:
"Calibri","sans-serif";color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoListParagraph><span lang=EN-GB style='font-size:11.0pt;font-family:
"Calibri","sans-serif";color:#1F497D'># user name to connect to the database<o:p></o:p></span></p>
<p class=MsoListParagraph><span lang=EN-GB style='font-size:11.0pt;font-family:
"Calibri","sans-serif";color:#1F497D'>db.pool.default.user=<b>USERNAME</b><o:p></o:p></span></p>
<p class=MsoListParagraph><span lang=EN-GB style='font-size:11.0pt;font-family:
"Calibri","sans-serif";color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoListParagraph><span lang=EN-GB style='font-size:11.0pt;font-family:
"Calibri","sans-serif";color:#1F497D'># password to connect to the database<o:p></o:p></span></p>
<p class=MsoListParagraph style='margin-left:0cm;text-indent:35.4pt'><span
lang=EN-GB style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'>db.pool.default.password=<b>PASSWORD</b><o:p></o:p></span></p>
<p class=MsoListParagraph style='margin-left:0cm'><span lang=EN-GB
style='font-size:10.0pt;font-family:"Verdana","sans-serif";color:blue'><o:p> </o:p></span></p>
<p class=MsoListParagraph style='margin-left:0cm'><span lang=EN-GB
style='font-size:10.0pt;font-family:"Verdana","sans-serif";color:blue'><o:p> </o:p></span></p>
<p class=MsoListParagraph style='margin-left:0cm'><span lang=EN-GB
style='font-size:10.0pt;font-family:"Verdana","sans-serif";color:#993366'>[SJS]
I changed username and password and left <o:p></o:p></span></p>
<p class=MsoListParagraph style='margin-left:0cm;text-indent:35.4pt'><span
lang=EN-GB style='font-size:10.0pt;font-family:"Verdana","sans-serif";
color:#993366'># URL of the JDBC driver<o:p></o:p></span></p>
<p class=MsoListParagraph><span lang=EN-GB style='font-size:10.0pt;font-family:
"Verdana","sans-serif";color:#993366'>db.pool.default.jdbcUrl=jdbc:mysql://localhost:3306/opencms<o:p></o:p></span></p>
<p class=MsoListParagraph><span lang=EN-GB style='font-size:10.0pt;font-family:
"Verdana","sans-serif";color:#993366'><o:p> </o:p></span></p>
<p class=MsoListParagraph><span lang=EN-GB style='font-size:10.0pt;font-family:
"Verdana","sans-serif";color:#993366'>the same, because the name of the db is
the same, also that it’s on the same machine as tomcat. Is that the right
procedure? <o:p></o:p></span></p>
<p class=MsoListParagraph><span lang=EN-GB style='font-size:10.0pt;font-family:
"Verdana","sans-serif";color:#993366'>Do I need to change the
“server.ethernet.adress”, too? That one is in Hex there, and ifconfig
tells me a hexadress only for the hardware adress, so is this that what I need
to put in there?<o:p></o:p></span></p>
<p class=MsoListParagraph style='margin-left:0cm'><span lang=EN-GB
style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>[KS2]
You don’t need to change that. AFAIK this value is used for generation of
UUIDs.<o:p></o:p></span></p>
<p class=MsoListParagraph><span lang=EN-GB style='font-size:10.0pt;font-family:
"Verdana","sans-serif";color:#993366'><o:p> </o:p></span></p>
<p class=MsoListParagraph style='text-indent:-18.0pt;mso-list:l0 level1 lfo2'><![if !supportLists]><span
lang=EN-GB style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'><span style='mso-list:Ignore'>2.<span style='font:7.0pt "Times New Roman"'>
</span></span></span><![endif]><span lang=EN-GB style='font-size:11.0pt;
font-family:"Calibri","sans-serif";color:#1F497D'>Change the server connection
in the opencms-system.xml as well.<o:p></o:p></span></p>
<p class=MsoListParagraph style='margin-left:0cm'><span lang=EN-GB
style='font-size:10.0pt;font-family:"Verdana","sans-serif";color:blue'>[SJS]
Did you mean something like<o:p></o:p></span></p>
<p class=MsoListParagraph><span lang=EN-GB style='font-size:10.0pt;font-family:
"Verdana","sans-serif";color:blue'> <sites><o:p></o:p></span></p>
<p class=MsoListParagraph><span lang=EN-GB style='font-size:10.0pt;font-family:
"Verdana","sans-serif";color:blue'>
<workplace-server>http://www. … .de</workplace-server><o:p></o:p></span></p>
<p class=MsoListParagraph><span lang=EN-GB style='font-size:10.0pt;font-family:
"Verdana","sans-serif";color:blue'> </span><span
style='font-size:10.0pt;font-family:"Verdana","sans-serif";color:blue'><default-uri>/sites/default/</default-uri><o:p></o:p></span></p>
<p class=MsoListParagraph><span lang=EN-GB style='font-size:10.0pt;font-family:
"Verdana","sans-serif";color:blue'> <site
server="http://www. ... .de" uri="/sites/default/"/><o:p></o:p></span></p>
<p class=MsoListParagraph><span lang=EN-GB style='font-size:10.0pt;font-family:
"Verdana","sans-serif";color:blue'>? I cannot find any ip-adress in there, only
URLs to websites, where the current projects are.<o:p></o:p></span></p>
<p class=MsoListParagraph style='margin-left:0cm'><span lang=EN-GB
style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>[KS]
Yes, that is correct. If you are accessing your new server via IP, you can type
an IP address in there.<o:p></o:p></span></p>
<p class=MsoListParagraph style='margin-left:0cm'><span lang=EN-GB
style='font-size:10.0pt;font-family:"Verdana","sans-serif";color:#993366'>[SJS]
Mmh, that is a little bit tricky: the old server is the one the websites lie on
now, and that server will continue to run. The new server is just for testing
purposes, that is, I want to change websites on that server, test if everything
works out fine and deploy them to the old web server, without changing of
addresses.<o:p></o:p></span></p>
<p class=MsoListParagraph style='margin-left:0cm'><span lang=EN-GB
style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>[KS2]
Ok, that sounds just like a second server for testing. There is no connection
between them. Right? <o:p></o:p></span></p>
<p class=MsoListParagraph style='margin-left:0cm'><span lang=EN-GB
style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>So for
opencms-system.xml enter the Servername or IP-Address (http://<a
href="http://www.mytestserver.de">www.mytestserver.de</a>:TOMCATPORT/ or <a
href="http://IP-ADDRESS:TOMCATPORT/">http://IP-ADDRESS:TOMCATPORT/</a>) to the
workplace-server and site-server node.<o:p></o:p></span></p>
<p class=MsoListParagraph style='margin-left:0cm'><span lang=EN-GB
style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>I don’t
know what to configure in Tomcat. I guess it must be the same as in
opencms-system.xml (http://<a href="http://www.mytestserver.de">www.mytestserver.de</a>:TOMCATPORT/
or <a href="http://IP-ADDRESS:TOMCATPORT/">http://IP-ADDRESS:TOMCATPORT/</a>).<o:p></o:p></span></p>
<p class=MsoListParagraph style='margin-left:0cm'><span lang=EN-GB
style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>Actually
there is no difference in the configuration of Tomcat for Linux or Windows
(AFAIK).<o:p></o:p></span></p>
<p class=MsoListParagraph><span lang=EN-GB style='font-size:10.0pt;font-family:
"Verdana","sans-serif";color:#993366'>So should I leave the opencms-system.xml</span><span
lang=EN-GB style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#993366'> </span><span lang=EN-GB style='font-size:10.0pt;font-family:
"Verdana","sans-serif";color:#993366'>as-is and copy the
/var/lib/tomcat5.5/conf/server.xml to the new server and e.g. change the Ports
in the following part to something else?:<o:p></o:p></span></p>
<p class=MsoListParagraph><span lang=EN-GB style='font-size:10.0pt;font-family:
"Verdana","sans-serif";color:#993366'><!—Website www. … .de
--><o:p></o:p></span></p>
<p class=MsoListParagraph><span lang=EN-GB style='font-size:10.0pt;font-family:
"Verdana","sans-serif";color:#993366'> <Connector
port="8189" maxHttpHeaderSize="8192"<o:p></o:p></span></p>
<p class=MsoListParagraph><span lang=EN-GB style='font-size:10.0pt;font-family:
"Verdana","sans-serif";color:#993366'>
maxThreads="150" minSpareThreads="25"
maxSpareThreads="75"<o:p></o:p></span></p>
<p class=MsoListParagraph><span lang=EN-GB style='font-size:10.0pt;font-family:
"Verdana","sans-serif";color:#993366'>
proxyName="www.actsystems.de" proxyPort="80"<o:p></o:p></span></p>
<p class=MsoListParagraph><span lang=EN-GB style='font-size:10.0pt;font-family:
"Verdana","sans-serif";color:#993366'>
enableLookups="true" redirectPort="8443"
acceptCount="100"<o:p></o:p></span></p>
<p class=MsoListParagraph><span lang=EN-GB style='font-size:10.0pt;font-family:
"Verdana","sans-serif";color:#993366'>
connectionTimeout="20000"<o:p></o:p></span></p>
<p class=MsoListParagraph><span lang=EN-GB style='font-size:10.0pt;font-family:
"Verdana","sans-serif";color:#993366'>
useURIValidationHack="false"<o:p></o:p></span></p>
<p class=MsoListParagraph><span lang=EN-GB style='font-size:10.0pt;font-family:
"Verdana","sans-serif";color:#993366'>
disableUploadTimeout="true" /><o:p></o:p></span></p>
<p class=MsoNormal style='text-autospace:none'><span lang=EN-GB
style='font-size:10.0pt;font-family:"Verdana","sans-serif";color:#993366'>
Or should I change the server connection to <o:p></o:p></span></p>
<p class=MsoNormal style='text-autospace:none'><span lang=EN-GB
style='font-size:10.0pt;font-family:"Verdana","sans-serif";color:#993366'>
</span><span lang=EN-GB style='font-size:9.0pt;font-family:"Courier New"'><mailhost
name="localhost" protocol="smtp" user="..."
password="..."/><o:p></o:p></span></p>
<p class=MsoNormal style='text-autospace:none'><span lang=EN-GB
style='font-size:9.0pt;font-family:"Courier New"'>
...<o:p></o:p></span></p>
<p class=MsoNormal style='text-autospace:none'><span lang=EN-GB
style='font-size:9.0pt;font-family:"Courier New"'>
<</span><span style='font-size:9.0pt;font-family:"Courier New"'>sites><o:p></o:p></span></p>
<p class=MsoNormal style='text-autospace:none'><span style='font-size:9.0pt;
font-family:"Courier New"'>
<workplace-server>http://localhost:8080</workplace-server><o:p></o:p></span></p>
<p class=MsoNormal style='text-autospace:none'><span style='font-size:9.0pt;
font-family:"Courier New"'>
<default-uri>/sites/default/</default-uri><o:p></o:p></span></p>
<p class=MsoNormal style='text-autospace:none'><span style='font-size:9.0pt;
font-family:"Courier New"'> </span><span
lang=EN-GB style='font-size:9.0pt;font-family:"Courier New"'><site
server="http://localhost:8080" uri="/sites/default/"/><o:p></o:p></span></p>
<p class=MsoNormal style='text-autospace:none'><span lang=EN-GB
style='font-size:9.0pt;font-family:"Courier New"'>
</sites><o:p></o:p></span></p>
<p class=MsoListParagraph><span lang=EN-GB style='font-size:10.0pt;font-family:
"Verdana","sans-serif";color:#993366'>as the websites will be on the same
machine as tomcat? I’m confused, because I’m still really new to
Linux, and even newer to OpenCms and I think I’m just missing something
really obvious.<o:p></o:p></span></p>
<p class=MsoListParagraph style='margin-left:0cm'><span lang=EN-GB
style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>[KS2]
It doesn’t matter how your infrastructure looks like. The settings in opencms-system.xml
have to be exactly like how you access the OpenCms with your browser
(Especially for the workplace-server setting). For the site server it is
possible to define aliases. But as I already mentioned, I don’t know very
much about Apache / Proxy configuration. Please refer to www.opencms-wiki.org.<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Verdana","sans-serif";
color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'>Regards<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'>Kai</span><span lang=EN-GB style='font-size:10.0pt;font-family:
"Verdana","sans-serif"'><o:p></o:p></span></p>
</div>
</body>
</html>