[opencms-dev] Installation encoding error

[grenoml]

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
> > > > visit
> > > > http://mail.opencms.org/mailman/listinfo/opencms-dev
> > > > 
> > > -- 
> > > Gokul
> > > 
> > > -- 
> > > http://www.fastmail.fm - Email service worth paying for. Try it
> for
> > free
> > 
> > 
> > __________________________________
> > 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


__________________________________
Do you Yahoo!?
The New Yahoo! Search - Faster. Easier. Bingo.
http://search.yahoo.com