Hello Jesus, thanks a mil for your prompt answer! I've deleted the tryton user and recreated it using -P but I still got the same error message. Are the tryton server password and the postgresql user password the same or are they completely different? If they're different, where can I get the tryton server password, or where can I set it?
Again thanks. Le jeudi 8 octobre 2015 09:42:15 UTC+2, Jesús Martín Jiménez a écrit : > > Hi Philippe, > > 2015-10-08 9:27 GMT+02:00 Philippe Côte <[email protected] > <javascript:>>: > >> Hello, >> I'm new on this Group, trying to start with Tryton running Ubuntu 15.04 >> and I have exactly the same issue as Bent with Tryton 3.6. I've created a >> tryton user using su postgres and createuser -s tryton >> > > createuser command has many option parameters [1]. You must put it > explicitly if you want to be asked when you create it. For example: > > createuser --pwprompt --createdb --no-createrole --no-superuser trytonuser > > [1] > $ createuser --help > createuser crea un nuevo rol de PostgreSQL. > > Empleo: > createuser [OPCIÓN]... [ROL] > > Opciones: > -c, --connection-limit=N límite de conexiones para el rol > (predeterminado: sin límite) > -d, --createdb el rol podrá crear bases de datos > -D, --no-createdb el rol no podrá crear bases de datos > (predeterm.) > -e, --echo mostrar las órdenes a medida que se ejecutan > -E, --encrypted almacenar la constraseña cifrada > -g, --role=ROL el nuevo rol será un miembro de este rol > -i, --inherit el rol heredará los privilegios de los roles de > los cuales es miembro (predeterminado) > -I, --no-inherit rol no heredará privilegios > -l, --login el rol podrá conectarse (predeterminado) > -L, --no-login el rol no podrá conectarse > -N, --unencrypted almacenar la contraseña sin cifrar > -P, --pwprompt asignar una contraseña al nuevo rol > -r, --createrole el rol podrá crear otros roles > -R, --no-createrole el rol no podrá crear otros roles > (predeterminado) > -s, --superuser el rol será un superusuario > -S, --no-superuser el rol no será un superusuario (predeterminado) > -V, --version mostrar información de versión y salir > --interactive preguntar los nombres y atributos de rol > faltantes > en lugar de asumir los valores por omisión > --replication el rol podrá iniciar replicación > --no-replication el rol no podrá iniciar replicación > -?, --help mostrar esta ayuda y salir > > Opciones de conexión: > -h, --host=ANFITRIÓN nombre del servidor o directorio del socket > -p, --port=PUERTO puerto del servidor > -U, --username=NOMBRE nombre de usuario con el cual conectarse > (no el usuario a crear) > -w, --no-password nunca pedir contraseña > -W, --password forzar la petición de contraseña > > > >> but i've never been asked to enter a password. And when I try to create a >> new database on localhost:8000 i've got a wrong password error... Am I >> missing something? >> >> Thanks for your help. >> >> Le jeudi 24 septembre 2015 01:37:32 UTC+2, Mark Hayden a écrit : >>> >>> >>> On 23 Sep 2015 4:45 pm, "Bent Hansen" <[email protected]> wrote: >>> > >>> > >>> > >>> > Den søndag den 20. september 2015 kl. 10.15.05 UTC+2 skrev Bent Hansen: >>> >> >>> >> I am running Ubuntu 14.04. Using Synaptic the Tryton server and >>> client was installed including all modules. It just installed out of the >>> box, no issues :-) The Tryton version is 3.02. and the demo is running >>> fine. But when I try to create my own database using File -> Database -> >>> New Database the "Tryton Server Password" is needed. The Server Connection >>> is "demo3.0.tryton.org:8000". >>> >> >>> >> I have tried a lot of different passwords, but the result is always >>> "Access denied!". Reading all the documentation I could find didn't help. >>> So I would appreciate very much if any one could give me a hint? Or how can >>> I use this installation for my own tasks? >>> > >>> > >>> > >>> > Thanks a lot for the fine answers. I have added a password to >>> /etc/trytond.conf. Then the client was executed. The menu File -> Database >>> -> New Database was entered. Server connection was changed to >>> "localhost:8000", the password entered, a database name defined, an admin >>> password defined and confirmed. And then when the Create button is pressed >>> an error message window is displayed: >>> > >>> > "Error creating database! Can't create the database, caused by an >>> unknown reason. If there is a database created, it could be broken. Maybe >>> drop this database! Please check the error message for possible >>> informations. Error message: FATAL:role "tryton" does not exist". >>> > >>> > Maybe I have messed up something. So using Synaptic a complete removal >>> of Tryton was done. And afterwards using Synaptic Tryton was installed >>> again. But the error remains. >>> > From the error message ( FATAL:role "tryton" does not exist) you could >>> assume that Tryton is not running. But as the demo executes fine it seems >>> to be running. Maybe I should try a manual installation. >>> >>> The problem was not with your Tryton installation. Your PostgreSQL >>> database does not have a user called "tryton" set up yet. You can fix this >>> by doing a CREATE USER or CREATE ROLE query to make a tryton database user. >>> Make sure to set the password to the same as your config file uses and >>> grant the tryton user ownership/permissions for the datsbase. >>> >> > > > -- > > Jesús Martín > > Zikzakmedia SL > C/ de Sant Jaume, 9, baixos, 2ª > 08720 Vilafranca del Penedès > ☏ 93 890 21 08 >
