[mr_sonicblue]

I'd like to hand MySQL for Public Beta out as a binary (no guarantees that it'll work). Does anyone want to test it?

The instructions for compiling it are lengthy

------------------
-Eric Schneider (SonicBlue)

[lonbaker]

I would love to test it. You can send it to me or place it on a web/ftp site and I will download it.

Lon

[rsanford]

I'd love to get my fingers on the binary. Instructions on how to compile it myself would be much apreciated as well. Please e-mail me. Thank you.

--
Ryan_S

[mr_sonicblue]

OK, here's the binary:

http://www.heatware.com/Files/mysql-...rwin1.2.tar.gz

Please DO NOT TRY THIS unless ALL of you important files are backed up. Although I can tell you I'm not trying to so so, I'm not responsible if this sends your computer into a flaming spiral of death. That said, here's how to use it:

- download the above file to /usr/local
- log into root
- use these commands to install it:
gunzip mysql-3.23.24-beta-powerpc-apple-darwin1.2.tar.gz
tar xvf mysql-3.23.24-beta-powerpc-apple-darwin1.2.tar.gz
rm mysql-3.23.24-beta-powerpc-apple-darwin1.2.tar.gz
- use these commands to run it:
cd /usr/local/mysql
./bin/safe_mysqld

That should start it up just fine. BUT, On my computer I am unable to get the daemon to shutdown (with 'mysqladmin shutdown' or force quitting with the process app) but things like 'mysqladmin reload' work fine.

The only testing I've done is setting up permissions and creating databases as root with 'mysql' and creating tables and inserting data as a normal user with both 'mysql' and a PHP4 interface running from local Apache so don't be surprised if anything else causes the daemon to crash.

I --> DID <-- get compile errors when 'make; make install'ing the binary, but I used the ignore (-i) switch to bypass them.

Good luck!

------------------
-Eric Schneider (SonicBlue)

[lonbaker]

thanks. Have you passed the configuration information to the Mysql.com gang? We should be communicating the information to them so they will handle future Darwin vs. OSX compiles.

[sordid]

You are my new hero dude

I've been able to compile PHP, Apache and MySQL to work really well together, except for not being able to shutdown mysql (but who cares).

I was wondering if you tried the fixes for the source when you were compiling, found on AK's site at http://www.prnet.de/RegEx/mysql.html

I also note that versiontracker released the new version of mysql for osx today, but I don't know if thats the Beta compatible version, or just the OS X server version.

[mr_sonicblue]

I checked the the new mysql earlier, and it's compiled for rhapsody5.5 like the last Mac OS X Server binary so I don't believe it'd work either.

Yes, I did try those patches, but they did not work. They were designed for Mac OS X Server WAY back when there were no binaries for it (version 3.22.21).

The method I used is one listed in the omnigroup.com mailing group. It was a patch to fix a few things with the make process that I could not get to work, so I did the patches by hand.

I did some more testing with a website of mine that uses complicated queries (with internal aliasing, string functions, etc) and it hasn't crashed yet

------------------
-Eric Schneider (SonicBlue)

[sordid]

AK has some newer fixes on that page that just came out yesterday, I don't think you have seen it, it says compiling on OS X Public Beta, I tried it, but It crashed out towards the end.

I've only found 1 bug sofar in your binary, and that is that MySQL will let me drop a database, but wont rmdir the databases's directory. But that can be simply removed at the command line, atleast untill someone does a proper binary port of it

[lonbaker]

I got your binary running but "INSERTS" using mysql keep failing with a "lost connection during query" error.

[sordid]

AK has some newer fixes on that page that just came out yesterday, I don't think you have seen it, it says compiling on OS X Public Beta, I tried it, but It crashed out towards the end.

I've only found 1 bug sofar in your binary, and that is that MySQL will let me drop a database, but wont rmdir the databases's directory. But that can be simply removed at the command line, atleast untill someone does a proper binary port of it

[rsanford]

I followed the new instructions at http://www.prnet.de/RegEx/mysql.html and successfully compiled my own install of mysql. I then added the line "/usr/local/bin/safe_mysqld &" to my /etc/rc.common file so it starts up automatically if I ever have to reboot. So far I've created one db with two tables and two additional users without indcident.

Now to switch my efforts back to getting an apache dso php4 module to compile...

I would also love to be able to test MySQL on OS X.


QUOTE]Originally posted by mr_sonicblue:
I'd like to hand MySQL for Public Beta out as a binary (no guarantees that it'll work). Does anyone want to test it?

The instructions for compiling it are lengthy

[/QUOTE]

[sordid]

rsanford: i found that compiling apache and php together (as per the instructions at php.net for UNIX installation) worked fine for getting PHP4 and Apache to work together.

[QUOTE]Originally posted by mr_sonicblue:
[B]OK, here's the binary:

http://www.heatware.com/Files/mysql-...rwin1.2.tar.gz

I tried your binary. At first I was enthusiastic, as it seemed to work very well, but then I stumbled on a few problems.

It looks as if the program has some problems when dealing with files -- on my box, at least. Here are three different, reproducible mishaps.

If I can be of any help in pinpointing the problem, I'll be glad to do it. On the othe rhand, I'll be grateful for any help in solving the problems if it turns out to be exclusively mine.

L.A.

---

mysql> load data infile '/usr/local/sar-el/languages.txt' into table languages;
ERROR 2013: Lost connection to MySQL server during query
700101 03:05:40 mysqld restarted

---

mysql> load data infile '/usr/local/apache/htdocs/sar-el/languages.txt' into table languages;
ERROR 2006: MySQL server has gone away
No connection. Trying to reconnect...
Connection id: 1
Current database: sarel
ERROR 2013: Lost connection to MySQL server during query
700101 03:05:53 mysqld restarted

---

mysql> drop database sarel;
ERROR 1010: Error dropping database (can't rmdir './sarel/', errno: 21)

[mr_sonicblue]

misterakko:

MySQL commonly "goes away" (as the client puts it) before or during queries, but it should automatically reconnect if it's working correctly. But, for some reason, my binary seems to have trouble doing so. The only thing I can recommend is, when such an error occurs, repeat the query.

About the 3rd error: something that deals with removing the database directory was either not made, made incorrectly, or configured incorrectly. Here's how to remove a database manually:

cd /usr/local/mysql/var
rm -rf [name of database]

------------------
-Eric Schneider (SonicBlue)

[LordJavac]

I am wondering how you got the configure script to run. It always dies on the 'ps' portion (where it's trying to figure out how to detect running mysqld). Thanks in advance.

[Richard5mith]

The binary seems to work fine, unlike all the other versions I've seen for compile (I can't get AK's version to work because pthreads just refuses to compile).

Some of the problems mentioned here might be down to the files needing to be owned by mysql.mysql - which means an extra user on the system. That's certainly the case under Linux anyway (where my mySQL usage is normally done).

My problem under OS X is I can't get it to connect to Perl. Data Dumper and DBI appear to compile and install fine with no errors, but the msql-mysql modules just error out on the "perl Makefile.PL" stage with not being able to find "Data/ShowTable.pm".

Anybody got any experience with this?

[mr_sonicblue]

LordJavac:
If I remember right, here's what I did for the binary listed here (The version I'm currently using has a more complicated patch, but doesn't work any better):

config.guess:
- Copy Rhapsody's detection section, and make one for Darwin (simply change "Rhapsody" to "Darwin")

config.sub:
- add "-darwin*" to the list of GNU OS's (where Rhapsody is listed)

configure:
- remove the error message about the ps switches (in the else block of the section) and replace it with the code in the elif block labelled "BSD Style".

Those are the simple fixes I made to make it configure correctly. But, this is not enough to make it compile correctly (because of the pthread stuff).

Richard5mith:
I use MySQL with PHP, so I don't know what's causeing your problems.

------------------
-Eric Schneider (SonicBlue)

[This message has been edited by mr_sonicblue (edited 10-08-2000).]

[QuatermassX]

I'm trying to run a query through a .php file. I can connect to the DB, I can choose the DB, but I cannot query a table -- I just get an error when I query the table, no data, nothing.

I can query the table using the Terminal, however.


<?php
# PHP CODE BEGINS HERE =======================================
if(!$chapter){ $chapter = 1; }
if(!$sect) {$sect = 1;}

$conn = mysql_connect(localhost,"","")
or die ("Unable to Connect to Sql Server");

mysql_select_db("pdf",$conn);


$table = mysql_query("select id from que;")

or die ("Unable to Get Records from server");

if(mysql_affected_rows($conn)){
while($rec = mysql_fetch_row($table)){
echo $rec[0];
} #end while
}else{
echo "Nothing Was Found Here";
}# end if
mysql_close($conn);


# PHP CODE ENDS HERE =========================================
?>


Any suggestions? Thanks!!

> $table = mysql_query("select id from que;")
>
> Any suggestions? Thanks!!

Maybe that's a typo, but you don't need the ending semicolon in your query from php (although of course you would from mysqlmonitor.) My apologies if the problem is more complex than that.

[mr_sonicblue]

jmb is right, that *might* be a typo. Other than that, I can't spot anything wrong with your code.

Did you try the same query from the mysql client?

If that works, you might have to wait for a stable binary release.

------------------
-Eric Schneider (SonicBlue)