How to connect to bugzilla mysql database from any other tool

classic Classic list List threaded Threaded
2 messages Options
Reply | Threaded
Open this post in threaded view
|

How to connect to bugzilla mysql database from any other tool

devom
Hello,
I am BugZilla admin and is trying to configure and schedule automatic BugZilla MySQL database backup.

For this I have a software which could connect to any MySQL database running on any Windows machine using mysql database username and password and then can take period backups of mySQL database.

When I am using this software and trying to connect to the BugZilla MySQL database it could not connect although I am supplying the correct BugZilla MySQL database credentials. It says "Failed to connect to MySQL server..."

Please help. Thanks in advance.

Regards,
Devom
_______________________________________________
support-bugzilla mailing list
[hidden email]
https://lists.mozilla.org/listinfo/support-bugzilla
PLEASE put [hidden email] in the To: field when you reply.
Reply | Threaded
Open this post in threaded view
|

Re: How to connect to bugzilla mysql database from any other tool

cthoong
Assume your bugzilla is running on linux system. 2 things could be blocking
the access.

1. iptables

a. check your bugzilla server security settings to ensure it allowed remote
access through mysql port 3306.
    service iptables status

-------------------
Chain INPUT (policy ACCEPT)
....
5    ACCEPT     tcp  --  192.168.0.12      0.0.0.0/0           tcp dpt:3306
-------------------

If not such rule, you need to add it and restart the iptables.

b. You can stop the iptables service to see if iptables blocking remote
access or not. Remember to start it back or this will risks bugzilla.

2. In mysql, grant the remote access to bugzilla DB "bugs" through the
bugzilla account in mysql.

a. Login to mysql as root, then grant the remote access right.

mysql> GRANT SELECT, INSERT, UPDATE, DELETE, INDEX, ALTER, CREATE, LOCK
TABLES, CREATE TEMPORARY TABLES, DROP, REFERENCES ON <DB>.* TO <ID>@'<IP
Address>' IDENTIFIED BY '<password>';

<DB> name of bugzilla DB
<ID> ID to be use/grant for remote login to mysql
<IP Address> Your backup PC's IP Address 192.168.0.12, can put a wildcard %
to allow a subnet 192.168.0.%
<Password> password to be use/grant for remote login to mysql

E.g.
mysql> GRANT SELECT, INSERT, UPDATE, DELETE, INDEX, ALTER, CREATE, LOCK
TABLES, CREATE TEMPORARY TABLES, DROP, REFERENCES ON bugs.* TO
bugs_id@'192.168.0.%' IDENTIFIED BY 'bug_pw';

b. Apply the settings
mysql> FLUSH PRIVILEGES;

c. check to ensure the grant success.
select * from mysql.user;




--
View this message in context: http://mozilla.6506.n7.nabble.com/How-to-connect-to-bugzilla-mysql-database-from-any-other-tool-tp275161p280037.html
Sent from the Bugzilla - Users mailing list archive at Nabble.com.
_______________________________________________
support-bugzilla mailing list
[hidden email]
https://lists.mozilla.org/listinfo/support-bugzilla
PLEASE put [hidden email] in the To: field when you reply.