AW: AW: [opencms-dev] Installation encoding error
grenoml
grenoml at yahoo.com
Tue May 27 23:32:01 CEST 2003
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
> this a problem or just a bug in output?
>
>
> Here is dump of mysql:user table entry:
> | localhost | opencmsuser |
> *976ee780ecd59f4f5ec81b0b05377abf670446269cd4 | N | N
> | N | N | N | N | N |
> N | N | N | N | N
> | N | N | N | N | N
> | N | N | N | N
> | | | | |
>
>
> 0 | 0 | 0 |
> | % | opencmsuser |
> *b7f81e7a19c47ae7a3a67e0f4cc9a59ed516fbf50e84 | N | N
> | N | N | N | N | N |
> N | N | N | N | N
> | N | N | N | N | N
> | N | N | N | N
> | | | | |
>
>
> 0 | 0 | 0 |
>
> Here is dump of mysql:db table entries:
> | localhost | opencms | opencmsuser | Y | Y | Y
> | Y | Y | Y | Y | Y
> | Y | Y | Y | Y
>
>
> |
> | % | opencms | opencmsuser | Y | Y | Y
> | Y | Y | Y | N | Y
> | Y | Y | Y | Y
>
> |
>
>
>
> thx,
> Gerry Reno
>
>
> --- Jakob Lemler <Jakob.Lemler at t-online.de> wrote:
> > Ok, so it's sure you have just a problem with your db-access
> rights.
> >
> > You can grant the necessary user and rights e.g. with:
> >
> > 1) connect as root to mysql: mysql --user root -psecret
> > 2) then: grant all privileges on opencms.* to username@"%"
> identified
> > by
> > 'secret';
> >
> > Then logout and reconnect with:
> > Mysql --user username at localhost -psecret opencms
> >
> > The last one must work to get the installation running... Good
> luck.
> >
> > Bye
> > Jakob
> >
> > -----Urspr�ngliche Nachricht-----
> > Von: grenoml [mailto:grenoml at yahoo.com]
> > Gesendet: Dienstag, 27. Mai 2003 16:47
> > An: opencms-dev at opencms.org
> > Cc: grenoml at yahoo.com; Jakob.Lemler at t-online.de
> > Betreff: Re: [opencms-dev] Installation encoding error
> >
> >
> > Please be sure to cc: me since I receive digest version. - thanks.
> >
> > Jakob,
> > I followed your suggestion and manually created the opencms
> database
> > and then tried to access it using the following commands:
> >
> > mysql --user root -psecret opencms (this works)
> >
> > mysql --user root at localhost -psecret opencms (this does not work)
> > ERROR
> > 1044: Access denied for user: '@localhost' to database 'opencms'
> >
> > mysql --user root -h localhost -psecret opencms (this works)
> >
> >
> > rgds,
> > Gerry Reno
> >
> >
> > --- grenoml <grenoml at yahoo.com> wrote:
> > > I retested and I can connect to database using:
> > >
> > > mysql -h localhost -P 3306
> > > (then providing password)
> > >
> > > and I can create the database using:
> > >
> > > mysql> create database opencms;
> > > Query OK, 1 row affected (0.04 sec)
> > >
> > > mysql> show databases;
> > > +----------+
> > > | Database |
> > > +----------+
> > > | mysql |
>
=== message truncated ===
__________________________________
Do you Yahoo!?
The New Yahoo! Search - Faster. Easier. Bingo.
http://search.yahoo.com
More information about the opencms-dev
mailing list