Ask Your Question
0

Forcing base to use the configured server, not trying localhost

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

Flightbase gravatar image

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?

edit retag flag offensive close merge delete

Comments

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

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

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

Flightbase gravatar imageFlightbase ( 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 gravatar imageRatslinger ( 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 gravatar imageFlightbase ( 2016-12-19 01:10:09 +0200 )edit

1 Answer

Sort by » oldest newest most voted
0

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

Ratslinger gravatar image
  • 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 more

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 gravatar imageRatslinger ( 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 gravatar imageRatslinger ( 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 gravatar imageFlightbase ( 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 gravatar imageRatslinger ( 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 gravatar imageFlightbase ( 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 gravatar imageRatslinger ( 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 gravatar imagerautamiekka ( 2016-12-20 12:07:07 +0200 )edit
Login/Signup to Answer

Question Tools

1 follower

Stats

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

Seen: 192 times

Last updated: Dec 19 '16