HI,
i just wanted to try out the SQL bundle but somehow i have problems. First i found no docs whats the best way to let Textmate find the mysql binary. He complained that he couldnt find it any of the mentioned paths, which was basically the PATH env. variable. Then i created a symlink to mysql binary into ...SQL.tmbundle/Support/ bin/
With that i was able to "Execute line with query" but with "Table Browser" i got this:
Traceback (most recent call last): File "/Users/marclogemann/ Applications/tools/TextMate.app/Contents/SharedSupport/Bundles/ SQL.tmbundle/Support/bin/tableBrowser.py", line 284, in ? sys.exit (main()) File "/Users/marclogemann/Applications/tools/TextMate.app/ Contents/SharedSupport/Bundles/SQL.tmbundle/Support/bin/ tableBrowser.py", line 109, in main listTables (dbName,dbHost,dbPort,serverType,passwd,dbUser) File "/Users/ marclogemann/Applications/tools/TextMate.app/Contents/SharedSupport/ Bundles/SQL.tmbundle/Support/bin/tableBrowser.py", line 130, in listTables mycon = MySQLdb.connect(db=dbName,host=dbHost,port=int (dbPort),user=dbUser,passwd=passwd) NameError: global name 'MySQLdb' is not defined
To be honest, i dont know what these _mysql files in there are, nor it is documented somehwere. So what is the best approach to get this running?
Furthermore is there a way to display correct encodings for international characters like german umlaute (äöü)? I get rubbish when these chars occur.
Thanks.
Marc
On 22/6/2006, at 1:57, Marc Logemann wrote:
i just wanted to try out the SQL bundle but somehow i have problems. First i found no docs whats the best way to let Textmate find the mysql binary.
How TM locates shell commands is explained here [1].
[...] Furthermore is there a way to display correct encodings for international characters like german umlaute (äöü)? I get rubbish when these chars occur.
The result returned from MySQL is expected to be utf-8. There is no configuration for this, but you could add something like ‘|iconv -f iso-8859-1 -t utf-8’ to the line which calls MySQL.
[1] http://macromates.com/textmate/manual/shell_commands#search_path
Hi,
but does this explain the error i am getting in the TableBrowser? It should not make a difference if i link to the binary via a symlink or putting the binary in some kind of path.
Marc
Am 22.06.2006 um 02:11 schrieb Allan Odgaard:
On 22/6/2006, at 1:57, Marc Logemann wrote:
i just wanted to try out the SQL bundle but somehow i have problems. First i found no docs whats the best way to let Textmate find the mysql binary.
How TM locates shell commands is explained here [1].
[...] Furthermore is there a way to display correct encodings for international characters like german umlaute (äöü)? I get rubbish when these chars occur.
The result returned from MySQL is expected to be utf-8. There is no configuration for this, but you could add something like ‘|iconv -f iso-8859-1 -t utf-8’ to the line which calls MySQL.
[1] http://macromates.com/textmate/manual/shell_commands#search_path
For new threads USE THIS: textmate@lists.macromates.com (threading gets destroyed and the universe will collapse if you don't) http://lists.macromates.com/mailman/listinfo/textmate
Hi,
yeah i am on intel. That explains it .... thanks.
Am 22.06.2006 um 18:42 schrieb Allan Odgaard:
On 22/6/2006, at 16:58, Marc Logemann wrote:
but does this explain the error i am getting in the TableBrowser?
No, I did not reply to that -- the Python script uses MySQL bindings rather than the mysql binary.
The ones in the bundle are only for PPC. Are you on an Intel Mac?
For new threads USE THIS: textmate@lists.macromates.com (threading gets destroyed and the universe will collapse if you don't) http://lists.macromates.com/mailman/listinfo/textmate
-
Allan Odgaard -
Marc Logemann