Ticket #406 (closed defect: fixed)

Opened 5 years ago

Last modified 5 years ago

Pressflow problem on Dev site

Reported by: chris Owned by: chris
Priority: blocker Milestone:
Component: Dev server Keywords:
Cc: laura, chris, jim Estimated Number of Hours: 0.0
Add Hours to Ticket: 0 Billable?: yes
Total Hours: 6.65

Description

When you try to login on the dev site:

http://dev.transitionnetwork.org/user/login

You get redirected to the installer for Pressflow:

https://dev.transitionnetwork.org/install.php?profile=default

I'm not sure what causes this, but it's not something I've done as far as I'm aware. I'm unable to proceed with testing Nginx and Drupal due to this.

Change History

comment:1 Changed 5 years ago by chris

  • Add Hours to Ticket changed from 0.0 to 1.25
  • Total Hours changed from 0.0 to 1.25

I have enabled lots of logging and found some other people who had this problem:

http://groups.drupal.org/node/87749

But I haven't found an answer yet...

The site works without a problem for non-authenticated users, see http://dev.transitionnetwork.org/ and also I have removed the server-level redirects to https, but when one tries to login here, http://dev.transitionnetwork.org/user/login you still get redirected to the pressflow installer here http://dev.transitionnetwork.org/install.php?profile=default This redirect isn't happening at a webserver level, it's a Drupal issue as far as I can tell.

I'll do some more work on this tomorrow...

comment:2 Changed 5 years ago by chris

  • Cc jim added
  • Add Hours to Ticket changed from 0.0 to 2.0
  • Status changed from new to assigned
  • Owner changed from jim to chris
  • Total Hours changed from 1.25 to 3.25

Not getting anywhere fast on this, done lots of searching, lots of people have had this problem, but I can't find an answer that helps. The dev site is fine:

http://dev.transitionnetwork.org/

As long as you don't try to login:

http://dev.transitionnetwork.org/user/login

Or use HTTPS:

https://dev.transitionnetwork.org/

I'll come back to this next week but I really don't know how to take it forward.

comment:3 Changed 5 years ago by chris

  • Add Hours to Ticket changed from 0.0 to 0.5
  • Total Hours changed from 3.25 to 3.75

As a test I have cloned a copy of Pressflow Drupal 6 and installed it on kiwi with exactly the same settings Nginx settings as we have for dev and test, and it appears to work without any problems:

http://drupal.kiwi.webarch.net/

This indicates to me that perhaps the problem with the dev site isn't with the Nginx settings? Jim, any thoughts about what further tests I could do?

comment:4 follow-up: ↓ 5 Changed 5 years ago by jim

I think you've kinda answered your own question: just delete the site and recreate it since we've nothing there we need, everything is in Git and in an ideal world DEV would be fully synced with LIVE in terms of DB and files again...

If you do, it'd def be worth setting InnoDB to use 1 file per table, and also to ensure cache clears aren't slow, leave (or convert back) the menu_router and search_* tables to MyISAM as D6 batch updates these tables in a retardedly slow manner. (confirmed though personal experience, see http://groups.drupal.org/node/18177 and others for more).

But anyway, I vote the DEV site is wiped, reinstalled and synced with LIVE.

Otherwise I won't get time to look at this before the weekend.

comment:5 in reply to: ↑ 4 Changed 5 years ago by chris

  • Add Hours to Ticket changed from 0.0 to 0.1
  • Total Hours changed from 3.75 to 3.85

Replying to jim:

I think you've kinda answered your own question: just delete the site and recreate it since we've nothing there we need, everything is in Git and in an ideal world DEV would be fully synced with LIVE in terms of DB and files again...

OK, I'll give that a go.

If you do, it'd def be worth setting InnoDB to use 1 file per table, and also to ensure cache clears aren't slow, leave (or convert back) the menu_router and search_* tables to MyISAM as D6 batch updates these tables in a retardedly slow manner. (confirmed though personal experience, see http://groups.drupal.org/node/18177 and others for more).

OK.

I'm reluctant to update the live server to use 1 file per table but I'll look at making the other change on live.

comment:6 Changed 5 years ago by chris

  • Add Hours to Ticket changed from 0.0 to 1.0
  • Total Hours changed from 3.85 to 4.85

Made a start on installing a new dev site:

cd /web/
mv dev.transitionnetwork.org.webarch.net dev.transitionnetwork.org.webarch.net.bak
mkdir dev.transitionnetwork.org
cd dev.transitionnetwork.org
mkdir www
git clone -b development git@github.com:i-jk/Transition-Network.git www
cd /web/dev.transitionnetwork.org/www/sites/default
chown www-data:www-data settings.php 

comment:7 Changed 5 years ago by chris

  • Add Hours to Ticket changed from 0.0 to 0.6
  • Total Hours changed from 4.85 to 5.45

Trying the dev server with a git checked copy of the code and then running the wiki:DevelopmentServer#live2dev script results in a non-functioning site:

Fatal error: Call to undefined function mailchimp_unsubscribe_page_title() in /web/dev.transitionnetwork.org.webarch.net/www/includes/menu.inc on line 506

I'm still sure that the problems are at a drupal level as the vanilla pressflow site works fine with exactly the same nginx setup, see http://drupal.kiwi.webarch.net/

Next I'll try doing it all manually to see if I can isolate the problem(s).

comment:8 Changed 5 years ago by chris

  • Add Hours to Ticket changed from 0.0 to 0.9
  • Total Hours changed from 5.45 to 6.35

Start from scratch with the dev site, first backup settings.php, then delete everything:

cd /web/dev.transitionnetwork.org.webarch.net/www
cp cp sites/default/settings.php ../
rm -rf *
rm -rf .htaccess .git .gitignore

Check out the code:

git clone -b development git@github.com:i-jk/Transition-Network.git .

Copy old settings.php back and the files dir and clear the cache:

cp ../settings.php sites/default/
mkdir /web/dev.transitionnetwork.org.webarch.net/www/sites/default/files
rsync -av --exclude=cache --exclude=filecache --exclude=imagecache \
      /home/live/quince/web/transitionnetwork.org/www/sites/default/files/ \
      /web/dev.transitionnetwork.org.webarch.net/www/sites/default/files/
chown -R www-data:www-data /web/dev.transitionnetwork.org.webarch.net/www/sites/default/files/
drush cc all

And all this results in the same problem, try to login and you get redirected to the Pressflow installer:

I'm not sure what to do next, I might try disabling modules to see if that helps or perhaps I should try running this same site via apache to see if that works?

comment:9 Changed 5 years ago by chris

  • Add Hours to Ticket changed from 0.0 to 0.1
  • Total Hours changed from 6.35 to 6.45

Generate a list of enabled modules and themes

cd /web/dev.transitionnetwork.org.webarch.net/www
drush pml | grep Enabled > /tmp/dev.pml

The list:

 Access control      Content Access (content_access)                     Module  Enabled        6.x-1.2     
 Administration      abuse (abuse)                                       Module  Enabled        6.x-1.2     
 Administration      Administration menu (admin_menu)                    Module  Enabled        6.x-1.x-dev 
 Caching             Varnish (varnish)                                   Module  Enabled        6.x-1.1     
 CCK                 CCK Private Fields (cck_private_fields)             Module  Enabled        6.x-1.1     
 CCK                 Content (content)                                   Module  Enabled        6.x-2.9     
 CCK                 Content Permissions (content_permissions)           Module  Enabled        6.x-2.9     
 CCK                 Content Taxonomy (content_taxonomy)                 Module  Enabled        6.x-1.0-rc2 
 CCK                 Email (email)                                       Module  Enabled        6.x-1.2     
 CCK                 Fieldgroup (fieldgroup)                             Module  Enabled        6.x-2.9     
 CCK                 FileField (filefield)                               Module  Enabled        6.x-3.10    
 CCK                 ImageField (imagefield)                             Module  Enabled        6.x-3.10    
 CCK                 Link (link)                                         Module  Enabled        6.x-2.9     
 CCK                 Location CCK (location_cck)                         Module  Enabled        6.x-3.x-dev 
 CCK                 Node access user reference                          Module  Enabled        6.x-3.3     
 CCK                 Node Reference (nodereference)                      Module  Enabled        6.x-2.9     
 CCK                 Number (number)                                     Module  Enabled        6.x-2.9     
 CCK                 Option Widgets (optionwidgets)                      Module  Enabled        6.x-2.9     
 CCK                 Text (text)                                         Module  Enabled        6.x-2.9     
 CCK                 User Reference (userreference)                      Module  Enabled        6.x-2.9     
 Chaos tool suite    Chaos tools (ctools)                                Module  Enabled        6.x-1.8     
 Chaos tool suite    Custom content panes (ctools_custom_content)        Module  Enabled        6.x-1.8     
 Chaos tool suite    Page manager (page_manager)                         Module  Enabled        6.x-1.8     
 Chaos tool suite    Views content panes (views_content)                 Module  Enabled        6.x-1.8     
 Content Profile     Content Profile (content_profile)                   Module  Enabled        6.x-1.0     
 Content Profile     Content Profile Tokens (content_profile_tokens)     Module  Enabled        6.x-1.0     
 Content Profile     Content Profile User Registration                   Module  Enabled        6.x-1.0     
 Context             Context (context)                                   Module  Enabled        6.x-2.1     
 Context             Context Contrib (context_contrib)                   Module  Enabled        6.x-2.1     
 Context             Context UI (context_ui)                             Module  Enabled        6.x-2.1     
 Core - alternate    Contact (contact)                                   Module  Enabled        6.x-2.x-dev 
 Core - optional     Comment (comment)                                   Module  Enabled        6.25        
 Core - optional     Content translation (translation)                   Module  Enabled        6.25        
 Core - optional     Forum (forum)                                       Module  Enabled        6.25        
 Core - optional     Help (help)                                         Module  Enabled        6.25        
 Core - optional     Locale (locale)                                     Module  Enabled        6.25        
 Core - optional     Menu (menu)                                         Module  Enabled        6.25        
 Core - optional     Path (path)                                         Module  Enabled        6.25        
 Core - optional     PHP filter (php)                                    Module  Enabled        6.25        
 Core - optional     Ping (ping)                                         Module  Enabled        6.25        
 Core - optional     Search (search)                                     Module  Enabled        6.25        
 Core - optional     Syslog (syslog)                                     Module  Enabled        6.25        
 Core - optional     Taxonomy (taxonomy)                                 Module  Enabled        6.25        
 Core - optional     Trigger (trigger)                                   Module  Enabled        6.25        
 Core - optional     Update status (update)                              Module  Enabled        6.25        
 Core - optional     Upload (upload)                                     Module  Enabled        6.25        
 Core - required     Block (block)                                       Module  Enabled        6.25        
 Core - required     Filter (filter)                                     Module  Enabled        6.25        
 Core - required     Node (node)                                         Module  Enabled        6.25        
 Core - required     System (system)                                     Module  Enabled        6.25        
 Core - required     User (user)                                         Module  Enabled        6.25        
 Custom Breadcrumbs  Custom Breadcrumbs (custom_breadcrumbs)             Module  Enabled        6.x-2.x-dev 
 Custom Breadcrumbs  Custom Breadcrumbs for Panels                       Module  Enabled        6.x-2.x-dev 
 Custom Breadcrumbs  Custom Breadcrumbs for Paths                        Module  Enabled        6.x-2.x-dev 
 Custom Breadcrumbs  Custom Breadcrumbs for Views                        Module  Enabled        6.x-2.x-dev 
 Custom Breadcrumbs  Custom Breadcrumbs Identifiers                      Module  Enabled        6.x-2.x-dev 
 Date/Time           Calendar (calendar)                                 Module  Enabled        6.x-2.4     
 Date/Time           Calendar iCal (calendar_ical)                       Module  Enabled        6.x-2.4     
 Date/Time           Calendar Popup (jcalendar)                          Module  Enabled        6.x-2.4     
 Date/Time           Date (date)                                         Module  Enabled        6.x-2.8     
 Date/Time           Date API (date_api)                                 Module  Enabled        6.x-2.8     
 Date/Time           Date Locale (date_locale)                           Module  Enabled        6.x-2.8     
 Date/Time           Date Popup (date_popup)                             Module  Enabled        6.x-2.8     
 Date/Time           Date Timezone (date_timezone)                       Module  Enabled        6.x-2.8     
 Features            Features (features)                                 Module  Enabled        6.x-1.2     
 Features            Initiatives Directory (initiatives_directory)       Module  Enabled        6.x-1.0-dev 
 Features            Transition - alert web contacts                     Module  Enabled        6.x-1.0     
 Features            Transition - raise alerts for profiles              Module  Enabled        6.x-1.0     
 Features            Transition Events (transition_events)               Module  Enabled        6.x-1.0-dev 
 Features            Transition import blogs (transition_import_blogs)   Module  Enabled        6.x-1.0     
 Features            Transition Network Projects                         Module  Enabled        6.x-1.0-bet 
 Features            Transition News (transition_news)                   Module  Enabled        6.x-1.0-dev 
 Features            Transition People (transition_people)               Module  Enabled        6.x-1.0-dev 
 Features            Transition PSE Widget (transition_pse_widget)       Module  Enabled        6.x-1.0-bet 
 Features            Transition Themes (transition_themes)               Module  Enabled        6.x-1.0-dev 
 Feeds               Feeds (feeds)                                       Module  Enabled        6.x-1.0-bet 
 Form Elements       Hierarchical Select (hierarchical_select)           Module  Enabled        6.x-3.8     
 Form Elements       Hierarchical Select Content Taxonomy                Module  Enabled        6.x-3.8     
 Form Elements       Hierarchical Select Taxonomy (hs_taxonomy)          Module  Enabled        6.x-3.8     
 Form Elements       Hierarchical Select Taxonomy Views                  Module  Enabled        6.x-3.8     
 i-JK                i-JK Plugins (ijk_plugins)                          Module  Enabled        6.x-1.0-dev 
 ImageCache          ImageAPI (imageapi)                                 Module  Enabled        6.x-1.10    
 ImageCache          ImageAPI ImageMagick (imageapi_imagemagick)         Module  Enabled        6.x-1.10    
 ImageCache          ImageCache (imagecache)                             Module  Enabled        6.x-2.0-bet 
 Input filters       Image resize filter (image_resize_filter)           Module  Enabled        6.x-1.13    
 Input filters       Pathologic (pathologic)                             Module  Enabled        6.x-3.x-dev 
 Location            GMap (gmap)                                         Module  Enabled        6.x-1.x-dev 
 Location            GMap Location (gmap_location)                       Module  Enabled        6.x-1.x-dev 
 Location            Location (location)                                 Module  Enabled        6.x-3.x-dev 
 Location            Node Locations (location_node)                      Module  Enabled        6.x-3.x-dev 
 Mail                Mime Mail (mimemail)                                Module  Enabled        6.x-1.0     
 Mail                Mime Mail CSS Compressor (mimemail_compress)        Module  Enabled        6.x-1.0     
 Media               Embedded Inline Media (eminline)                    Module  Enabled        6.x-2.5     
 Media               Embedded Media Field (emfield)                      Module  Enabled        6.x-2.5     
 Media               Embedded Video Field (emvideo)                      Module  Enabled        6.x-2.5     
 Media               Media: Vimeo (media_vimeo)                          Module  Enabled        6.x-1.1     
 Media               Media: YouTube (media_youtube)                      Module  Enabled        6.x-1.3     
 Node Hierarchy      Node Hierarchy (nodehierarchy)                      Module  Enabled        6.x-1.4     
 Nodequeue           Nodequeue (nodequeue)                               Module  Enabled        6.x-2.11    
 Organic groups      Organic groups (og)                                 Module  Enabled        6.x-2.3     
 Organic groups      Organic groups access control (og_access)           Module  Enabled        6.x-2.3     
 Organic groups      Organic groups actions (og_actions)                 Module  Enabled        6.x-2.3     
 Organic groups      Organic groups Views integration (og_views)         Module  Enabled        6.x-2.3     
 Other               Advanced Forum (advanced_forum)                     Module  Enabled        6.x-1.2     
 Other               Author Pane (author_pane)                           Module  Enabled        6.x-2.3     
 Other               Autoload (autoload)                                 Module  Enabled        6.x-2.1     
 Other               Automatic Nodetitles (auto_nodetitle)               Module  Enabled        6.x-1.2     
 Other               Backup and Migrate (backup_migrate)                 Module  Enabled        6.x-2.5     
 Other               Better Formats (better_formats)                     Module  Enabled        6.x-1.2     
 Other               Block Class (block_class)                           Module  Enabled        6.x-1.4     
 Other               Colorbox (colorbox)                                 Module  Enabled        6.x-1.x-dev 
 Other               Corresponding Node References                       Module  Enabled        6.x-4.1     
 Other               Custom Error (customerror)                          Module  Enabled        6.x-1.1     
 Other               IMCE (imce)                                         Module  Enabled        6.x-2.3     
 Other               Insert (insert)                                     Module  Enabled        6.x-1.1     
 Other               Job Scheduler (job_scheduler)                       Module  Enabled        6.x-1.0-bet 
 Other               LoginToboggan (logintoboggan)                       Module  Enabled        6.x-1.10    
 Other               Menu Block (menu_block)                             Module  Enabled        6.x-2.4     
 Other               Mollom (mollom)                                     Module  Enabled        6.x-1.16    
 Other               Nodeauthor (nodeauthor)                             Module  Enabled        6.x-1.8     
 Other               Path redirect (path_redirect)                       Module  Enabled        6.x-1.x-dev 
 Other               Pathauto (pathauto)                                 Module  Enabled        6.x-2.0     
 Other               Publish Content (publishcontent)                    Module  Enabled        6.x-1.x-dev 
 Other               Revision Deletion (revision_deletion)               Module  Enabled        6.x-1.0-rc2 
 Other               Site map (site_map)                                 Module  Enabled        6.x-2.x-dev 
 Other               String Overrides (stringoverrides)                  Module  Enabled        6.x-1.8     
 Other               Strongarm (strongarm)                               Module  Enabled        6.x-2.1     
 Other               Terms of Use (terms_of_use)                         Module  Enabled        6.x-1.13    
 Other               Token (token)                                       Module  Enabled        6.x-1.18    
 Other               Unique field (unique_field)                         Module  Enabled        6.x-1.4     
 Other               Update status advanced settings (update_advanced)   Module  Enabled        6.x-1.1     
 Other               Web Widgets (web_widgets)                           Module  Enabled        6.x-1.4     
 Panels              Panel nodes (panels_node)                           Module  Enabled        6.x-3.10    
 Panels              Panels (panels)                                     Module  Enabled        6.x-3.10    
 Performance and     Memcache (memcache)                                 Module  Enabled        6.x-1.10    
 Performance and     Memcache Admin (memcache_admin)                     Module  Enabled        6.x-1.10    
 Pressflow           Path alias cache (path_alias_cache)                 Module  Enabled                    
 Rules               Node limit number (node_limitnumber)                Module  Enabled        6.x-2.0-bet 
 Rules               Rules (rules)                                       Module  Enabled        6.x-1.4     
 Rules               Rules Administration UI (rules_admin)               Module  Enabled        6.x-1.4     
 Security            443 Session (session443)                            Module  Enabled        6.x-1.0     
 Service Links       Service links (service_links)                       Module  Enabled        6.x-2.1     
 Service Links       Service Links Sprites (service_links_sprites)       Module  Enabled        6.x-2.1     
 Service Links -     General Services (general_services)                 Module  Enabled        6.x-2.1     
 Site Tweaks         iTweak Upload (itweak_upload)                       Module  Enabled        6.x-2.5     
 Spam control        CAPTCHA (captcha)                                   Module  Enabled        6.x-2.4     
 Spam control        reCAPTCHA (recaptcha)                               Module  Enabled        6.x-1.x-dev 
 Statistics          Google Analytics (googleanalytics)                  Module  Enabled        6.x-3.3     
 Statistics          Piwik Web analytics (piwik)                         Module  Enabled        6.x-2.2     
 Taxonomy            Tagadelic (tagadelic)                               Module  Enabled        6.x-1.3     
 Transition          Transition Sharing Engine Client                    Module  Enabled        6.x-1.0-DEV 
 Transition Network  Transition Extras (transition_extras)               Module  Enabled        6.x         
 Transition Network  Transition Project Sharing Engine (transition_pse)  Module  Enabled        6.x-1.0-alp 
 User interface      IMCE Wysiwyg API bridge (imce_wysiwyg)              Module  Enabled        6.x-1.1     
 User interface      jQuery UI (jquery_ui)                               Module  Enabled        6.x-1.5     
 User interface      jQuery Update (jquery_update)                       Module  Enabled        6.x-2.0-alp 
 User interface      Multi-column checkboxes radios                      Module  Enabled        6.x-1.6     
 User interface      Wysiwyg (wysiwyg)                                   Module  Enabled        6.x-2.4     
 Views               Bonus: Views Export (views_bonus_export)            Module  Enabled        6.x-1.1     
 Views               Tagadelic Views (tagadelic_views)                   Module  Enabled        6.x-1.x-dev 
 Views               Views (views)                                       Module  Enabled        6.x-2.16    
 Views               Views Custom Field (views_customfield)              Module  Enabled        6.x-1.0     
 Views               Views JSON (views_json)                             Module  Enabled        6.x-1.x-dev 
 Views               Views Slideshow (views_slideshow)                   Module  Enabled        6.x-2.4     
 Views               Views Slideshow: SingleFrame                        Module  Enabled        6.x-2.4     
 Views               Views UI (views_ui)                                 Module  Enabled        6.x-2.16    
 Voting              Fivestar (fivestar)                                 Module  Enabled        6.x-1.20    
 Voting              Voting API (votingapi)                              Module  Enabled        6.x-2.x-dev 
 Webform             Webform (webform)                                   Module  Enabled        6.x-3.17    
 XML sitemap         XML sitemap (xmlsitemap)                            Module  Enabled        6.x-2.0-rc1 
 XML sitemap         XML sitemap node (xmlsitemap_node)                  Module  Enabled        6.x-2.0-rc1 
 XML sitemap         XML sitemap taxonomy (xmlsitemap_taxonomy)          Module  Enabled        6.x-2.0-rc1 
 Other               Transition (transition)                             Theme   Enabled        2.4         
 Other               Transition CMS (transitioncms)                      Theme   Enabled        1.24        
 Other               Transition2 (transition2)                           Theme   Enabled        2.4         

}}}

comment:10 Changed 5 years ago by chris

  • Add Hours to Ticket changed from 0.0 to 0.2
  • Status changed from assigned to closed
  • Resolution set to fixed
  • Total Hours changed from 6.45 to 6.65

Disable Varnish module (since the site isn't using varnish with nginx):

cd /web/dev.transitionnetwork.org.webarch.net/www
drush dis varnish
  The following extensions will be disabled: varnish
  Do you really want to continue? (y/n): y
  varnish was disabled successfully.              [ok]
  The configuration options have been saved.      [status]

The login page still redirects to the installer.

Disable 443 Session since the dev site is currently set to allow logins via port 80 will I'm trying to get it working:

The following extensions will be disabled: session443
Do you really want to continue? (y/n): y
WD php: Notice: Use of undefined constant SESSION443_STATUS_DISABLED - assumed  [error]
'SESSION443_STATUS_DISABLED' in session443_disable() (line 22 of
/web/dev.transitionnetwork.org.webarch.net/www/sites/all/modules/session443/session443.install).
session443 was disabled successfully. 

And now the login page loads!!!

http://dev.transitionnetwork.org/user/login

It's a shame it took almost 7 hours to track this down, but now we have a working dev site with nginx!

So I'm closing this ticket.

Note: See TracTickets for help on using tickets.