PostgreSQL + Stoq [RESOLVIDO]

harima
(usa Debian)

Enviado em 11/04/2012 - 13:04h

Boa tarde, alguem poderia me dar uma ajudinha aqui quando ta criando o banco de dados do Stoq ele da erro.e para de criar.


Executing: stoqdbadmin init --no-load-config --no-register-station -v --enable-plugins ecf --create-dbuser -d estoque -H localhost -p 5432 -u stoq -w teste
12:47:12 environ No pt_PT translation found for domain stoqdrivers
psql: FATAL: Peer authentication failed for user "stoq"
stoqcreatedbuser: 'stoq' exists, making sure it can create databases
ALTER ROLE
12:47:18 stoqlib.lib.settings Migrating settings from Stoq.conf
12:47:18 stoqlib.admin Initialize_system
12:47:18 stoqlib.db.database Cleaning database estoque
12:47:18 stoqlib.db.database Dropped database estoque
12:47:19 stoqlib.admin Creating base schema
12:47:19 stoqlib.database.create SCHEMA
12:47:19 stoqlib.db.database Executing SQL script /usr/share/stoq/sql/schema-03.sql
12:47:19 stoqlib.db.database executing psql -U stoq -h localhost -p 5432 -n -q -f - --variable ON_ERROR_STOP= estoque
Traceback (most recent call last):
File "/usr/lib/pymodules/python2.7/stoq/lib/startup.py", line 209, in clean_database
initialize_system()
File "/usr/lib/pymodules/python2.7/stoqlib/database/admin.py", line 339, in initialize_system
create_base_schema()
File "/usr/lib/pymodules/python2.7/stoqlib/database/admin.py", line 299, in create_base_schema
if execute_sql(schema) != 0:
File "/usr/lib/pymodules/python2.7/stoqlib/database/database.py", line 166, in execute_sql
raise SQLError(stderr[:-1])
SQLError: Password for user stoq:
psql: FATAL: password authentication failed for user "stoq"
FATAL: password authentication failed for user "stoq"
12:47:19 stoq.pluginmanager Loading plugin ecf
Traceback (most recent call last):
File "/usr/bin/stoqdbadmin", line 74, in <module>
sys.exit(dbadmin.main(sys.argv))
File "/usr/lib/pymodules/python2.7/stoq/dbadmin.py", line 427, in main
return handler.run_command(options, cmd, args)
File "/usr/lib/pymodules/python2.7/stoq/dbadmin.py", line 93, in run_command
return func(options, *args)
File "/usr/lib/pymodules/python2.7/stoq/dbadmin.py", line 140, in cmd_init
self._enable_plugins(options.plugins.split(','))
File "/usr/lib/pymodules/python2.7/stoq/dbadmin.py", line 194, in _enable_plugins
manager.install_plugin(plugin_name)
File "/usr/lib/pymodules/python2.7/stoqlib/lib/pluginmanager.py", line 191, in install_plugin
if plugin_name in self.installed_plugins_names:
File "/usr/lib/pymodules/python2.7/stoqlib/lib/pluginmanager.py", line 86, in installed_plugins_names
InstalledPlugin.select(connection=get_connection())]
File "/usr/lib/stoqlib/sqlobject/sresults.py", line 169, in __iter__
return self.lazyIter()
File "/usr/lib/stoqlib/sqlobject/sresults.py", line 177, in lazyIter
return conn.iterSelect(self)
File "/usr/lib/stoqlib/sqlobject/dbconnection.py", line 370, in iterSelect
select, keepConnection=False)
File "/usr/lib/stoqlib/sqlobject/dbconnection.py", line 762, in __init__
self.dbconn._executeRetry(self.rawconn, self.cursor, self.query)
File "/usr/lib/stoqlib/sqlobject/dbconnection.py", line 304, in _executeRetry
return cursor.execute(query)
psycopg2.ProgrammingError: relation "installed_plugin" does not exist
LINE 1: ...plugin_name, installed_plugin.plugin_version FROM installed_...
^


ai quando entro no postgresl o banco de dados esta la porem incompleto.

instalei usando o seguinte comando: sudo apt-get install postgresql pgadmin3 stoq
sudo -u postgres createuser stoq -drs -P

se alguem puder ajudar agradeçeria muito.

-----

Depois de insistir tanto na reinstalação deu certo.