Gold - main ok - subdomain : unable to select database

[dany]

Gold has been down most of the week.

My main website : natzo.com works but the subdomains return the same message : "unable to select database"

natzo.com/biblionotes/
natzo.com/minacia/

They have been running for more than a year now (myphpnuke) so I don't understand why a full restore doesn't bring them back to life !!!


PLEASE HELP ME ....

Dany

[dany]

I've checked the sub domains and their \admin directories ARE MISSING ... which contains the database config and so on !

What kind of backup software are you using ?

That's really not professional.

[lijoe]

Hi Dany,

If you have opened a ticket, do send me the ticket number and also add the following details your admin password for both the phpnuke as well as the version it is.

[dany]

I modified a lot a files into this admin directory so how my phpnuke version and password will help to recover them ?

[Julian Muñoz]

Hey dany. I see your sites working fine

[dany]

I had a hold backup (is that my job to make backup ??) ...

Anyway, I've restored the admin dirctories.
I had to register back the FTP accounts and also .httacces !

We don't have the same conception of the word "backup"

[Vin DSL]

Originally posted by dany
I had a hold backup (is that my job to make backup ??) ...

We don't have the same conception of the word "backup"...

OMG!!! I wish I was a customer service rep on JagPC I'd do it for free...

YES!!! You need to make your own backups. Hello?!?!?

You don't realize how lucky you are, my friend. They are doing the restores for free, right now, as a good will gesture, because of all the recent problems with hackers, et cetera. Otherwise, they charge $75.00/hr or $15.00/file (whichever is greatest) to restore files from THEIR backups.

Don't believe me?

Originally posted by Vin DSL
A word to the wise...

I don't know what JagPC's policy is on file recovery, but MANY hosts charge you for this service. It's a time-consuming, labor-intensive process to isolate and restore a single 35K file out of a 100GB backup, or whatever.

This is one of those areas where YOU have to read the 'fine print.' My former host did daily backups, but if YOU needed to have your site restored, as in YOU accidently erased something, they charged $200/hour for that service...

Originally posted by Jag
We charge $15 per file/or $75hr (whichever is greatest) to recover something from a backup .

In other words, CYA and do your own backups. That is, unless you're independently wealthy and don't mind passing YOUR "job" off to them.

Personally, I backup my own site, but it's your life...

[dany]

My last backup is from 02/28 so I do make backups but after 4 days down ... do we get any money back ? No ! So it's fair enough to get a kind of restore.

I've recovered my missing directory. I can see the site now.

I can login but it looks like my login is not recorded so in fact I stay Guest so no possibility to change anything.

I tried to change some file access but it doesn't seem to come from that. It's like I can't write into the DB !

Maybe another pb on the database itself ?

When I look at the registered DB on the CP I can see for example :


alpha_beta

Users in alpha_beta
alpha_userone

Connection Strings

Perl
$dbh = DBI-
>connect("DBI:mysql:alpha_beta:localhost ","alpha_userone","<PASSWORD HERE>");

PHP
$dbh=mysql_connect ("localhost", "alpha_userone", "<PASSWORD HERE>") or die ('I cannot connect to the database because: ' . mysql_error());
mysql_select_db ("alpha_beta");

[dany]

My last backup is from 02/28 so I do make backups but after 4 days down ... do we get any money back ? No ! So it's fair enough to get a kind of restore.

I've recovered my missing directory. I can see the site now.

I can login but it looks like my login is not recorded so in fact I stay Guest so no possibility to change anything.

I tried to change some file access but it doesn't seem to come from that. It's like I can't write into the DB !

Maybe another pb on the database itself ?

When I look at the registered DB on the CP I can see for example :


alpha_beta

Users in alpha_beta
alpha_userone

Connection Strings

Perl
$dbh = DBI-
>connect("DBI:mysql:alpha_beta:localhost ","alpha_userone","<PASSWORD HERE>");

PHP
$dbh=mysql_connect ("localhost", "alpha_userone", "<PASSWORD HERE>") or die ('I cannot connect to the database because: ' . mysql_error());
mysql_select_db ("alpha_beta");

[dany]

Cookie issue .... oupps ... that was easy this time ....

[Vin DSL]

Originally posted by dany
Cookie issue .... oupps ... that was easy this time ....

You know, that's weird! I had a similar issue after I upgraded to PHP-Nuke 6.5 a couple of nights ago. I logged in as the admin, but I couldn't logout. After playing with it a while, I started thinking that maybe it was a cookie thing. I erased the cookies on my hard drive, from my site, and it fixed the problem. I was just thinking about that when you posted. I guess we must be reading each others minds. That's a little scarry, huh?

[Vin DSL]

BTW, did you happen to read this:

http://forums.jaguarpc.com/showthrea...&threadid=9019

I think I know the answer to that problem too...

[Defender]

I find it weird that I as well am missing my /admin directory.

Did they exclude those from the restores or something? Luckily I have all the files on my website on my hdd, so old backups are never an issue for me.

I "used" to have a cron set up to backup my database on a regular basis, but that just stopped working for some reason, so I just back it up after I make any changes now.