Hi. You're getting the error because the (openerp) database is not setup (populated) yet.
You need to put the db_user and db_password in the openerp-server.conf then start the server (without --init). After server is started, start the client and create the database (from File menu). Note: don't login before creating the database. Just 'Cancel' the login prompt and create database first. Cheers. Mugoma, Yengas. Mehul Ved wrote: > [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
