Sun MySQL OpenOffice connector

[Zsemlye Marian]

Hi.

 

I have been using your Alpha1 version of OpenOffice to MySQL Native Connector, wtich was build for OOo 2.4

The new version Alpha2/Beta1 for OOo 3.1 unfortunatelly does not support the remote MySQL connect - trought IP and internet.

On the local network is everything OK, but trought internet it generate no connection.

Version Alpha1 on OOo 2.4 is still working fine.

 

 

Thanks for help

 

Marian Zsemlye
Vedúci odd. IT / EDV Leiter / IT Leader

Alu König Frankstahl Slovensko s. r. o.
Poľná 4
903 01 Senec
Slovensko

T: +421 /2/ 40 20 49 62
F: +421 /2/ 45 65 03 17

M: +421 /903/ 401 153
E-mail: m.zsemlye <mailto:m.zsemlye@...> @akfs.sk  

http://  <blocked::http://www.akfs.sk> www.akfs.sk

 



__________ Informacia od ESET NOD32 Antivirus, verzia databazy 4115 (20090529) __________

Tuto spravu preveril ESET NOD32 Antivirus.

http://www.eset.sk

[Mechtilde Stehmann-2]

Hello,

Zsemlye Marian schrieb:
> Hi.
>

> The new version Alpha2/Beta1 for OOo 3.1 unfortunatelly does not
> support the remote MySQL connect - trought IP and internet.

Do you get an error message?

Which OS at server and client.
>
> On the local network is everything OK, but trought internet it
> generate no connection.

We need more information.

Regards

Mechtilde


--
Dipl. Ing. Mechtilde Stehmann
## http://de.openoffice.org
## Ansprechpartnerin für die deutschsprachige QA
## Freie Office-Suite für Linux, Mac, Windows, Solaris
## Meine Seite http://www.mechtilde.de
## PGP encryption welcome! Key-ID: 0x53B3892B


---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@...
For additional commands, e-mail: users-help@...

[Zsemlye Marian]

Hi.

 

Thanks for answer and I will give you more details :

 

By connection (or by the try) I always get an error message :

"Lost connection to MySQL server at 'waiting for initial communication packet,', system error :2".

 

I use the linux server (Fedora 10) with MySQL Sever 5.1.34 (will be upgraded to 5.1.35).

As a client is used OpenOffice 3.1 on Windows XP Profesional and Linux (Fedora 10).

 

Old version was removed. Only the new version is installed.

 

MySQL can be connected via IP with other programs (MySQL Quary Browser, OpenOffice 2.4 with Alpha1 connection....).

 

Java runtime is istalled and set up.

 

 

Thanks for your help

 

 

Marian Zsemlye
Vedúci odd. IT / EDV Leiter / IT Leader

Alu König Frankstahl Slovensko s. r. o.
Poľná 4
903 01 Senec
Slovensko

T: +421 /2/ 40 20 49 62
F: +421 /2/ 45 65 03 17

M: +421 /903/ 401 153
E-mail: m.zsemlye <mailto:m.zsemlye@...> @akfs.sk  

http://  <blocked::http://www.akfs.sk> www.akfs.sk

 

[frank.schoenheit]

Hello,

> I have been using your Alpha1 version of OpenOffice to MySQL Native
> Connector, wtich was build for OOo 2.4
>
> The new version Alpha2/Beta1 for OOo 3.1 unfortunatelly does not
> support the remote MySQL connect - trought IP and internet.
>
> On the local network is everything OK, but trought internet it
> generate no connection.
>
> Version Alpha1 on OOo 2.4 is still working fine.

Please submit an issue for this at
http://www.openoffice.org/issues/enter_bug.cgi?component=Database%20access&subcomponent=MySQL%20Connector%2FOOo.

I'll try to reproduce, but I might have problems finding a non-intranet
MySQL server for testing :-\
Anybody knows where to quickly get a free MySQL server to test this
(outside the Sun network)?

Ciao
Frank

--
- Frank Schönheit, Software Engineer         frank.schoenheit@... -
- Sun Microsystems                      http://www.sun.com/staroffice -
- OpenOffice.org Base                       http://dba.openoffice.org -
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -

---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@...
For additional commands, e-mail: users-help@...

[Fernand Vanrie]

Frank ,

We found this problems on our "Windows Network" = "intranet" is suppose
You must(can)  reproduce the same behavior on your Sun Network unless
the Connector is allergic to MS servers :-)

If needed i can force our Network gui's to open the MySQL for your
testing, just let me know

> Hello,
>
>  
>> I have been using your Alpha1 version of OpenOffice to MySQL Native
>> Connector, wtich was build for OOo 2.4
>>
>> The new version Alpha2/Beta1 for OOo 3.1 unfortunatelly does not
>> support the remote MySQL connect - trought IP and internet.
>>
>> On the local network is everything OK, but trought internet it
>> generate no connection.
>>
>> Version Alpha1 on OOo 2.4 is still working fine.
>>    
>
> Please submit an issue for this at
> http://www.openoffice.org/issues/enter_bug.cgi?component=Database%20access&subcomponent=MySQL%20Connector%2FOOo.
>
> I'll try to reproduce, but I might have problems finding a non-intranet
> MySQL server for testing :-\
> Anybody knows where to quickly get a free MySQL server to test this
> (outside the Sun network)?
>
> Ciao
> Frank
>
>  

---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@...
For additional commands, e-mail: users-help@...

[frank.schoenheit]

Hi Fernand,

> We found this problems on our "Windows Network" = "intranet" is suppose
> You must(can)  reproduce the same behavior on your Sun Network unless
> the Connector is allergic to MS servers :-)

so you say that any host other than "localhost" does not work for you,
if specified by IP address?

Hmm, cannot reproduce. What exactly do you mean with "MS server"? I
tried with some Windows Server 2003, where one of our MySQL servers is
running. Connecting via IP address works like a charm.
(And my client ran on some Windows machine, too.)

Do you use standard ports? Does the very same connection work if you do
not use the IP address, but the machine name?

IIRC, you can enable tracing for the MySQL Connector/C++ (that's the one
underlying our extension, and doing a lot of the real work) by setting
an environment variable MYSQLCPPCONN_TRACE_ENABLED to something non-empty.

Unfortunately, this prints to STDOUT, which isn't easy to capture on
Windows. I know two ways to do that: First, you could use cygwin, but
it's unlikely you have this at hand :) Second, it should be possible to
copy the "unopkg.com" in your "program" directory to "soffice.com", and
start "soffice.com", which in theory will automatically start
"soffice.exe", and capture its output. Unfortunately, this didn't work
in my 3.1 installation here.

Any other ideas anybody?

Perhaps the log could give a hint what's going on.

> If needed i can force our Network gui's to open the MySQL for your
> testing, just let me know

May need to come back to this, thanks for the offer.

Ciao
Frank

--
- Frank Schönheit, Software Engineer         frank.schoenheit@... -
- Sun Microsystems                      http://www.sun.com/staroffice -
- OpenOffice.org Base                       http://dba.openoffice.org -
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -

---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@...
For additional commands, e-mail: users-help@...

[Fernand Vanrie]

Frank ,

Sorry but I think I replyed to the wrong tread, we have no problems to
"connect" my reply was intented to the "slowness" problem when accesing
large tables.
BTW:Our offer stays to open a server for you

Fernand

>
>  
>> We found this problems on our "Windows Network" = "intranet" is suppose
>> You must(can)  reproduce the same behavior on your Sun Network unless
>> the Connector is allergic to MS servers :-)
>>    
>
> so you say that any host other than "localhost" does not work for you,
> if specified by IP address?
>
> Hmm, cannot reproduce. What exactly do you mean with "MS server"? I
> tried with some Windows Server 2003, where one of our MySQL servers is
> running. Connecting via IP address works like a charm.
> (And my client ran on some Windows machine, too.)
>
> Do you use standard ports? Does the very same connection work if you do
> not use the IP address, but the machine name?
>
> IIRC, you can enable tracing for the MySQL Connector/C++ (that's the one
> underlying our extension, and doing a lot of the real work) by setting
> an environment variable MYSQLCPPCONN_TRACE_ENABLED to something non-empty.
>
> Unfortunately, this prints to STDOUT, which isn't easy to capture on
> Windows. I know two ways to do that: First, you could use cygwin, but
> it's unlikely you have this at hand :) Second, it should be possible to
> copy the "unopkg.com" in your "program" directory to "soffice.com", and
> start "soffice.com", which in theory will automatically start
> "soffice.exe", and capture its output. Unfortunately, this didn't work
> in my 3.1 installation here.
>
> Any other ideas anybody?
>
> Perhaps the log could give a hint what's going on.
>
>  
>> If needed i can force our Network gui's to open the MySQL for your
>> testing, just let me know
>>    
>
> May need to come back to this, thanks for the offer.
>
> Ciao
> Frank
>
>  

---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@...
For additional commands, e-mail: users-help@...

[frank.schoenheit]

Hi Fernand,

> Sorry but I think I replyed to the wrong tread, we have no problems to
> "connect" my reply was intented to the "slowness" problem when accesing
> large tables.

Ah, okay.

> BTW:Our offer stays to open a server for you

Okay, please send me data by private mail (frank.schoenheit@...),
let's see if I can find something in the C/C++ code (unfortunately, the
main developers are on vacation :-\ - Drew, no comments, please :) )

Ciao
Frank

--
- Frank Schönheit, Software Engineer         frank.schoenheit@... -
- Sun Microsystems                      http://www.sun.com/staroffice -
- OpenOffice.org Base                       http://dba.openoffice.org -
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -

---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@...
For additional commands, e-mail: users-help@...