Howto store a password for jdbc-connection?

dBase, Calc, CSV, MS ACCESS, MySQL, PostgrSQL, OTHER
Post Reply
User avatar
joris
Posts: 20
Joined: Mon Aug 11, 2008 10:15 am

Howto store a password for jdbc-connection?

Post by joris »

In my setup openoffice is acting as a front end for a mysql database. Every time I log in to a openoffice database, i have to fill in the password for the Mysql-database. That is ok because the mysql database is password is protected and i like to keep it that way. But i would like openoffice to remember the password, so i don't have to type it every time I login.

It is not an option to disable the password in Mysql, because sometimes i need to connect to the database over the internet and that is why it has a strong password. (that also a reason why it is annoying to type it in very often). As far as i can see there is no gui where you can make openoffice remember the password. It only can remember it for the session and remember the username.

Maybe there is some configuration file i can edit the connection string for my database so it doesn't pop up for my password. Or maybe there is some password manager for openoffice, similar to thunderbird? Any help would be appreciated.
Libre Office on Ubuntu 12.10
kidbrax
Posts: 1
Joined: Thu Dec 04, 2008 4:28 pm

Re: Howto store a password for jdbc-connection?

Post by kidbrax »

Did you ever find a solution for this? I would like to do the same thing.
OOo 3.0.X on Mac OSx Leopard
User avatar
joris
Posts: 20
Joined: Mon Aug 11, 2008 10:15 am

Re: Howto store a password for jdbc-connection?

Post by joris »

Sorry, no, this still is an issue. (and one of the reasons why the new openoffice front end still isn't implemented in the organisation I made it for.) Maybe i should make a feature request for this.
Libre Office on Ubuntu 12.10
karl.kashofer
Posts: 1
Joined: Thu Sep 23, 2010 2:56 pm

Re: Howto store a password for jdbc-connection?

Post by karl.kashofer »

I know this thread is old, but its first on google and maybe this helps someone:

The jdts syntax allows to set parameters in the url:

jdbc:jdts:sqlserver://server.host.com:1433/database;password=mysecurepwd

There are also other parameters detailed on the bottom of this page:
http://jtds.sourceforge.net/faq.html

Cheers,
Karl
Openoffice 3.2 on Debian Lenny
Credomo
Posts: 1
Joined: Fri Sep 16, 2011 11:43 am

Re: Howto store a password for jdbc-connection?

Post by Credomo »

Hello,

A solution ...

database URL :

Code: Select all

 jdbc:postgresql://192.168.0.100:5432/database?user=your_login&password=your_password
Field User name : Empty
Required password : Uncheck

Works fine, direct connection, but not secure
LibreOffice 3.3.0 on Windows 7
Post Reply