Database Driven Sessions

[trlacey]

Hi there,

I'm using a Webserver that I've written under Windows XP Pro using PHP 5.0.3 and the PHP ISAPI Interface.

Everything seems to work great except certain people who use IE get "page cannot be displayed" errors quite frequently when attempting to change their Profile information.  Especially those on dialup, it seems.  This only happens in IE.  Netscape, et al. seem to function fine.

I disabled the "Use database driven sessions" option a few days ago and I've had reports that everything is working great now.  Any thoughts on why that might be?  If I receive anymore feedback regarding this issue I'll let you know in this Thread.

Also, is there an escape character that will disable one instance of BBC text in a Post?

[[Unknown]]

1.1 will have an "escape" sort of tag.  I think there may be a mod for this, currently.

As for the session problems, are you sure you're threading things properly?  That would be my only worry; that somehow the session close handler is not being called properly.

-[Unknown]

[trlacey]

Thanks Guys.

Yes.  It's entirely possible that I'm doing something wrong.  That's what I'm trying to determine at the moment.  If I am then I'd like to fix it ASAP.  If I'm not then I'd like to determine what the actual problem is.

Once I hand the Post off to the PHP ISAPI Extension, things are a little out of my hands though.  And shutting down a Thread isn't all that complicated.  But I may be missing something.

The problem doesn't seem to occur when I'm using Microsoft IIS instead of my own Webserver.  But it does seem a bit odd that none of the other Web Clients have the same problem.  It could be another Microsoft "feature" as well.  I'll keep testing.

If there is a mod for the BBC tag thing, can you point me to it?  I can't seem to find one in the Forum.

Thanks again.

Regards,

Terry

[[Unknown]]

Does your server run as SYSTEM, IUSR_COMPUTERNAME, or another account?

-[Unknown]

[trlacey]

Do you mean the IIS Server?  When I run it, I run it under IUSR_COMPUTERNAME, (the default), under my admin account.

When I run the webserver I wrote, I run it on the same computer in the admin account.  It's not subject to Web permissions.  The mySQL Server is running locally on the same computer under the same account.

Why?  Do you think there's something I need to be considering there?

[[Unknown]]

If there is a mod for the BBC tag thing, can you point me to it?  I can't seem to find one in the Forum.

http://www.simplemachines.org/community/index.php?topic=19485.0

When I run the webserver I wrote, I run it on the same computer in the admin account. It's not subject to Web permissions. The mySQL Server is running locally on the same computer under the same account.

Why? Do you think there's something I need to be considering there?

Well, I was poking.  If you had it running as SYSTEM (common for services, etc.) and IIS running as IUSR_COMPUTERNAME, there could have been something there.

Can you try turning on the query log (temporarily!):
http://dev.mysql.com/doc/mysql/en/query-log.html

When you do so, does it look like the page is going through properly and all the DELETE, INSERT, UPDATE, and similar commands are run?  If you're not sure which should be, can you post/link to said log (all I'd need is those queries that affect smf_sessions...)

Do you have mysql.trace_mode enabled, at all?

Does it take a long period of time for the error to come up, or is it immediate?

-[Unknown]

[trlacey]

Hi,

Thanks.  I just enabled the log and the "Database Driven Sessions" option running under my Webserver.  I'll let it log for 24 hours or so and make it available to you.

I don't know what trace_mode is and I can't find it in my.ini, but I can enable it of you'd like.

[[Unknown]]

I don't know what trace_mode is and I can't find it in my.ini, but I can enable it of you'd like.

No, no... enabling it is sorta bad, and I've seen it cause problems (like this one.)  By default it is disabled, so if you haven't heard of it (it is quite obscure) it's probably not the problem.

-[Unknown]

[trlacey]

Great.  I'll leave it.  The Escape Tag Mod works great.  Thanks.

[trlacey]

Does it take a long period of time for the error to come up, or is it immediate?

-[Unknown]

The error comes up immediately after the Post.

[trlacey]

Actually, what I'll try to do is catch a dialup client when they're online and start the logging then.

[trlacey]

No errors today.  Figures.  People only ******, and software only misbehaves when I'm not watching.  But the Forum was slow today due to the weekend.  Load may be a factor.  Or maybe I've changed something in my Webserver that's fixed the problem.  I'll keep the Database Sessions option enabled and let you know if the same thing happens again.

Thanks,

Terry

[[Unknown]]

Thanks for keeping me up to date on this.... hopefully it's gone, by some crazy luck .

And, indeed, things only go wrong when there's no one to fix them.  That's why people who sit around at job sites, bored out of their mind (like technical engineers, security guards, etc.) are so necessary.  They're preventive, even when it seems like that makes no sense .

-[Unknown]

[trlacey]

Well no errors have been reported, so I'm assuming this discussion has been a rather cathartic experience for my Forum. 

I'll Post back if anything happens later.  Thanks for the help.