[AstroPy] Question about Atpy with MySQL

Dr. Juan E Cabanela Ph.D. cabanela at mnstate.edu
Mon May 23 16:38:29 EDT 2011

I am new to python, trying to convert myself from the pain that is the current combination of perl, C, FORTRAN, and MySQL that I use for my research.

I have been trying to implement a MySQL query in ATpy to my MySQL 5.5.12 database.  I have ATpy and MySQL-Python 1.2.3 installed.

Whenever I try to issue a query like the following (in my case in the 'ipython -pylab' environment):

import atpy
t = atpy.Table('mysql', user='juan', password='XXXX', database='BigGalaxies', \
    table='CompareParams', \
    query='SELECT * FROM CompareParams;' )

I get the following error:

TypeError: 'password' is an invalid keyword argument for this function

If I am interpreting the trace error correctly, the ultimate error get
traced to MySQLdb/connections.pyc.  I suspect this means my MySQL-python installation
is bad.  

Does anyone have any advice/wisdom for resolving this sort of error?  


Dr. Juan Cabanela                    218-477-2453 (V)  218-477-2290 (F)
Minnesota State University Moorhead     WWW: http://www.cabanela.com/     
Dept. of Physics and Astronomy      Twitter: Juan_Kinda_Guy 
1104 Seventh Ave South, Hagen 307B       IM: AstroJuanCab (AIM)   
Moorhead, MN 56563                           cabanela at mnstate.edu (MSN)
                                             juancab at gmail.com (GTalk)
   Public PGP Key available at: http://www.cabanela.com/juan_public.asc

More information about the AstroPy mailing list