db error on first login

[colmconn]

Greetings,

I've finally managed to get phpscheduleit 1.2.7 to authenticate aginst my OpenLDAP server, however when I login for the first time using a user id in the LDAP server I get this error message:

There was an error executing your query:
DB Error: no such field INSERT INTO permission (memberid, machid) SELECT "sc1468e696f49362", machid FROM resources WHERE autoassign=1 [nativecode=ERROR: column "sc1468e696f49362" does not exist]

The data base in this case was newly created and is running on postgresql 7.4. I'm using PHP 4.3.9 and apache 2.0

When I login using the same user id and password as before this error does not occur. Any idea what's causing it?

Also this user id treated as an ordinary user and not admin even though it is the first login to the system (with a freshly created DB). I set the adminEmail to be the userid (not email) of the first person who would login. I figured it would be the same as if phpscheduleit was managing the user db itself. Is this not the case when authenticating against LDAP? How does on set up the admin a/c when authenticating against LDAP.

Also would it be much trouble to retrieve group associations from LDAP instead of in the sql database?

Thanks,

Colm.

[Nick]

Probably a compatibility issue with Postgres.  Try changing line 186 of lib/db/AuthDB.class.php to:

      $sql = 'INSERT INTO ' . $this->get_table('permission') . ' (memberid, machid) SELECT "' . $id . '" as memberid, machid FROM ' . $this->get_table('resources') . ' WHERE autoassign=1';

[colmconn]

unfortunately this made no difference. i still get the error message when i login for the first time (on a newly created db).

one thing to note though is that the error makes sense as the resource table is empty. when I run selet * from resources; i get this:

phpscheduleit=> select * from resources;
 machid | scheduleid | name | location | rphone | notes | status | minres | maxres | autoassign | approval | allow_multi | max_participants | min_notice_time | max_notice_time
--------+------------+------+----------+--------+-------+--------+--------+--------+------------+----------+-------------+------------------+-----------------+-----------------
(0 rows)

Any ideas?

[Nick]

One other quick thing to try is changing that same line to this:

Code:

$sql = 'INSERT INTO ' . $this->get_table('permission') . " (memberid, machid) SELECT '" . $id . "' as memberid, machid FROM " . $this->get_table('resources') . ' WHERE autoassign=1';

Which just changes the quotes to be single instead of double.

[colmconn]

cool, that seems to have done the trick. the only thing is that the first user logging in is not automatically made the admin. the only way to do this seems to be to manually update the sql db.

thanks for your help.

[colmconn]

now when I add a resource i get this error message

There was an error executing your query:
DB Error: no such field INSERT INTO permission (memberid, machid) SELECT memberid, "sc146926d626ebf3" FROM login [nativecode=ERROR: column "sc146926d626ebf3" does not exist]

[colmconn]

i fixed the last error by changing line 791 in AdminDB.class.php to

$sql = 'INSERT INTO ' . $this->get_table(TBL_PERMISSION) . " (memberid, machid) SELECT memberid, '" . $machid . "' FROM " . $this->get_table('login');