Can not connect to remote MySQL DB from Django -


i having troubles connecting remote mysql server django. setup uses multiple databases:

databases = {     'default': {         'engine': 'django.db.backends.mysql', # add 'postgresql_psycopg2', 'mysql', 'sqlite3' or 'oracle'.         'name': 'ldatabase',                      # or path database file if using sqlite3.         # following settings not used sqlite3:         'user': 'luser',         'password': 'lpass',         'host': '',                      # empty localhost through domain sockets or '127.0.0.1' localhost through tcp.         'port': '',                      # set empty string default.     },     'physics': {         'engine': 'django.db.backends.mysql', # add 'postgresql_psycopg2', 'mysql', 'sqlite3' or 'oracle'.         'name': 'rdatabase',                      # or path database file if using sqlite3.         # following settings not used sqlite3:         'user': 'ruser',         'password': 'rpass',         'host': 'hostname',                      # empty localhost through domain sockets or '127.0.0.1' localhost through tcp.         'port': '3306',                      # set empty string default.     } }

the default db running on localhost (aka client) machine , physics on remote server.

i can connect remote mysql server with:

> mysql -u ruser -prpass -h hostname welcome mysql monitor.  commands end ; or \g. mysql connection id 34714 server version: 5.5.29 mysql community server (gpl) ...

or python

> python python 2.7.3 (default, aug  9 2012, 17:23:57)  [gcc 4.7.1 20120720 (red hat 4.7.1-5)] on linux2 ... >>> import mysqldb >>> con = mysqldb.connect(host='hostname', port=3306, user='ruser', passwd='rpass', db='rdatabase') >>> cursor = con.cursor() >>> cursor.execute('select * rdatabase.labs') 425l

however connection django fails with:

exception value: (2003, "can't connect mysql server on 'hostname' (13)")

in fact, i've tested setup on laptop: laptop client , remote mysql server has same settings. works fine.

please, issue have run out of ideas. maybe there kind of hidden django setting on client machine missing?

find client , server configurations below.

thanks.

client setup

> python python 2.7.3 (default, aug  9 2012, 17:23:57)  [gcc 4.7.1 20120720 (red hat 4.7.1-5)] on linux2 ...  > pip list django (1.5.1) mysql-python (1.2.4) ...  > uname --all linux <hostname> 3.8.9-200.fc18.x86_64 #1 smp fri apr 26 12:50:07 utc 2013 x86_64 x86_64 x86_64 gnu/linux  > mysql welcome mysql monitor.  commands end ; or \g. mysql connection id 31 server version: 5.5.31 mysql community server (gpl)

server setup

> uname --all linux <hostname> 3.6.10-2.fc16.x86_64 #1 smp tue dec 11 18:55:03 utc 2012 x86_64 x86_64 x86_64 gnu/linux  > mysql welcome mysql monitor.  commands end ; or \g. mysql connection id 34712 server version: 5.5.29 mysql community server (gpl)  > cat /etc/mysql.cnf [mysqld] datadir =/var/lib/mysql socket  =/var/lib/mysql/mysql.sock #user   =mysql  # disabling symbolic-links recommended prevent assorted security risks symbolic-links=0 #default-character-set=utf8 max_allowed_packet = 1048576000 [mysqld_safe] log-error   =/var/log/mysqld.log pid-file    =/var/run/mysqld/mysqld.pid  [client] #default-character-set=utf8

the problem selinux prevents apache scripts connect network db default in fedora 18 explained here:

weird mysql python mod_wsgi can't connect mysql server on 'localhost' (49) problem

the solution enable httpd_can_network_connect via:

sudo setsebool -p httpd_can_network_connect_db on

Comments

Post a Comment

Popular posts from this blog

php - cannot display multiple markers in google maps v3 from traceroute result -

i'm newbie in php mysql , google maps v3. have problems in google maps v3. made traceroute web based , map traceroute's result in google maps v3 final project of college education. have try many tutorials didn't work. have tried tutorials in forum nothing worked. problem cannot display multiple markers got location data database. maybe because i'm newbie , not know how do. confuse looping show markers. here code <?php error_reporting(e_all ^ (e_notice)); ini_set('max_execution_time', 360); $enable_log_user = false; global $ip, $host_name, $host_ip; $host = @$_post['host']; $trace = @$_post['trace']; $self = $_server['php_self']; include("phpsqlajax_dbinfo.php"); $connection = mysql_connect ('127.0.0.1', $username, $password); if (!$connection) { die('not connected : ' . mysql_error());} $db_selected = mysql_select_db($database, $connection); if (!$db_selected) { die ('can\'t use db : ...
Read more

c# - DetailsView in ASP.Net - How to add another column on the side/add a control in each row? -

i have detailsview control on page used edit various fields of record, works in respect. i looking way add 1 column (and if works, why not more) right, absolutely read-only, show same fields of record comparison purposes. i aware there no obvious way such thing out of box detailsview . have looked other controls (transposed gridview , recommended formview , listview ), nothing satisfies. have special data binding setup using detailsview , can't out of without losing features. anyone on how "hack in" additional columns (for display only) on detailsview ? the solution have now, use second detailsview , visible set false in aspx. in code, make sure databind hidden detailsview hosts data third column first, initial detailsview named itemdetails . and in item created event, pass third column html rendering of hidden controls (in last code block) : protected void itemdetails_itemcreated(object sender, eventargs e) { if (dataite...
Read more

javascript - firefox memory leak -

i have following script (i use raphaeljs also) draws circle, waits 1 second, draws circle again, etc (you can copy paste - functional, need include raphael raphaeljs.com): <div id="holder"> </div> <script src="raphael.js" type="text/javascript"></script> <script> var paper = raphael(10, 50, 320, 200); var rad = math.pi / 180; var finangle = 0; function sector(cx, cy, r, startangle, endangle, params) { var x1 = cx + r * math.cos(-startangle * rad), x2 = cx + r * math.cos(-endangle * rad), y1 = cy + r * math.sin(-startangle * rad), y2 = cy + r * math.sin(-endangle * rad); return ["m", cx, cy, "l", x1, y1, "a", r, r, 0, +(endangle - startangle > 180), 0, x2, y2]; } var path = sector(100,100,50,0,180); var arc = paper.path(path); function draw() { path = sector(100,100,50,0,finangle); ...
Read more