Python script and database connection.

[rohankudtarkar]

Hi,
I wrote a Python scripts, i need to connect this with my database in postgresql, but while running the __init__.py it gives the message that unable to connect to database. Please guide me. my code is as follow...
try:
conn=psycopg2.connect("dbname="+ dbname + "user=" + username + "password=" + password)
print"connected"
except:
print "I am unable to connect to the database, exiting."
sys.exit()

[jlm699]

Hi,
I wrote a Python scripts, i need to connect this with my database in postgresql, but while running the __init__.py it gives the message that unable to connect to database. Please guide me. my code is as follow...
try:
conn=psycopg2.connect("dbname="+ dbname + "user=" + username + "password=" + password)
print"connected"
except:
print "I am unable to connect to the database, exiting."
sys.exit()

On first inspection it looks like you are missing spaces between your string concatenation so that inside the connect function you are passing the following:
"dbname=foobaruser=usrfoopassword=passwd".
I find it easier to make the string first so that you can do some sanity-checking and then passing the string to the connect function. Here's a snippet from a postgresql gui that I made:

dsn = "host=" + dbip + " dbname=" + dbname +\
    " user=" + dbuser + " password=" + dbpass
#Defaults: ip=192.168.100.48 dbname=Tools user=toolsusr password=toolsdb"
try:
    db = psycopg2.connect(dsn)
except:
    #WriteToLogs('Cannot connect to Database, please check your Database Options')
    return
 

Notice the spaces before dbname=, user=, and password= .... HTH