AW: AW: AW: [opencms-dev] Still problems installing openCMS under Linux
Kammel, Ulrich, FCI3
ulrich.kammel at lfk.eads.net
Tue Jun 3 17:52:01 CEST 2003
Hi Björn,
it can be helpfull, if you change all the privileges to 'Y' .
(You need the privileges for creating a new database at installation time)
Have You tested to connect with the new user directly to mysql?
> > --> mysql -u opencmsuser -p
> > then type in password
The jdbc.jar in my opinion is included in the opencms.war file. I didn't
need
it somewhere else.
With opencms version 5 I used MySQL 4.0.12 , but it should also work with
your version
of MySQL.
Ulrich
> -----Ursprüngliche Nachricht-----
> Von: Björn Aberti [SMTP:bjoern_al at hotmail.com]
> Gesendet am: Dienstag, 3. Juni 2003 16:27
> An: opencms-dev at opencms.org
> Betreff: Re: AW: AW: [opencms-dev] Still problems installing openCMS
> under Linux
>
>
> 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
>
> _______________________________________________
> 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
More information about the opencms-dev
mailing list