#691: I want to use turbogears to access a database which has no password.
-----------------------+----------------------------------------------------
Reporter: anonymous | Owner: anonymous
Type: defect | Status: new
Priority: high | Milestone:
Component: SQLObject | Version: 0.8
Severity: major | Keywords: MySQL .connect password
-----------------------+----------------------------------------------------
When using tg-admin sql create with
sqlobject.dburi="mysql://user:""@host:8080/databasename" in dev.cfg
I see something like this:
Traceback (most recent call last):
File "/home/utils/TurboGears-0.8.9/tg-admin", line 7, in ?
sys.exit(
File "/home/utils/Python-2.4.1/lib/python2.4/site-
packages/TurboGears-0.8.9-py2.4.egg/turbogears/command/__init__.py", line
186, in main
command.run()
File "/home/utils/Python-2.4.1/lib/python2.4/site-
packages/TurboGears-0.8.9-py2.4.egg/turbogears/command/__init__.py", line
106, in run
command.the_runner.run(sys.argv)
File "/home/utils/Python-2.4.1/lib/python2.4/site-packages/SQLObject-0.7
.1dev_r1457-py2.4.egg/sqlobject/manager/command.py", line 102, in run
runner.run()
File "/home/utils/Python-2.4.1/lib/python2.4/site-packages/SQLObject-0.7
.1dev_r1457-py2.4.egg/sqlobject/manager/command.py", line 233, in run
self.command()
File "/home/utils/Python-2.4.1/lib/python2.4/site-packages/SQLObject-0.7
.1dev_r1457-py2.4.egg/sqlobject/manager/command.py", line 550, in command
exists = soClass._connection.tableExists(soClass.sqlmeta.table)
File "/home/utils/Python-2.4.1/lib/python2.4/site-packages/SQLObject-0.7
.1dev_r1457-py2.4.egg/sqlobject/mysql/mysqlconnection.py", line 108, in
tableExists
for (table,) in self.queryAll('SHOW TABLES'):
File "/home/utils/Python-2.4.1/lib/python2.4/site-packages/SQLObject-0.7
.1dev_r1457-py2.4.egg/sqlobject/dbconnection.py", line 316, in queryAll
return self._runWithConnection(self._queryAll, s)
File "/home/utils/Python-2.4.1/lib/python2.4/site-packages/SQLObject-0.7
.1dev_r1457-py2.4.egg/sqlobject/dbconnection.py", line 215, in
_runWithConnection
conn = self.getConnection()
File "/home/utils/Python-2.4.1/lib/python2.4/site-packages/SQLObject-0.7
.1dev_r1457-py2.4.egg/sqlobject/dbconnection.py", line 226, in
getConnection
conn = self.makeConnection()
File "/home/utils/Python-2.4.1/lib/python2.4/site-packages/SQLObject-0.7
.1dev_r1457-py2.4.egg/sqlobject/mysql/mysqlconnection.py", line 43, in
makeConnection
raise self.module.OperationalError(
_mysql_exceptions.OperationalError: (2003, "Can't connect to MySQL server
on 'host' (111)"); used connection string: host=host, port=8080,
db=database, user=user, pwd=
I am not able to remove this error. All paths and libraries seem to be
correctly installed. I am able to connect to the database from the command
prompt. Also I am able to use the MySQLdb.connect in other scripts without
fail.
Please advice
--
Ticket URL: <http://trac.turbogears.org/turbogears/ticket/691>
TurboGears <http://www.turbogears.org/>
TurboGears front-to-back web development
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"TurboGears Tickets" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/turbogears-tickets
-~----------~----~----~----~------~----~------~--~---