XAMPP/APACHE/MYSQL/PHP HANGING IN PHP PROGRAMS

[iskeen]

HI,

I'm running pc with Vista and Apache (xampp) as well as mysql. When I go into the control panel and run queries in my database, I have no problems. However, when my php programs run, they seem to encounter some kind of "clogging." When I first restart the computer, I can get to my main page very easily and it displays correctly. Then I go to a page requiring a login, and that is okay, too. Then I can even update the database through my php pages -- so far so good. Then if I log out and try to go into another part of the site, it hangs and I get a progress bar that doesn't move. Meanwhile, I can go to the database using the xampp control panel and everything appears to be working fine. Eventually, the system gets so clogged, that I can't even open the start page. So, in a word, things work and then slow down and then stop working.

I thought maybe this problem was a result of security software which was recently reinstalled when I had a software crash and all everything had to be reinstalled. I turned off all of the security, but it didn't help. I put the names and ports in the services so that they would be allowed, but that didn't seem to help either.

When the screen goes blank or gets hung up, is there any facility I can turn on in order to figure out where the system is getting hung? Any ideas on this would be greatly appreciated.

Here is some technical info copied from my xampp admin:
Apache/2.2.12 (Win32) DAV/2 mod_ssl/2.2.12 OpenSSL/0.9.8k mod_autoindex_color PHP/5.3.0 mod_perl/2.0.4 Perl/v5.10.0
MySQL client version: mysqlnd 5.0.5-dev - 081106 - $Revision: 1.3.2.27 $
PHP extension: mysqli.

One other thought -- in my latest programming I was making extensive use of $_SESSION -- could that cause these problems? Thanks.

PS: An update on this last (SESSION) -- I restarted the computer and used only the pages which have not been changed by the recent programming effort. These pages hung up in exactly the same clogging way -- so it is not the SESSION variable. When I went to my website to test the same facility, it works perfectly (sigh of relief!).

All security I can find has been disabled. Any suggestions on this would be very greatly appreciated. Thanks, Ilene

I have more information on this problem now -- it looks to me like a program I didn't have before and am not using in mysql implementation for some reason thinks it has to run. Here is the error log:

091224 4:27:09 [Note] Plugin 'FEDERATED' is disabled.
091224 04:27:10 [Note] PrimeBase XT (PBXT) Engine 1.0.08 RC loaded...
091224 04:27:10 [Note] Paul McCullagh, PrimeBase Technologies GmbH, http://www.primebase.org
091224 4:27:11 InnoDB: Started; log sequence number 0 1898733
091224 04:27:12 [Note] PBXT: Recovering from 1-43, bytes to read: 33554389
091224 04:27:12 [Note] PBXT: 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
091224 04:27:13 [Note] PBXT: 26 27 28 29 30 091224 4:27:14 [Note] Event Scheduler: Loaded 0 events
091224 4:27:14 [Note] C:\xampp\mysql\bin\mysqld.exe: ready for connections.
Version: '5.1.37' socket: '' port: 3306 Source distribution
31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50
091224 04:27:14 [Note] PBXT: 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
091224 04:27:15 [Note] PBXT: 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
091224 04:27:17 [Note] PBXT: Recovering complete at 1-43, bytes read: 33554389

Looks like I need to reinstall the Apache package and remove pxbt. Any confirmation of this would be greatly appreciated.

[iskeen]

Well, I see that plenty of people have looked at my post, but no one has offered any ideas. I am still having problems. It appears to me that it has to do with the facility that is getting filled up and not cleaning itself out properly. I followed instructions that I found about wben to delete the repository files. When I stopped the service and deleted the files and then restarted (twice), the system worked quickly as it used to -- for a very short time. And then it got hung again.

I have two leads: It could be apache is in conflict with IIs because I am getting error messages about that. I am also getting error message about wmis (that's why I tried deleting the repository files. The error message which occurs most often is:

- <Event xmlns="http://schemas.microsoft.com/win/2004/08/events/event">
- <System>
<Provider Name="Service Control Manager" Guid="{555908D1-A6D7-4695-8E1E-26931D2012F4}" EventSourceName="Service Control Manager" />
<EventID Qualifiers="49152">7000</EventID>
<Version>0</Version>
<Level>2</Level>
<Task>0</Task>
<Opcode>0</Opcode>
<Keywords>0x80000000000000</Keywords>
<TimeCreated SystemTime="2009-12-30T01:02:03.000Z" />
<EventRecordID>80855</EventRecordID>
<Correlation />
<Execution ProcessID="0" ThreadID="0" />
<Channel>System</Channel>
<Computer>BigPayDay</Computer>
<Security />
</System>
- <EventData>
<Data Name="param1">BCM42RLY</Data>
<Data Name="param2">%%2</Data>
</EventData>
</Event>

The other error message which seems germane is this one:

- <Event xmlns="http://schemas.microsoft.com/win/2004/08/events/event">
- <System>
<Provider Name="Microsoft-Windows-WMI" Guid="{1edeee53-0afe-4609-b846-d8c0b2075b1f}" EventSourceName="WinMgmt" />
<EventID Qualifiers="49152">10</EventID>
<Version>0</Version>
<Level>2</Level>
<Task>0</Task>
<Opcode>0</Opcode>
<Keywords>0x80000000000000</Keywords>
<TimeCreated SystemTime="2009-12-29T21:26:10.000Z" />
<EventRecordID>3429</EventRecordID>
<Correlation />
<Execution ProcessID="0" ThreadID="0" />
<Channel>Application</Channel>
<Computer>BigPayDay</Computer>
<Security />
</System>
- <EventData>
<Data>//./root/CIMV2</Data>
<Data>SELECT * FROM __InstanceModificationEvent WITHIN 60 WHERE TargetInstance ISA "Win32_Processor" AND TargetInstance.LoadPercentage > 99</Data>
<Data>0x80041003</Data>
</EventData>
</Event>

One final thought -- the part of my site which seems to be most affected on the testing server is the members directory with a password on it. Could there be some recent upgrade to windows which now conflicts with the way apache handles secure pages. MySql seems to be working fine when I go into it directly. I use the same passwords and permissions to get to my databases on both the localhost and the remote. Mysql is not generating messages on this -- if it is as mysql failure, is there a way I can find this out? When I run my queries directly in mysql, they work fine.

When I installed apache, I used the package and the easy install -- straightforward and no changes. If there is someone who has a glimmer of hope for me, I would really appreciate hearing from you.

Help!