Hi List, I'm new to OpenOffice (been using Linux for some time though), and am having a hard time getting it to connect remotely to a MySQL database.
In the past I've used Navicat to connect remotely to my MySQL databases. For the new server I can connect fine from my Windows Desktop via first going through a port 22 SSH tunnel – Navicat is set up to first get a connection via port 22 and once that's established, I go through port 3306 and all works well, I can go through tables very fast, edit with no problem, etc.. I'm trying to do that same thing on my new Centos Deskop using the OpenOffice 2.3 Calc spreadsheet application running in KDE (instead of Navicat) because I want to go all Linux at home too, (at least as much as possible excepting applications like photoshop), and because I love the way Konqueror works for FTP. Since the Centos 5.1 Distro only comes with OpenOffice 2.0, I upgraded to OO 2.3 so I could get OO Base and the JRE capabilities. So after installing 2.3, I installed both the Java Runtime Environment jre-6u5-linux-x64-rpm.bin and the MySQL JDBC for OpenOffice – MySQL-Connector-Java-5.08 to get the remote dababase connection capabilities for OO. Supposedly they are installed correctly. I disabled SELinux on my desktop machine because OO will not start up if it's enabled, unless (from what I have been told), I use setroubleshoot and IPTables to tweak the system I can get a remote connection to server from Calc via port 3306 non secure (using OpenOffice Calc, and finally last night I was able to get a secure connection via OpenOffice Clac by executing in Terminal: ssh -L 3307:localhost:3306 [EMAIL PROTECTED] and then entering in localhost into the Calc dialog box - OO Calc spreadsheet will then load database tables. The problem in both cases with my Centos desktop, is that with Calc, the scrolling through the data in the tables is very slow, and after about a half minute or so, the tables, and then the entire Calc application freezes up, locks up, and I have to do a CtrAltDelete to restart OpenOffice. So I am wondering if it's a problem server side (which I doubt because it works fine with Navicat) or more likely the way I have my desktop configured for making remote connections. Or maybe I need to log on in a different way or execute a different command to server to do this. Does anyone have any ideas as to why Calc is crashing? Any suggestions as to what I could do to get this working the way I want to? _________________________________________________________________ Climb to the top of the charts! Play the word scramble challenge with star power. http://club.live.com/star_shuffle.aspx?icid=starshuffle_wlmailtextlink_jan --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
