[MonetDB-users] import error in python script
hi all i use MonetDB Database Server Toolkit v0.4 and ubuntu 8.10. im unable to issue any of the monetdb commands without prefixing them with a ./ that is instead of mserver5,it works only when i give ./mserver5 And im able to issue these commands only when im in the bin directory though i ve permanantly set the PATH variable in .bash_profile when i try to connect to monetdb using the sample python script that is given in the docs,i get an import error telling unable to import MonetDbSQL,though i ve set the PYTHONPATH variable to /prefix/lib/python2.5/site-packages/MonetDb directory the script is import MonetSQLdb # Let the cursor return dictionaries instead of tuples: # x = MonetSQLdb.connect(cursorclass = MonetSQLdb.cursors.DictCursor) x = MonetSQLdb.connect(host = 'localhost', user = 'monetdb',password = 'monet\db', lang = 'sql') #x = MonetSQLdb.connect(lang='sql') c = x.cursor() c.execute('select * from test') #print c.fetchone() print c.fetchall() x.close() But the script works fine on Debian Etch. i need to overcome these two issues... Thanks in advance, Mahesh ----------------------------------------- This email was sent using TCEMail Service. Thiagarajar College of Engineering Madurai - 625015 (India)
On Thu, Mar 12, 2009 at 8:06 AM, Ranadeeran <ranadeeran@tce.edu> wrote:
hi all i use MonetDB Database Server Toolkit v0.4 and ubuntu 8.10. im unable to issue any of the monetdb commands without prefixing them with a ./ that is instead of mserver5,it works only when i give ./mserver5
And im able to issue these commands only when im in the bin directory though i ve permanantly set the PATH variable in .bash_profile
Do your commands have the executable bit set? What does ls -l mserver5 say?
when i try to connect to monetdb using the sample python script that is given in the docs,i get an import error telling unable to import MonetDbSQL,though i ve set the PYTHONPATH variable to /prefix/lib/python2.5/site-packages/MonetDb directory
What is the python error you are getting? Does your script work when you invoke as PYTHONPATH=/prefix/lib/python2.5/site-packages/MonetDb script.py ? -matt
Hi, can you please send the output of the following commands on your terminal: echo $PATH echo $LD_LIBRARY_PATH echo $PYTHONPATH and ofcourse echo $SHELL All hte errors you describe look like wrong settings in these global vars. Also, how did you install Monet? did you used a tarball version, a cvs or the new ubuntu/debian packages? Thank you, lefteris On Thu, Mar 12, 2009 at 4:06 PM, Ranadeeran <ranadeeran@tce.edu> wrote:
hi all i use MonetDB Database Server Toolkit v0.4 and ubuntu 8.10. im unable to issue any of the monetdb commands without prefixing them with a ./ that is instead of mserver5,it works only when i give ./mserver5
And im able to issue these commands only when im in the bin directory though i ve permanantly set the PATH variable in .bash_profile
when i try to connect to monetdb using the sample python script that is given in the docs,i get an import error telling unable to import MonetDbSQL,though i ve set the PYTHONPATH variable to /prefix/lib/python2.5/site-packages/MonetDb directory
the script is import MonetSQLdb # Let the cursor return dictionaries instead of tuples: # x = MonetSQLdb.connect(cursorclass = MonetSQLdb.cursors.DictCursor) x = MonetSQLdb.connect(host = 'localhost', user = 'monetdb',password = 'monet\db', lang = 'sql') #x = MonetSQLdb.connect(lang='sql') c = x.cursor() c.execute('select * from test') #print c.fetchone() print c.fetchall() x.close()
But the script works fine on Debian Etch.
i need to overcome these two issues...
Thanks in advance, Mahesh
----------------------------------------- This email was sent using TCEMail Service. Thiagarajar College of Engineering Madurai - 625015 (India)
------------------------------------------------------------------------------ Apps built with the Adobe(R) Flex(R) framework and Flex Builder(TM) are powering Web 2.0 with engaging, cross-platform capabilities. Quickly and easily build your RIAs with Flex Builder, the Eclipse(TM)based development software that enables intelligent coding and step-through debugging. Download the free 60 day trial. http://p.sf.net/sfu/www-adobe-com _______________________________________________ MonetDB-users mailing list MonetDB-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-users
You should set PYTHONPATH to something like /prefix/lib/python2.5/site-packages Can you confirm? Thanx, Lazaros. On Thu, Mar 12, 2009 at 08:36:08PM +0530, Ranadeeran wrote:
hi all i use MonetDB Database Server Toolkit v0.4 and ubuntu 8.10. im unable to issue any of the monetdb commands without prefixing them with a ./ that is instead of mserver5,it works only when i give ./mserver5
And im able to issue these commands only when im in the bin directory though i ve permanantly set the PATH variable in .bash_profile
when i try to connect to monetdb using the sample python script that is given in the docs,i get an import error telling unable to import MonetDbSQL,though i ve set the PYTHONPATH variable to /prefix/lib/python2.5/site-packages/MonetDb directory
the script is import MonetSQLdb # Let the cursor return dictionaries instead of tuples: # x = MonetSQLdb.connect(cursorclass = MonetSQLdb.cursors.DictCursor) x = MonetSQLdb.connect(host = 'localhost', user = 'monetdb',password = 'monet\db', lang = 'sql') #x = MonetSQLdb.connect(lang='sql') c = x.cursor() c.execute('select * from test') #print c.fetchone() print c.fetchall() x.close()
But the script works fine on Debian Etch.
i need to overcome these two issues...
Thanks in advance, Mahesh
----------------------------------------- This email was sent using TCEMail Service. Thiagarajar College of Engineering Madurai - 625015 (India)
------------------------------------------------------------------------------ Apps built with the Adobe(R) Flex(R) framework and Flex Builder(TM) are powering Web 2.0 with engaging, cross-platform capabilities. Quickly and easily build your RIAs with Flex Builder, the Eclipse(TM)based development software that enables intelligent coding and step-through debugging. Download the free 60 day trial. http://p.sf.net/sfu/www-adobe-com _______________________________________________ MonetDB-users mailing list MonetDB-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-users
participants (4)
-
Lazaros Koromilas -
Lefteris -
m h -
Ranadeeran