FUDforum: Bug Reports » ldap user login

Home » FUDforum Development » Bug Reports » ldap user login (SQL error with ldap plugin - duplicate key)

Show: Today's Messages :: Polls :: Message Navigator

ldap user login [message #162421]

Fri, 07 May 2010 23:12

lbrigman124

Messages: 26
Registered: March 2010

Karma: 0

Junior Member

I am getting a user error on auto registration with the
ldap plugin. I have updated to the 4953 svn version.

(/var/www/html/forums/index.php:98
/var/www/html/forums/index.php:194
/var/www/html/forums/theme/default/login.php:198
/var/www/FUDforum/plugins/ldap/ldap.plugin:98
:
/var/www/FUDforum/include/plugins.inc:28
/var/www/html/forums/theme/default/login.php:629
/var/www/html/forums/index.php:1257
) : ERROR: duplicate key violates unique constraint "fud30_users_i_e"
Query: INSERT INTO fud30_users ( login, alias, passwd, salt, name, email, icq, aim, yahoo, msnm, jabber, affero, google, skype, twitter, posts_ppg, time_zone, bday, last_visit, conf_key, user_image, join_date, location, theme, occupation, interests, referer_id, last_read, sig, home_page, bio, users_opt, reg_ip, topics_per_page, flag_cc, flag_country ) VALUES ( 'dromrell', 'dromrell', 'f673f90518cb8c45df5c1b29d209b0b99253eb06', '007307c68', '', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 40, 'America/Los_Angeles', 0, 1273273025, '', NULL, 1273273025, NULL, 1, NULL, NULL, 0, 1273273025, NULL, NULL, NULL, 4357012, 2130706433, 40, NULL, NULL )
_GET: array ( 't' => 'login', )
_POST: array ( 'login' => 'dromrell', 'password' => 'xxxxxxxx', 'use_cookie' => 'Y', 'S' => '1f1dbe2e5b2be2eeb4dcef9f0a2f734f', 'SQ' => '0', 'adm' => '', )
Database Version: PostgreSQL 8.1.18 on x86_64-redhat-linux-gnu, compiled by GCC gcc (GCC) 4.1.2 20080704 (Red Hat 4.1.2-46)
[Referring Page] http://xfiles/forums/index.php?t=login&S=1f1dbe2e5b2be2eeb4dcef9f0a2f73 4f

Report message to a moderator

Re: ldap user login [message #162422 is a reply to message #162421]

Sat, 08 May 2010 02:11

naudefj

Messages: 3771
Registered: December 2004

Karma: 28

Senior Member
Administrator
Core Developer

It fails on a duplicate e-mail address '' (empty string). Try to assign a NULL or dummy e-mail address in the plugin. For example:

$uent->email = $login .'@'. $ini['LDAP_HOST'];

Report message to a moderator

Previous Topic:	NNTP Syncing :: Header for Reply from Email Notification Doesn't Contain Reference in Header
Next Topic:	log files and external scripts problem

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Nov 10 15:31:58 GMT 2024

Total time taken to generate the page: 0.02423 seconds