Page 3 of 13
Posted: Wed Mar 20, 2013 2:52 pm
by Nissan_Ranger
Geez, Al, that was some story. It's totally greek to me but was fascinating to read. I'm proud of myself when I can get my wireless modem configured without it ending up at the receiving end of a rifle range...
What all is it you do with this set-up? Is there some small re-compensation involved??
Andy
Posted: Wed Mar 20, 2013 4:23 pm
by asavage
We stayed on DSL for less than a day -- it was awful.
Even power-cycling the modem didn't help. I could ping Google but couldn't bring up a Google page!
We're now switched back to Wave cable.
The individual DSL lines are carrying asymmetrical speeds: line one is about 6Mb/s, and line 2 is only 3Mb/s. If they could get that second line up to speed, and fix the throughput problem, I'd stay with DSL. If Wave could get their line to stay up for whole days at a time, I'd stay with them.
At this point, neither of them are really any good.
No, I get NO financial recompense for any of this, except the occasional donation. It used to be my hobby; now, it's more annoying than not, but I'll keep it going as long as it's reasonably feasible.
Posted: Wed Mar 20, 2013 5:58 pm
by dn29626
Al, we appreaciate you.
Posted: Thu Apr 18, 2013 8:52 am
by asavage
The MySQL (database) server module has blown up twice in the past five days, throwing a breakpoint exception SYS3173. This is not really something I can fix with a restarter script. As it's a module built in 2007 (v4.1.7), there's no support for fixing it. I'm looking into replacing it with a modern MySQL module port (v5.1.68 ).
I am told that the Apache MySQL client of that vintage *should* be able to interoperate with the newer server module. I sure hope it gets along with the old PHP.
In practical terms, I'm installing the newer server module on another box, and if it looks as if it runs OK, I'll move it to the production box. We shall see.
Posted: Thu Apr 18, 2013 9:35 am
by plenzen
Thanks for keeping us alive Al
Posted: Thu Apr 18, 2013 12:56 pm
by Nissan_Ranger
MySQL is a military acronym for 'My Square Lever'...
Posted: Thu Apr 18, 2013 6:28 pm
by asavage
I realize that most of you will not see this until *after*, but . . .
I've been playing with the newer MySQL server module on a test box all day, and other than having to rename one database (one of my databases' names contains a hypen, which is outlawed since about 2008 or so), and a couple other lightweight foibles, it was refreshingly easy to make work . . . all by itself, anyway. I still don't know how it will interact with PHP and Apache.
I'm going to spoil all this by trying to copy the install to the production server sometime soon. Expect downtime. I'm not going to do anything non-reversible, but reboots of the prod servers are ~15 minutes, if reboots are needed.
[The new server -- the one that's supposed to replace the old prod server -- with five times the storage reboots in under four minutes -- not a big deal, if I never reboot, and in normal circumstances, I never do. But lately, I've been having to reboot more and more often. The damn thing's dying, as do all things.]
Posted: Thu Apr 18, 2013 7:18 pm
by asavage
OK . . . we are running on the new MySQL server module. Report errors if you find any.
Posted: Thu Apr 18, 2013 8:05 pm
by asavage
Knock on wood -- the Wave cable broadband has been pretty much trouble-free for two weeks, the best run I've had since the initial 4-week honeymoon.
I've just updated the various scripts that revolve around the MySQL server module, so the backups happen from the correct place, and the correct client is invoked when I have to open a console. So far, it looks OK.
Posted: Sat Apr 20, 2013 7:47 am
by plenzen
S F S G from what I have been looking at.
Posted: Sat Apr 20, 2013 8:04 am
by asavage
The server trapped (for a different reason) the first night, but all seems well in yesterday's re-jigger testing, and backups are happening OK. I'm calling it good.
Posted: Sat Apr 20, 2013 8:08 am
by plenzen
The "Re-jiggler" test.
Is that an official technical term or a Savage euphemism.
Posted: Sat Apr 20, 2013 4:40 pm
by dn29626
I enjoy reading this blog more than some of the (other) posts.
Posted: Mon Apr 22, 2013 5:53 am
by asavage
I've caught the MySQL module silently dying in the night twice now. I could make excuses for the first time, but not last night's. I will work on it more today.
Posted: Tue Apr 23, 2013 7:23 am
by asavage
Search for terms isn't working; I'm rebuilding the Search tables again. That takes 35 to 65 minutes.
I've created three bug reports for the MySQL server module:
http://mantis.smedley.id.au/view.php?id=569
http://mantis.smedley.id.au/view.php?id=571
http://mantis.smedley.id.au/view.php?id=572
Though I don't know if these are problems that Paul can help with.
I may try an older version to see if this is a regression problem.