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....