[opencms-dev] Installation encoding error

[Sèbastien DESCAMPS]

Hi gremol,

I think that your opencmsuser is not properly configured.
In your DB mysql, you should have:
     table user
        localhost, opencmsuser, password, N, N, N, ...
     table db
        localhost, opencms, opencmsuser, Y, Y, Y, ...
 
--
Sebastien DESCAMPS
Stagiaire Net2s
sdescamps at net2s.com

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