MySQLdb module works when running Python script from the command line, but not as a cron job -


i trying create cron job run python script wrote, reason script runs when i'm running command line. worked before, accidentally deleted crontab. when crontab wrote tries run it, error mysqldb module being wrong architecture:

    traceback (most recent call last):   file "/users/myuser/documents/ee_sfdc integration/csv_reader/weekly_updates/weekly_confirmation/weekly_confirm.py", line 7, in <module>     import mysqldb   file "/library/python/2.7/site-packages/mysqldb/__init__.py", line 19, in <module>     import _mysql importerror: dlopen(/library/python/2.7/site-packages/_mysql.so, 2): no suitable image found.  did find:     /library/python/2.7/site-packages/_mysql.so: mach-o, wrong architecture

in crontab, i've tried using full path several python versions (2.7 , 3.4), still issue. when use 3.4, don't error mysqldb, do error on print .forma() statement being wrong syntax.

but again, doesn't happen when run script command line, expect not correct version either.

the cron job looks this:

14 12 * * * today=`date +"\%y-\%m-\%d"` && /system/library/frameworks/python.framework/versions/2.7/bin/python2 /users/myuser/documents/ee_sfdc\ integration/csv_reader/weekly_updates/weekly_confirmation/weekly_confirm.py > /users/myuser/documents/ee/run_logs/weekly_sync_runlog_$today.txt 2>&1

any appreciated!

the error message typically means have mismatch between mysqldb (or dependency) , python architecture.

that is, 1 of them 64-bit, while other 32-bit.

what happens if try following in terminal?

$ /system/library/frameworks/python.framework/versions/2.7/bin/python2 (take note of exact version) >>> import platform >>> print platform.architecture() >>> import mysqldb

do again, time python path , see if differ

$ python >>> import platform >>> print platform.architecture() >>> import mysqldb

edit:

you might check file, architecture module built for.

$ file /library/python/2.7/site-packages/_mysql.so /library/python/2.7/site-packages/_mysql.so: mach-o universal binary 2 architectures /library/python/2.7/site-packages/_mysql.so (for architecture x86_64):  mach-o 64-bit bundle x86_64 /library/python/2.7/site-packages/_mysql.so (for architecture i386):    mach-o bundle i386

-

Comments

Post a Comment

Popular posts from this blog

OpenCV OpenCL: Convert Mat to Bitmap in JNI Layer for Android -

there several posts converting mat bitmap using utils.mattobitmap() function. i'm assuming function can called in java layer after importing utils class. i want transfer data memory address pointed uint32_t* bmpcontent; in code below. jniexport void jnicall java_com_nod_nodcv_nodcvactivity_runfilter( jnienv *env, jclass clazz, jobject outbmp, jbytearray indata, jint width, jint height, jint choice, jint filter) { int outsz = width*height; int insz = outsz + outsz/2; androidbitmapinfo bmpinfo; if (androidbitmap_getinfo(env, outbmp, &bmpinfo) < 0) { throwjavaexception(env,"gaussianblur","error retrieving bitmap meta data"); return; } if (bmpinfo.format != android_bitmap_format_rgba_8888) { throwjavaexception(env,"gaussianblur","expecting rgba_8888 format"); return; } uint32_t* bmpcontent; if (androidbitmap_lockpixels(env, outbmp,(void**)&bmpcontent)...
Read more

android - org.xmlpull.v1.XmlPullParserException: expected: START_TAG {http://schemas.xmlsoap.org/soap/envelope/}Envelope -

i trying hit soap api in application login purpose , getting above mentioned error , can 1 tell me going wrong , first time soap apis. here code hit soap :- vector<object> args = new vector<object>(); hashtable<string, object> hashtable = new hashtable<string, object>(); hashtable.put("email", "mss.siddhart28@gmail.com"); hashtable.put("password", "siddharth"); args.add(hashtable); soapserializationenvelope envelope = new soapserializationenvelope( soapenvelope.ver11); envelope.dotnet = true; envelope.xsd = soapserializationenvelope.xsd; envelope.enc = soapserializationenvelope.enc; (new marshalhashtable()).register(envelope); httptransportse androidhttptransport = new httptransportse( "http://tempuri.org/", 15000); androidhttptransport.debug = true; string result = ""; try { soapobject request = new soapobject("http:...
Read more

python - How to remove the Xframe Options header in django? -

i have made page has iframe . inside iframe want show multiple different links article facebook, or news, or youtube video or other possible url. but, due xframe header, unable so. referred following link: https://docs.djangoproject.com/en/1.8/ref/clickjacking/ , django xframeoptionsmiddleware (x-frame-options) - allow iframe client ip but didn't help. my settings.py file's middleware_classes is: middleware_classes = ( 'django.contrib.sessions.middleware.sessionmiddleware', 'django.middleware.common.commonmiddleware', 'django.middleware.csrf.csrfviewmiddleware', 'django.contrib.auth.middleware.authenticationmiddleware', 'django.contrib.auth.middleware.sessionauthenticationmiddleware', 'django.contrib.messages.middleware.messagemiddleware', 'django.middleware.clickjacking.xframeoptionsmiddleware', ) from http://django-secure.readthedocs.org/en/latest/middleware.html , found using ...
Read more