AW: [opencms-dev] Installation encoding error

grenoml grenoml at yahoo.com
Tue May 27 21:36:01 CEST 2003


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



More information about the opencms-dev mailing list