Lunarpages Web Hosting Forum

Author Topic: ::sigh:: Setting up coppermine  (Read 8164 times)

Offline EJ

  • Galactic Royalty
  • *****
  • Posts: 247
::sigh:: Setting up coppermine
« 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?
I love the new LPF theme

Offline Matthew Alan

  • Jabba the Hutt
  • *****
  • Posts: 738
Re: ::sigh:: Setting up coppermine
« Reply #1 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
« Last Edit: October 05, 2009, 05:22:09 PM by Matthew Alan »

Offline EJ

  • Galactic Royalty
  • *****
  • Posts: 247
Re: ::sigh:: Setting up coppermine
« Reply #2 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.



I love the new LPF theme

Offline EJ

  • Galactic Royalty
  • *****
  • Posts: 247
Re: ::sigh:: Setting up coppermine
« Reply #3 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)
« Last Edit: October 06, 2009, 02:06:44 AM by EJ »
I love the new LPF theme

Offline Mitch

  • Berserker Poster
  • *****
  • Posts: 12634
    • MitchKeeler.com
Re: ::sigh:: Setting up coppermine
« Reply #4 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!
New to Web Site Hosting? Check Out the Lunarpages Blog Hosting Guide!


Follow us @lunarpages on Twitter!
Important Threads: Read This Before Posting! | Lunarforums Rules! | Mitch's Link of the Day!
Also, be sure to check out and subscribe to the Lunartics Blog and the Lunarpages Newsletter !

Need Web Hosting Help? Check out the Lunarpages Web Hosting Wiki. It has tons of tips, tutorials and resources!

Offline EJ

  • Galactic Royalty
  • *****
  • Posts: 247
Re: ::sigh:: Setting up coppermine
« Reply #5 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.
« Last Edit: October 06, 2009, 05:33:06 AM by EJ »
I love the new LPF theme

Offline Mitch

  • Berserker Poster
  • *****
  • Posts: 12634
    • MitchKeeler.com
Re: ::sigh:: Setting up coppermine
« Reply #6 on: October 06, 2009, 06:02:40 AM »
Whoops, that is my mistake - try lpsql01.lunariffic.com  .
New to Web Site Hosting? Check Out the Lunarpages Blog Hosting Guide!


Follow us @lunarpages on Twitter!
Important Threads: Read This Before Posting! | Lunarforums Rules! | Mitch's Link of the Day!
Also, be sure to check out and subscribe to the Lunartics Blog and the Lunarpages Newsletter !

Need Web Hosting Help? Check out the Lunarpages Web Hosting Wiki. It has tons of tips, tutorials and resources!

Offline EJ

  • Galactic Royalty
  • *****
  • Posts: 247
Re: ::sigh:: Setting up coppermine
« Reply #7 on: October 06, 2009, 06:15:26 AM »
 :yey: :yey:


Mitch comes through for me again...you rock
I love the new LPF theme

Offline Mitch

  • Berserker Poster
  • *****
  • Posts: 12634
    • MitchKeeler.com
Re: ::sigh:: Setting up coppermine
« Reply #8 on: October 06, 2009, 06:43:03 AM »
Happy to help out!
New to Web Site Hosting? Check Out the Lunarpages Blog Hosting Guide!


Follow us @lunarpages on Twitter!
Important Threads: Read This Before Posting! | Lunarforums Rules! | Mitch's Link of the Day!
Also, be sure to check out and subscribe to the Lunartics Blog and the Lunarpages Newsletter !

Need Web Hosting Help? Check out the Lunarpages Web Hosting Wiki. It has tons of tips, tutorials and resources!