Greets, I've been here and there, trying like mad to get a persistent connection to an SQL database the past few days, rather than connecting at will, and I've ALMOST got it. However, there's a few problems with it.
The code I've been using is stuff that was contributed to the list a while back this year, and it works GREAT, except for the fact that every time the mysql table is written to, it crashes the mud. It WRITES to the table just perfectly (I've got a front end that I use to go through entries every once in a while, so I can check that rather easily), but it's crashing the mud. Reading of the table is handled just wonderfully actually, no crashes whatsoever. The problem is writing to it, like something is still locked? Or it's trying to reload something yet failing or (?) I'm clueless here. To me, it would appear that this is a signal issue, yet another wonderful Redhat problem (if that's the case), as I've had problems with signals and RH in the past, but I'm not sure. I've gone through, tried removing the signal stuff, it still does the same thing (crashes the mud), have tried a couple of various things, and it's still doing it. I've enclosed the code I'm using (not something I wrote mind you, just modified it a li'l), in case someone can see something I'm missing here. I've poured through logs, no core dump, nada. Thoughts, ideas? +----------------------------------------------------+ + TJW: Head Tech, designer: Dreamless Realms Mud + + Mud : http://drealms.kyndig.com + + Telnet: drealms.kyndig.com port 9275 + + OLC Docs: http://olc.kyndig.com + +----------------------------------------------------+
sql_connect.c
Description: Binary data
