AW: AW: [opencms-dev] Still problems installing openCMS under Linux

[Mario Wallnöfer]

dear björn,

it doesnt matter, if there is a table in mysql defined yet. first, make a
connection to the mysql database with

--> mysql -u root -p
then type in password
connect to the system db:
--> \r mysql
now you have to add the new user:
insert into user (user,host,password)
values('opencmsuser','%',PASSWORD('geheim'));


now, your new user is created and you can use it for opencms connections.

mario

-----Ursprüngliche Nachricht-----
Von: opencms-dev-admin at opencms.org
[mailto:opencms-dev-admin at opencms.org]Im Auftrag von Björn Aberti
Gesendet: Dienstag, 03. Juni 2003 12:28
An: opencms-dev at opencms.org
Betreff: Re: AW: [opencms-dev] Still problems installing openCMS under
Linux


I thank you so much for your answer!!

But how can I create a 'opencms'-user if I have no tables in my 'opencms'
database? Or do you mean in database 'mysql' in table 'users'? In this table
I have already an user 'root' with a password, which I use for the mysql
connection. If I use this password also in the password field for the
'openCMS connection', it doesn't work.

This all is a bit confusing to me...

Best regards

Björn



>From: Mario Wallnöfer <mario.wallnoefer at msk-informatik.at>
>Reply-To: opencms-dev at opencms.org
>To: <opencms-dev at opencms.org>
>Subject: AW: [opencms-dev] Still problems installing openCMS under Linux
>Date: Tue, 3 Jun 2003 12:16:08 +0200
>
>dear björn,
>
>i had similar problems a few weeks ago.
>
>try to create an opencms user with a password. i think opencms cannot
>handle
>"no password".
>
>and it is really insecure too.
>
>
>mario
>
>
>
>-----Ursprüngliche Nachricht-----
>Von: opencms-dev-admin at opencms.org
>[mailto:opencms-dev-admin at opencms.org]Im Auftrag von Björn Aberti
>Gesendet: Dienstag, 03. Juni 2003 12:07
>An: opencms-dev at opencms.org
>Betreff: Re: [opencms-dev] Still problems installing openCMS under Linux
>
>
>Does nobody know a solution? It's really urgent!!! Or havn't I explained my
>problem clearly?
>
>Pls help!
>
>
> >From: Björn Aberti <bjoern_al at hotmail.com>
> >Reply-To: opencms-dev at opencms.org
> >To: opencms-dev at opencms.org
> >Subject: [opencms-dev] Still problems installing openCMS under Linux
> >Date: Tue, 03 Jun 2003 07:29:41 +0000
> >
> >Hello everybody,
> >
> >I'm using Suse Linux 8.1., Tomcat 4.1.18 and mySQL 3.32.52 and try to
> >install openCMS 5.
> >When wizard tries to create the tables of the opencms database, it says
> >'access denied for root at localhost'. What password do I have to enter at
> >'openCMS connection' and which user? Under Windows I had to let the
> >password field blank, and it worked. In my opencms.properties file also
>no
> >password is entered: 'pool.mysql.user=root' and 'pool.mysql.password='.
>Do
> >I have to enter a password here?
> >
> >If I just continiue installation without creating tables, the install
> >window appears and nothing happens. I'm using the konqueror, and this is
> >not the problem with the refresh...
> >
> >God, please support me with a good documentation for openCMS
> >installation...
> >
> >Thanks for your help
> >
> >Björn
> >

_________________________________________________________________
Messenger  -  Wer in Echtzeit kommunizieren will, lädt den MSN Messenger.
Cool, kostenlos und mit 3D Emoticons: http://messenger.msn.de

_______________________________________________
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