The msg is: The type of database your Drupal data will be stored in. Your PHP configuration only supports a single database type, so it has been automatically selected. and only SQLite was detected.

However, MySQL was running OK, which was confirmed by running phpMyAdmin

One more step to confirm: Installed D6.19, and it can find MySQL (But, the advanced option is not available)

MySQL Server is 5.0.51a-24+lenny4, phpMyAdmin is-

php is 5.2.14, and phpinfo() is below. For more details about the hosting infrastructure, please see my notes

System Linux li219-11 #1 SMP Sun Jul 25 21:32:42 UTC 2010 i686
Build Date Oct 25 2010 16:24:14
Configure Command './configure' '--enable-fastcgi' '--enable-fpm' '--with-mcrypt' '--with-zlib' '--enable-mbstring' '--enable-pdo' '--with-curl' '--disable-debug' '--with-pic' '--disable-rpath' '--enable-inline-optimization' '--with-bz2' '--enable-xml' '--with-zlib' '--enable-sockets' '--enable-sysvsem' '--enable-sysvshm' '--enable-pcntl' '--enable-mbregex' '--with-mhash' '--with-xsl' '--enable-zip' '--with-pcre-regex' '--with-gd' '--with-mysqli-sock=/var/run/mysqld/mysqld.sock' '--with-mysql=/usr'
Server API CGI/FastCGI
Virtual Directory Support disabled
Configuration File (php.ini) Path /usr/local/lib
Loaded Configuration File /usr/local/lib/php.ini
Scan this dir for additional .ini files (none)
additional .ini files parsed (none)
PHP API 20041225
PHP Extension 20060613
Zend Extension 220060519
Debug Build no
Thread Safety disabled
Zend Memory Manager enabled
IPv6 Support enabled
Registered PHP Streams compress.zlib, compress.bzip2, php, file, data, http, ftp, zip
Registered Stream Socket Transports tcp, udp, unix, udg
Registered Stream Filters zlib.*, bzip2.*, convert.iconv.*, string.rot13, string.toupper, string.tolower, string.strip_tags, convert.*, consumed

This program makes use of the Zend Scripting Language Engine:
Zend Engine v2.2.0, Copyright (c) 1998-2010 Zend Technologies

PHP Credits


PHP Core

Directive Local Value Master Value
allow_call_time_pass_reference Off Off
allow_url_fopen On On
allow_url_include Off Off
always_populate_raw_post_data Off Off
arg_separator.input & &
arg_separator.output & &
asp_tags Off Off
auto_append_file no value no value
auto_globals_jit On On
auto_prepend_file no value no value
browscap no value no value
default_charset no value no value
default_mimetype text/html text/html
define_syslog_variables Off Off
disable_classes no value no value
disable_functions no value no value
display_errors Off Off
display_startup_errors Off Off
doc_root no value no value
docref_ext no value no value
docref_root no value no value
enable_dl On On
error_append_string no value no value
error_log no value no value
error_prepend_string no value no value
error_reporting 6143 6143
expose_php On On
extension_dir /usr/lib/php5/20060613+lfs/ /usr/lib/php5/20060613+lfs/
file_uploads On On #FFFFFF #FFFFFF
highlight.comment #FF8000 #FF8000
highlight.default #0000BB #0000BB
highlight.html #000000 #000000
highlight.keyword #007700 #007700
highlight.string #DD0000 #DD0000
html_errors On On
ignore_repeated_errors Off Off
ignore_repeated_source Off Off
ignore_user_abort Off Off
implicit_flush Off Off
include_path .:/usr/local/lib/php .:/usr/local/lib/php
log_errors On On
log_errors_max_len 1024 1024
magic_quotes_gpc Off Off
magic_quotes_runtime Off Off
magic_quotes_sybase Off Off
mail.force_extra_parameters no value no value
max_execution_time 30 30
max_file_uploads 20 20
max_input_nesting_level 64 64
max_input_time 60 60
memory_limit 128M 128M
open_basedir no value no value
output_buffering 4096 4096
output_handler no value no value
post_max_size 8M 8M
precision 14 14
realpath_cache_size 16K 16K
realpath_cache_ttl 120 120
register_argc_argv Off Off
register_globals Off Off
register_long_arrays Off Off
report_memleaks On On
report_zend_debug On On
safe_mode Off Off
safe_mode_exec_dir no value no value
safe_mode_gid Off Off
safe_mode_include_dir no value no value
sendmail_from no value no value
sendmail_path -t -i -t -i
serialize_precision 100 100
short_open_tag Off Off
SMTP localhost localhost
smtp_port 25 25
sql.safe_mode Off Off
track_errors Off Off
unserialize_callback_func no value no value
upload_max_filesize 2M 2M
upload_tmp_dir no value no value
user_dir no value no value
variables_order GPCS GPCS
xmlrpc_error_number 0 0
xmlrpc_errors Off Off
y2k_compliance On On
zend.ze1_compatibility_mode Off Off


APC Support enabled
Version 3.0.19
MMAP Support Enabled
MMAP File Mask no value
Locking type pthread mutex Locks
Revision $Revision: $
Build Date Oct 23 2010 14:22:19

Directive Local Value Master Value
apc.cache_by_default On On
apc.coredump_unmap Off Off
apc.enable_cli Off Off
apc.enabled On On
apc.file_update_protection 2 2
apc.filters no value no value
apc.gc_ttl 3600 3600
apc.include_once_override Off Off
apc.max_file_size 1M 1M
apc.mmap_file_mask no value no value
apc.num_files_hint 1000 1000
apc.report_autofilter Off Off
apc.rfc1867 Off Off
apc.rfc1867_freq 0 0
apc.rfc1867_prefix upload_ upload_
apc.shm_segments 1 1
apc.shm_size 30 30
apc.slam_defense 0 0
apc.stat On On
apc.stat_ctime Off Off
apc.ttl 0 0
apc.user_entries_hint 4096 4096
apc.user_ttl 0 0
apc.write_lock On On


BZip2 Support Enabled
Stream Wrapper support compress.bz2://
Stream Filter support bzip2.decompress, bzip2.compress
BZip2 Version 1.0.5, 10-Dec-2007


Directive Local Value Master Value
cgi.check_shebang_line 1 1
cgi.fix_pathinfo 1 1
cgi.nph 0 0
cgi.rfc2616_headers 0 0
fastcgi.error_header no value no value
fastcgi.logging 1 1

php-fpm active
php-fpm version 0.5.14


ctype functions enabled


cURL support enabled
cURL Information libcurl/7.18.2 OpenSSL/0.9.8g zlib/ libidn/1.8 libssh2/0.18


date/time support enabled
"Olson" Timezone Database Version 2010.9
Timezone Database internal
Default timezone UTC

Directive Local Value Master Value
date.default_latitude 31.7667 31.7667
date.default_longitude 35.2333 35.2333
date.sunrise_zenith 90.583333 90.583333
date.sunset_zenith 90.583333 90.583333
date.timezone no value no value


DOM/XML enabled
DOM/XML API Version 20031129
libxml Version 2.6.32
HTML Support enabled
XPath Support enabled
XPointer Support enabled
Schema Support enabled
RelaxNG Support enabled


Input Validation and Filtering enabled
Revision $Revision: 298196 $

Directive Local Value Master Value
filter.default unsafe_raw unsafe_raw
filter.default_flags no value no value


GD Support enabled
GD Version bundled (2.0.34 compatible)
GIF Read Support enabled
GIF Create Support enabled
PNG Support enabled
WBMP Support enabled
XBM Support enabled


hash support enabled
Hashing Engines md2 md4 md5 sha1 sha256 sha384 sha512 ripemd128 ripemd160 ripemd256 ripemd320 whirlpool tiger128,3 tiger160,3 tiger192,3 tiger128,4 tiger160,4 tiger192,4 snefru gost adler32 crc32 crc32b haval128,3 haval160,3 haval192,3 haval224,3 haval256,3 haval128,4 haval160,4 haval192,4 haval224,4 haval256,4 haval128,5 haval160,5 haval192,5 haval224,5 haval256,5


iconv support enabled
iconv implementation glibc
iconv library version 2.7

Directive Local Value Master Value
iconv.input_encoding ISO-8859-1 ISO-8859-1
iconv.internal_encoding ISO-8859-1 ISO-8859-1
iconv.output_encoding ISO-8859-1 ISO-8859-1


json support enabled
json version 1.2.1


libXML support active
libXML Version 2.6.32
libXML streams enabled


Multibyte Support enabled
Multibyte string engine libmbfl
Multibyte (japanese) regex support enabled
Multibyte regex (oniguruma) version 4.4.4
Multibyte regex (oniguruma) backtrack check On

mbstring extension makes use of "streamable kanji code filter and converter", which is distributed under the GNU Lesser General Public License version 2.1.

Directive Local Value Master Value
mbstring.detect_order no value no value
mbstring.encoding_translation Off Off
mbstring.func_overload 0 0
mbstring.http_input pass pass
mbstring.http_output pass pass
mbstring.internal_encoding no value no value
mbstring.language neutral neutral
mbstring.strict_detection Off Off
mbstring.substitute_character no value no value


mcrypt support enabled
Version 2.5.7
Api No 20021217
Supported ciphers cast-128 gost rijndael-128 twofish arcfour cast-256 loki97 rijndael-192 saferplus wake blowfish-compat des rijndael-256 serpent xtea blowfish enigma rc2 tripledes
Supported modes cbc cfb ctr ecb ncfb nofb ofb stream

Directive Local Value Master Value
mcrypt.algorithms_dir no value no value
mcrypt.modes_dir no value no value


memcache support enabled
Active persistent connections 0
Version 2.2.6
Revision $Revision: 303962 $

Directive Local Value Master Value
memcache.allow_failover 1 1
memcache.chunk_size 8192 8192
memcache.default_port 11211 11211
memcache.default_timeout_ms 1000 1000
memcache.hash_function crc32 crc32
memcache.hash_strategy standard standard
memcache.max_failover_attempts 20 20


MHASH support Enabled
MHASH API Version 20060101


MySQL Support enabled
Active Persistent Links 0
Active Links 0
Client API version 5.0.51a
MYSQL_SOCKET /var/run/mysqld/mysqld.sock
MYSQL_INCLUDE -I/usr/include/mysql
MYSQL_LIBS -L/usr/lib -lmysqlclient

Directive Local Value Master Value
mysql.allow_persistent On On
mysql.connect_timeout 60 60
mysql.default_host no value no value
mysql.default_password no value no value
mysql.default_port no value no value
mysql.default_socket no value no value
mysql.default_user no value no value
mysql.max_links Unlimited Unlimited
mysql.max_persistent Unlimited Unlimited
mysql.trace_mode Off Off


MysqlI Support enabled
Client API library version 5.0.51a
Client API header version 5.0.51a
MYSQLI_SOCKET /var/run/mysqld/mysqld.sock

Directive Local Value Master Value
mysqli.default_host no value no value
mysqli.default_port 3306 3306
mysqli.default_pw no value no value
mysqli.default_socket no value no value
mysqli.default_user no value no value
mysqli.max_links Unlimited Unlimited
mysqli.reconnect Off Off


pcntl support enabled


PCRE (Perl Compatible Regular Expressions) Support enabled
PCRE Library Version 8.02 2010-03-19

Directive Local Value Master Value
pcre.backtrack_limit 100000 100000
pcre.recursion_limit 100000 100000


PDO support enabled
PDO drivers sqlite, sqlite2


PDO Driver for SQLite 3.x enabled
PECL Module version (bundled) 1.0.1 $Id: pdo_sqlite.c 293036 2010-01-03 09:23:27Z sebastian $
SQLite Library 3.3.7


Revision $Revision: 293036 $


Reflection enabled
Version $Id: php_reflection.c 300129 2010-06-03 00:43:37Z felipe $


Session Support enabled
Registered save handlers files user sqlite memcache
Registered serializer handlers php php_binary

Directive Local Value Master Value
session.auto_start Off Off
session.bug_compat_42 Off Off
session.bug_compat_warn On On
session.cache_expire 180 180
session.cache_limiter nocache nocache
session.cookie_domain no value no value
session.cookie_httponly Off Off
session.cookie_lifetime 0 0
session.cookie_path / /
session.cookie_secure Off Off
session.entropy_file no value no value
session.entropy_length 0 0
session.gc_divisor 1000 1000
session.gc_maxlifetime 1440 1440
session.gc_probability 1 1
session.hash_bits_per_character 5 5
session.hash_function 0 0 PHPSESSID PHPSESSID
session.referer_check no value no value
session.save_handler files files
session.save_path no value no value
session.serialize_handler php php
session.use_cookies On On
session.use_only_cookies Off Off
session.use_trans_sid 0 0


Simplexml support enabled
Revision $Revision: 299016 $
Schema support enabled


Sockets Support enabled


SPL support enabled
Interfaces Countable, OuterIterator, RecursiveIterator, SeekableIterator, SplObserver, SplSubject
Classes AppendIterator, ArrayIterator, ArrayObject, BadFunctionCallException, BadMethodCallException, CachingIterator, DirectoryIterator, DomainException, EmptyIterator, FilterIterator, InfiniteIterator, InvalidArgumentException, IteratorIterator, LengthException, LimitIterator, LogicException, NoRewindIterator, OutOfBoundsException, OutOfRangeException, OverflowException, ParentIterator, RangeException, RecursiveArrayIterator, RecursiveCachingIterator, RecursiveDirectoryIterator, RecursiveFilterIterator, RecursiveIteratorIterator, RecursiveRegexIterator, RegexIterator, RuntimeException, SimpleXMLIterator, SplFileInfo, SplFileObject, SplObjectStorage, SplTempFileObject, UnderflowException, UnexpectedValueException


SQLite support enabled
PECL Module version 2.0-dev $Id: sqlite.c 298697 2010-04-28 12:10:10Z iliaa $
SQLite Library 2.8.17
SQLite Encoding iso8859

Directive Local Value Master Value
sqlite.assoc_case 0 0


Regex Library Bundled library enabled
Dynamic Library Support enabled
Path to sendmail -t -i

Directive Local Value Master Value 1 1
assert.bail 0 0
assert.callback no value no value
assert.quiet_eval 0 0
assert.warning 1 1
auto_detect_line_endings 0 0
default_socket_timeout 60 60
safe_mode_allowed_env_vars PHP_ PHP_
safe_mode_protected_env_vars LD_LIBRARY_PATH LD_LIBRARY_PATH
url_rewriter.tags a=href,area=href,frame=src,input=src,form=fakeentry a=href,area=href,frame=src,input=src,form=fakeentry
user_agent no value no value


Tokenizer Support enabled


XML Support active
XML Namespace Support active
libxml2 Version 2.6.32


XMLReader enabled


XMLWriter enabled


XSL enabled
libxslt Version 1.1.24
libxslt compiled against libxml Version 2.6.32
EXSLT enabled
libexslt Version 1.1.24


Zip enabled
Extension Version $Id: php_zip.c 293036 2010-01-03 09:23:27Z sebastian $
Zip version 1.8.11
Libzip version 0.9.0


ZLib Support enabled
Stream Wrapper support compress.zlib://
Stream Filter support zlib.inflate, zlib.deflate
Compiled Version
Linked Version

Directive Local Value Master Value
zlib.output_compression Off Off
zlib.output_compression_level -1 -1
zlib.output_handler no value no value

Additional Modules

Module Name


Variable Value
HOSTNAME no value
PATH /usr/local/bin:/usr/bin:/bin
TMP /tmp
TEMP /tmp
OSTYPE no value
MACHTYPE no value
USER www-data
HOME /var/www

PHP Variables

Variable Value
_REQUEST["__utmz"] 22502371.1274066560.1.1.utmcsr=(direct)|utmccn=(direct)|utmcmd=(none)
_REQUEST["SESS0f0db7765fb1daee958a93e132180d6a"] kNLH5Ku3l0xsUkzij2XfVxIULTQk9DUPychQLQKjVRs
_REQUEST["Drupal_visitor_name"] Anonymous
_REQUEST["Drupal_tableDrag_showWeight"] 0
_REQUEST["__utma"] 237308868.1802736240.1286575044.1287086645.1287093720.7
_REQUEST["Drupal_toolbar_collapsed"] 0
_REQUEST["SESSa2c721770955eb5b55cee891c8c9160e"] 6d78f7eb5f77cd7a9f0f572501e058fc
_REQUEST["has_js"] 1
_COOKIE["__utmz"] 22502371.1274066560.1.1.utmcsr=(direct)|utmccn=(direct)|utmcmd=(none)
_COOKIE["SESS0f0db7765fb1daee958a93e132180d6a"] kNLH5Ku3l0xsUkzij2XfVxIULTQk9DUPychQLQKjVRs
_COOKIE["Drupal_visitor_name"] Anonymous
_COOKIE["Drupal_tableDrag_showWeight"] 0
_COOKIE["__utma"] 237308868.1802736240.1286575044.1287086645.1287093720.7
_COOKIE["Drupal_toolbar_collapsed"] 0
_COOKIE["SESSa2c721770955eb5b55cee891c8c9160e"] 6d78f7eb5f77cd7a9f0f572501e058fc
_COOKIE["has_js"] 1
_SERVER["HOSTNAME"] no value
_SERVER["PATH"] /usr/local/bin:/usr/bin:/bin
_SERVER["TMP"] /tmp
_SERVER["TEMP"] /tmp
_SERVER["OSTYPE"] no value
_SERVER["MACHTYPE"] no value
_SERVER["USER"] www-data
_SERVER["HOME"] /var/www
_SERVER["SCRIPT_NAME"] /test.php
_SERVER["REQUEST_URI"] /test.php
_SERVER["HTTP_ACCEPT"] application/xml,application/xhtml+xml,text/html;q=0.9,text/plain;q=0.8,image/png,*/*;q=0.5
_SERVER["HTTP_USER_AGENT"] Mozilla/5.0 (X11; U; Linux x86_64; en-US) AppleWebKit/534.11 (KHTML, like Gecko) Ubuntu/10.04 Chromium/9.0.562.0 Chrome/9.0.562.0 Safari/534.11
_SERVER["HTTP_ACCEPT_ENCODING"] gzip,deflate,sdch
_SERVER["HTTP_ACCEPT_CHARSET"] ISO-8859-1,utf-8;q=0.7,*;q=0.3
_SERVER["HTTP_COOKIE"] __utmz=22502371.1274066560.1.1.utmcsr=(direct)|utmccn=(direct)|utmcmd=(none); __utmz=237308868.1286575044.1.1.utmcsr=(direct)|utmccn=(direct)|utmcmd=(none); SESS0f0db7765fb1daee958a93e132180d6a=kNLH5Ku3l0xsUkzij2XfVxIULTQk9DUPychQLQKjVRs;;; Drupal.tableDrag.showWeight=0; __utma=237308868.1802736240.1286575044.1287086645.1287093720.7; Drupal.toolbar.collapsed=0; SESSa2c721770955eb5b55cee891c8c9160e=6d78f7eb5f77cd7a9f0f572501e058fc; __utma=22502371.596070430.1284683642.1287846537.1288022626.29; has_js=1
_SERVER["PHP_SELF"] /test.php
_SERVER["REQUEST_TIME"] 1288025561


Damien Tournoud’s picture

Category:bug» support
Status:Active» Closed (works as designed)

You need PDO MySQL, as stated in the requirements.

skyredwang’s picture

Category:support» bug
Priority:Critical» Normal
Status:Closed (works as designed)» Active

OK. from the phpinfo() above, I have


PDO support enabled
PDO drivers sqlite, sqlite2


PDO Driver for SQLite 3.x enabled
PECL Module version (bundled) 1.0.1 $Id: pdo_sqlite.c 293036 2010-01-03 09:23:27Z sebastian $
SQLite Library 3.3.7

It doesn't have PDO MySQL

So, does the installation page need to tell admin that PDO MySQL is not enabled instead of being quiet?

Damien Tournoud’s picture

Category:bug» support
Status:Active» Closed (works as designed)

Drupal cannot read your mind. You don't have PDO MySQL installed, but have PDO SQLite, it can safely assume that you know what you are doing.

skyredwang’s picture

fair enough

haik’s picture

excuse me, i met with the same problem.
and after i have installed the and modified the php.ini (simply add a single,
i couldn't connect to the 'localhost'.
I'd like to know if you have solved the problem and how...
contact me:
many thx....