Forcing base to use the configured server, not trying localhost

asked 2016-12-16 17:14:34 +0200

Flightbase
1 ●1 ●2 ●1

Hi,

I got some calc file and I want to move it into a remote(!) mysql database. So I`ve setup&registered my database using native MySql connection (SDBC plugin 1.2.0). Testing the connection works fine.

As soon I try to get the calc data into the database, he tries to put it on a local sql server. error: "unknown database databasename@localcomputer".

how can i force libreoffice to use the configured and registered server and not my local machine?

Comments

What method are you using to put the Calc data into DB - CSV, copy/paste into existing Table, etc.?

Ratslinger ( 2016-12-16 17:36:06 +0200 )edit

I tried copy&paste and drag+drop so far.

Flightbase ( 2016-12-16 17:45:49 +0200 )edit

I just tried a copy/paste. Selected a number of rows in calc sheet, went to DB, selected table, pasted, wizard came up (append data pre-selected), selected Next, Columns/data OK, selected Create and table was updated with the data.

Also drag & drop worked creating a table - just had to change some field types. It even created a primary key.

And you can see and access the DB tables on the server? I am using mysql-connector-java-5.1.36 (sorry, just re-checked). Lo v5.2.3.3 on Mint 18

Ratslinger ( 2016-12-16 18:13:30 +0200 )edit

Hi,

ya, I see existing tables on the database server. But as soon I try to transfer data, he tries to insert it at my local computer.

Flightbase ( 2016-12-19 01:10:09 +0200 )edit

add a comment

answered 2016-12-19 02:54:53 +0200

Ratslinger

14698 ●8 ●28 ●90

You may want to reset you LO user profile (possible corruption) - see this page
Make sure you have no instances of MySQL running on your local machine. If you do, shut it down.
Be sure Edit->Database->Properties contains the IP address of the MySQL server or its' hostname on the network; also verify correct database name is being used.
Make sure you have proper privileges for the database; can you insert a record or create a table from your local machine using something like "MySQL Workbench"?

Other than an incorrect setting, not sure how else it may be trying to access the local host.

edit flag offensive delete link

Comments

Also, not sure about the connector you are using. Only finding this referenced under Apache OpenOffice. You may want to try a different connector.

Ratslinger ( 2016-12-19 03:14:00 +0200 )edit

Ran a couple of quick tests. Used the SBDC 1.2.0 extension without problems. Also tried the older Oracle 1.0.1 connector without problems. Got to be something else at your end.

Ratslinger ( 2016-12-19 04:07:09 +0200 )edit

Well I tried everything you suggested. Should I just uninstall and reinstall everything? It`s not really urgend, since the ods file got only 1600 of 5000 lines so far, but I keep on trying -_-

Flightbase ( 2016-12-19 04:59:31 +0200 )edit

What version of LO & what OS are you running? Hate to ask, but what is your step by step in trying data transfer - similar to what I stated in earlier comment. To existing or new table?

Ratslinger ( 2016-12-19 05:17:29 +0200 )edit

Version: 5.2.3.2 Build-ID: c019706a50de7fcb07d0d528b09b46a887562beb CPU-Threads: 8; BS-Version: Windows 6.1; UI-Render: GL; Gebietsschema: de-DE (de_DE); Calc: group

So win 7 pro 64bit.

Does not matter if existing or new table.

Flightbase ( 2016-12-19 19:23:45 +0200 )edit

Well, the only difference with the information at hand is you're using Windows. In that regard, make sure it's not a firewall or anti-virus program blocking you. Otherwise, for now I'm out of ideas. Will post if something else occurs to me. If you do happen to re-load LO, make sure you clear out any remnants left in the registry after deleting and before re-loading.

Ratslinger ( 2016-12-19 19:51:44 +0200 )edit

I've used Oracle MySQL J Connector before, and it worked just fine, and I recall using Oracle MySQL ODBC Connector too. I'm looking at MariaDB J Connector 1.5.5, it says it's based on Oracle MySQL J Connector 5.1.18 and Oracle MySQL ODBC 5.1.9, available from https://downloads.mariadb.org/connect.... Then there's MariaDB ODBC 2.0.13 with binaries for Window$ and Linux at https://downloads.mariadb.org/connect....

rautamiekka ( 2016-12-20 12:07:07 +0200 )edit

add a comment

Forcing base to use the configured server, not trying localhost

Comments

1 Answer

Comments

Question Tools

Stats

Related questions

Forcing base to use the configured server, not trying localhost edit

Comments

1 Answer

Comments

Question Tools

Stats

Related questions

Forcing base to use the configured server, not trying localhost