Discussion :

[embargo]

bonsoir, j'ai un pb d'acces a PhpMyAdmin, apres identification (root et mdp mysql) j'obtiens une page blanche

je suis sous win 7, Firefox 3.6.3, apache 2.2.15, php 5.3.2 vc6, phpmyadmin 3.3.1, mysql 5.1.45 (idem sous IE8)

test de ma config au fur et a mesure des installations

apache tourne nickel, phpinfo(); donne bien toute les infos
test d'un echo avec erreur, l'erreur est bien retournée a l'ecran (E_ALL actif donc)

mais quand je souhaite me logger a PMA, j'obtiens une page blanche

j'ai aussi essayer de configurer PMA via http://localhost/pma/setup/
que ce soit en cookie, config ou http, ca reste pareil

mon PATH :

Code :

Sélectionner tout - Visualiser dans une fenêtre à part

PATH=C:\Windows\system32;C:\Windows;C:\Windows\System32\Wbem;C:\Windows\System32\WindowsPowerShell\v1.0\;E:\sites\apache-2.2\bin;E:\sites\MySQL Server 5.1\bin;E:\sites\php5;

mon httpd.conf d'apache 2.2.15 :

Code :

Sélectionner tout - Visualiser dans une fenêtre à part

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
ServerRoot "E:/sites/apache-2.2" ##################################
Listen 80
LoadModule actions_module modules/mod_actions.so
LoadModule alias_module modules/mod_alias.so
LoadModule asis_module modules/mod_asis.so
LoadModule auth_basic_module modules/mod_auth_basic.so
LoadModule authn_default_module modules/mod_authn_default.so
LoadModule authn_file_module modules/mod_authn_file.so
LoadModule authz_default_module modules/mod_authz_default.so
LoadModule authz_groupfile_module modules/mod_authz_groupfile.so
LoadModule authz_host_module modules/mod_authz_host.so
LoadModule authz_user_module modules/mod_authz_user.so
LoadModule autoindex_module modules/mod_autoindex.so
LoadModule cgi_module modules/mod_cgi.so
LoadModule dir_module modules/mod_dir.so
LoadModule env_module modules/mod_env.so
LoadModule include_module modules/mod_include.so
LoadModule isapi_module modules/mod_isapi.so
LoadModule log_config_module modules/mod_log_config.so
LoadModule mime_module modules/mod_mime.so
LoadModule negotiation_module modules/mod_negotiation.so
LoadModule setenvif_module modules/mod_setenvif.so
<IfModule !mpm_netware_module>
<IfModule !mpm_winnt_module>
User daemon
Group daemon
</IfModule>
</IfModule>
ServerAdmin admin@localhost ##################################
DocumentRoot "E:/sites/monsite" ##################################
<Directory />
    Options FollowSymLinks
    AllowOverride None
    Order deny,allow
    Deny from all
</Directory>
<Directory "E:/sites/monsite"> ##################################
    Options Indexes FollowSymLinks
    AllowOverride None
    Order allow,deny
    Allow from all
</Directory>
<IfModule dir_module>
    DirectoryIndex index.html index.php ##################################
</IfModule>
<FilesMatch "^\.ht">
    Order allow,deny
    Deny from all
    Satisfy All
</FilesMatch>
ErrorLog "logs/error.log"
LogLevel warn
<IfModule log_config_module>
    LogFormat "%h %l %u %t \"%r\" %>s %b \"%{Referer}i\" \"%{User-Agent}i\"" combined
    LogFormat "%h %l %u %t \"%r\" %>s %b" common
    <IfModule logio_module>
      LogFormat "%h %l %u %t \"%r\" %>s %b \"%{Referer}i\" \"%{User-Agent}i\" %I %O" combinedio
    </IfModule>
    CustomLog "logs/access.log" common
</IfModule>
<IfModule alias_module>
    ScriptAlias /cgi-bin/ "E:/sites/apache-2.2/cgi-bin/" ##################################
</IfModule>
<Directory "E:/sites/apache-2.2/cgi-bin"> ##################################
    AllowOverride None
    Options None
    Order allow,deny
    Allow from all
</Directory>
DefaultType text/plain
<IfModule mime_module>
    TypesConfig conf/mime.types
    AddType application/x-compress .Z
    AddType application/x-gzip .gz .tgz
</IfModule>
<IfModule ssl_module>
SSLRandomSeed startup builtin
SSLRandomSeed connect builtin
</IfModule>
 
##########################################################################################
LoadModule php5_module "E:\sites\php5\php5apache2_2.dll"
Addtype application/x-httpd-php .php .inc
Alias /pma "E:\sites\monsite\phpmyadmin_3.3.1"
PHPIniDir "E:\sites\php5"
##########################################################################################

mon php.ini de PHP 5.3.2 :

Code :

Sélectionner tout - Visualiser dans une fenêtre à part

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
[PHP]
engine = On
short_open_tag = Off
asp_tags = Off
precision = 14
y2k_compliance = On
output_buffering = 4096
zlib.output_compression = Off
implicit_flush = Off
unserialize_callback_func =
serialize_precision = 100
allow_call_time_pass_reference = Off
safe_mode = Off
safe_mode_gid = Off
safe_mode_include_dir =
safe_mode_exec_dir =
safe_mode_allowed_env_vars = PHP_
safe_mode_protected_env_vars = LD_LIBRARY_PATH
disable_functions =
disable_classes =
expose_php = On
max_execution_time = 30
max_input_time = 60
memory_limit = 128M
error_reporting = E_ALL
display_errors = On ;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;
display_startup_errors = On ;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;
log_errors = On
log_errors_max_len = 1024
ignore_repeated_errors = Off
ignore_repeated_source = Off
report_memleaks = On
track_errors = Off
html_errors = Off
variables_order = "GPCS"
request_order = "GP"
register_globals = Off
register_long_arrays = Off
register_argc_argv = Off
auto_globals_jit = On
post_max_size = 8M
magic_quotes_gpc = Off
magic_quotes_runtime = Off
magic_quotes_sybase = Off
auto_prepend_file =
auto_append_file =
default_mimetype = "text/html"
doc_root =
user_dir =
extension_dir = "E:/sites/php5/ext" ;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;
enable_dl = Off
file_uploads = On
upload_max_filesize = 2M
max_file_uploads = 20
allow_url_fopen = On
allow_url_include = Off
default_socket_timeout = 60
extension=php_bz2.dll
extension=php_gd2.dll
extension=php_mbstring.dll
extension=php_mysql.dll
extension=php_mysqli.dll
extension=php_xsl.dll
[Pdo_mysql]
pdo_mysql.cache_size = 2000
pdo_mysql.default_socket=
[Syslog]
define_syslog_variables  = Off
[mail function]
SMTP = localhost
smtp_port = 25
mail.add_x_header = On
[SQL]
sql.safe_mode = Off
[ODBC]
odbc.allow_persistent = On
odbc.check_persistent = On
odbc.max_persistent = -1
odbc.max_links = -1
odbc.defaultlrl = 4096
odbc.defaultbinmode = 1
[Interbase]
ibase.allow_persistent = 1
ibase.max_persistent = -1
ibase.max_links = -1
ibase.timestampformat = "%Y-%m-%d %H:%M:%S"
ibase.dateformat = "%Y-%m-%d"
ibase.timeformat = "%H:%M:%S"
[MySQL]
mysql.allow_local_infile = On
mysql.allow_persistent = On
mysql.cache_size = 2000
mysql.max_persistent = -1
mysql.max_links = -1
mysql.default_port =
mysql.default_socket =
mysql.default_host =
mysql.default_user =
mysql.default_password =
mysql.connect_timeout = 60
mysql.trace_mode = Off
[MySQLi]
mysqli.max_persistent = -1
mysqli.allow_persistent = On
mysqli.max_links = -1
mysqli.cache_size = 2000
mysqli.default_port = 3306
mysqli.default_socket =
mysqli.default_host =
mysqli.default_user =
mysqli.default_pw =
mysqli.reconnect = Off
[mysqlnd]
mysqlnd.collect_statistics = On
mysqlnd.collect_memory_statistics = Off
[PostgresSQL]
pgsql.allow_persistent = On
pgsql.auto_reset_persistent = Off
pgsql.max_persistent = -1
pgsql.max_links = -1
pgsql.ignore_notice = 0
pgsql.log_notice = 0
[Sybase-CT]
sybct.allow_persistent = On
sybct.max_persistent = -1
sybct.max_links = -1
sybct.min_server_severity = 10
sybct.min_client_severity = 10
[bcmath]
bcmath.scale = 0
[Session]
session.save_handler = files
session.save_path = "E:/sites/php5/sessions/" ;;;;;;;;;;;;;;;;;;;;;;;;;;;;;
session.use_cookies = 1
session.use_only_cookies = 1
session.name = PHPSESSID
session.auto_start = 0
session.cookie_lifetime = 0
session.cookie_path = /
session.cookie_domain =
session.cookie_httponly =
session.serialize_handler = php
session.gc_probability = 1
session.gc_divisor = 1000
session.gc_maxlifetime = 1440
session.bug_compat_42 = Off
session.bug_compat_warn = Off
session.referer_check =
session.entropy_length = 0
session.entropy_file =
session.cache_limiter = nocache
session.cache_expire = 180
session.use_trans_sid = 0
session.hash_function = 0
session.hash_bits_per_character = 5
url_rewriter.tags = "a=href,area=href,frame=src,input=src,form=fakeentry"
[MSSQL]
mssql.allow_persistent = On
mssql.max_persistent = -1
mssql.max_links = -1
mssql.min_error_severity = 10
mssql.min_message_severity = 10
mssql.compatability_mode = Off
mssql.secure_connection = Off
[Tidy]
tidy.clean_output = Off
[soap]
soap.wsdl_cache_enabled=1
soap.wsdl_cache_dir="/tmp"
soap.wsdl_cache_ttl=86400
soap.wsdl_cache_limit = 5
[ldap]
ldap.max_links = -1

et mon config.inc.php de PMA 3.3.1 :

Code :

Sélectionner tout - Visualiser dans une fenêtre à part

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
<?php
$cfg['blowfish_secret'] = '';
$i = 0;
$i++;
$cfg['Servers'][$i]['auth_type'] = 'cookie';
$cfg['Servers'][$i]['host'] = 'localhost';
$cfg['Servers'][$i]['connect_type'] = 'tcp';
$cfg['Servers'][$i]['compress'] = false;
$cfg['Servers'][$i]['extension'] = 'mysqli';
$cfg['Servers'][$i]['AllowNoPassword'] = false;
$cfg['Servers'][$i]['bs_garbage_threshold'] = 50;
$cfg['Servers'][$i]['bs_repository_threshold'] = '32M';
$cfg['Servers'][$i]['bs_temp_blob_timeout'] = 600;
$cfg['Servers'][$i]['bs_temp_log_threshold'] = '32M';
$cfg['Servers'][$i]['controluser'] = 'pma';
$cfg['Servers'][$i]['controlpass'] = 'pmapass';
$cfg['Servers'][$i]['pmadb'] = 'phpmyadmin';
$cfg['Servers'][$i]['bookmarktable'] = 'pma_bookmark';
$cfg['Servers'][$i]['relation'] = 'pma_relation';
$cfg['Servers'][$i]['table_info'] = 'pma_table_info';
$cfg['Servers'][$i]['table_coords'] = 'pma_table_coords';
$cfg['Servers'][$i]['pdf_pages'] = 'pma_pdf_pages';
$cfg['Servers'][$i]['column_info'] = 'pma_column_info';
$cfg['Servers'][$i]['history'] = 'pma_history';
$cfg['Servers'][$i]['designer_coords'] = 'pma_designer_coords';
$cfg['UploadDir'] = '';
$cfg['SaveDir'] = '';
?>

et le error.log d'apache pour la sequence d'actions suivante :
demarré apache/arreté apache/demarré apache/ acces page pma / page blanche apres login

Code :

Sélectionner tout - Visualiser dans une fenêtre à part

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
httpd.exe: Could not reliably determine the server's fully qualified domain name, using 192.168.0.11 for ServerName
[Thu Apr 08 23:21:47 2010] [notice] Apache/2.2.15 (Win32) PHP/5.3.2 configured -- resuming normal operations
[Thu Apr 08 23:21:47 2010] [notice] Server built: Mar  4 2010 11:27:46
[Thu Apr 08 23:21:47 2010] [notice] Parent: Created child process 4048
httpd.exe: Could not reliably determine the server's fully qualified domain name, using 192.168.0.11 for ServerName
httpd.exe: Could not reliably determine the server's fully qualified domain name, using 192.168.0.11 for ServerName
[Thu Apr 08 23:21:47 2010] [notice] Child 4048: Child process is running
[Thu Apr 08 23:21:47 2010] [notice] Child 4048: Acquired the start mutex.
[Thu Apr 08 23:21:47 2010] [notice] Child 4048: Starting 64 worker threads.
[Thu Apr 08 23:21:47 2010] [notice] Child 4048: Starting thread to listen on port 80.
[Thu Apr 08 23:21:49 2010] [notice] Parent: Received shutdown signal -- Shutting down the server.
[Thu Apr 08 23:21:49 2010] [notice] Child 4048: Exit event signaled. Child process is ending.
[Thu Apr 08 23:21:50 2010] [notice] Child 4048: Released the start mutex
[Thu Apr 08 23:21:51 2010] [notice] Child 4048: All worker threads have exited.
[Thu Apr 08 23:21:51 2010] [notice] Child 4048: Child process is exiting
[Thu Apr 08 23:21:51 2010] [notice] Parent: Child process exited successfully.
httpd.exe: Could not reliably determine the server's fully qualified domain name, using 192.168.0.11 for ServerName
[Thu Apr 08 23:21:54 2010] [notice] Apache/2.2.15 (Win32) PHP/5.3.2 configured -- resuming normal operations
[Thu Apr 08 23:21:54 2010] [notice] Server built: Mar  4 2010 11:27:46
[Thu Apr 08 23:21:54 2010] [notice] Parent: Created child process 2504
httpd.exe: Could not reliably determine the server's fully qualified domain name, using 192.168.0.11 for ServerName
httpd.exe: Could not reliably determine the server's fully qualified domain name, using 192.168.0.11 for ServerName
[Thu Apr 08 23:21:54 2010] [notice] Child 2504: Child process is running
[Thu Apr 08 23:21:54 2010] [notice] Child 2504: Acquired the start mutex.
[Thu Apr 08 23:21:54 2010] [notice] Child 2504: Starting 64 worker threads.
[Thu Apr 08 23:21:54 2010] [notice] Child 2504: Starting thread to listen on port 80.
[Thu Apr 08 23:22:23 2010] [error] [client 127.0.0.1] PHP Warning:  phpinfo(): It is not safe to rely on the system's timezone settings. You are *required* to use the date.timezone setting or the date_default_timezone_set() function. In case you used any of those methods and you are still getting this warning, you most likely misspelled the timezone identifier. We selected 'Europe/Paris' for '2.0/DST' instead in E:\\sites\\monsite\\index.php on line 12
[Thu Apr 08 23:22:24 2010] [error] [client 127.0.0.1] File does not exist: E:/sites/monsite/favicon.ico
[Thu Apr 08 23:22:26 2010] [error] [client 127.0.0.1] File does not exist: E:/sites/monsite/favicon.ico
[Thu Apr 08 23:23:44 2010] [error] [client 127.0.0.1] PHP Warning:  phpinfo(): It is not safe to rely on the system's timezone settings. You are *required* to use the date.timezone setting or the date_default_timezone_set() function. In case you used any of those methods and you are still getting this warning, you most likely misspelled the timezone identifier. We selected 'Europe/Paris' for '2.0/DST' instead in E:\\sites\\monsite\\index.php on line 12

Merci de votre aide, je tourne en rond depuis 3 jours a toujours tout reinstaller et tout tester

[embargo]

sur Win 7, malgré la modif du fichier system HOSTS (retrait des #)

il fallait juste modifier la ligne du config.inc.php de PMA :

Code :

Sélectionner tout - Visualiser dans une fenêtre à part

$cfg['Servers'][$i]['host'] = 'localhost';

en

Code :

Sélectionner tout - Visualiser dans une fenêtre à part

$cfg['Servers'][$i]['host'] = '127.0.0.1';

vraiment, merci msft