Thank you for your assistance. Your hints have allowed me to resolve the problem.
XAMPP stores its my.cnf file in /opt/lampp/etc. The my.cnf file at that location had skip-networking uncommented. Once this had been commented out and the server restarted I was able define an .odb file connecting to the test database in MariaDB. This has now worked perfectly. Many thanks again. Mike email: [email protected] On Mon, 27 Jul 2020 at 22:57, Michael Manning <[email protected]> wrote: > The server appears to be running on port 3306 according to this command > and result: > > $ mysql -u michael -p --port=3306 > Enter password: > Welcome to the MariaDB monitor. Commands end with ; or \g. > Your MariaDB connection id is 28 > Server version: 10.4.6-MariaDB Source distribution > > Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others. > > Type 'help;' or '\h' for help. Type '\c' to clear the current input > statement. > > cheers > Mike > email: [email protected] | facebook.com/MikeLouise > > > > On Mon, 27 Jul 2020 at 22:33, Michael Manning <[email protected]> > wrote: > >> Thank you for your responses. >> I am testing using a database with a single table created with the mysql >> command line client. This table has 3 fields, an auto-incrementing primary >> key, and two fields each defined as varchar(50). The table was defined >> using the mysql command line client, and then 3 records were inserted into >> the table. I also used the mysql command line client to ensure that I >> could retrieve all 3 records using the command: >> select * from test1; >> >> I do not have a /etc/my.cnf file. >> >> The only line that is not a comment in my /etc/mysql/my.cnf file is: >> !includedir /etc/mysql/conf.d/ >> >> I should also mention that I am using XAMPP for the installation of MySQL >> and that this has also installed an apache web server and PHPMyAdmin which >> are all working correctly. Should this make any difference to the way that >> LibreOffice connects via the JDBC connector? >> >> PHPMyAdmin reports the server as: >> >> - Server: Localhost via UNIX socket >> - Server type: MariaDB >> - Server connection: SSL is not being used [image: Documentation] >> <http://localhost/phpmyadmin/doc/html/setup.html#ssl> >> - Server version: 10.4.6-MariaDB - Source distribution >> - Protocol version: 10 >> - User: michael@localhost >> - Server charset: cp1252 West European (latin1) >> >> Is this a hint that sockets are being used and not port 3306 that >> LibreOffice is expecting? If so, how should I fix this? >> cheers >> Mike >> email: [email protected] >> >> >> >> On Mon, 27 Jul 2020 at 18:22, Alexander Thurgood <[email protected]> >> wrote: >> >>> Le 27/07/2020 à 09:06, Michael Manning a écrit : >>> >>> Hi Michael, >>> >>> > >>> > Issues arise when attempting to create a new database within >>> Libreoffice. >>> > When I test connecting to a database, I get the following error >>> message: >>> > SQL Status: 08S01 >>> > Communications link failure >>> > The last packet sent successfully to the server was 0 milliseconds >>> ago. The >>> > driver has not received any packets from the server. >>> > >>> >>> As Robert has indicated, could you be clearer on what you mean by >>> "creating a new database within LibreOffice ?" >>> >>> Are you: >>> (1) trying to create a new database schema from within a running LO >>> instance ? As Robert has mentioned, you can't actually do this, the DB >>> schema needs to be created from the msyql command line or an alternative >>> GUI tool (such as e.g. phpmyadmin) ; >>> >>> (2) trying to connect to an existing mysql DB schema, and receiving the >>> error message you have indicated ? >>> >>> >>> The error message itself might be slightly misleading, as this is >>> usually displayed when you can not even connect to the mariadb/mysql >>> instance. >>> >>> What does your /etc/mysql/my.cnf or /etc/my.cnf contain next to : >>> >>> bind-address >>> and >>> skip-networking >>> >>> >>> >>> >>> Alex >>> >> -- To unsubscribe e-mail to: [email protected] Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/users/ Privacy Policy: https://www.documentfoundation.org/privacy
