Lunarpages Web Hosting Forum

Web Hosting Guidance and Advice => LPCP Control Panel Help and Tips => Topic started by: EJ on October 05, 2009, 04:45:37 PM

Title: ::sigh:: Setting up coppermine
Post by: EJ on October 05, 2009, 04:45:37 PM
OK I have followed the tutorials and I can't connect to my coppermine data base

Tried to get into the admin interface (with assigned user) I keep getting errors

Coppermine critical error:
Unable to connect to database !

Configure

MySQL said: Access denied for user 'copper'@'localhost' (using password: YES)

Could not create a mySQL connection, please check the SQL values entered

MySQL error was : Access denied for user 'admin'@'localhost' (using password: YES)


I have set up coppermine before the old CP and had no problems. What am I doing wrong?
Title: Re: ::sigh:: Setting up coppermine
Post by: Matthew Alan on October 05, 2009, 05:12:41 PM
I haven't used LPCP, but as you may remember you needed to do cpaneluser_dbuser so try that

lpcpuser_dbuser and lpcpuser_dbname
Title: Re: ::sigh:: Setting up coppermine
Post by: EJ on October 06, 2009, 01:53:44 AM
I don't think I ever had to enter it that way?  

I have manually installed copper mine, deleted the database and assigned user. Figured I would start fresh.

I've attached a pic of the CM install. I don't know/remember what to put in these fields.

(http://steelsheen.com/cm.jpg)

Title: Re: ::sigh:: Setting up coppermine
Post by: EJ on October 06, 2009, 02:03:18 AM
I haven't used LPCP, but as you may remember you needed to do cpaneluser_dbuser so try that

lpcpuser_dbuser and lpcpuser_dbname

Tried, no go

Could not create a mySQL connection, please check the SQL values entered

MySQL error was : Access denied for user 'xxxxx_xxxxx'@'localhost' (using password: YES)
Title: Re: ::sigh:: Setting up coppermine
Post by: Mitch on October 06, 2009, 04:36:03 AM
Since you are using a LPCP-powered account, localhost would not be used when installing the Coppermine script (as the MySQL host).  This is because these servers store the MySQL databases on another server (for performance and reliability issues).  Try replacing localhost with lpmysql01.lunariffic.com.  Hope that helps!
Title: Re: ::sigh:: Setting up coppermine
Post by: EJ on October 06, 2009, 05:31:15 AM
MySQL error was : Unknown MySQL server host 'lpmysql01.lunariffic.com

I guess I'm getting a little closer? lol

 A gallery was a big factor for my friend, any other ideas?

Besides this issue I have managed to navigate LPCP fairly well. I have to admit creating databases is a lot easier in CP.
Title: Re: ::sigh:: Setting up coppermine
Post by: Mitch on October 06, 2009, 06:02:40 AM
Whoops, that is my mistake - try lpsql01.lunariffic.com  .
Title: Re: ::sigh:: Setting up coppermine
Post by: EJ on October 06, 2009, 06:15:26 AM
 :yey: :yey:


Mitch comes through for me again...you rock
Title: Re: ::sigh:: Setting up coppermine
Post by: Mitch on October 06, 2009, 06:43:03 AM
Happy to help out!