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
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 mich...@freepascal.org 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 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] MariaDB access - modifying the MySQL56Connection component
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? TIA Susie --- Susie Nichol Christchurch, New Zealand. -- ___ 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] MariaDB access - modifying the MySQL56Connection component
Many thanks both of you Susie On Sun, Jun 28, 2015 at 9:35 PM, Michael Van Canneyt mich...@freepascal.org 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
