Il 20/04/2011 12.53, Martin Rabl wrote: > Hi, Hi and thx for your reply. > > Am 19.04.2011 um 12:29 schrieb Comune di Cossato - Andrea Ferraris: >> I toke the Linux ones and put them in SOgo with psql like that: >> >> INSERT INTO sogo_view VALUES ('alice', 'alice', 'linux-md5-password', >> 'Alice Thompson', 'alice-PV5Ro7/m...@public.gmane.org'); > > Read: http://www.postgresql.org/docs/current/static/functions-string.html
I read it this morning. Thank you. > And try: > INSERT INTO sogo_view VALUES ('alice', 'alice', md5('linux-password-for_md5'), > 'Alice Thompson', 'alice-PV5Ro7/m...@public.gmane.org'); The *big* problem is that I don't know the hundreds clear text passwords of my users, but I have only the linux md5 passwords in /etc/shadow and I'd like to use them, but at now it seems impossible. Andrea Ferraris A.d.S. CED Comune di Cossato Tel. fisso: 015/9893235 Tel. cell.: 329/2107393 -- users@sogo.nu https://inverse.ca/sogo/lists