[email protected] wrote:
Hi.
When creating user specify the host (-h) option. Then try to login (psql) using
the user just created (with -h option as well).
Postgres assumes intend authentication if the hostname is not specified.
Cheers.
Mugoma,
Yengas.
Thank you for the reply.
I tried dropping oerp user and creating it again. The process fails if I
pass -h parameter to createuser but it works if I remove the -h
parameter. Check below
-bash-3.2$ createuser --createdb --no-createrole --pwprompt -h localhost
oerp
Enter password for new role:
Enter it again:
Shall the new role be a superuser? (y/n) n
createuser: could not connect to database postgres: FATAL: Ident
authentication failed for user "postgres"
-bash-3.2$ logout
[r...@sys ~]# /etc/init.d/postgresql status
postmaster (pid 3232 3231 3230 3229 3227 3222) is running...
[r...@sys ~]# su - postgres
-bash-3.2$ createuser --createdb --no-createrole --pwprompt oerp
Enter password for new role:
Enter it again:
Shall the new role be a superuser? (y/n) n
I have seemingly got past this by setting the password for the user
tinyerp. Your reply was useful in this context as I read up on ident and
got the reason as to why the error is occuring.
Now, though I have a altogether different problem. Here is it's traceback.
-----xxxxx-----
Traceback (most recent call last):
File "./openerp-server.py", line 108, in <module>
pooler.get_db_and_pool(db, update_module=tools.config['init'] or
tools.config['update'])
File "/usr/lib/python2.5/site-packages/openerp-server/bin/pooler.py",
line 40, in get_db_and_pool
addons.load_modules(db, force_demo, status, update_module)
File
"/usr/lib/python2.5/site-packages/openerp-server/bin/addons/__init__.py",
line 692, in load_modules
cr.execute("SELECT name from ir_module_module WHERE state in (%s)" %
','.join(['%s']*len(STATES_TO_LOAD)), STATES_TO_LOAD)
File "/usr/lib/python2.5/site-packages/openerp-server/bin/sql_db.py",
line 76, in wrapper
return f(self, *args, **kwargs)
File "/usr/lib/python2.5/site-packages/openerp-server/bin/sql_db.py",
line 118, in execute
res = self._obj.execute(query, params)
psycopg2.ProgrammingError: relation "ir_module_module" does not exist
-----xxxxx-----
This error only occurs when running the init script and not when
executing openerp-server.py from the command line manually. In the
latter case there is no error.
With Regards,
Mehul Ved
_______________________________________________
Tinyerp-users mailing list
http://tiny.be/mailman/listinfo/tinyerp-users
