Re: [opencms-dev] opencmsuser into opencms.properties when finish the OpenCms installation

[Christian Steinert]

> -----Ursprüngliche Nachricht-----
> Von: The OpenCms mailing list <opencms-dev at opencms.org>
> Gesendet: 27.06.06 16:07:26
> An: opencms-dev at opencms.org
> Betreff: [opencms-dev] opencmsuser into opencms.properties when finish the OpenCms installation


> 
> 
>     Hello to all,
> 
>     I've just finished to install OpenCms, and the last note says:
> 
>     Don't forget to add the new user and password to all connect strings
>     of the database in your |opencms.properties| file. Only the new user
>     can now connect to the OpenCms tables.
> 
>     What does it means?
> 
>     Anyone could help me to stablish a good opcencms.properties file?
> 
>     Thanks and best regards,
>     Maria
> 
>     Now, it's:
> # user name to connect to the database

Hi MArtina,

the idea is to create a database user with lower privileges. This user should only have permissions for your opencms database and not for the whole database server.
(look at the GRANT statement in the mysql documentation
  it should be sth. like 
    grant all privileges on opencms.* to opecmsdbuser identified by "somepassword"

After creating such a user, you should shutdown opencms and set that user account in your opencms.properties file. For example:

db.pool.default.user=opencmsdbuser
db.pool.default.password=somepassword


Also, you should change your DB root password and if you use the password elsewhere you should change it there, too! 
It was NOT a good idea that you sent your database password out to the mailing list!!!

christian
_____________________________________________________________________
Der WEB.DE SmartSurfer hilft bis zu 70% Ihrer Onlinekosten zu sparen!
http://smartsurfer.web.de/?mc=100071&distributionid=000000000071