AW: [opencms-dev] Installation encoding error

[Jakob Lemler]

Try to connect with:

Mysql --user xxxxx -pyyyy dddddd from commandline, afterwards try:
Mysql --user xxxxx at localhost -pyyyy ddddd both times xxx = User which
you use in Opencms, yyy = Password for OpenCms user and ddd = the
database name, here obviously opencms.

When this works we look further.

Bye Jakob
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
_______________________________________________
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