Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Eclipse Projects » 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 Go to next message
Dejan Vujanic is currently offline Dejan Vujanic
Messages: 66
Registered: October 2011
Member
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]

Report message to a moderator

Re: BIRT report for MYSQL database [message #934184 is a reply to message #933942] Fri, 05 October 2012 14:36 Go to previous message
Jason Weathersby is currently offline Jason Weathersby
Messages: 9167
Registered: July 2009
Senior Member

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:
  


Current Time: Wed Jul 30 15:32:15 EDT 2014

Powered by FUDForum. Page generated in 0.02873 seconds