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

[Björn Aberti]

Hi Mario and Ulrich,

First thanks a lot for your help.
I createt the new user as you said. I enterd 'localhost' for host instead of 
the '%' sign, hope this was correct. Then I flushed the privileges (I think 
this was useless since I didn't change any previleges...) When I tried to 
connect to opencms with this user, I got the same result. Do I have to 
change his privileges to 'Y' or is 'N' correct? I'm not sure... Do I 
actually need the jdbc.jar in the Java class-path? I saw that I don't have 
it in my 'lib'-folder.

Best regards

Björn

>From: "Kammel, Ulrich, FCI3" <ulrich.kammel at lfk.eads.net>
>Reply-To: opencms-dev at opencms.org
>To: "'opencms-dev at opencms.org'" <opencms-dev at opencms.org>
>Subject: AW: AW: [opencms-dev] Still problems installing openCMS under 
>Linux
>Date: Tue, 3 Jun 2003 15:49:36 +0200
>
>Hi björn,
>
>if you still are not able to connect to mysql with the new opencmsuser or
>you want to change the privileges from this user
>you have to finish your changes with the command:
>      flush privileges;
>and then try again.
>
>           Ulrich
>
> > -----Ursprüngliche Nachricht-----
> > Von:	Mario Wallnöfer [SMTP:mario.wallnoefer at msk-informatik.at]
> > Gesendet am:	Dienstag, 3. Juni 2003 14:26
> > An:	opencms-dev at opencms.org
> > Betreff:	AW: AW: [opencms-dev] Still problems installing openCMS
> > under Linux
> >
> > 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