| All Forums |
Register |
Login |
Search |
Subscriptions |
My Profile |
Inbox |
| Tool Warehouse |
FAQs |
Resources |
Help |
Member List |
Address Book |
Logout |
|
|
MySQL 5.0 troubles
|
Logged in as: Guest |
| Users viewing this topic: none |
|
Login  |
|
|
 MySQL 5.0 troubles - Jan. 13, '06, 10:13:52 AM
|
|
|
policyvote
Posts: 13
Joined: Jan. 11, '06,
Status: offline
|
Good morning all (well, it's morning here . . .)
As a quick intro, I just started a new job at a data warehousing services firm. As the "new guy" they've had me running around and fixing things. One of the things that needs to be fixed is MySQL 5.0.
Right now, we have a Win2K3 box at the customer site that is our interface with the warehouse. The Win2K3 is running Interix/SFU so our developers can use scripting tools to automate a lot of the annoying data cleanup/vaildation.
We have installed MySQL 5.0 (for Windows) on this box, but we are unable to run it from a remote prompt--we get the error message "(Unable to read --unknown error (error:9))". Going to the MySQL forums, I can see that I am not the only user with this problem. I'm attempting to determine if it's a MySQL problem or a SFU problem.
To that end, I am attempting to compile and install MySQL 5.0 source with SFU. I decided to install SFU 3.5 on my XP Pro laptop and try it, rather than mess with the server. I have set my environment flags as I should to use configure, and added "/noexecute=AlwaysOff" to my boot.ini. configure runs, but when I run make I get the following:
thr_alarm.c: In function 'end_thr_alarm':
thr_alarm.c:417: error: storage size of 'abstime' isn't known
*** Error code 1
Stop.
*** Error code 1
By searching, I see one other person had this problem (when complining Apache), but the only help he got was that he was using the wrong version of Apache. Any advice out there?
Peace
policy
|
|
|
|
|
RE: MySQL 5.0 troubles - Jan. 17, '06, 9:03:28 AM
|
|
|
policyvote
Posts: 13
Joined: Jan. 11, '06,
Status: offline
|
quote:
ORIGINAL: Rodney
I'll refer you to the FAQ page's developer section first (# 4.02).
Are these the setting that you are speaking of in your post?
They solve the vast majority of configure problems including thread building errors (which is
what you are quoting above).
Right, those are the settings I was talking about. I was having a devil of a time getting configure to run at all, but once I added those settings, configure reported that it ran successfully.
One thing that I've heard you say can cause problems is not changing the default home directory for a user, as that path contains spaces. I changed it under Computer Management, but SFU still defaults to the . . . uh, default. Am I barking up the wrong tree with that?
Peace
policy
PS--thanks for the thanks on the new job!
|
|
|
|
|
RE: MySQL 5.0 troubles - Jan. 17, '06, 3:29:09 PM
|
|
|
Rodney
Posts: 3714
Joined: Jul. 9, '02,
From: /Tools lab
Status: offline
|
> ... but SFU still defaults to the . . . uh, default.
You'd need to start a new shell or a new login for the environment
variables to change. The getpw*() call should all be fine. But that
shouldn't affect the running of configure. The home directory-thing
has it's big influence with running binaries (such as ssh).
If you do a "finger username" you'll see if the home
directory got set okay.
< Message edited by Rodney -- Feb. 8, '06, 12:22:46 PM >
|
|
|
|
|
RE: MySQL 5.0 troubles - Feb. 8, '06, 11:25:37 AM
|
|
|
policyvote
Posts: 13
Joined: Jan. 11, '06,
Status: offline
|
Just as an update, I was able to compile MySQL 5.0 as a client (--without-server). I can now connect remotely and talk to the Win32 server process! Excellent.
Peace
policy
|
|
|
|
 New Messages |
 No New Messages |
 Hot Topic w/ New Messages |
 Hot Topic w/o New Messages |
|
 Locked w/ New Messages |
 Locked w/o New Messages |
|
 Post New Thread
Reply to Message
Post New Poll
Submit Vote
Delete My Own Post
Delete My Own Thread
Rate Posts |
|
|
|
Printable Version
