Fingers getting rubbed raw...
Jul. 23rd, 2000 02:01 pm![[personal profile]](https://www.dreamwidth.org/img/silk/identity/user.png)
Dropped e-mail at the developer of the program, but his reply throws no light on my problem. I have a feeling that perhaps my problem lies with the build of OpenSSL, since the linker appears to find the libcrypto.a library without problem...it's just that the appropriate reference doesn't show up. I'm recalling something about ELF systems and position-independent code in the dark recesses of my memory, but it's not quite surfacing.
The compile of MySQL died sometime during the night. The last error message says something about running out of virtual memory. I retry the make and get the same error. I am not enthusiastic about trying to track down the cause of the error. This leads me to rethink the recommended approach to getting MySQL on kerouac, which is to install a binary.
I download the MySQL-3.22.32-1.i386 binary from www.mysql.com and install the rpm. Upon completing the install, I get the message:
PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER !
This is done with:
/usr/bin/mysqladmin -u root password 'new-password'
See the manual for more instructions.
There is no `mysqladmin' anywhere on my machine. I go RTFM.
Aha. It appears that `mysqladmin' is a MySQL client program, so it's back to www.mysql.com to download the client binaries. Again with the rpm invocation to install the client apps. Then try the suggested command line (with something more esoteric than `new-password'). Works.
Now run `mysql_install_db' to create an initial database. Works.
Okay. Let's see if the MySQL server is working. Enter:
mysqladmin version
It says I can't do it. Aha! I need a `-p' so it asks me my password... Better yet...as I'm the only user for now...go back and change my password to nothing at all. Now the version shows up just peachy.
So, I now have a server with Apache, PHP3, and MySQL up and running. I've run the PHP3 version of `Hello, world!' and it works. But life is calling me, and there's some stuff to do around the house. Later...
Cheers...
P.S. Tiger Woods nailed the British Open about an hour ago with an overall score of -19, something like 8 shots ahead of everyone else. I find it quite enjoyable to watch someone like Woods do his thing. He is very goal-driven and works hard; one of the color commentators noted that he has a video library of major golf tournaments going back many years, and that he studies the footage in order to learn how other players handled various holes and to learn the courses. Woods' victory puts him in some pretty rarefied company, as only the fifth person to win a 'grand slam' of championships. At 24, though, he's probably only "playing through."
The compile of MySQL died sometime during the night. The last error message says something about running out of virtual memory. I retry the make and get the same error. I am not enthusiastic about trying to track down the cause of the error. This leads me to rethink the recommended approach to getting MySQL on kerouac, which is to install a binary.
I download the MySQL-3.22.32-1.i386 binary from www.mysql.com and install the rpm. Upon completing the install, I get the message:
PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER !
This is done with:
/usr/bin/mysqladmin -u root password 'new-password'
See the manual for more instructions.
There is no `mysqladmin' anywhere on my machine. I go RTFM.
Aha. It appears that `mysqladmin' is a MySQL client program, so it's back to www.mysql.com to download the client binaries. Again with the rpm invocation to install the client apps. Then try the suggested command line (with something more esoteric than `new-password'). Works.
Now run `mysql_install_db' to create an initial database. Works.
Okay. Let's see if the MySQL server is working. Enter:
mysqladmin version
It says I can't do it. Aha! I need a `-p' so it asks me my password... Better yet...as I'm the only user for now...go back and change my password to nothing at all. Now the version shows up just peachy.
So, I now have a server with Apache, PHP3, and MySQL up and running. I've run the PHP3 version of `Hello, world!' and it works. But life is calling me, and there's some stuff to do around the house. Later...
Cheers...
P.S. Tiger Woods nailed the British Open about an hour ago with an overall score of -19, something like 8 shots ahead of everyone else. I find it quite enjoyable to watch someone like Woods do his thing. He is very goal-driven and works hard; one of the color commentators noted that he has a video library of major golf tournaments going back many years, and that he studies the footage in order to learn how other players handled various holes and to learn the courses. Woods' victory puts him in some pretty rarefied company, as only the fifth person to win a 'grand slam' of championships. At 24, though, he's probably only "playing through."