I checked the production.ini file for the sqlalchemy.url= settings. I see the postgresql://baruwa:[email protected]:5432/baruwa line. Did a su postgres. Then psql -h 127.0.0.1 -U baruwa -d baruwa. Got prompted for the password. Entered the password that is in the production.ini file on the sqlalchemy.url line and got to the psql prompt. Was able to enter \l and \dt commands and \q normally. Sorry if I am on the wrong path here but I might be in over my head at this point.
Angelo ________________________________ From: [email protected] [[email protected]] on behalf of Jeremy McSpadden [[email protected]] Sent: Thursday, July 18, 2013 1:43 PM To: Baruwa users list Subject: Re: [Baruwa] Error using Jeremy centos script in baruwa admin function sqlalchemy.exc.OperationalError: (OperationalError) asynchronous connection failed None None Traceback (most recent call last): Looks like it is unable to connect. -- Jeremy McSpadden Flux Labs, Inc | http://www.fluxlabs.net<http://www.fluxlabs.net/> | Endless Solutions Office : 850-250-5590x101<tel:850-250-5590;101> | Cell : 850-890-2543<tel:850-890-2543> | Fax : 850-254-2955<tel:850-254-2955> On Jul 17, 2013, at 11:38 PM, "Valbuena, Angelo" <[email protected]<mailto:[email protected]>> wrote: I am using the latest centos install script on a 6.3 minimal install and get the following error in the baruwa admin installation section. I don't exactly know where to start looking at what might be wrong and causing the error. New python executable in px/bin/python Installing distribute................................................................................................................................................................................................................................done. Installing pip................done. /home/baruwa/px/lib/python2.6/site-packages/baruwa/model/messages.py:46: SADeprecationWarning: Passing arguments to type object constructor <class 'sqlalchemy.types.Date'> is deprecated date = Column(Date(timezone=True), index=True) /home/baruwa/px/lib/python2.6/site-packages/baruwa/model/messages.py:176: SADeprecationWarning: Passing arguments to type object constructor <class 'sqlalchemy.types.Date'> is deprecated date = Column(Date(timezone=True), index=True) Running setup_app() from baruwa.websetup ---------------------------------------------------------------------------------------------------- 2013-07-18 00:12:11,961 INFO [baruwa.websetup] [MainThread] Creating tables Traceback (most recent call last): File "/home/baruwa/px/bin/paster", line 9, in <module> load_entry_point('PasteScript==1.7.5', 'console_scripts', 'paster')() File "/home/baruwa/px/lib/python2.6/site-packages/paste/script/command.py", line 104, in run invoke(command, command_name, options, args[1:]) File "/home/baruwa/px/lib/python2.6/site-packages/paste/script/command.py", line 143, in invoke exit_code = runner.run(args) File "/home/baruwa/px/lib/python2.6/site-packages/paste/script/appinstall.py", line 68, in run return super(AbstractInstallCommand, self).run(new_args) File "/home/baruwa/px/lib/python2.6/site-packages/paste/script/command.py", line 238, in run result = self.command() File "/home/baruwa/px/lib/python2.6/site-packages/paste/script/appinstall.py", line 456, in command self, config_file, section, self.sysconfig_install_vars(installer)) File "/home/baruwa/px/lib/python2.6/site-packages/paste/script/appinstall.py", line 598, in setup_config mod.setup_app, command, filename, section, vars) File "/home/baruwa/px/lib/python2.6/site-packages/paste/script/appinstall.py", line 614, in _call_setup_app func(command, conf, vars) File "/home/baruwa/px/lib/python2.6/site-packages/baruwa/websetup.py", line 34, in setup_app Base.metadata.create_all(bind=Session.bind) File "/home/baruwa/px/lib/python2.6/site-packages/sqlalchemy/schema.py", line 2737, in create_all tables=tables) File "/home/baruwa/px/lib/python2.6/site-packages/sqlalchemy/engine/base.py", line 1486, in _run_visitor with self._optional_conn_ctx_manager(connection) as conn: File "/usr/lib64/python2.6/contextlib.py", line 16, in __enter__ return self.gen.next() File "/home/baruwa/px/lib/python2.6/site-packages/sqlalchemy/engine/base.py", line 1479, in _optional_conn_ctx_manager with self.contextual_connect() as conn: File "/home/baruwa/px/lib/python2.6/site-packages/sqlalchemy/engine/base.py", line 1669, in contextual_connect self.pool.connect(), File "/home/baruwa/px/lib/python2.6/site-packages/sqlalchemy/pool.py", line 272, in connect return _ConnectionFairy(self).checkout() File "/home/baruwa/px/lib/python2.6/site-packages/sqlalchemy/pool.py", line 425, in __init__ rec = self._connection_record = pool._do_get() File "/home/baruwa/px/lib/python2.6/site-packages/sqlalchemy/pool.py", line 855, in _do_get return self._create_connection() File "/home/baruwa/px/lib/python2.6/site-packages/sqlalchemy/pool.py", line 225, in _create_connection return _ConnectionRecord(self) File "/home/baruwa/px/lib/python2.6/site-packages/sqlalchemy/pool.py", line 318, in __init__ self.connection = self.__connect() File "/home/baruwa/px/lib/python2.6/site-packages/sqlalchemy/pool.py", line 368, in __connect connection = self.__pool._creator() File "/home/baruwa/px/lib/python2.6/site-packages/sqlalchemy/engine/strategies.py", line 80, in connect return dialect.connect(*cargs, **cparams) File "/home/baruwa/px/lib/python2.6/site-packages/sqlalchemy/engine/default.py", line 279, in connect return self.dbapi.connect(*cargs, **cparams) File "/home/baruwa/px/lib/python2.6/site-packages/psycopg2/__init__.py", line 164, in connect conn = _connect(dsn, connection_factory=connection_factory, async=async) File "/home/baruwa/px/lib/python2.6/site-packages/eventlet/support/psycopg2_patcher.py", line 44, in eventlet_wait_callback state = conn.poll() sqlalchemy.exc.OperationalError: (OperationalError) asynchronous connection failed None None Traceback (most recent call last): File "/home/baruwa/px/bin/paster", line 9, in <module> load_entry_point('PasteScript==1.7.5', 'console_scripts', 'paster')() File "/home/baruwa/px/lib/python2.6/site-packages/paste/script/command.py", line 104, in run invoke(command, command_name, options, args[1:]) File "/home/baruwa/px/lib/python2.6/site-packages/paste/script/command.py", line 143, in invoke exit_code = runner.run(args) File "/home/baruwa/px/lib/python2.6/site-packages/paste/script/command.py", line 238, in run result = self.command() File "/home/baruwa/px/lib/python2.6/site-packages/baruwa/commands/createadmin.py", line 119, in command Session.commit() File "/home/baruwa/px/lib/python2.6/site-packages/sqlalchemy/orm/scoping.py", line 149, in do return getattr(self.registry(), name)(*args, **kwargs) File "/home/baruwa/px/lib/python2.6/site-packages/sqlalchemy/orm/session.py", line 693, in commit self.transaction.commit() File "/home/baruwa/px/lib/python2.6/site-packages/sqlalchemy/orm/session.py", line 332, in commit self._prepare_impl() File "/home/baruwa/px/lib/python2.6/site-packages/sqlalchemy/orm/session.py", line 311, in _prepare_impl self.session.flush() File "/home/baruwa/px/lib/python2.6/site-packages/sqlalchemy/orm/session.py", line 1788, in flush self._flush(objects) File "/home/baruwa/px/lib/python2.6/site-packages/sqlalchemy/orm/session.py", line 1870, in _flush flush_context.execute() File "/home/baruwa/px/lib/python2.6/site-packages/sqlalchemy/orm/unitofwork.py", line 372, in execute rec.execute(self) File "/home/baruwa/px/lib/python2.6/site-packages/sqlalchemy/orm/unitofwork.py", line 525, in execute uow File "/home/baruwa/px/lib/python2.6/site-packages/sqlalchemy/orm/persistence.py", line 44, in save_obj uowtransaction) File "/home/baruwa/px/lib/python2.6/site-packages/sqlalchemy/orm/persistence.py", line 139, in _organize_states_for_save states): File "/home/baruwa/px/lib/python2.6/site-packages/sqlalchemy/orm/persistence.py", line 769, in _connections_for_states base_mapper) File "/home/baruwa/px/lib/python2.6/site-packages/sqlalchemy/orm/session.py", line 194, in connection return self._connection_for_bind(bind) File "/home/baruwa/px/lib/python2.6/site-packages/sqlalchemy/orm/session.py", line 266, in _connection_for_bind conn = self._parent._connection_for_bind(bind) File "/home/baruwa/px/lib/python2.6/site-packages/sqlalchemy/orm/session.py", line 277, in _connection_for_bind conn = bind.contextual_connect() File "/home/baruwa/px/lib/python2.6/site-packages/sqlalchemy/engine/base.py", line 1669, in contextual_connect self.pool.connect(), File "/home/baruwa/px/lib/python2.6/site-packages/sqlalchemy/pool.py", line 272, in connect return _ConnectionFairy(self).checkout() File "/home/baruwa/px/lib/python2.6/site-packages/sqlalchemy/pool.py", line 425, in __init__ rec = self._connection_record = pool._do_get() File "/home/baruwa/px/lib/python2.6/site-packages/sqlalchemy/pool.py", line 855, in _do_get return self._create_connection() File "/home/baruwa/px/lib/python2.6/site-packages/sqlalchemy/pool.py", line 225, in _create_connection return _ConnectionRecord(self) File "/home/baruwa/px/lib/python2.6/site-packages/sqlalchemy/pool.py", line 318, in __init__ self.connection = self.__connect() File "/home/baruwa/px/lib/python2.6/site-packages/sqlalchemy/pool.py", line 368, in __connect connection = self.__pool._creator() File "/home/baruwa/px/lib/python2.6/site-packages/sqlalchemy/engine/strategies.py", line 80, in connect return dialect.connect(*cargs, **cparams) File "/home/baruwa/px/lib/python2.6/site-packages/sqlalchemy/engine/default.py", line 279, in connect return self.dbapi.connect(*cargs, **cparams) File "/home/baruwa/px/lib/python2.6/site-packages/psycopg2/__init__.py", line 164, in connect conn = _connect(dsn, connection_factory=connection_factory, async=async) File "/home/baruwa/px/lib/python2.6/site-packages/eventlet/support/psycopg2_patcher.py", line 44, in eventlet_wait_callback state = conn.poll() sqlalchemy.exc.OperationalError: (OperationalError) asynchronous connection failed None None Angelo _______________________________________________ http://pledgie.com/campaigns/12056
_______________________________________________ http://pledgie.com/campaigns/12056
