Re: [Lazarus] MariaDB access - modifying the MySQL56Connection component
Yes, it is working. The diff is incorrect, but comments in the bug track correct it. I used your method 2; method 1 didn't work and I think I know why: my testing has upset the directory structure. I'll look into that after I get this project finished. Susie On Sun, Jun 28, 2015 at 9:35 PM, Michael Van Canneyt wrote: > > > On Sun, 28 Jun 2015, Susie Nicol wrote: > > Hi >> >> This question has obviously been asked many times before, but I am having >> trouble dealing with the answers. >> >> I run MariaDB, rather than MYSQL, using OpenSUSE 13.2, with Lazarus 1.4, >> Free Pascal 2.6.4, downloaded from Sourceforge. I have the usual issue >> getting a database connection: "TMySQL56Connection can >> not work with the installed MySQL client version: Expected (5.6), got >> (10.0.13-MariaDB)" >> >> There's a diff associated with the bug report at >> http://bugs.freepascal.org/view.php?id=26620 which I have attempted to >> apply, without success. >> >> What I tried was: >> >> - patch >> /usr/share/fpsrc/2.6.4/packages/fcl-db/src/sqldb/mysql/mysqlconn.inc as in >> the diff >> - rebuilt, using the Makefile in that directory >> - within Lazarus, rebuilt the IDE. >> >> This hasn't achieved anything. I get the same error, which presumably >> means I have missed out some steps. >> >> I'm starting to find the documentation wiki "a mass of twisted passages, >> all alike". Is there a simple explanation of what I have missed? >> > > Compiling is not enough. Did you install the .ppu ? > > Several ways are possible: > > 1. The clean way >That is, in /usr/share/fpsrc/2.6.4/packages/fcl-db you should run "make > install", as root. >But that may lead to other problems since you will have newer .ppu's of > all > > 2. find the newly generated mysql56conn.ppu and mysql56conn.o, and just > copy these over the installed version > > And then rebuild lazarus. > > The simplest solution may be to: > 3. Simply copy 2 files: mysql56conn.pp and mysqlconn.inc from > /usr/share/fpsrc/2.6.4/packages/fcl-db/src/sqldb/mysql to your project's > directory. >Recompile your project. >You will then not be able to make the connection in the lazarus form > designer, but the compiled program should then work. > > Michael. > -- > ___ > Lazarus mailing list > Lazarus@lists.lazarus.freepascal.org > http://lists.lazarus.freepascal.org/mailman/listinfo/lazarus > > -- ___ Lazarus mailing list Lazarus@lists.lazarus.freepascal.org http://lists.lazarus.freepascal.org/mailman/listinfo/lazarus
Re: [Lazarus] MariaDB access - modifying the MySQL56Connection component
On Mon, 29 Jun 2015, Susie Nicol wrote: Many thanks both of you Susie Did you manage to get it to work ? Michael. -- ___ Lazarus mailing list Lazarus@lists.lazarus.freepascal.org http://lists.lazarus.freepascal.org/mailman/listinfo/lazarus
Re: [Lazarus] MariaDB access - modifying the MySQL56Connection component
Many thanks both of you Susie On Sun, Jun 28, 2015 at 9:35 PM, Michael Van Canneyt wrote: > > > On Sun, 28 Jun 2015, Susie Nicol wrote: > > Hi >> >> This question has obviously been asked many times before, but I am having >> trouble dealing with the answers. >> >> I run MariaDB, rather than MYSQL, using OpenSUSE 13.2, with Lazarus 1.4, >> Free Pascal 2.6.4, downloaded from Sourceforge. I have the usual issue >> getting a database connection: "TMySQL56Connection can >> not work with the installed MySQL client version: Expected (5.6), got >> (10.0.13-MariaDB)" >> >> There's a diff associated with the bug report at >> http://bugs.freepascal.org/view.php?id=26620 which I have attempted to >> apply, without success. >> >> What I tried was: >> >> - patch >> /usr/share/fpsrc/2.6.4/packages/fcl-db/src/sqldb/mysql/mysqlconn.inc as in >> the diff >> - rebuilt, using the Makefile in that directory >> - within Lazarus, rebuilt the IDE. >> >> This hasn't achieved anything. I get the same error, which presumably >> means I have missed out some steps. >> >> I'm starting to find the documentation wiki "a mass of twisted passages, >> all alike". Is there a simple explanation of what I have missed? >> > > Compiling is not enough. Did you install the .ppu ? > > Several ways are possible: > > 1. The clean way >That is, in /usr/share/fpsrc/2.6.4/packages/fcl-db you should run "make > install", as root. >But that may lead to other problems since you will have newer .ppu's of > all > > 2. find the newly generated mysql56conn.ppu and mysql56conn.o, and just > copy these over the installed version > > And then rebuild lazarus. > > The simplest solution may be to: > 3. Simply copy 2 files: mysql56conn.pp and mysqlconn.inc from > /usr/share/fpsrc/2.6.4/packages/fcl-db/src/sqldb/mysql to your project's > directory. >Recompile your project. >You will then not be able to make the connection in the lazarus form > designer, but the compiled program should then work. > > Michael. > -- > ___ > Lazarus mailing list > Lazarus@lists.lazarus.freepascal.org > http://lists.lazarus.freepascal.org/mailman/listinfo/lazarus > > -- ___ Lazarus mailing list Lazarus@lists.lazarus.freepascal.org http://lists.lazarus.freepascal.org/mailman/listinfo/lazarus
Re: [Lazarus] Mailing list archive as mbox file
On 2015-06-28 11:47, Graeme Geldenhuys wrote: > A not so nice feature of Lazarus's mailing list archives, is that it > mangled the email addresses, removing the @ symbol and replaced it with Ah, I see that script fixes the email address format too. Very nice. Worked like a charm. Ended up with a 134MB file, and its busy importing it now. :) Regards, - Graeme - -- fpGUI Toolkit - a cross-platform GUI toolkit using Free Pascal http://fpgui.sourceforge.net/ -- ___ Lazarus mailing list Lazarus@lists.lazarus.freepascal.org http://lists.lazarus.freepascal.org/mailman/listinfo/lazarus
Re: [Lazarus] Mailing list archive as mbox file
On 2015-06-28 10:37, Michael Van Canneyt wrote: > You're not the only one, it seems: > https://mail.python.org/pipermail/mailman-users/2012-October/074208.html Nice thanks! That will do perfectly. That got me thinking... I also found that doing a Google search for: pipermail filetype:mbox found some archives with 10k-20k of messages each. ps: A not so nice feature of Lazarus's mailing list archives, is that it mangled the email addresses, removing the @ symbol and replaced it with the word "at" and added some spaces etc. I'll sure I could tweak the importing tool to fix those though. Regards, - Graeme - -- fpGUI Toolkit - a cross-platform GUI toolkit using Free Pascal http://fpgui.sourceforge.net/ -- ___ Lazarus mailing list Lazarus@lists.lazarus.freepascal.org http://lists.lazarus.freepascal.org/mailman/listinfo/lazarus
Re: [Lazarus] Mailing list archive as mbox file
On Sun, 28 Jun 2015, Graeme Geldenhuys wrote: Hi, I know I can download the archive on a month-by-month basis from: http://lists.lazarus.freepascal.org/pipermail/lazarus/ Is there some hidden URL where I could download everything as a single download and even better, as a single large mbox file? Or does anybody know how I can use a bash script or something to merge all the individual files as one large file. I've written a new email/nntp/rss program which is SQL based and want to put it through its paces with a large volume of emails. eg: hopefully way over 100,000+ messages. You're not the only one, it seems: https://mail.python.org/pipermail/mailman-users/2012-October/074208.html Michael. -- ___ Lazarus mailing list Lazarus@lists.lazarus.freepascal.org http://lists.lazarus.freepascal.org/mailman/listinfo/lazarus
Re: [Lazarus] MariaDB access - modifying the MySQL56Connection component
On Sun, 28 Jun 2015, Susie Nicol wrote: Hi This question has obviously been asked many times before, but I am having trouble dealing with the answers. I run MariaDB, rather than MYSQL, using OpenSUSE 13.2, with Lazarus 1.4, Free Pascal 2.6.4, downloaded from Sourceforge. I have the usual issue getting a database connection: "TMySQL56Connection can not work with the installed MySQL client version: Expected (5.6), got (10.0.13-MariaDB)" There's a diff associated with the bug report at http://bugs.freepascal.org/view.php?id=26620 which I have attempted to apply, without success. What I tried was: - patch /usr/share/fpsrc/2.6.4/packages/fcl-db/src/sqldb/mysql/mysqlconn.inc as in the diff - rebuilt, using the Makefile in that directory - within Lazarus, rebuilt the IDE. This hasn't achieved anything. I get the same error, which presumably means I have missed out some steps. I'm starting to find the documentation wiki "a mass of twisted passages, all alike". Is there a simple explanation of what I have missed? Compiling is not enough. Did you install the .ppu ? Several ways are possible: 1. The clean way That is, in /usr/share/fpsrc/2.6.4/packages/fcl-db you should run "make install", as root. But that may lead to other problems since you will have newer .ppu's of all 2. find the newly generated mysql56conn.ppu and mysql56conn.o, and just copy these over the installed version And then rebuild lazarus. The simplest solution may be to: 3. Simply copy 2 files: mysql56conn.pp and mysqlconn.inc from /usr/share/fpsrc/2.6.4/packages/fcl-db/src/sqldb/mysql to your project's directory. Recompile your project. You will then not be able to make the connection in the lazarus form designer, but the compiled program should then work. Michael.-- ___ Lazarus mailing list Lazarus@lists.lazarus.freepascal.org http://lists.lazarus.freepascal.org/mailman/listinfo/lazarus
[Lazarus] Mailing list archive as mbox file
Hi, I know I can download the archive on a month-by-month basis from: http://lists.lazarus.freepascal.org/pipermail/lazarus/ Is there some hidden URL where I could download everything as a single download and even better, as a single large mbox file? Or does anybody know how I can use a bash script or something to merge all the individual files as one large file. I've written a new email/nntp/rss program which is SQL based and want to put it through its paces with a large volume of emails. eg: hopefully way over 100,000+ messages. Regards, - Graeme - -- fpGUI Toolkit - a cross-platform GUI toolkit using Free Pascal http://fpgui.sourceforge.net/ -- ___ Lazarus mailing list Lazarus@lists.lazarus.freepascal.org http://lists.lazarus.freepascal.org/mailman/listinfo/lazarus
Re: [Lazarus] MariaDB access - modifying the MySQL56Connection component
> This hasn't achieved anything. I get the same error, which presumably means I have missed out some steps. - patch /usr/share/fpsrc/2.6.4/packages/fcl-db/src/sqldb/mysql/mysqlconn.inc as in the diff - rebuilt, using the Makefile in that directory >>> - install it, replacing the shipped mysqlXY compiled units - within Lazarus, rebuilt the IDE. -- View this message in context: http://free-pascal-lazarus.989080.n3.nabble.com/Lazarus-MariaDB-access-modifying-the-MySQL56Connection-component-tp4042985p4042987.html Sent from the Free Pascal - Lazarus mailing list archive at Nabble.com. -- ___ Lazarus mailing list Lazarus@lists.lazarus.freepascal.org http://lists.lazarus.freepascal.org/mailman/listinfo/lazarus
Re: [Lazarus] Beyond Compare finally moved to LCL
> AFAIK we've submitted all/most of our LCL changes to the bug tracker, though I'll admit David hasn't been proactive about actually committing them into the official repository. Lovely, huge thanks :) -- View this message in context: http://free-pascal-lazarus.989080.n3.nabble.com/Lazarus-Beyond-Compare-finally-moved-to-LCL-tp4042961p4042986.html Sent from the Free Pascal - Lazarus mailing list archive at Nabble.com. -- ___ Lazarus mailing list Lazarus@lists.lazarus.freepascal.org http://lists.lazarus.freepascal.org/mailman/listinfo/lazarus