Changed to Postgresql 9.1 and it worked, also I can connect to pqsl with
root user.
Thank you to all.
On 9 September 2013 18:48, Massimo Di Pierro massimo.dipie...@gmail.comwrote:
You need postgresql 8.2+. postgresql 8.1 does not allow you changing the
string escaping and, by default, it is
Postgresql would not allow root as a database user. It is also not safe to
work with 'postgres' as your normal user for normal day-to-day usage as
postgres is the superuser for Postgresql. So you have to create a user in
postgresql, create the correct database with the user you created as owner,
Change the platform: windows XP and postgresql 8.1,
everything local, no root user, but now trys 5 seconds
and give this error:
type 'exceptions.RuntimeError' Failure to connect, tried 5 times:
Traceback (most recent call last): File
/home/mdipierro/make_web2py/web2py/gluon/dal.py, line 7413, in
You need postgresql 8.2+. postgresql 8.1 does not allow you changing the
string escaping and, by default, it is non conform to the SQL standard.
This results in a security issue with web2py. You must upgrade.
On Monday, 9 September 2013 10:43:55 UTC-5, Sartglider wrote:
Change the platform:
Postgres probably doesn't have 'root' as user. Its root user is 'postgres'.
After that check if your address is allowed to connect to postgres server
in pg_hba.conf and if server is listening on your network
('listen_addresses' setting in postgresql.conf). It could also be a
firewall issue,
Actually it as a root user because all application connect to the server by
root, the other software is made with
python pscopg2.
I try to connect by psql from the server that as web2py and it worked,
also create a model with this script:
This is odd. Normally, web2py flushes a html error saying that he tried to
connect five times (i guess) but with no success. Have you tried to look
the sql.log? And try check the params that Dragan described to you.
Em domingo, 8 de setembro de 2013 12h47min38s UTC-3, Sartglider escreveu:
7 matches
Mail list logo