Hi There In addition to the other problem, the text colour in the table view in forms, I thought I'd try creating a new Base document from scratch. I set the connection fine etc, and the connection to MySQL worked perfectly fine, but then here is the snag. The MySQL databases have a number views, which show up in the Base table listing perfectly fine, however, none of the tables do?? The table does show, if I was to create a new table through the Base gui, but not of the pre-existing tables are viewable? In a existing base database, last modified in LibreOffice 4.4, that connects to the same database, the tables can quite clearly be seen.
@Tony : how are you accessing the mysql instance, i.e. which driver combination are you using ?
Hi there I'm using the mariadb-java-client-1.1.8.jar in the classpath And the DB connection is mysql://localhost:3306/dbname I've also tried with mariadb://localhost:3306/dbname Using MariaDB 10.0.15 On Centos 6
No repro on Version: 5.2.0.0.alpha0+ Build ID: ac91a81b7b47fc9eba24455d34e2168309ea51d1 CPU Threads: 2; OS Version: -; UI Render: default; Locale: fr-FR (fr.UTF-8) OSX 10.11.2 using mysql-connector-java-5.1.34 to a remote mysql 5.1 instance My connection to the mysql server was created via the db wizard, using Connect to existing database, chossing mysql, then in the next step, selecting JDBC as the driver type. Could be that it is your connector jar which is causing the problem, or else the type of connection setup in LO - how is it setup JDBC or MySQL (Wizard First step) ? From your description, it sounds like you set this up directly as a JDBC connection, and not as a MySQL connection choosing JDBC as the connector type in the subsequent step.
I would add that my mysql instance has a db with both tables and views in it and I can see them all in my connection via LO
There were also some changes made in 5.1 dev with respect to filtering of tables in the code that only applied to mysql(jdbc) connection configurations, and not to JDBC connections in general - perhaps what you are experiencing is a rebound effect of those changes.
Hi there I've had a go, using the wizard. And that worked fine, I don't know, if anybody has noticed, but if after you have got the connection working, if you edit the connection, and take the database name out of the parameters, you get access to all databases that the connecting user has access to. I hope that's by design, as that is an absolute bonus :-)
(In reply to Tony from comment #6) > Hi there > > I've had a go, using the wizard. And that worked fine, I don't know, if > anybody has noticed, but if after you have got the connection working, if > you edit the connection, and take the database name out of the parameters, > you get access to all databases that the connecting user has access to. > > I hope that's by design, as that is an absolute bonus :-) Let's just say that it is an interesting side-effect :) Per your comment, closing then as WFM