Eclipse Community Forums: BIRT » Connecting BIRT to Remote MySQL Server

Home » Archived » BIRT » Connecting BIRT to Remote MySQL Server(Need help on making MySQL connection, if feasible.)

Connecting BIRT to Remote MySQL Server [message #700092]

Fri, 22 July 2011 16:30

Eclipse User

I have multiple databases I have had no trouble properly connecting to on my laptop, but I have one on my work server that I need to connect to. I can't make a database dump because the MySQL database is too large for my laptop at this point in time. Does anyone have any suggestions for getting BIRT to connect remotely to the server and accessing the database?

I have previously used the com.mysql.jdbc.Driver (v5.1) on my laptop to connect locally to databases. Need more insight on this if anyone has it.

Re: Connecting BIRT to Remote MySQL Server [message #700096 is a reply to message #700092]

Fri, 22 July 2011 16:35

Eclipse User

Does setting the jdbc url to point to the remove machine not work?

Jason

On 7/22/2011 4:30 PM, Selena wrote:
> I have multiple databases I have had no trouble properly connecting to
> on my laptop, but I have one on my work server that I need to connect
> to. I can't make a database dump because the MySQL database is too large
> for my laptop at this point in time. Does anyone have any suggestions
> for getting BIRT to connect remotely to the server and accessing the
> database?
>
> I have previously used the com.mysql.jdbc.Driver (v5.1) on my laptop to
> connect locally to databases. Need more insight on this if anyone has it.

Re: Connecting BIRT to Remote MySQL Server [message #700103 is a reply to message #700096]

Fri, 22 July 2011 16:57

Eclipse User

The database is on a server that I don't have administrative privileges over. I am simply needing to generate some reports from the database stored on there. I have tried with the standard URL, but I sense that maybe I can't access it because I don't have administrative rights. Could this be an issue? Here is a couple of examples that I have previously tried

Quote:

jdbc:MySQL://someserver.com/someDB

and

Quote:

jdbc:MySQL://someserver.com:port#/someDB

Re: Connecting BIRT to Remote MySQL Server [message #700372 is a reply to message #700103]

Sat, 23 July 2011 05:08

Eclipse User

Originally posted by: Donkey Hottie

22.7.2011 23:57, Selena kirjoitti:
> The database is on a server that I don't have administrative privileges
> over. I am simply needing to generate some reports from the database
> stored on there. I have tried with the standard URL, but I sense that
> maybe I can't access it because I don't have administrative rights.
> Could this be an issue? Here is a couple of examples that I have
> previously tried
>
> Quote:
>> jdbc:MySQL://someserver.com/someDB
>
>
> and
>
> Quote:
>> jdbc:MySQL://someserver.com:port#/someDB
>

Administrative rights is not an issue here. But two factors are:

1) is the MySQL listening on its network interface? Often it is put to
listen only localhost, for security reasons.

2) firewall? Is the MySQL opened for external access? If the server is
on internet, probably not.

--

Afternoon very favorable for romance. Try a single person for a change.

Previous Topic:	APIs error conection
Next Topic:	Birt 3.7 OdaException

Goto Forum:

-=] Back to Top [=-

Current Time: Thu Jul 24 14:22:58 EDT 2025

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter