Package: dbconfig-common Version: 1.8.39 We'd like to be able to tell dbconfig-common from which machine(IP address) the db connection will be coming from.
We have two servers, a web server and a db server. The webserver has 2 IP, a public one and a private one. The connection to the db server is made other the private network. The webserver hostname resolves to the public IP. Upon installation dbconfig common uses the hostname information to create the database user. But later on the db connection won't be possible as we will use the private IP to connect to the database. Mysql will refuse the connection telling that user 'xyz'@'privateIP' is not allowed to connect. If we look at mysql.user table we can see the connection for user 'xyz' should be coming from the webserver hostname. We have tried installing the db-test-mysql_2.1_all.deb test package provided by dbconfig-common with the servers settings described above. I would suggest to add a question at configuration time asking the IP of machine from which the db connection will be made and if none is provided default to the hostname.
signature.asc
Description: PGP signature
