AW: AW: AW: [opencms-dev] Installation encoding error
grenoml
grenoml at yahoo.com
Wed May 28 06:02:02 CEST 2003
Jakob, Frank,
Ok, I solved the installation encoding problem. It was the 2.0.14
JDBC driver. I downloaded and installed the newer 3.0.8 JDBC driver
and everything started working properly. Everything is installed with
UTF-8 encoding.
---------------
71: 5.0_rc_2 Kaitain
70: . Link rules init : finished
69: . Generating rulesets : ok
68: . Link rules init : starting
67: . Element cache : enabled
66: . Password validation : com.opencms.util.PasswordValidtation
65: . Launcher init : finished
64: . Launcher loaded : com.opencms.flex.CmsJspLoader with id 6
63: JSP export URL: null
62: JSP repository (web application path): /WEB-INF/jsp
61: JSP repository (absolute path):
/usr/local/jakarta-tomcat/webapps/opencms/WEB-INF/jsp/
60: Initialized!
59: . Launcher loaded : com.opencms.launcher.CmsLinkLauncher with
id 4
58: . Launcher loaded : com.opencms.flex.CmsDumpLoader with id 1
57: . Launcher loaded : com.opencms.flex.CmsXmlTemplateLoader with
id 3
56: [CmsTemplateCache] Initialized successfully.
55: . Launcher package : com.opencms.launcher
54: . Launcher init : starting
53: . Flex cache init : finished
52: . Flex cache init : starting
51: . Default file : 2 - index.jsp
50: . Default file : 1 - index.html
49: . Resource translation : 4 rules initialized
48: . Filename translation : enabled
47: . Resource translation : 0 rules initialized
46: . Directory translation: disabled
45: . Old locale support : disabled
44: . JSP errorPage commit : enabled
43: . OpenCms scheduler : enabled
42: . Legacy HTTP streaming: disabled
41: . Found mime types : 127 entrys
40: . Resource broker init : phase 4 ok - finished
39: . Initializing registry: finished
38: . Initializing registry: starting
37: [com.opencms.dbpool.CmsPool] mysqlonline: starting connection-guard
36: [com.opencms.dbpool.CmsPool] mysqlonline: created
35: [com.opencms.dbpool.CmsPool] mysqlonline: creating new connection.
Current Amount is:4
34: [com.opencms.dbpool.CmsPool] mysqlonline: creating new connection.
Current Amount is:3
33: [com.opencms.dbpool.CmsPool] mysqlonline: creating new connection.
Current Amount is:2
32: [com.opencms.dbpool.CmsPool] mysqlonline: creating new connection.
Current Amount is:1
31: [com.opencms.dbpool.CmsPool] mysqlonline: creating new connection.
Current Amount is:0
30: . Database fill default: yes
29: [com.opencms.dbpool.CmsPool] mysql: starting connection-guard
28: [com.opencms.dbpool.CmsPool] mysql: created
27: [com.opencms.dbpool.CmsPool] mysql: creating new connection.
Current Amount is:9
26: [com.opencms.dbpool.CmsPool] mysql: creating new connection.
Current Amount is:8
25: [com.opencms.dbpool.CmsPool] mysql: creating new connection.
Current Amount is:7
24: [com.opencms.dbpool.CmsPool] mysql: creating new connection.
Current Amount is:6
23: [com.opencms.dbpool.CmsPool] mysql: creating new connection.
Current Amount is:5
22: [com.opencms.dbpool.CmsPool] mysql: creating new connection.
Current Amount is:4
21: [com.opencms.dbpool.CmsPool] mysql: creating new connection.
Current Amount is:3
20: [com.opencms.dbpool.CmsPool] mysql: creating new connection.
Current Amount is:2
19: [com.opencms.dbpool.CmsPool] mysql: creating new connection.
Current Amount is:1
18: [com.opencms.dbpool.CmsPool] mysql: creating new connection.
Current Amount is:0
17: . Using digest encoding: MD5 from SUN version 1.42
16: . Digest file encoding : UTF-8
15: . Digest configured : MD5
14: . Database backup pool : jdbc:opencmspool:mysqlbackup
13: . Database online pool : jdbc:opencmspool:mysqlonline
12: . Database offline pool: jdbc:opencmspool:mysql
11: . Database access init : ok
10: . Resource broker init : phase 3 ok - creating db access module
9: . Resource broker init : phase 2 ok - initializing database
8: . Resource broker init : phase 1 ok - starting
7: . Resource broker class: com.opencms.file.mySql.CmsResourceBroker
6: . Resource broker used : mysql
5: . Operating sytem : Linux 2.4.18-19.8.0 i386
4: . Java VM in use : Java HotSpot(TM) Client VM 1.4.2-beta-b19
mixed mode Sun Microsystems Inc.
3: . Encoding set to : UTF-8
2: . System file.encoding : UTF-8
1: . OpenCms encoding : UTF-8
0: %%% props:
/usr/local/jakarta-tomcat/webapps/opencms/WEB-INF/config/opencms.properties
---------------
Seems like everything is ok now with the installation since switching
to the new 3.0.8 JDBC driver. In doing some research it may also have
been possible to get the 2.0.14 JDBC driver working with charset UTF-8
by adding the following URL parameters: useUnicode=true and
characterEncoding=UTF-8.
Ok, so now, the installation finishes and goes to final window
explaining activex control stuff for msie. Of course we have none of
this on Linux. I click on link to start opencms and it pops a
completely blank window in Mozilla. What now?
Ok, that link was taking me to:
http://localhost:8080/opencms/opencms/index.jsp
but if I strip off the filename and just go to:
http://localhost:8080/opencms/opencms
then I see the 'Congratulations!' page.
Ok, got logged into opencms and went and looked at index.jsp
properties. It has encoding set to iso-8859-1 which may have something
to do with why I got a blank page.
So now I am going to explore adding Java applet editor from Anil
Patel.
Thanks for all your help through this process.
rgds,
Gerry Reno
--- Jakob Lemler <Jakob.Lemler at t-online.de> wrote:
> Gerry,
>
> Ups, yes 4.1.0a could be the problem... But I am not sure, here the
> mailing list (or archive) would be the best place to ask. In the
> mysql
> manual there is a possibilty to create a logfile for mysql, perhaps
> there is some more information...
>
> As far as I could see, compared to my installation the differences
> are:
> 1) I use "root" and "rootsecret" for Database Server Connection and a
> separate user for OpenCms connection.
> 2) I put the jdbc driver into %catalina_home%/common/lib instead of
> the
> application lib directory.
> 3) I use the actual version of the mysql jdbc driver.
> 4) At this point of time I am running under Windows XP and mysql
> 4.0.12
>
> If you do not succeed this night I will discuss a little bit with
> Frank
> tommorrow morning (we are working actual on different projects in the
> same company...)
>
> If I will find the time, I will try the installation under Suse-Linux
> during the next days. If I will have some findings you'll get a new
> email...
>
> Today, point 1 and 2 would be my favorites...
> By the way, if you delete the space between "-p" and "secret" in the
> commandline you do not have to input the passwort again...
>
> Bye
> Jakob
> -----Urspr�ngliche Nachricht-----
> Von: opencms-dev-admin at opencms.org
> [mailto:opencms-dev-admin at opencms.org] Im Auftrag von grenoml
> Gesendet: Dienstag, 27. Mai 2003 23:23
> An: opencms-dev at opencms.org; Jakob Lemler
> Betreff: Re: AW: AW: [opencms-dev] Installation encoding error
>
>
> Jakob,
> Ok, let me see if I have everything you requested:
>
> OS: RH 8.0
>
> MySQL: 4.1.0a
>
> JDBC driver:
> mysql-connector-java-2_0_14-bin.jar is located in
> $CATALINA_HOME/webapps/opencms/WEB-INF/lib
>
> Here is everything on Setup wizard page:
> ---------------
> OpenCms Setup Wizard
> Select Database MySQL
>
> User Password
> Database Server Connection opencmsuser secret
> OpenCms Connection opencmsuser secret
> Connection String jdbc:mysql://localhost:3306/
> Database opencms
>
> {checked} Create database and tables
> Warning: Existing database will be dropped !
> ---------------
>
> recycled mysql
> recycled tomcat
>
> # mysql --user opencmsuser -p opencms
> Enter password: ******
> Welcome to the MySQL monitor. Commands end with ; or \g.
> Your MySQL connection id is 6 to server version: 4.1.0-alpha-max-log
>
> Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
>
> mysql> show tables;
> Empty set (0.01 sec)
>
> mysql> quit;
> Bye
>
> So I can access the database from the command line.
> Now, when I go through the opencms installation:
>
> ---------------
> Could no connect to database via: jdbc:mysql://localhost:3306/
> java.sql.SQLException: Communication failure during handshake. Is
> there
> a server running on localhost:3306?
> ---------------
>
> This one is a real mystery. I would attribute it to using 4.1.0a but
> everything else I have done with other apps with 4.1.0a has not had
> any
> problems at all with connections or accessing the test database.
>
> thx,
> Gerry Reno
>
>
> --- Jakob Lemler <Jakob.Lemler at t-online.de> wrote:
> > Hmm, last (hopefully not silly question) You installed the mysql
> jdbc
> > driver did you? I do not remember if it comes already together with
>
> > mysql binaries or if
> > I downloaded it separately...
> >
> > Bye Jakob
> >
> > -----Urspr�ngliche Nachricht-----
> > Von: grenoml [mailto:grenoml at yahoo.com]
> > Gesendet: Dienstag, 27. Mai 2003 22:07
> > An: Frank_Steinbauer/objectcomp/DE.OBJECTCOMP at objectcomp.com;
> > jakob.lemler at t-online.de; opencms-dev at opencms.org
> > Cc: grenoml at yahoo.com
> > Betreff: Re: AW: [opencms-dev] Installation encoding error
> >
> >
> > Frank,
> > Yes it will work without @localhost but the installation still
> does
> > not work.
> >
> > ----------------
> > Could no connect to database via: jdbc:mysql://localhost:3306/
> > java.sql.SQLException: Invalid authorization specification: Access
> > denied for user: 'opencmsuser at localhost' (Using password: YES)
> > ----------------
> >
> > Jakob was saying that it must work with user at localhost for
> > installation to work. And the passwords are the same for
> opencmsuser.
>
> > I think mysql
> > uses hostname field in creating encrypted password.
> >
> > Any other ideas?
> >
> > thx,
> > Gerry Reno
> >
> > --- Frank_Steinbauer/objectcomp/DE.OBJECTCOMP at objectcomp.com wrote:
> >
> > ---------------------------------
> >
> > Hi,
> >
> >
> >
> > sorry for answering this way. But normally my mails do not appear
> in
> > the mailing list. Do not know why.
> >
> >
> >
> > When I have a look at your dump, I think you have two different
> > passwords for the same user.
> >
> > But back to your problem, try it with out the @localhost when you
> want
> > to login.
> >
> >
> >
> > Frank
> >
> >
> > grenoml <grenoml at yahoo.com>
> > Sent by: opencms-dev-admin at opencms.org
> > 27.05.2003 12:26 MST
> > Please respond to opencms-dev
> >
> > To: Jakob Lemler <Jakob.Lemler at t-online.de>,
> opencms-dev at opencms.org
> > cc: grenoml at yahoo.com
> > bcc:
> > Subject: Re: AW: [opencms-dev] Installation encoding error
> >
> >
> >
> >
> > Jakob,
> > Ok, I did exactly what you suggested. I even created user
> > 'opencmsuser' and this is what is happening:
> >
> > here are commands:
> > create database opencms;
> > grant all on opencms.* to opencmsuser at localhost identified by
> > 'secret';
> > grant all on opencms.* to opencmsuser@"%" identified by 'secret';
> >
> > mysql --user opencmsuser at localhost -psecret opencms
> > ERROR 1045: Access denied for user:
> 'opencmsuser at localhost@localhost'
> > (Using password: YES)
> > ** Why is it showing multiple '@localhost'? **^^^^^^^^^^^^^^^^^^^^
> Is
>
=== message truncated ===
__________________________________
Do you Yahoo!?
Yahoo! Calendar - Free online calendar with sync to Outlook(TM).
http://calendar.yahoo.com
More information about the opencms-dev
mailing list