I was using MySQL 4.1 for Mac OS X (Intel), the prebuilt installer  
from MySQL's web site, and MySQLdb 1.2.1c7.  The compatibility isn't  
as scary as it sounds.

And oddly enough, I have just rebuilt MySQLdb yet again (doing  
nothing different, as far as I can tell) and it seems to be working  
with ActivePython 2.4 now.

I ought to try and recreate the non-working version (I didn't have  
any problems creating a non-working version before, and I'm a bit  
afraid to try and actively break things now), but the main things I  
can point to are:

* the MySQL install doesn't add /usr/local/mysql/bin to the PATH,  
which can cause issues for other things expecting MySQL to be there
* ActivePython's install doesn't add /usr/local/bin to the PATH, and  
if it's not in your PATH before /usr/bin, then things looking for the  
default install of Python get confused

although neither of these things explain the error message, which  
indicates that _mysql.so is in the right place, and that the right  
version of Python is being used.





On 11/03/2006, at 11:13 AM, Trent Mick wrote:

> 
>  [Brett Powley wrote]
> > ...
> > ImportError: Failure linking new module: /Library/Frameworks/
> > Python.framework/Versions/2.4/lib/python2.4/site-packages/_mysql.so:
> > Symbol not found: _mysql_get_host_info
> > Referenced from: /Library/Frameworks/Python.framework/Versions/2.4/
> > lib/python2.4/site-packages/_mysql.so
> > Expected in: dynamic lookup
> > ...
> 
>  Well aren't MySQLdb's instructions for MySQL version compat just  
>  fun. :)
> 
>      + MySQL 3.23.32 or higher
>        * http://www.mysql.com/downloads/
>        * Versions lower than 3.22 definitely WON'T WORK.
>        * Versions lower than 3.22.19 might not work.
>        * MySQL-3.22 is deprecated in favor of 3.23, but still  
>  supported.
>        * MySQL-3.23 is supported, but slightly deprecated.
>        * MySQL-4.0 is supported.
>        * MySQL-4.1 is mostly supported; the new prepared statements API
>          is not yet supported, and probably won't be until  
>  MySQLdb-1.3 or 2.0.
>        * MySQL-5.0 and newer are not currently supported, but might  
>  work.
> 
>  Brett,
>  Which version of MySQL are you building against? Did you build  
>  MySQL yourself
>  or get a prebuild from somewhere? If so where? Fink? Darwin Ports?  
>  mysql.com?
>  other?
> 
>  Cheers,
>  Trent
> 
>  -- 
>  Trent Mick
>  TrentM@[...].com
> 

_______________________________________________
ActivePython mailing list
ActivePython@[...].com
To unsubscribe: http://listserv.ActiveState.com/mailman/mysubs
Other options: http://listserv.ActiveState.com/mailman/listinfo/ActivePython