[opencms-dev] Setup question - initial database connection

[David Penton]

Thanks, Alex.

Could you give me some clarification of the OpenCms Connection please?

If I user the mysql user "root" for the "Setup Connection", opencms 
creates the database correctly.

But if I enter "opencms" with password "opencms" in the OpenCms 
Connection field, I get the following:

Could no connect to database via: jdbc:mysql://localhost:3306/opencms
java.sql.SQLException: Invalid authorization specification: Access 
denied for user: 'opencms at localhost.localdomain' (Using password: YES)

I did not create a user "opencms" in mysql before running the opencms 
setup. I assumed that setup creates the user "opencms" and its 
permissions to the database.

Am I doing something wrong?

Alexander Kandzior wrote:

>The first "Setup Connection" is for the DB table creation. Special ("admin")
>permissions are required for this. This connection is used only in the
>wizard and not stored in the opencms configration files.
>
>The second "OpenCms Connection" is for running the OpenCms instance after
>setup. This can be a different user from root or just the same, depending on
>how many other use the MySQL instance. This user will be stored inthe
>opencms configuration file, including it's password.
>
>Best Regards,
>Alex.
>
>Alexander Kandzior
>Alkacon Software - The OpenCms Experts
>http://www.alkacon.com
>
> 
>
>  
>
>>-----Original Message-----
>>From: opencms-dev-bounces at opencms.org 
>>[mailto:opencms-dev-bounces at opencms.org] On Behalf Of David Penton
>>Sent: Saturday, March 05, 2005 2:37 AM
>>To: The OpenCms mailing list
>>Subject: [opencms-dev] Setup question - initial database connection
>>
>>I have been trying to set up opencms for a couple days now. I 
>>think there are several things preventing me from proceeding. 
>>My server runs Fedora Core 2; tomcat version is 4.1.31. I am 
>>using mysql version 3.23.
>>
>>I find the setup documentation unclear in relation to 
>>database creation. 
>>The documentation says:
>>
>>"Follow the instructions of the OpenCms Setup-Wizard, using 
>>the "Standard" setup. It will set up the OpenCms database and 
>>import all workplace resources into the system."
>>
>>I find that to be less info than I need. I don't understand 
>>what I should fill in on the page that asks for "Database 
>>Server Connection" 
>>and "OpenCms Connection". I assume the first one requires 
>>that I use the admin user for mysql. It seems to create the 
>>database if I do that. But what is the second one, the 
>>"OpenCms Connection" stuff? Should this be an existing mysql 
>>user? Or does the database creation code create the user and 
>>password? I get an error on setup if I just make up a user 
>>such as "opencms" with password "opencms".
>>
>>I have scanned the mailing list archives for answers to this, 
>>and also perused the jsp pages in ocsetup. I still don't get it.
>>
>>Looking forward to your help.
>>
>>- Dave Penton -
>>
>>
>>
>>_______________________________________________
>>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
>>
>>
>>    
>>
>
>
>
>_______________________________________________
>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
>
>
>
>  
>