Hi,
The following code was working when using SQLite, and now that I have moved
to postgres it is failing:
auth.login_bare(request.vars.email, request.vars.password)
I have the passwords for the time being in plaintext, both in postgres and
SQLite. I have imported the data to postgres like this:
# PRAGMA and AUTOINCREMENT are not supported in postgres
# sqlite_sequence is specific to sqlite
sqlite3 storage.sqlite .dump | sed -e
'/^PRAGMA/d;/sqlite_sequence/d;s/AUTOINCREMENT//' > /tmp/from_sqlite.sql
sudo -u postgres PGPASSWORD=mypass psql -h localhost -U myuser -d
web2py_wavportal < /tmp/from_sqlite.sql
I have verified that the data in postgres looks fine:
web2py_wavportal=# \dt
List of relations
Schema | Name | Type | Owner
--------+-----------------+-------+-----------
public | auth_cas | table | wavportal
public | auth_event | table | wavportal
public | auth_group | table | wavportal
public | auth_membership | table | wavportal
public | auth_permission | table | wavportal
public | auth_user | table | wavportal
public | fulluser | table | wavportal
(7 rows)
The credentials in auth_user are as expected, but auth.login_bare is
failing. Why could that be?
Thanks,
Daniel
--
