Advanced search  

News:

cpg1.5.48 Security release - upgrade mandatory!
The Coppermine development team is releasing a security update for Coppermine in order to counter a recently discovered vulnerability. It is important that all users who run version cpg1.5.46 or older update to this latest version as soon as possible.
[more]

Pages: [1]   Go Down

Author Topic: Where is my database ?? Oh Stupid me  (Read 6685 times)

0 Members and 1 Guest are viewing this topic.

cogwheel

  • Coppermine newbie
  • Offline Offline
  • Gender: Male
  • Posts: 7
Where is my database ?? Oh Stupid me
« on: April 08, 2010, 02:55:39 pm »

I am using Coppermine for years and I am very happy with it. Recently I had a visit from a @#$%^hacker who managed to replace all index.php and index htm files.
Apart from a separate ecard  program nothing was destroyed. Simply placed back the back up and searched for any more files probably edited. I am clean now but i like to upgrade to a newer version. And there starts the trouble. Where is my database.
I have 2 hosting accounts at Godaddy with several dbases but none of them belongs to the coppermine.
I also installed a community offered by godaddy but they installed that outside of my space. To avoid that Godaddy advises to make your own installation on your own space. I did that with the coppermine, so I assumed the database was there too.
Is it possible (I can remember such tips) that go daddy users are to be advised to store the database elsewhere? An if so Where.
Without a back up, i m not upgrading.
Logged

Joe Carver

  • Dev Team member
  • Coppermine addict
  • ****
  • Country: us
  • Offline Offline
  • Gender: Male
  • Posts: 1510
  • aka 'i-imagine'
    • Home Page
Re: Where is my database ?? Oh Stupid me
« Reply #1 on: April 08, 2010, 03:26:49 pm »

Without a back up, i m not upgrading.

Without an upgrade you can be hacked once again.

You should read and follow the steps in thread:

         Yikes, I've been hacked

Use your godaddy control panel (or whatever interface they provide) to get your db info.. Perhaps they even have installed phpMyAdmin for users too. If the site was hosted on godaddy then the db was also on godaddy.

Remember to post a link to your Coppermine in your next postings - it is a rule of this support forum.

cogwheel

  • Coppermine newbie
  • Offline Offline
  • Gender: Male
  • Posts: 7
Re: Where is my database ?? Oh Stupid me
« Reply #2 on: April 08, 2010, 04:53:35 pm »

I asked Godaddy support, But there is none
And yes they have phpMYadmin and I have over 5 databases running in the Linux hosting (in the windows hosting no databases.)
(Packardgoose forum database, Packardgoose ecard database, packard goose simplealbum database, packardgoose chat database, Ploeg Ecards database) but no Coppermine database.

dbserver 10.0.11.146
db user 47584_eploeg
dbpass XXXXXXXXXXXXX
dbname user_474584

gODADDY RESPONSE
Discussion Notes
Support Staff Response
Dear Ed Ploeg,

Thank you for contacting online support. Unfortunately, we are unable to locate the database user_474584. It does not appear that this database is located in either of your hosting accounts. We apologize for any inconvenience regarding this issue.
 
www.ploeg.ws/coppermine

Logged

Joe Carver

  • Dev Team member
  • Coppermine addict
  • ****
  • Country: us
  • Offline Offline
  • Gender: Male
  • Posts: 1510
  • aka 'i-imagine'
    • Home Page
Re: Where is my database ?? Oh Stupid me
« Reply #3 on: April 08, 2010, 05:29:51 pm »

dbserver 10.0.11.146
db user 47584_eploeg
dbpass XXXXXXXXXXXXX
dbname user_474584

Did you copy that info. from www.ploeg.ws/coppermine/include/config.inc.php?

The 10.0.11.146 address should be for an internal/non-public use and (to me anyway..) does not fit.

cogwheel

  • Coppermine newbie
  • Offline Offline
  • Gender: Male
  • Posts: 7
Re: Where is my database ?? Oh Stupid me
« Reply #4 on: April 08, 2010, 05:41:37 pm »

It is used a lot in combination with coppermine. Try to google on it.
Checked my site again and sorry not 5 but 6 mysql databases and 2 sql databases all known, but no coppermine.
Logged

Joachim Müller

  • Dev Team member
  • Coppermine addict
  • ****
  • Offline Offline
  • Gender: Male
  • Posts: 47843
  • aka "GauGau"
    • gaugau.de
Re: Where is my database ?? Oh Stupid me
« Reply #5 on: April 08, 2010, 07:57:45 pm »

Ask your webhost, not us. We can't help you figure out your database details. Your webhost can.
Logged

cogwheel

  • Coppermine newbie
  • Offline Offline
  • Gender: Male
  • Posts: 7
Re: Where is my database ?? Oh Stupid me
« Reply #6 on: April 08, 2010, 11:28:52 pm »

tnx for your kind helpfull words, probably lost with soccer?  :D
If they can't as stated in the second last post of me , and you can't or would help.
It is all over.


Logged

phill104

  • Administrator
  • Coppermine addict
  • *****
  • Country: gb
  • Offline Offline
  • Gender: Male
  • Posts: 4853
    • Windsurf.me
Re: Where is my database ?? Oh Stupid me
« Reply #7 on: April 09, 2010, 12:32:48 am »

Only you and your webhost will know those details. They are password protected for a reason. There is no way we can find them out for you.

Take a look at your include.config.inc.php file with a plain text editor and that should have the details of your db inside. Then check to see if those details correspond with anything on your serve via phpmyadmin.
Logged
It is a mistake to think you can solve any major problems just with potatoes.

Joachim Müller

  • Dev Team member
  • Coppermine addict
  • ****
  • Offline Offline
  • Gender: Male
  • Posts: 47843
  • aka "GauGau"
    • gaugau.de
Re: Where is my database ?? Oh Stupid me
« Reply #8 on: April 09, 2010, 07:39:22 am »

tnx for your kind helpfull words, probably lost with soccer?  :D
I haven't posted what I said above because I was annoyed with anything - it was just the facts. You're dragging this on a level where it doesn't belong. The old rivalry between the Netherlands and Germany as far as soccer is concerned doesn't matter on this board, so stop it, will you?

If they can't as stated in the second last post of me , and you can't or would help.
It is all over.
Stop claiming that we don't want to help you - that's not true. I told you as it is: we can not help you. Stop your lame accusations.
Logged

phill104

  • Administrator
  • Coppermine addict
  • *****
  • Country: gb
  • Offline Offline
  • Gender: Male
  • Posts: 4853
    • Windsurf.me
Re: Where is my database ?? Oh Stupid me
« Reply #9 on: April 09, 2010, 10:56:31 am »

From this user via my website email ::)

Quote
Thank you for your advise on the coppermine forum. Sorry to say that I dislike the
style of Mr. Muller.

I've already done all what you said but there is really no database in my hosting.

I can remember, that a few years ago godaddy users always had problems on this issue
and it was advised to stall your database elswhere at a coppermine friendly host. I
think I did that but looses everything on a disk crash last year

BTW nice site this one


We disabled PM's for a reason. Shouldn't that be enough of a hint that you should only contact us via the forum?
Logged
It is a mistake to think you can solve any major problems just with potatoes.

cogwheel

  • Coppermine newbie
  • Offline Offline
  • Gender: Male
  • Posts: 7
Re: Where is my database ??
« Reply #10 on: April 14, 2010, 10:37:50 am »

Never give up, they say... and finally I managed to solve my (and probably a lot of godaddy users) problem.
I searched and found the backup plugin.
Made a dump from the database ( I presume it is somewhere on the server but not reachable for me)
Created a new empty SQL database
Copied the total coppermine directory including everything to a new dir coppermine2
Removed install lock from dir. Include
Runned the install PHP ( The tableprefix must be the same as in the dump) and coppermine 2 was up and running but empty
Than I edited the sqldump (The URL in the stats was pointing to the old dir)
After that I restored the database from the dump with the use of the plugin.
Bingo
You can see the results
on www.ploeg.ws/coppermine (with the somewhere database)
and www.ploeg.ws/coppermine2 ( with a new for me reachable database)
Finally I can make a database back up via Myphp admin and upgrade the gallery.

Tnx to the makers of the backup plugin2.3 


Logged
Pages: [1]   Go Up
 

Page created in 0.022 seconds with 20 queries.