<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=us-ascii">
<META NAME="Generator" CONTENT="MS Exchange Server version 6.5.7036.0">
<TITLE>MySQLdb compile error with AMD64</TITLE>
</HEAD>
<BODY>
<!-- Converted from text/rtf format -->
<BR>
<P ALIGN=LEFT><SPAN LANG="en-us"><FONT SIZE=2 FACE="Courier New">></FONT></SPAN><SPAN LANG="en-us"><FONT SIZE=2 FACE="Courier New">></FONT></SPAN><SPAN LANG="en-us"><I><FONT SIZE=2 FACE="Courier New"> Can anyone offer any assistance on this one?</FONT></I></SPAN></P>
<P ALIGN=LEFT><SPAN LANG="en-us"><FONT SIZE=2 FACE="Courier New">></FONT></SPAN><SPAN LANG="en-us"></SPAN></P>
<P ALIGN=LEFT><SPAN LANG="en-us"><FONT SIZE=2 FACE="Courier New">></FONT></SPAN><SPAN LANG="en-us"><FONT SIZE=2 FACE="Courier New">Look here:</FONT></SPAN></P>
<P ALIGN=LEFT><SPAN LANG="en-us"><FONT SIZE=2 FACE="Courier New">></FONT></SPAN><SPAN LANG="en-us"></SPAN></P>
<P ALIGN=LEFT><SPAN LANG="en-us"><FONT SIZE=2 FACE="Courier New">></FONT></SPAN><SPAN LANG="en-us"><FONT SIZE=2 FACE="Courier New">>></FONT></SPAN><SPAN LANG="en-us"><I><FONT SIZE=2 FACE="Courier New"> gcc -pthread -fno-strict-aliasing -DNDEBUG -O2 -fmessage-length=0 -Wall</FONT></I></SPAN></P>
<P ALIGN=LEFT><SPAN LANG="en-us"><FONT SIZE=2 FACE="Courier New">></FONT></SPAN><SPAN LANG="en-us"><FONT SIZE=2 FACE="Courier New">>></FONT></SPAN><SPAN LANG="en-us"><I><FONT SIZE=2 FACE="Courier New"> -D_FORTIFY_SOURCE=2 -g -fPIC -I/usr/include/mysql</FONT></I></SPAN></P>
<P ALIGN=LEFT><SPAN LANG="en-us"><FONT SIZE=2 FACE="Courier New">></FONT></SPAN><SPAN LANG="en-us"><FONT SIZE=2 FACE="Courier New">>></FONT></SPAN><SPAN LANG="en-us"><I><FONT SIZE=2 FACE="Courier New"> -I/usr/include/python2.4 -c _mysql.c -o</FONT></I></SPAN></P>
<P ALIGN=LEFT><SPAN LANG="en-us"><FONT SIZE=2 FACE="Courier New">></FONT></SPAN><SPAN LANG="en-us"><FONT SIZE=2 FACE="Courier New">>></FONT></SPAN><SPAN LANG="en-us"><I><FONT SIZE=2 FACE="Courier New"> build/temp.linux-x86_64-2.4/_mysql.o -I/usr/include/mysql -g</FONT></I></SPAN></P>
<P ALIGN=LEFT><SPAN LANG="en-us"><FONT SIZE=2 FACE="Courier New">></FONT></SPAN><SPAN LANG="en-us"><FONT SIZE=2 FACE="Courier New">>></FONT></SPAN><SPAN LANG="en-us"><I><FONT SIZE=2 FACE="Courier New"> -march=i586 -mcpu=i686 -fmessage-length=0</FONT></I></SPAN></P>
<P ALIGN=LEFT><SPAN LANG="en-us"><FONT SIZE=2 FACE="Courier New">></FONT></SPAN><SPAN LANG="en-us"></SPAN></P>
<P ALIGN=LEFT><SPAN LANG="en-us"><FONT SIZE=2 FACE="Courier New">></FONT></SPAN><SPAN LANG="en-us"><FONT SIZE=2 FACE="Courier New">specifically at -march=i586. MySQLdb sets CFLAGS which aren't applicable to</FONT></SPAN></P>
<P ALIGN=LEFT><SPAN LANG="en-us"><FONT SIZE=2 FACE="Courier New">></FONT></SPAN><SPAN LANG="en-us"><FONT SIZE=2 FACE="Courier New">your processor, and as such the compile barfs. You should probably just run</FONT></SPAN></P>
<P ALIGN=LEFT><SPAN LANG="en-us"><FONT SIZE=2 FACE="Courier New">></FONT></SPAN><SPAN LANG="en-us"><FONT SIZE=2 FACE="Courier New">it with something like</FONT></SPAN></P>
<P ALIGN=LEFT><SPAN LANG="en-us"><FONT SIZE=2 FACE="Courier New">></FONT></SPAN><SPAN LANG="en-us"></SPAN></P>
<P ALIGN=LEFT><SPAN LANG="en-us"><FONT SIZE=2 FACE="Courier New">></FONT></SPAN><SPAN LANG="en-us"><FONT SIZE=2 FACE="Courier New">CFLAGS="-march=athlon-64" python setup.py build</FONT></SPAN></P>
<P ALIGN=LEFT><SPAN LANG="en-us"><FONT SIZE=2 FACE="Courier New">></FONT></SPAN><SPAN LANG="en-us"></SPAN></P>
<P ALIGN=LEFT><SPAN LANG="en-us"><FONT SIZE=2 FACE="Courier New">></FONT></SPAN><SPAN LANG="en-us"><FONT SIZE=2 FACE="Courier New">I am positive that MySQLdb works on AMD64, I have it running there. Anyway,</FONT></SPAN></P>
<P ALIGN=LEFT><SPAN LANG="en-us"><FONT SIZE=2 FACE="Courier New">></FONT></SPAN><SPAN LANG="en-us"><FONT SIZE=2 FACE="Courier New">the CFLAGS fix should work.</FONT></SPAN></P>
<P ALIGN=LEFT><SPAN LANG="en-us"><B><FONT COLOR="#000080" SIZE=2 FACE="Verdana">Hey there!</FONT></B></SPAN></P>
<P ALIGN=LEFT><SPAN LANG="en-us"><B><FONT COLOR="#000080" SIZE=2 FACE="Verdana">Appreciate the help but the CFLAGS did not change the gcc</FONT></B></SPAN><SPAN LANG="en-us"><B> <FONT COLOR="#000080" SIZE=2 FACE="Verdana">–</FONT></B></SPAN><SPAN LANG="en-us"><B><FONT COLOR="#000080" SIZE=2 FACE="Verdana">march</FONT></B></SPAN><SPAN LANG="en-us"><B><FONT COLOR="#000080" SIZE=2 FACE="Verdana"> (I tried it as above and with CFLAGS=</FONT></B></SPAN><SPAN LANG="en-us"><B><FONT COLOR="#000080" SIZE=2 FACE="Verdana">”</FONT></B></SPAN><SPAN LANG="en-us"><B><FONT COLOR="#000080" SIZE=2 FACE="Verdana">-march=athlon64</FONT></B></SPAN><SPAN LANG="en-us"><B><FONT COLOR="#000080" SIZE=2 FACE="Verdana">”</FONT></B></SPAN><SPAN LANG="en-us"><B><FONT COLOR="#000080" SIZE=2 FACE="Verdana"> which I found in a GCC flag FAQ)</FONT></B></SPAN><SPAN LANG="en-us"><B><FONT COLOR="#000080" SIZE=2 FACE="Verdana">.</FONT></B></SPAN><SPAN LANG="en-us"><B> </B></SPAN></P>
<P ALIGN=LEFT><SPAN LANG="en-us"><B><FONT COLOR="#000080" SIZE=2 FACE="Verdana">I</FONT></B></SPAN><SPAN LANG="en-us"><B> <FONT COLOR="#000080" SIZE=2 FACE="Verdana">realize</FONT></B></SPAN><SPAN LANG="en-us"><B><FONT COLOR="#000080" SIZE=2 FACE="Verdana"> that</FONT></B></SPAN><SPAN LANG="en-us"><B> <FONT COLOR="#000080" SIZE=2 FACE="Verdana">the</FONT></B></SPAN><SPAN LANG="en-us"><B> <FONT COLOR="#000080" SIZE=2 FACE="Verdana">–</FONT></B></SPAN><SPAN LANG="en-us"><B><FONT COLOR="#000080" SIZE=2 FACE="Verdana">march</FONT></B></SPAN><SPAN LANG="en-us"><B> <FONT COLOR="#000080" SIZE=2 FACE="Verdana">is my problem but I can</FONT></B></SPAN><SPAN LANG="en-us"><B><FONT COLOR="#000080" SIZE=2 FACE="Verdana">’</FONT></B></SPAN><SPAN LANG="en-us"><B><FONT COLOR="#000080" SIZE=2 FACE="Verdana">t work out how to change it.</FONT></B></SPAN></P>
<P ALIGN=LEFT><SPAN LANG="en-us"><B><FONT COLOR="#000080" SIZE=2 FACE="Verdana">Any ideas?</FONT></B></SPAN></P>
<P ALIGN=LEFT><SPAN LANG="en-us"><B><FONT COLOR="#000080" SIZE=2 FACE="Verdana">Thanks!</FONT></B></SPAN></P>
</BODY>
</HTML>