Gentoo Websites Logo
Go to: Gentoo Home Documentation Forums Lists Bugs Planet Store Wiki Get Gentoo!
Bug 355559 - Drupal fails install script, MySQL database tables not fully populated
Summary: Drupal fails install script, MySQL database tables not fully populated
Status: RESOLVED FIXED
Alias: None
Product: Gentoo Linux
Classification: Unclassified
Component: New packages (show other bugs)
Hardware: x86 Linux
: High normal (vote)
Assignee: Gentoo Web Application Packages Maintainers
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2011-02-19 14:25 UTC by Don Bishop
Modified: 2011-02-23 03:37 UTC (History)
2 users (show)

See Also:
Package list:
Runtime testing required: ---


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description Don Bishop 2011-02-19 14:25:15 UTC
Drupal does not complete installation.  Symptoms are very predictable.  Installation starts normally, pages display okay, but MySQL tables are not fully populated and then everything starts breaking.  Lots of shrugs from Drupal developers, asking to check cookie settings and so on.  I've tried this on a test server and even tried using a browser (Firefox)  on the same machine to sidestep most of the firewall/cookie concerns.

Please see also my bug filed on Drupal http://drupal.org/node/1061964

I have tried a install/uninstall/reinstall quite a number of times.  It always ends with the same 32 tables populated, ad the Drupal folks say that this is not enough.

This machine runs mediawiki just fine and is accessible from everywhere.  This machine is in a DMZ.  As an aside, I did try Joomla too and it also fails, complaining about cookies.  But I have seen the cookies get created.  Someone mentioned something about a reverse proxy configuration for apache, but my apache kung fu is not all that great.  Anyway, I did try to do everything from the same machine, and that didn't work either.  And the machine is in a vhost environment (just like the working wiki).

I could use some help :-)


davies www # emerge --info
Portage 2.1.9.25 (default/linux/x86/10.0, gcc-4.4.4, glibc-2.11.2-r3, 2.6.36-gentoo-r5 i686)
=================================================================
System uname: Linux-2.6.36-gentoo-r5-i686-Intel-R-_Pentium-R-_4_CPU_2.80GHz-with-gentoo-1.12.14
Timestamp of tree: Wed, 16 Feb 2011 07:30:01 +0000
ccache version 2.4 [enabled]
app-shells/bash:     4.1_p9
dev-lang/python:     2.6.6-r1, 3.1.2-r4
dev-util/ccache:     2.4-r9
dev-util/cmake:      2.8.1-r2
sys-apps/baselayout: 1.12.14-r1
sys-apps/sandbox:    2.4
sys-devel/autoconf:  2.13, 2.65-r1
sys-devel/automake:  1.11.1
sys-devel/binutils:  2.20.1-r1
sys-devel/gcc:       4.4.4-r2
sys-devel/gcc-config: 1.4.1
sys-devel/libtool:   2.2.10
sys-devel/make:      3.81-r2
virtual/os-headers:  2.6.36.1 (sys-kernel/linux-headers)
ACCEPT_KEYWORDS="x86"
ACCEPT_LICENSE="* -@EULA"
CBUILD="i686-pc-linux-gnu"
CFLAGS="-march=native -O2 -pipe"
CHOST="i686-pc-linux-gnu"
CONFIG_PROTECT="/etc"
CONFIG_PROTECT_MASK="/etc/ca-certificates.conf /etc/env.d /etc/fonts/fonts.conf /etc/gconf /etc/php/apache2-php5.3/ext-active/ /etc/php/cgi-php5.3/ext-active/ /etc/php/cli-php5.3/ext-active/ /etc/revdep-rebuild /etc/sandbox.d /etc/terminfo /etc/texmf/language.dat.d /etc/texmf/language.def.d /etc/texmf/updmap.d /etc/texmf/web2c"
CXXFLAGS="-march=native -O2 -pipe"
DISTDIR="/usr/portage/distfiles"
FEATURES="assume-digests binpkg-logs ccache distlocks fixlafiles fixpackages news parallel-fetch protect-owned sandbox sfperms strict unknown-features-warn unmerge-logs unmerge-orphans userfetch"
GENTOO_MIRRORS="http://distfiles.gentoo.org"
LDFLAGS="-Wl,-O1 -Wl,--as-needed"
PKGDIR="/usr/portage/packages"
PORTAGE_CONFIGROOT="/"
PORTAGE_RSYNC_OPTS="--recursive --links --safe-links --perms --times --compress --force --whole-file --delete --stats --timeout=180 --exclude=/distfiles --exclude=/local --exclude=/packages"
PORTAGE_TMPDIR="/var/tmp"
PORTDIR="/usr/portage"
SYNC="rsync://kreiger.bish0p.org/gentoo-portage"
USE="X X509 acl apache2 bash-completion berkdb bzip2 cli compat cracklib crypt ctype cups curl cxx dri dvd extras filter firefox fortran ftp gd gdbm gif gnutls gpm gtk gzip hddtemp iconv image imagemagick imap imlib ipv6 jpeg jpeg2k json lm_sensors math mhash modules mudflap mysql mysqli ncurses nfs nls nptl nptlonly odbc openmp pam pcap pcre pdf pdo perl php png postfix pppd python qt4 readline reflection samba sensord session spl sqlite sqlite3 ssl svg sysfs tcpd tiff truetype udev unicode vhosts x86 x86emu xml xmlreader xmlrpc xmlwriter xorg xsl zip zlib" ALSA_CARDS="ali5451 als4000 atiixp atiixp-modem bt87x ca0106 cmipci emu10k1 emu10k1x ens1370 ens1371 es1938 es1968 fm801 hda-intel intel8x0 intel8x0m maestro3 trident usb-audio via82xx via82xx-modem ymfpci" ALSA_PCM_PLUGINS="adpcm alaw asym copy dmix dshare dsnoop empty extplug file hooks iec958 ioplug ladspa lfloat linear meter mmap_emul mulaw multi null plug rate route share shm softvol" APACHE2_MODULES="actions alias auth_basic authn_alias authn_anon authn_dbm authn_default authn_file authz_dbm authz_default authz_groupfile authz_host authz_owner authz_user autoindex cache cgi cgid dav dav_fs dav_lock deflate dir disk_cache env expires ext_filter file_cache filter headers include info log_config logio mem_cache mime mime_magic negotiation rewrite setenvif speling status unique_id userdir usertrack vhost_alias" CAMERAS="ptp2" COLLECTD_PLUGINS="df interface irq load memory rrdtool swap syslog" ELIBC="glibc" GPSD_PROTOCOLS="ashtech aivdm earthmate evermore fv18 garmin garmintxt gpsclock itrax mtk3301 nmea ntrip navcom oceanserver oldstyle oncore rtcm104v2 rtcm104v3 sirf superstar2 timing tsip tripmate tnt ubx" INPUT_DEVICES="evdev keyboard mouse kbd" KERNEL="linux" LCD_DEVICES="bayrad cfontz cfontz633 glk hd44780 lb216 lcdm001 mtxorb ncurses text" PHP_TARGETS="php5-3" RUBY_TARGETS="ruby18" USERLAND="GNU" VIDEO_CARDS="i810 i830 i915 vesa fbdev" XTABLES_ADDONS="quota2 psd pknock lscan length2 ipv4options ipset ipp2p iface geoip fuzzy condition tee tarpit sysrq steal rawnat logmark ipmark dhcpmac delude chaos account" 
Unset:  CPPFLAGS, CTARGET, EMERGE_DEFAULT_OPTS, FFLAGS, INSTALL_MASK, LANG, LC_ALL, LINGUAS, MAKEOPTS, PORTAGE_BUNZIP2_COMMAND, PORTAGE_COMPRESS, PORTAGE_COMPRESS_FLAGS, PORTAGE_RSYNC_EXTRA_OPTS, PORTDIR_OVERLAY
Comment 1 Jorge Manuel B. S. Vicetto (RETIRED) Gentoo Infrastructure gentoo-dev 2011-02-22 14:20:47 UTC
What drupal version are you using? How are you running the installation script?
For the record I have drupal-7.0 installed on 2 systems and didn't have installation issues.
Comment 2 Don Bishop 2011-02-23 03:37:28 UTC
I was installing Drupal 7.0  As it happens, my issue was related to an innocuous setting in my php.ini session.secure_cookie . If this is enabled and your site isn't configured for ssl, the database installation will be incomplete and you'll get lots of errors that don't mean much.  it's a setting that webapp-config suggests in the post install instructions.  It could probably be worded better.  Once I found out the what the problem was (actually someone on gentoo forums had the exact same problem and found it and clued me in), I was all set.  Then I could find a few vague references to cookie settings causing Drupal installation problems, but since a lot of errors get reported as PDO errors it was difficult to make use of any of the bug reports.

So, if anyone has a partial database install (mine completed with 74 tables, the broken database always had 32 tables) followed by PDO exceptions, make sure that you don't have session.cookie_secure set in any php.ini file.  If you do  comment them out, restart apache, drop the associated mysql schema, delete the drupal directory (mine was a vhost at /var/www/[directory]), rerun webapp-config, and head to the drupal install page.  I did an update to the gentoo wiki on this too.

Sorry for the false alarm.  But someone should also clean up the webapp notice though...