[support] site down after i CHANGED the database password!

[jo]

success!

thank you so much for your clear and great support!

now i know what happenend: i simply changed passwords in confixx without  knowing that it would also change the database-password..

what i do not understand yet: why is it secure to have the mysql-password stored in plaintext?

many greetings from the snowy winterhills of the taunus

:-jo


--- Victor Kane <victorkane at gmail.com> schrieb am Mi, 3.12.2008:

> Von: Victor Kane <victorkane at gmail.com>
> Betreff: Re: [support] site down after i deactivated views via phpmyadmin
> An: support at drupal.org
> Datum: Mittwoch, 3. Dezember 2008, 21:00
> Once settings.php is pointed to the correct database with
> the correct
> username and password, and your fresh install is working,
> you can
> restore the database with your previous version, and you
> should be
> good to go.
> 
> You can do this either by installing Drupal anew, and
> filling in the
> correct database and user info during the installation, or
> else by
> directly editing settings.php.
> 
> The line you need to edit is the following (about half-way
> down):
> 
> $db_url =
> 'mysql://your-real-db-user-name:your-real-db-user-password@localhost/your-real-databasename';
> 
> Hope that helps,
> 
> Victor Kane
> http://awebfactory.com.ar
> 
> On Wed, Dec 3, 2008 at 5:54 PM, jo
> <joinkemel at yahoo.de> wrote:
> > thank you very much for your hints, now i am at least
> stuck at another point ;-)
> >
> > i tried your option 1 (deleting all tables and
> restore) with no positive results.
> >
> > then i tried option 2 (reinstalling drupal by
> replacing all files with fresh drupal 6.6 files and a
> databank-restore, but also there was the same 'site
> down' errorpage.
> >
> > which i read again and remembered that it says i
> should have a look at settings.php.
> >
> > so next thing i did was renaming the settings.php with
> uglysettings.php and renaming default.settings.php with
> settings.php, so i would use the default settings from a
> fresh install - now i really was able to see the drupal
> installation-page where now i have problems with the
> database-configuration-step:
> >
> > with the name of my existing database and the user and
> password i enter in phpmyadmin to come in, drupal
> doesn't go to the next step, but also it doesn't
> create any errormessage, just all fields are empty again.
> > when i enter any adequate fantasy-names, it tells that
> this is the wrong password or username..why is that?
> >
> > and what should i do now, especially in case i would
> love to avoid creating all nodes again - is there any
> possibility to recreate the nodes from the old database when
> i do a fresh-install and the backup is faulty?
> >
> > :-jo
> >
> >
> >
> >
> > --- Victor Kane <victorkane at gmail.com> schrieb
> am Mi, 3.12.2008:
> >
> >> Von: Victor Kane <victorkane at gmail.com>
> >> Betreff: Re: [support] site down after i
> deactivated views via phpmyadmin
> >> An: support at drupal.org
> >> Datum: Mittwoch, 3. Dezember 2008, 11:05
> >> On Wed, Dec 3, 2008 at 7:31 AM, jo
> >> <joinkemel at yahoo.de> wrote:
> >> > dear list,
> >> >
> >> > as i am quite new to mysql-issues and the
> database, i
> >> don't know how to put my site to life again..
> >> >
> >> > as i had troubles with the installation of
> the
> >> views-module (all the other first 7 modules did
> install with
> >> no problems) i wanted to deactivate it.
> >> >
> >> > because i couldn't access my
> >> /admin/modules-frontend anymore, i used
> instructions on
> >> >
> >> > http://www.drupalcenter.de/handbuch/11551
> (german
> >> language)
> >> >
> >> > to deactivate the views-module(s) in the
> database
> >> using phpmyadmin. (open phpmyadmin, select system,
> find the
> >> views-moulde-entries, deactivate it with setting
> status to
> >> 0)
> >>
> >> Let's assume for the moment that the
> implementation of
> >> this advanced
> >> admin procedure did something wrong to the
> database, and
> >> that that
> >> left Drupal in an undefined state.
> >>
> >> But a restore to the database should have left
> things as
> >> they were.
> >>
> >> Try this:
> >>
> >> 1. Drop all the tables in the database.
> >> 2. Then restore from last week.
> >>
> >> If that doesn't work then something is amiss
> in the
> >> file system or on
> >> the server configuration. In that case, try a
> fresh Drupal
> >> install on
> >> the same database. If that works then restore
> again.
> >>
> >> Victor Kane
> >> http://awebfactory.com.ar
> >>
> >> >
> >> > after that, the site is down completely
> >> > (drupal error-site is showing "site
> down"
> >> > 'because of technical issues - please
> check your
> >> database settings in the settings.php file and
> ensure that
> >> your hosting provider's database server is
> running')
> >> >
> >> > so, what to do now?
> >> >
> >> > i already posted a forum-topic and followed
> the hint
> >> of one member with no results and even a complete
> >> confixx-restore with a backup of all files and the
> database
> >> i did one week ago when all was running well
> doesn't
> >> change anything.
> >> >
> >> > could it be, i should have taken the site
> down with my
> >> admin-frontend, before changing something in the
> database?
> >> >
> >> > thank you for reading anyhow
> >> >
> >> > :-jo
> >> >
> >> >
> >> >
> >> >
> >> >
> >> > --
> >> > [ Drupal support list |
> http://lists.drupal.org/ ]
> >> >
> >> --
> >> [ Drupal support list | http://lists.drupal.org/ ]
> >
> >
> >
> >
> > --
> > [ Drupal support list | http://lists.drupal.org/ ]
> >
> -- 
> [ Drupal support list | http://lists.drupal.org/ ]