Howto store a password for jdbc-connection?

dBase, Calc, CSV, MS ACCESS, MySQL, PostgrSQL, OTHER

Howto store a password for jdbc-connection?

Postby joris » Wed Sep 17, 2008 2:07 pm

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
User avatar
joris
 
Posts: 20
Joined: Mon Aug 11, 2008 10:15 am

Re: Howto store a password for jdbc-connection?

Postby kidbrax » Thu Dec 04, 2008 4:37 pm

Did you ever find a solution for this? I would like to do the same thing.
OOo 3.0.X on Mac OSx Leopard
kidbrax
 
Posts: 1
Joined: Thu Dec 04, 2008 4:28 pm

Re: Howto store a password for jdbc-connection?

Postby joris » Thu Dec 04, 2008 6:10 pm

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
User avatar
joris
 
Posts: 20
Joined: Mon Aug 11, 2008 10:15 am

Re: Howto store a password for jdbc-connection?

Postby karl.kashofer » Thu Sep 23, 2010 3:00 pm

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
karl.kashofer
 
Posts: 1
Joined: Thu Sep 23, 2010 2:56 pm

Re: Howto store a password for jdbc-connection?

Postby Credomo » Fri Sep 16, 2011 11:55 am

Hello,

A solution ...

database URL :
Code: Select all   Expand viewCollapse view
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
Credomo
 
Posts: 1
Joined: Fri Sep 16, 2011 11:43 am


Return to External Data Sources

Who is online

Users browsing this forum: No registered users and 1 guest