I can not use mysql connector in libo 4.4.3.2. Can not load module libmysqlcppconn.so [closed]

edit

Hi Doug, Thanks for answering but this is not the solution. I tried it but I get "This extension 'mysql connector' will not run on this computer". I do not know which version this is but I'm using Linux. I tried that as well and got the extension I already had. I do not know if there is a new version for 4.4 (I'm using Libre Office 4.4.4.3)

I have the extension 4.x active on both Windows and Linux machines, OpenSuse 13.2. LO 5 is the development version. I would force reinstall of LO. If you are simply trying to connect to MySQL without preference of connectors, consider the JDBC / Java connectors here and here. See instructions here.

Hi Doug, I already reinstalled LO. I even updated from 4.4.3.2 to 4.4.4.3. I also have a SSD installed, so I would prefer not to use java in any kind of way, especially Oracle java. I have one option left which is virtualbox. I have windows 7 installed there. I will try it. I'm using Linux Mint 17.2

I wouldn't want to encourage reliance on Windows either. I was under the impression that LO already relies heavily on Java, in its case IcedTea or something like that, but others may be better informed. I will look around further to see if there is anything else I can say about this.

The folder I found in home directory you reference is empty; my connector payload appears to be at /usr/lib/libreoffice/share/extensions/mysql-connector-ooo/. The location you reference appears to be the archive of the downloaded extension itself; the oxt archive does indeed contain that library. The business end of the connector on my system appears to be mysqlc.uno.so in the referenced directory, and Drivers.xcu in the subdir registry/data/org/openoffice/Office/DataAccess/.

Indeed, Components.rdb in the same folder contains a single reference to <component loader="com.sun.star.loader.SharedLibrary" uri="./mysqlc.uno.so"><implementation name="com.sun.star.comp.sdbc.mysqlc.MysqlCDriver"><service name="com.sun.star.sdbc.Driver"/></implementation></component></components>

Hi Doug, I will not rely on Windows. But I have tested it. It works for now, the only thing is, not on linux. The steps I have taken are 1) in my.cnf (mysql config file) comment out bind_address = 127.0.0.1. 2) restart the server. 3) create a base database and connect to mysql. During this process the address changes. For example: if the database is located at 192.168.1.5 and you make a test connection then it will say 192.168.1.15. So, probably some coding error?

Also, I connected as root, which you must not do. The first time I got a connection but I was not allowed. After some research I came to know that you cannot login as root. So I created a user account for libreoffice and loggedin that way. Now it works in windows but not linux. I got the same error about not be able to load that library from the first post, in linux. The problem still exists.

That is right. LO does rely on Java. But like Oracle's Java which causes a lot of write action to the ssd drive, which is not good for the drive. So, if I use Java then it came a long with Linux it self and not a 3rd party like Oracle.

I have found maybe a solution to this. Kinda a workaround? This is what I did. I remembered the xml file you mentioned. I had a look at it, then I remembered some option in LO called pooling. You can find it in the settings like this: Tools -> Options -> LO base -> Connections -> Pooling. Enable it en select the mysql option set it to yes. Then save it and create a base database and connect to Mysql. I still can't login though but I get some error which means there is a connection.