AW: [opencms-dev] Installation encoding error
grenoml
grenoml at yahoo.com
Tue May 27 23:39:01 CEST 2003
Frank,
Yes, they are N in global sense. If you look in db table you will
see that user opencmsuser has all these permissions on db opencms. I
think flush privileges is only needed if you modify grants table
directly. Anyway, yes I did it and also restarted mysql and tomcat
several times. I have sent another email with answers to Jakobs
questions. Take a look at it.
thx,
Gerry Reno
--- Frank_Steinbauer/objectcomp/DE.OBJECTCOMP at objectcomp.com wrote:
---------------------------------
Hi,
ok, next look at your dump. Damed, lot of "N" for the privileges.
I think you need at least the select, insert, update and delete
privileg. I am not sure about the create, but you should grant it to
the user, course the setup creates some tables.
1st N = select
2nd N = insert
3th N = update
4th N = delete
5th N = create
Change them to "Y".
Another question, did you restart the db after you created the user or
executed the command "flush privileges;"? If not, try it before you
update the table entries.
By the way, my password encryption is much shorter then yours.
Frank
grenoml <grenoml at yahoo.com>
27.05.2003 13:07 MST
To: Frank_Steinbauer/objectcomp/DE.OBJECTCOMP at objectcomp.com,
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
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 |
> > | opencms |
> > | test |
> > +----------+
> > 3 rows in set (0.00 sec)
> >
> > but the installation refuses to do the same. What can be done?
> >
> > thx,
> > Gerry Reno
> >
> >
> > --- grenoml <grenoml at yahoo.com> wrote:
> > > Gokul,
> > > Thanks for the reply. Yes, I had an error in my password. But
> > now
> > > password is correct and it is not creating any database. It
> gives
> > a
> > > new error:
> > > ------------------
> > > Could no connect to database via: jdbc:mysql://localhost:3306/
> > > java.sql.SQLException: Cannot connect to MySQL server on
> > > localhost:3306. Is there a MySQL server running on the
> machine/port
> > > you are trying to connect to? (java.lang.NumberFormatException)
> > >
> > > -------------------------------------------
> > > java.lang.NullPointerException
> > >
> > > -------------------------------------------
> > > ------------------
> > >
> > > I verified that mysql is running and I can connect to it using
> > > 'mysql' in xterm window. What is the
> > > java.lang.NumberFormatException?
> > >
> > >
> > > thx,
> > > Gerry Reno
> > >
> > >
> > > --- Gokul Poduval wrote:
> > > > Hello,
> > > > If you could get beyond the file encoding check, then that
> part
> > > of
> > > > your
> > > > problem is already solved.
> > > >
> > > > As for database creating, make sure you are using the right
> > > > username
> > > > password. In my case I have granted all privileges on
> opencms.*
> > > to
> > > > opencmsuser at localhost
> > > >
> > > > Gokul
> > > >
> > > > On Mon, 26 May 2003 17:17:06 -0700 (PDT), "grenoml"
> > > > said:
> > > > > Hello,
> > > > > I am attempting to install OpenCMS on RH9 but running into
> > some
> > > > > encoding problems. I am receiving the following error:
> > > > > -----------------
> > > > > Error: the encoding of your Java VM is different from the
> > OpenCms
> > > > > encoding!
> > > > >
> > > > > Java VM file encoding: UTF-8
> > > > >
> > > > > OpenCms encoding: ISO-8859-1
> > > > > -----------------
> > > > >
> > > > > I have about twenty other Tomcat webapps running well using
> > the
> > > > UTF-8
> > > > > encoding for the Java VM and I would like not to change that.
> > > How
> > > > can
> > > > > I get the install to work? I went into opencms.properties
> and
> > > > changed
> > > > > the default encoding to UTF-8 and restarted Tomcat but I then
> > get
> > > > > database errors:
> > > > > -----------------
> > > > >
> > > > > Creating database ... Failed
> > > > >
> > > > > Could no connect to database via:
> jdbc:mysql://localhost:3306/
> > > > > java.sql.SQLException: Invalid authorization specification:
> > > Access
> > > > > denied for user: 'root at localhost' (Using password: YES)
> > > > >
> > > > > -------------------------------------------
> > > > > java.lang.NullPointerException
> > > > >
> > > > > -------------------------------------------
> > > > >
> > > > > Creating tables ... Failed
> > > > >
> > > > > Could no connect to database via:
> > > > jdbc:mysql://localhost:3306/opencms
> > > > > java.sql.SQLException: Invalid authorization specification:
> > > Access
> > > > > denied for user: 'root at localhost' (Using password: YES)
> > > > >
> > > > > -------------------------------------------
> > > > > java.lang.NullPointerException
> > > > >
> > > > > ... {many times}
> > > > >
> > > > > java.lang.NullPointerException
> > > > >
> > > > > -------------------------------------------
> > > > >
> > > > > I am using the mysql database user/password for root and
> not
> > > > system
> > > > > user/password for root.
> > > > >
> > > > > My question is how to get the installation working without
> > > > changing
> > > > > the default encoding for the VM?
> > > > >
> > > > > thx,
> > > > > Gerry Reno
> > > > >
> > > > >
> > > > > __________________________________
> > > > > Do you Yahoo!?
> > > > > The New Yahoo! Search - Faster. Easier. Bingo.
> > > > > http://search.yahoo.com
> > > > > _______________________________________________
> > > > > This mail is send to you from the opencms-dev mailing list To
>
> > > > > change your list options, or to unsubscribe from the list,
> > > > please
>
=== message truncated ===
__________________________________
Do you Yahoo!?
The New Yahoo! Search - Faster. Easier. Bingo.
http://search.yahoo.com
_______________________________________________
This mail is send to you from the opencms-dev mailing list
To change your list options, or to unsubscribe from the list, please
visit
http://mail.opencms.org/mailman/listinfo/opencms-dev
__________________________________
Do you Yahoo!?
The New Yahoo! Search - Faster. Easier. Bingo.
http://search.yahoo.com
__________________________________
Do you Yahoo!?
The New Yahoo! Search - Faster. Easier. Bingo.
http://search.yahoo.com
More information about the opencms-dev
mailing list