November 2014 - Pharo-users

Re: [Pharo-users] 'function unavailable' when calling OpenDBXDriver for MySQL

by Brad Selfridge

On 11/17/2014 11:37 AM, Markus Fritsche wrote: > sudo apt-get install libopendbx1:i386 libopendbx1-mysql:i386 brad@brads-linux-laptop:~$ sudo apt-get install libopendbx1:i386 libopendbx1-mysql:i386 [sudo] password for brad: Reading package lists... Done Building dependency tree Reading state information... Done libopendbx1:i386 is already the newest version. libopendbx1:i386 set to manually installed. libopendbx1-mysql:i386 is already the newest version. 0 upgraded, 0 newly installed, 0 to remove and 3 not upgraded. brad@brads-linux-laptop:~$

Nov. 17, 2014

Re: [Pharo-users] 'function unavailable' when calling OpenDBXDriver for MySQL

by Markus Fritsche

Hello Brad, as far as I can tell, you have the 32 bit mysql client libraries installed (don't worry, the 64 and 32 bit version can coexist) - but I am not sure about opendbx. Please try sudo apt-get install libopendbx1:i386 libopendbx1-mysql:i386 Best regards, Markus

Nov. 17, 2014

Re: [Pharo-users] 'function unavailable' when calling OpenDBXDriver for MySQL

by bsselfridge＠gmail.com

The "libmysqlclient18:amd64" looks suspicious. brad@brads-linux-laptop:~$ sudo dpkg -l | grep mysql | awk ' { print $2 } ' libdbd-mysql-perl libmysqlclient18:amd64 libmysqlclient18:i386 libmysqlcppconn7 libopendbx1-mysql libqt4-sql-mysql:i386 mysql-client mysql-client-5.5 mysql-client-core-5.5 mysql-common mysql-server mysql-server-5.5 mysql-server-core-5.5 mysql-utilities mysql-workbench mysql-workbench-data python-mysql.connector brad@brads-linux-laptop:~$ brad@brads-linux-laptop:~$ sudo dpkg -l | grep dbx | awk ' { print $2 } ' libopendbx1 libopendbx1-mysql brad@brads-linux-laptop:~$ ----- Brad Selfridge -- View this message in context: http://forum.world.st/function-unavailable-when-calling-OpenDBXDriver-for-M… Sent from the Pharo Smalltalk Users mailing list archive at Nabble.com.

Nov. 17, 2014

Re: [Pharo-users] 'function unavailable' when calling OpenDBXDriver for MySQL

by Markus Fritsche

Hello Brad, On 2014-11-17 17:34, bsselfridge(a)gmail.com wrote: > My database is 64 bit on my 64bit Ubuntu machine. > > However, on my 32bit Ubuntu 14.04 machine, I have a 64 debian VM > running > that has a 64bit MySQL running which I can access just fine from 32bit > host > machine running Pharo. I would guess that the 32 Bit MySQL client libraries are not installed. Please check if you have libmysqlclient:i386 and libopendbx:i386 (or what the proper name is, I'm not on an ubuntu machine right now) installed. dpkg -l | grep mysql | awk ' { print $2 } ' dpkg -l | grep dbx | awk ' { print $2 } '

Nov. 17, 2014

Re: [Pharo-users] 'function unavailable' when calling OpenDBXDriver for MySQL

by bsselfridge＠gmail.com

My database is 64 bit on my 64bit Ubuntu machine. However, on my 32bit Ubuntu 14.04 machine, I have a 64 debian VM running that has a 64bit MySQL running which I can access just fine from 32bit host machine running Pharo. ----- Brad Selfridge -- View this message in context: http://forum.world.st/function-unavailable-when-calling-OpenDBXDriver-for-M… Sent from the Pharo Smalltalk Users mailing list archive at Nabble.com.

Nov. 17, 2014

Re: [Pharo-users] 'function unavailable' when calling OpenDBXDriver for MySQL

by Stephan Eggermont

Hi Brad, You don't tell us if your MySQL is 32 bit? Stephan

Nov. 17, 2014

Re: [Pharo-users] 'function unavailable' when calling OpenDBXDriver for MySQL

by bsselfridge＠gmail.com

Ill have to check Brad Selfridge 913-269-2385 > On Nov 17, 2014, at 9:41 AM, Stephan Eggermont [via Smalltalk] <ml-node+s1294792n4790646h20(a)n4.nabble.com> wrote: > > Hi Brad, > > You don't tell us if your MySQL is 32 bit? > > Stephan > > > > If you reply to this email, your message will be added to the discussion below: > http://forum.world.st/function-unavailable-when-calling-OpenDBXDriver-for-M… > To unsubscribe from 'function unavailable' when calling OpenDBXDriver for MySQL, click here. > NAML ----- Brad Selfridge -- View this message in context: http://forum.world.st/function-unavailable-when-calling-OpenDBXDriver-for-M… Sent from the Pharo Smalltalk Users mailing list archive at Nabble.com.

Nov. 17, 2014

Re: [Pharo-users] 'function unavailable' when calling OpenDBXDriver for MySQL

by bsselfridge＠gmail.com

It looks like eveything is there. This configuration looks almost identical to my 32os machine. root@brads-linux-laptop:/usr/lib# ldd libopendbx.so.1.2.0 linux-gate.so.1 => (0xf76df000) libdl.so.2 => /lib/i386-linux-gnu/libdl.so.2 (0xf76b8000) libc.so.6 => /lib/i386-linux-gnu/libc.so.6 (0xf7508000) /lib/ld-linux.so.2 (0xf76e0000) root@brads-linux-laptop:/usr/lib# ----- Brad Selfridge -- View this message in context: http://forum.world.st/function-unavailable-when-calling-OpenDBXDriver-for-M… Sent from the Pharo Smalltalk Users mailing list archive at Nabble.com.

Nov. 17, 2014

Re: [Pharo-users] MultiByteFileStream problem

by JosÃ© ComesaÃ±a

Thank you for the idea Phil, but I'd like the same code to work both on OSX and Windows. I don't like calling OS commands, either (my fault, I know...) 2014-11-17 11:30 GMT+01:00 phil(a)highoctane.be <phil(a)highoctane.be>: > I do not know which OS you are on. > > But I have solved a similar problem by calling tail -5 through OSProcess > on Linux for a quick fix. > > tac file can also help to read a file in reverse. > > Phil > > On Mon, Nov 17, 2014 at 10:20 AM, JosÃ© ComesaÃ±a <jose.comesana(a)gmail.com> > wrote: > >> Thank you Sven. >> >> I an trying to read a veeeery long log file, and extract the last 5 >> messages for the user to see them. Reading the whole file from the >> beginning is too expensive. So maybe I could try reading backwards from the >> end using binary mode and look for a lf... I have to think about it a >> little bit, and study your proposal, of course. >> >> >> >> >> >> 2014-11-17 9:26 GMT+01:00 Sven Van Caekenberghe <sven(a)stfx.eu>: >> >>> Hi JosÃ©, >>> >>> > On 17 Nov 2014, at 02:06, JosÃ© ComesaÃ±a <jose.comesana(a)gmail.com> >>> wrote: >>> > >>> > There is an annoying error in MultiByteFileStream, reading back when >>> you have a unicode character. It is also the cause of some FileOut errors. >>> Your can reproduce it this way: >>> > >>> > testString := 'abcdÃ©'. >>> > filename := 'test.txt'. >>> > filename asFileReference ensureDelete. >>> > filename asFileReference >>> > writeStreamDo: [ :stream | >>> > stream >>> > nextPutAll: testString ]. >>> > >>> > f := 'test.txt' asFileReference readStream. >>> > >>> > f setToEnd. >>> > >>> > f skip: -1. >>> > >>> > f peek. >>> > >>> > >>> > Any ideas how to solve it? Avoiding reading back is not an option ;). >>> Maybe making skip to go back one more byte to check if there is a unicode >>> character around?. >>> > >>> > Thanks a lot. >>> >>> This is a known problem/issue/limitation of MultiByteFileStream and the >>> TextConverters. >>> >>> The more modern/logical ZnCharacterEncoders can do this reliably >>> (provided the underlying stream can itself move backwards and the current >>> position is between whole characters). >>> >>> 'test.txt' asFileReference readStreamDo: [ :in | >>> in binary; setToEnd. >>> ZnUTF8Encoder new backOnStream: in; nextFromStream: in ] >>> >>> IMHO, the ability to move backwards and to play with positions without >>> restrictions on streams only makes sense with in-memory streams, not with >>> file or network streams. It plays badly with buffering too. >>> >>> I know this doesn't solve your issue but I hope it gives you a better >>> idea of the situation. >>> >>> Where exactly do you have this issue ? >>> >>> Sven >>> >>> >>> >> >

Nov. 17, 2014

Re: [Pharo-users] MultiByteFileStream problem

by phil＠highoctane.be

I do not know which OS you are on. But I have solved a similar problem by calling tail -5 through OSProcess on Linux for a quick fix. tac file can also help to read a file in reverse. Phil On Mon, Nov 17, 2014 at 10:20 AM, JosÃ© ComesaÃ±a <jose.comesana(a)gmail.com> wrote: > Thank you Sven. > > I an trying to read a veeeery long log file, and extract the last 5 > messages for the user to see them. Reading the whole file from the > beginning is too expensive. So maybe I could try reading backwards from the > end using binary mode and look for a lf... I have to think about it a > little bit, and study your proposal, of course. > > > > > > 2014-11-17 9:26 GMT+01:00 Sven Van Caekenberghe <sven(a)stfx.eu>: > >> Hi JosÃ©, >> >> > On 17 Nov 2014, at 02:06, JosÃ© ComesaÃ±a <jose.comesana(a)gmail.com> >> wrote: >> > >> > There is an annoying error in MultiByteFileStream, reading back when >> you have a unicode character. It is also the cause of some FileOut errors. >> Your can reproduce it this way: >> > >> > testString := 'abcdÃ©'. >> > filename := 'test.txt'. >> > filename asFileReference ensureDelete. >> > filename asFileReference >> > writeStreamDo: [ :stream | >> > stream >> > nextPutAll: testString ]. >> > >> > f := 'test.txt' asFileReference readStream. >> > >> > f setToEnd. >> > >> > f skip: -1. >> > >> > f peek. >> > >> > >> > Any ideas how to solve it? Avoiding reading back is not an option ;). >> Maybe making skip to go back one more byte to check if there is a unicode >> character around?. >> > >> > Thanks a lot. >> >> This is a known problem/issue/limitation of MultiByteFileStream and the >> TextConverters. >> >> The more modern/logical ZnCharacterEncoders can do this reliably >> (provided the underlying stream can itself move backwards and the current >> position is between whole characters). >> >> 'test.txt' asFileReference readStreamDo: [ :in | >> in binary; setToEnd. >> ZnUTF8Encoder new backOnStream: in; nextFromStream: in ] >> >> IMHO, the ability to move backwards and to play with positions without >> restrictions on streams only makes sense with in-memory streams, not with >> file or network streams. It plays badly with buffering too. >> >> I know this doesn't solve your issue but I hope it gives you a better >> idea of the situation. >> >> Where exactly do you have this issue ? >> >> Sven >> >> >> >

Nov. 17, 2014