Cant Log In After Moving Site
I have done about an hour of research on this issue before posting to the list. I have transferred a database that had both Drupal and CiviCRM tables in one database and split it so that the Drupal database is on database and the CiviCRM database is in another. I had it working when all the tables were together in one database but I had a different problem and re-imported the data and now it does not work. I have tried to go back to one database and that does not work either. I have create a new user directly in the database and this user cant login. I have cleared the sessions table. I have changed the password of the admin user and used the MD5 function in PHPmyAdmin. I turned off CiviCRM in the system table and there is no change. I am out of ideas. Thank you very much! Thanks, Steve Steve Kessler Denver DataMan 303-587-4428 <http://www.denverdataman.com/denver-dataman-e-newsletter-signup> Sign up for the Denver DataMan Free eNewslettter
Whats the symptom? error message? white screen of death? is clean urls switched on (mod_rewrite etc)? On Thu, Apr 22, 2010 at 6:22 AM, Steve Kessler <skessler@denverdataman.com>wrote:
I have done about an hour of research on this issue before posting to the list.
I have transferred a database that had both Drupal and CiviCRM tables in one database and split it so that the Drupal database is on database and the CiviCRM database is in another. I had it working when all the tables were together in one database but I had a different problem and re-imported the data and now it does not work. I have tried to go back to one database and that does not work either.
I have create a new user directly in the database and this user cant login.
I have cleared the sessions table.
I have changed the password of the admin user and used the MD5 function in PHPmyAdmin.
I turned off CiviCRM in the system table and there is no change.
I am out of ideas.
Thank you very much!
Thanks,
Steve
Steve Kessler
*Denver DataMan *
303-587-4428
Sign up for the Denver DataMan Free eNewslettter<http://www.denverdataman.com/denver-dataman-e-newsletter-signup>
-- [ Drupal support list | http://lists.drupal.org/ ]
-- -- -- Steve Power Principal Consultant Mobile: +44 (0) 7747 027 243 Skype: steev_initsix www.initsix.co.uk :: Initsix Heavy Engineering Limited -- This email and any attachments to it may be confidential and are intended solely for the use of the individual to whom it is addressed. Any views or opinions expressed are solely those of the author and do not necessarily represent those of Initsix Heavy Engineering Limited. If you are not the intended recipient of this email, you must neither take any action based upon its contents, nor copy or show it to anyone. Please contact the sender if you believe you have received this email in error.
I get Access denied for the new user and "Sorry, unrecognized username or password. Have you forgotten your <http://64.25.226.138/bh_migrate/?q=user/password> password?" with the users that were in the database. It is not a white screen. It is Drupal 5.6 and we are using the default .htaccess files for Drupal. We are not using clean URLs. I am not sure what else there is to share. Thanks, Steve Steve Kessler Denver DataMan 303-587-4428 Sign up <http://www.denverdataman.com/denver-dataman-e-newsletter-signup> for the Denver DataMan Free eNewslettter From: Steve Power [mailto:steev@initsix.co.uk] Sent: Wednesday, April 21, 2010 11:26 PM To: support@drupal.org Subject: Re: [support] Cant Log In After Moving Site Whats the symptom? error message? white screen of death? is clean urls switched on (mod_rewrite etc)? On Thu, Apr 22, 2010 at 6:22 AM, Steve Kessler <skessler@denverdataman.com> wrote: I have done about an hour of research on this issue before posting to the list. I have transferred a database that had both Drupal and CiviCRM tables in one database and split it so that the Drupal database is on database and the CiviCRM database is in another. I had it working when all the tables were together in one database but I had a different problem and re-imported the data and now it does not work. I have tried to go back to one database and that does not work either. I have create a new user directly in the database and this user cant login. I have cleared the sessions table. I have changed the password of the admin user and used the MD5 function in PHPmyAdmin. I turned off CiviCRM in the system table and there is no change. I am out of ideas. Thank you very much! Thanks, Steve Steve Kessler Denver DataMan 303-587-4428 Sign up for the Denver DataMan Free eNewslettter <http://www.denverdataman.com/denver-dataman-e-newsletter-signup> -- [ Drupal support list | http://lists.drupal.org/ ] -- -- -- Steve Power Principal Consultant Mobile: +44 (0) 7747 027 243 Skype: steev_initsix www.initsix.co.uk :: Initsix Heavy Engineering Limited -- This email and any attachments to it may be confidential and are intended solely for the use of the individual to whom it is addressed. Any views or opinions expressed are solely those of the author and do not necessarily represent those of Initsix Heavy Engineering Limited. If you are not the intended recipient of this email, you must neither take any action based upon its contents, nor copy or show it to anyone. Please contact the sender if you believe you have received this email in error.
sorry, cant help with D5 On Thu, Apr 22, 2010 at 6:41 AM, Steve Kessler <skessler@denverdataman.com>wrote:
I get Access denied for the new user and “Sorry, unrecognized username or password. Have you forgotten your password?<http://64.25.226.138/bh_migrate/?q=user/password>” with the users that were in the database. It is not a white screen.
It is Drupal 5.6 and we are using the default .htaccess files for Drupal. We are not using clean URLs.
I am not sure what else there is to share.
Thanks,
Steve
Steve Kessler
*Denver DataMan *
303-587-4428
Sign up for the Denver DataMan Free eNewslettter<http://www.denverdataman.com/denver-dataman-e-newsletter-signup>
*From:* Steve Power [mailto:steev@initsix.co.uk] *Sent:* Wednesday, April 21, 2010 11:26 PM *To:* support@drupal.org *Subject:* Re: [support] Cant Log In After Moving Site
Whats the symptom? error message? white screen of death? is clean urls switched on (mod_rewrite etc)?
On Thu, Apr 22, 2010 at 6:22 AM, Steve Kessler <skessler@denverdataman.com> wrote:
I have done about an hour of research on this issue before posting to the list.
I have transferred a database that had both Drupal and CiviCRM tables in one database and split it so that the Drupal database is on database and the CiviCRM database is in another. I had it working when all the tables were together in one database but I had a different problem and re-imported the data and now it does not work. I have tried to go back to one database and that does not work either.
I have create a new user directly in the database and this user cant login.
I have cleared the sessions table.
I have changed the password of the admin user and used the MD5 function in PHPmyAdmin.
I turned off CiviCRM in the system table and there is no change.
I am out of ideas.
Thank you very much!
Thanks,
Steve
Steve Kessler
*Denver DataMan *
303-587-4428
Sign up for the Denver DataMan Free eNewslettter<http://www.denverdataman.com/denver-dataman-e-newsletter-signup>
-- [ Drupal support list | http://lists.drupal.org/ ]
-- -- -- Steve Power Principal Consultant Mobile: +44 (0) 7747 027 243 Skype: steev_initsix www.initsix.co.uk :: Initsix Heavy Engineering Limited -- This email and any attachments to it may be confidential and are intended solely for the use of the individual to whom it is addressed. Any views or opinions expressed are solely those of the author and do not necessarily represent those of Initsix Heavy Engineering Limited. If you are not the intended recipient of this email, you must neither take any action based upon its contents, nor copy or show it to anyone. Please contact the sender if you believe you have received this email in error.
-- -- -- Steve Power Principal Consultant Mobile: +44 (0) 7747 027 243 Skype: steev_initsix www.initsix.co.uk :: Initsix Heavy Engineering Limited -- This email and any attachments to it may be confidential and are intended solely for the use of the individual to whom it is addressed. Any views or opinions expressed are solely those of the author and do not necessarily represent those of Initsix Heavy Engineering Limited. If you are not the intended recipient of this email, you must neither take any action based upon its contents, nor copy or show it to anyone. Please contact the sender if you believe you have received this email in error.
If you have access to the mySQL database, you can probably resolve this by going directly into the user table. Steve Power wrote:
sorry, cant help with D5
On Thu, Apr 22, 2010 at 6:41 AM, Steve Kessler <skessler@denverdataman.com <mailto:skessler@denverdataman.com>> wrote:
I get Access denied for the new user and “Sorry, unrecognized username or password. Have you forgotten your password? <http://64.25.226.138/bh_migrate/?q=user/password>” with the users that were in the database. It is not a white screen.
It is Drupal 5.6 and we are using the default .htaccess files for Drupal. We are not using clean URLs.
I am not sure what else there is to share.
Thanks,
Steve
Steve Kessler
*Denver DataMan *
303-587-4428
Sign up for the Denver DataMan Free eNewslettter <http://www.denverdataman.com/denver-dataman-e-newsletter-signup>
*From:* Steve Power [mailto:steev@initsix.co.uk <mailto:steev@initsix.co.uk>] *Sent:* Wednesday, April 21, 2010 11:26 PM *To:* support@drupal.org <mailto:support@drupal.org> *Subject:* Re: [support] Cant Log In After Moving Site
Whats the symptom? error message? white screen of death? is clean urls switched on (mod_rewrite etc)?
On Thu, Apr 22, 2010 at 6:22 AM, Steve Kessler <skessler@denverdataman.com <mailto:skessler@denverdataman.com>> wrote:
I have done about an hour of research on this issue before posting to the list.
I have transferred a database that had both Drupal and CiviCRM tables in one database and split it so that the Drupal database is on database and the CiviCRM database is in another. I had it working when all the tables were together in one database but I had a different problem and re-imported the data and now it does not work. I have tried to go back to one database and that does not work either.
I have create a new user directly in the database and this user cant login.
I have cleared the sessions table.
I have changed the password of the admin user and used the MD5 function in PHPmyAdmin.
I turned off CiviCRM in the system table and there is no change.
I am out of ideas.
Thank you very much!
Thanks,
Steve
Steve Kessler
*Denver DataMan *
303-587-4428
Sign up for the Denver DataMan Free eNewslettter <http://www.denverdataman.com/denver-dataman-e-newsletter-signup>
-- [ Drupal support list | http://lists.drupal.org/ ]
-- -- -- Steve Power Principal Consultant Mobile: +44 (0) 7747 027 243 Skype: steev_initsix www.initsix.co.uk <http://www.initsix.co.uk> :: Initsix Heavy Engineering Limited -- This email and any attachments to it may be confidential and are intended solely for the use of the individual to whom it is addressed. Any views or opinions expressed are solely those of the author and do not necessarily represent those of Initsix Heavy Engineering Limited. If you are not the intended recipient of this email, you must neither take any action based upon its contents, nor copy or show it to anyone. Please contact the sender if you believe you have received this email in error.
-- -- -- Steve Power Principal Consultant Mobile: +44 (0) 7747 027 243 Skype: steev_initsix www.initsix.co.uk <http://www.initsix.co.uk> :: Initsix Heavy Engineering Limited -- This email and any attachments to it may be confidential and are intended solely for the use of the individual to whom it is addressed. Any views or opinions expressed are solely those of the author and do not necessarily represent those of Initsix Heavy Engineering Limited. If you are not the intended recipient of this email, you must neither take any action based upon its contents, nor copy or show it to anyone. Please contact the sender if you believe you have received this email in error.
It is Drupal 5.6 and we are using the default .htaccess files for Drupal. We are not using clean URLs.
A few ideas: 1. Remove civicrm.settings.php 2. Turn off all add-on modules 3. Upgrade to 5.22 (for sure do this) Then try again. Can you login at all? Does the password reset feature of Drupal work? F
I would try to export/import the database via a different method. If your original installation was ok, you should be able to move it. Better to retry export/import than to try to fix an installation which should be ok if moved correctly. Check also if there are differences between server and settings (check php info) between the servers where you move. Different method to move db could be: - Use backup_migrate module to export and import the db of - Export db with php myadmin to sql, import with bigdump Hans www.koba.be -- Hans Rossel KOBA Webdesign bvba Beukenlaan 56 9051 Gent (Sint-Denijs-Westrem) Belgium BTW 0817.931.516 +32.9.334.52.60 +32.472.79.32.16 www.koba.be info@koba.be
The problem was far less esoteric and more embarrassing. I will tell people the problem to give people something to check if they look at this conversation. Somehow the line $cookie_domain = 'example.com'; got separated from the # in settings.php. Once the cookies were not going to the wrong domain, one could log in again. Thank you for your time! Steve Kessler Denver DataMan 303-587-4428 Sign up <http://www.denverdataman.com/denver-dataman-e-newsletter-signup> for the Denver DataMan Free eNewslettter From: KOBA | Hans Rossel [mailto:hans.rossel@koba.be] Sent: Thursday, April 22, 2010 2:12 AM To: support@drupal.org; skessler@denverdataman.com Subject: Re: [support] Cant Log In After Moving Site I would try to export/import the database via a different method. If your original installation was ok, you should be able to move it. Better to retry export/import than to try to fix an installation which should be ok if moved correctly. Check also if there are differences between server and settings (check php info) between the servers where you move. Different method to move db could be: - Use backup_migrate module to export and import the db of - Export db with php myadmin to sql, import with bigdump Hans www.koba.be -- Hans Rossel KOBA Webdesign bvba Beukenlaan 56 9051 Gent (Sint-Denijs-Westrem) Belgium BTW 0817.931.516 +32.9.334.52.60 +32.472.79.32.16 www.koba.be info@koba.be
participants (5)
-
Fred Jones -
KOBA | Hans Rossel -
sebastian -
Steve Kessler -
Steve Power