Hi Philippe,
2015-10-08 9:27 GMT+02:00 Philippe Côte <[email protected]>:
> 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
