BIRT report for MYSQL database [message #933942] |
Fri, 05 October 2012 13:36 |
Dejan Vujanic Messages: 67 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 13:44] Report message to a moderator
|
|
|
|
Powered by
FUDForum. Page generated in 0.03456 seconds