Author |
|
DomX
Joined: 12 Jul 2008 Posts: 6
|
Posted: Sat 12 Jul '08 2:06 Post subject: Apache x64 on Vista64 - export with PHPMyAdmin -> restart |
|
|
Hi all,
I have working PHP Version 5.2.5 (x64) - fusionxlan, MySQL 5.0.51b (x64) and Apache 2.2.9 (x64) - blackdot.
When I want to export data from DB using PHPMyAmin the result is restart of Apache.
Any idea? Thanks!
PS: with MySQL front its working good. |
|
Back to top |
|
James Blond Moderator
Joined: 19 Jan 2006 Posts: 7371 Location: Germany, Next to Hamburg
|
Posted: Mon 28 Jul '08 16:13 Post subject: |
|
|
You may try PHP in fcgid. Than apache won't restart if PHP fails. |
|
Back to top |
|
DomX
Joined: 12 Jul 2008 Posts: 6
|
Posted: Tue 09 Sep '08 0:25 Post subject: |
|
|
James Blond wrote: | You may try PHP in fcgid. Than apache won't restart if PHP fails. |
Thank you,
I tried it, but now the Windows shows: Program CGI/FastCGI stopped working (something like that).
Therefore the export is successful.
Any idea to patch this? |
|
Back to top |
|
James Blond Moderator
Joined: 19 Jan 2006 Posts: 7371 Location: Germany, Next to Hamburg
|
Posted: Tue 09 Sep '08 12:19 Post subject: |
|
|
You you make a screenshot of that? What is in your windows event log about that?
You may also turn on the php error log to see more. |
|
Back to top |
|
DomX
Joined: 12 Jul 2008 Posts: 6
|
Posted: Thu 11 Sep '08 13:41 Post subject: |
|
|
OK, I made some screenshots and logs. Unfortunately I donĀ“t know, how to make PHP logs...
Apache as module logs & screens:
Acces.log
127.0.0.1 - - [11/Sep/2008:13:06:33 +0200] "GET /PHPMyAdmin/themes/original/img/s_fulltext.png HTTP/1.1" 200 308
127.0.0.1 - - [11/Sep/2008:13:06:32 +0200] "GET /PHPMyAdmin/sql.php?db=shop_lekarskeknihy_cz&token=0dfa39ebc6cf53849e5e118ea7d0040f&table=items&goto=tbl_structure.php HTTP/1.1" 200 130222
127.0.0.1 - - [11/Sep/2008:13:06:33 +0200] "GET /PHPMyAdmin/themes/original/img/b_views.png HTTP/1.1" 200 477
127.0.0.1 - - [11/Sep/2008:13:06:36 +0200] "GET /PHPMyAdmin/tbl_export.php?db=shop_lekarskeknihy_cz&table=items&token=0dfa39ebc6cf53849e5e118ea7d0040f&goto=tbl_sql.php&back=tbl_sql.php&single_table=true HTTP/1.1" 200 34024
error.log
[Thu Sep 11 13:05:55 2008] [notice] Digest: generating secret for digest authentication ...
[Thu Sep 11 13:05:55 2008] [notice] Digest: done
[Thu Sep 11 13:05:55 2008] [notice] Apache/2.2.9 (Win32) DAV/2 PHP/5.2.5 (x64) configured -- resuming normal operations
[Thu Sep 11 13:05:55 2008] [notice] Server built: Jun 18 2008 11:38:39
[Thu Sep 11 13:05:56 2008] [notice] Parent: Created child process 2380
[Thu Sep 11 13:05:57 2008] [notice] Digest: generating secret for digest authentication ...
[Thu Sep 11 13:05:57 2008] [notice] Digest: done
[Thu Sep 11 13:05:57 2008] [notice] Child 2380: Child process is running
[Thu Sep 11 13:05:58 2008] [notice] Child 2380: Acquired the start mutex.
[Thu Sep 11 13:05:58 2008] [notice] Child 2380: Starting 64 worker threads.
[Thu Sep 11 13:05:58 2008] [notice] Child 2380: Starting thread to listen on port 80.
[Thu Sep 11 13:07:03 2008] [notice] Parent: child process exited with status 255 -- Restarting.
[Thu Sep 11 13:07:03 2008] [notice] Digest: generating secret for digest authentication ...
[Thu Sep 11 13:07:03 2008] [notice] Digest: done
[Thu Sep 11 13:07:03 2008] [notice] Apache/2.2.9 (Win32) DAV/2 PHP/5.2.5 (x64) configured -- resuming normal operations
[Thu Sep 11 13:07:03 2008] [notice] Server built: Jun 18 2008 11:38:39
[Thu Sep 11 13:07:04 2008] [notice] Parent: Created child process 4544
[Thu Sep 11 13:07:05 2008] [notice] Digest: generating secret for digest authentication ...
[Thu Sep 11 13:07:05 2008] [notice] Digest: done
[Thu Sep 11 13:07:05 2008] [notice] Child 4544: Child process is running
[Thu Sep 11 13:07:05 2008] [notice] Child 4544: Acquired the start mutex.
[Thu Sep 11 13:07:05 2008] [notice] Child 4544: Starting 64 worker threads.
[Thu Sep 11 13:07:06 2008] [notice] Child 4544: Starting thread to listen on port 80.
Windows event log error:
- System
- Provider
[ Name] Application Error
- EventID 1000
[ Qualifiers] 0
Level 2
Task 100
Keywords 0x80000000000000
- TimeCreated
[ SystemTime] 2008-09-11T10:46:31.000Z
EventRecordID 6524
Channel Application
Computer HP-PC
Security
- EventData
httpd.exe
2.2.9.0
4858e602
ntdll.dll
6.0.6001.18000
4791adec
c0000374
00000000000a6e97
f64
01c913fb76588c04
Apache as CGI logs & screens:
Acces.log
127.0.0.1 - - [11/Sep/2008:13:15:24 +0200] "POST /PHPMyAdmin/export.php HTTP/1.1" 200 2297392
error.log
[Thu Sep 11 13:14:48 2008] [warn] Init: Session Cache is not configured [hint: SSLSessionCache]
[Thu Sep 11 13:14:49 2008] [notice] Digest: generating secret for digest authentication ...
[Thu Sep 11 13:14:49 2008] [notice] Digest: done
[Thu Sep 11 13:14:49 2008] [notice] Apache/2.2.9 (Win32) DAV/2 mod_ssl/2.2.9 OpenSSL/0.9.8h configured -- resuming normal operations
[Thu Sep 11 13:14:49 2008] [notice] Server built: Jun 18 2008 11:38:39
[Thu Sep 11 13:14:50 2008] [notice] Parent: Created child process 4324
[Thu Sep 11 13:14:50 2008] [warn] Init: Session Cache is not configured [hint: SSLSessionCache]
[Thu Sep 11 13:14:51 2008] [notice] Digest: generating secret for digest authentication ...
[Thu Sep 11 13:14:51 2008] [notice] Digest: done
[Thu Sep 11 13:14:51 2008] [notice] Child 4324: Child process is running
[Thu Sep 11 13:14:51 2008] [notice] Child 4324: Acquired the start mutex.
[Thu Sep 11 13:14:51 2008] [notice] Child 4324: Starting 64 worker threads.
[Thu Sep 11 13:14:52 2008] [notice] Child 4324: Starting thread to listen on port 80.
Windows event log error:
- System
- Provider
[ Name] Application Error
- EventID 1000
[ Qualifiers] 0
Level 2
Task 100
Keywords 0x80000000000000
- TimeCreated
[ SystemTime] 2008-09-11T11:15:32.000Z
EventRecordID 6527
Channel Application
Computer HP-PC
Security
- EventData
php-cgi.exe
5.2.5.5
473796eb
ntdll.dll
6.0.6001.18000
4791adec
c0000374
00000000000a6e97
11f8
01c913ffafa23574
|
|
Back to top |
|
DomX
Joined: 12 Jul 2008 Posts: 6
|
Posted: Tue 30 Dec '08 16:01 Post subject: Problem solved |
|
|
I just changed $cfg['Servers'][$i]['extension'] in phpMyAdmin cofig.inc.php from mysql to mysqli
Now export is working perfectly |
|
Back to top |
|
SquallATF
Joined: 19 Oct 2007 Posts: 11
|
|
Back to top |
|