Eclipse Community Forums: BIRT » BIRT report for MYSQL database

Home » Archived » BIRT » BIRT report for MYSQL database(Connection to mysql database is not allowed)

BIRT report for MYSQL database [message #933942]

Fri, 05 October 2012 09:36

Eclipse User

Hi,

I created BIRT report and it works fine on my lap-top.
MySQL database by default does not allow remote connection to it so my report could not be run on the server.
I also wasn't able to make connection from Eclipse to MySQL database because of that remote connection so I changed /etc/mysql/my.cnf configuration file. (http://www.ghacks.net/2009/12/27/allow-remote-connections-to-your-mysql-server/)

MYSQL sever is on example on 192.168.0.1 address and my IP address is on example 192.168.0.41

I just commented line bind address:

[client]
port = 3306
socket = /var/run/mysqld/mysqld.sock

# This was formally known as [safe_mysqld]. Both versions are currently parsed.
[mysqld_safe]
socket = /var/run/mysqld/mysqld.sock
nice = 0

user = mysql
socket = /var/run/mysqld/mysqld.sock
port = 3306
basedir = /usr
datadir = /var/lib/mysql
tmpdir = /tmp
skip-external-locking
#
# Instead of skip-networking the default is now to listen only on
# localhost which is more compatible and is not less secure.
#bind-address = 127.0.0.1

And also did:
GRANT ALL ON *.* TO root@'192.168.0.41' IDENTIFIED BY 'my_password';

BIRT report is imported on server 192.168.0.3. But it can be run by anyone.
How can I made this report available for everyone to run it?
Does anyone created reports for MYSQL (this is my first one) and had similar problems because of MYSQL does not allow remote connection?

Thank you

[Updated on: Fri, 05 October 2012 09:44] by Moderator

Re: BIRT report for MYSQL database [message #934184 is a reply to message #933942]

Fri, 05 October 2012 14:36

Eclipse User

Have you looked at these threads?
http://www.birt-exchange.org/org/forum/index.php/topic/21526-connection-to-mysql-database/
and
http://www.eclipse.org/forums/index.php/m/700372/

Jason

Previous Topic:	how to change this prompt for each supported language - birt.viewer.progressbar.prompt
Next Topic:	How to import BIRT report on Sugar CRM?

Goto Forum:

-=] Back to Top [=-

Current Time: Wed Jul 16 08:34:14 EDT 2025

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter