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: michaelgmanning@gmail.com On Mon, 27 Jul 2020 at 22:57, Michael Manning <michaelgmanning@gmail.com> 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: michaelgmanning@gmail.com | facebook.com/MikeLouise On Mon, 27 Jul 2020 at 22:33, Michael Manning <michaelgmanning@gmail.com> 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: michaelgmanning@gmail.com On Mon, 27 Jul 2020 at 18:22, Alexander Thurgood <alex.thurgood@gmail.com> wrote:Le 27/07/2020 à 09:06, Michael Manning a écrit : Hi Michael,Issues arise when attempting to create a new database withinLibreoffice.When I test connecting to a database, I get the following errormessage:SQL Status: 08S01 Communications link failure The last packet sent successfully to the server was 0 millisecondsago. Thedriver 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: users+unsubscribe@global.libreoffice.org 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