[Tfug] Lost control panel on Drupal after move from testing to live

[keith smith]

Thank you Paul!!  It will take me a while to decipher this. So basically one needs to go through all the tables looking for "drupal.xxx.tld" and replace it with "www.xxx.tld" and truncate the cach table.  Is that correct?

 

------------------------

Keith Smith

--- On Wed, 11/10/10, Paul Lemmons <paul at lemmons.name> wrote:

From: Paul Lemmons <paul at lemmons.name>
Subject: Re: [Tfug] Lost control panel on Drupal after move from testing to live
To: "Tucson Free Unix Group" <tfug at tfug.org>
Cc: "keith smith" <klsmith2020 at yahoo.com>
Date: Wednesday, November 10, 2010, 1:41 PM



  

    
  -------- Original Message  --------

    Subject: [Tfug] Lost control panel on Drupal after move from testing
    to live

    From: keith smith <klsmith2020 at yahoo.com>

    To: Tucson Free Unix Group <tfug at tfug.org>

    Date: 11/10/2010 12:43 PM

    
      
        
          
            Hi,

              

              I'm stuck with a Drupal problem.  We built a Drupal site
              using a sub-domain drupal.xxxxx.tld.  Then when we were
              ready to make it live, basically all I did was change
              ServerName  from drupal.xxxxx.tld  to  www.xxxxxxx.tld

              

              We are able to access the site and it displays the content
              as expected.  The problem is when I try to log in to the
              admin control panel at http://www.xxxxx.tld/admin I am
              taken to https://drupal.xxxxx.tld which does not exist.
              (after completing the form and clicking submit)  This
              results in "The webpage cannot be found".

              

              I have removed the virtual host from the ssl.conf file in
              an attempt to get down to the basics so I can figure out
              what is going wrong.

              

              There was a line in the setting.php file : $cookie_domain
              = 'drupal.xxxxx.tld';  I modified it to read
              $cookie_domain = 'www.xxxxx.tld';

              

              I'm feeling like there is a setting in drupal that I need
              to modify.  Could that be so?

              

              Any and all feedback is much appreciated.

              

              Thanks!

              

              

              ------------------------

              Keith Smith
          
        
      
      

      
_______________________________________________
Tucson Free Unix Group - tfug at tfug.org
Subscription Options:
http://www.tfug.org/mailman/listinfo/tfug_tfug.org

    
    

    You need to update the links in the drupal database. I have a script
    that I use to clone once instance into another, most often a
    production instance to a test instance on a different box. The
    script is below. You can modify it to fit your needs. Basically it
    dumps the source database through sed to update links and then loads
    the data into a new database. It then truncates the cache table in
    the destination database and copies over the directory structure.
    You may not need all of that but it is there for completeness. You
    would for sure need to update the <bla-bla-bla> tags in the
    script.

    

    #!/bin/bash

      

      mysqldump                      \

            --max_allowed_packet=64M \

            --host=<srcHostname>     \

            --user=<srcDbUserName>   \

            --password=<dbPassword>  \

            --allow-keywords         \

            --create-options         \

            --extended-insert        \

            --single-transaction     \

            --add-drop-table         \

            <srcDbName>              \

      |                              \

      sed  \

            -e "s/drupal.xxx.tld/www.xxx.tld/g"                  \

            -e "s/http:\/\/www.xxx.tld/https:\/\/www.xxx.tld/g"  \

      |                              \

      mysql                          \

            --host=<destHostname>    \

            --user=<destDbUserName>  \

            --password=<destDbPass>  \

            <destDB>

      

      

      echo "truncate table cache;"   \

      |                              \

      mysql                          \

         
      --host=<destHostname>    \

            --user=<destDbUserName>  \

            --password=<destDbPass>  \

            <destDB>

    

    options="\

            --verbose      \

            --checksum     \

            --recursive    \

            --update       \

            --links        \

            --hard-links   \

            --perms        \

            --owner        \

            --group        \

            --times        \

            --ipv4         \

            --progress     \

      "

      

      rsync $options srcHostName:/var/www/html/srcHttpDir/*
      /var/www/html/destHttpDir/

      

      chown -R apache:apache  /var/www/html/destHttpDir/

    chmod -R g+w           
    /var/www/html/destHttpDir/

    

    

  

-----Inline Attachment Follows-----

_______________________________________________
Tucson Free Unix Group - tfug at tfug.org
Subscription Options:
http://www.tfug.org/mailman/listinfo/tfug_tfug.org



      
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://tfug.org/pipermail/tfug_tfug.org/attachments/20101110/3160829c/attachment-0002.html>