Mint/Mac OS X 10.6 Server/MySQL not working // Troubleshooting // Forum // Mint: A Fresh Look at your Site

Older | Newer

Mint/Mac OS X 10.6 Server/MySQL not working

Chris Anderson
Minted
Posted on Oct 21, '09 at 04:26 pm

Trying to re-setup Mint on a recently upgraded 10.6 Snow Leopard Server. Everything was working great on 10.5 Leopard. Now, I can log in to Mint but it isn’t tracking any new data - hits, searches, everything.

Running the compatibility test gives me the following error for mysql -

“MySQL mysqlnd 5.0.5-dev - 081106 - $Revision: 1.3.2.27 $ is not compatible with Mint. MySQL 3.23 or higher is required.”

Snow Leopard comes with MySQL 5 already installed, but Mint does not seem to be recognizing it. Any suggestions?

Shaun Inman
Mint/Pepper Developer
Posted on Oct 21, '09 at 05:00 pm

How does your server fare with the updated SCS? (There’s a bug in PHP’s version_compare(), it can’t handle the complex string returned by your mysql_get_client_info().)

Your server is dropping the connection for the Mint JavaScript. You will have to check your PHP logs as to why that’s happening.

Chris Anderson
Minted
Posted on Oct 21, '09 at 05:54 pm

Latest SCS says:

PHP 5.3.0 is compatible with Mint.

×MySQL mysqlnd 5.0.5-dev - 081106 - $Revision: 1.3.2.27 $ is not compatible with Mint. MySQL 3.23 or higher is required.

Will try taking a look into the PHP logs - not exactly sure where they are on a Mac server, but will try to dig them up.

Chris Anderson
Minted
Posted on Oct 21, '09 at 06:10 pm

Browsing to one of my pages with Mint enabled does show

“GET /mint/?js HTTP/1.1” 200 26”

in the Apache logs, so it appears that the Javascript is loading - or were you talking about a different log?

Chris Anderson
Minted
Posted on Oct 21, '09 at 06:24 pm

I also get this error when I try to visit /mint/?errors/

[Wed Oct 21 18:20:28 2009] [error] [client 10.0.1.10] PHP Deprecated: Assigning the return value of new by reference is deprecated in /Volumes/Share/web/mint/app/lib/mint.php on line 3400

Only happens when going to/mint/?errors, and the page itself just displays the normal Mint screen.

Chris Anderson
Minted
Posted on Oct 21, '09 at 06:32 pm

Yeah it’s acting real weird. Tried unchecking the box to count my own visits, and the preference didn’t save. Tried logging out and the site just starting flashing ?! like it was in a constant loop. Tried again and it seemed to keep doing that. Will trying reinstalling Mint but this was already a fresh install so suffice it to say I’m very confused!

Shaun Inman
Mint/Pepper Developer
Posted on Oct 23, '09 at 03:51 pm

I’m seeing a 404 for your Mint installation now. If you had visited yourdomain.com/mint/?js in a browser before it went 404 you would have seen that the server was dropping the connection (despite what the logs said).

The deprecated warning you see when using ?errors only applies to Mint with the ?errors query command (the code causing that warning is only used by debug code).

You need to figure out a way to get your server to display PHP errors rather than just dropping the connection before I can begin to diagnose this problem.

joeldavies
Minted
Posted on Oct 27, '09 at 02:27 pm

I’m having the same problem with two sites on a snow leopard server.

If someone could point me in the direction of PHP logs in OS X server, I’m happy to spend some time trying to figure this one out

Shaun Inman
Mint/Pepper Developer
Posted on Oct 28, '09 at 09:41 am

It looks like Snow Leopard ships with PHP 5.3 in which the mysql_close() function is horribly broken. If you are experiencing this problem open up /mint/app/paths/record/index.php and comment out the mysql_close() function call. (This function is not usually required and included only for thoroughness. Commenting it out shouldn’t have a negative affect on Mint or server performance.)

Older | Newer

You must be logged in to reply. Login above or create an account

Mint Forum

Mint/Mac OS X 10.6 Server/MySQL not working