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.
Howto store a password for jdbc-connection?
Howto store a password for jdbc-connection?
Libre Office on Ubuntu 12.10
Re: Howto store a password for jdbc-connection?
Did you ever find a solution for this? I would like to do the same thing.
OOo 3.0.X on Mac OSx Leopard
Re: Howto store a password for jdbc-connection?
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
-
- Posts: 1
- Joined: Thu Sep 23, 2010 2:56 pm
Re: Howto store a password for jdbc-connection?
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
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
Re: Howto store a password for jdbc-connection?
Hello,
A solution ...
database URL :
Field User name : Empty
Required password : Uncheck
Works fine, direct connection, but not secure
A solution ...
database URL :
Code: Select all
jdbc:postgresql://192.168.0.100:5432/database?user=your_login&password=your_password
Required password : Uncheck
Works fine, direct connection, but not secure
LibreOffice 3.3.0 on Windows 7