[dokuwiki] Re: SMF integration
- From: Lunatic <lunatic@xxxxxxxx>
- To: dokuwiki@xxxxxxxxxxxxx
- Date: Fri, 6 Jan 2006 17:29:40 +0100
Le Vendredi 6 Janvier 2006 13:27, Matthias Grimm a écrit :
> On Fri, 6 Jan 2006 11:58:49 +0100
>
> Lunatic <lunatic@xxxxxxxx> wrote:
> > Hello,
> >
> > I try for several days to integrate SMF with dokuwiki, without success. I
> > always get a bad password / unknown username error.
>
> This error message appear after checkPass has failed. Your SQL below
> looks good for me so lets do some basic checks:
>
> 1. Do you run the development tree of Dokuwiki? The SQL statements you
> defined will only work with the development tree. see
> http://wiki.splitbrain.org/wiki:auth_mysql to configure the current
> stable release.
Yes I run the development tree which dates from 2005-12-27
> 2. Is your local.php formally correct? PHP will deny the whole file if
> it contains syntax errors. Please check your webserver's log file
> for error messages.
I've checked and re-checked this file, all seem to be ok. No syntax errors, no
errors messages in log file.
> 3. If the answers to the first two questions will be 'yes', please post
> the definition of the smf_members table and it's contents for further
> investigation. Please filter the information and _don't_ send any
> secret passwords to the list.
>
Ok, here is the complete definition of the table :
CREATE TABLE `smf_members` (
`ID_MEMBER` mediumint(8) unsigned NOT NULL auto_increment,
`memberName` varchar(80) NOT NULL default '',
`dateRegistered` int(10) unsigned NOT NULL default '0',
`posts` mediumint(8) unsigned NOT NULL default '0',
`ID_GROUP` smallint(5) unsigned NOT NULL default '0',
`lngfile` tinytext NOT NULL,
`lastLogin` int(10) unsigned NOT NULL default '0',
`realName` tinytext NOT NULL,
`instantMessages` smallint(5) NOT NULL default '0',
`unreadMessages` smallint(5) NOT NULL default '0',
`pm_ignore_list` text NOT NULL,
`passwd` varchar(64) NOT NULL default '',
`emailAddress` tinytext NOT NULL,
`personalText` tinytext NOT NULL,
`gender` tinyint(4) unsigned NOT NULL default '0',
`birthdate` date NOT NULL default '0001-01-01',
`websiteTitle` tinytext NOT NULL,
`websiteUrl` tinytext NOT NULL,
`location` tinytext NOT NULL,
`ICQ` tinytext NOT NULL,
`AIM` varchar(16) NOT NULL default '',
`YIM` varchar(32) NOT NULL default '',
`MSN` tinytext NOT NULL,
`hideEmail` tinyint(4) NOT NULL default '0',
`showOnline` tinyint(4) NOT NULL default '1',
`timeFormat` varchar(80) NOT NULL default '',
`signature` text NOT NULL,
`timeOffset` float NOT NULL default '0',
`avatar` tinytext NOT NULL,
`pm_email_notify` tinyint(4) NOT NULL default '0',
`karmaBad` smallint(5) unsigned NOT NULL default '0',
`karmaGood` smallint(5) unsigned NOT NULL default '0',
`usertitle` tinytext NOT NULL,
`notifyAnnouncements` tinyint(4) NOT NULL default '1',
`notifyOnce` tinyint(4) NOT NULL default '1',
`memberIP` tinytext NOT NULL,
`secretQuestion` tinytext NOT NULL,
`secretAnswer` varchar(64) NOT NULL default '',
`ID_THEME` tinyint(4) unsigned NOT NULL default '0',
`is_activated` tinyint(3) unsigned NOT NULL default '1',
`validation_code` varchar(10) NOT NULL default '',
`ID_MSG_LAST_VISIT` int(10) unsigned NOT NULL default '0',
`additionalGroups` tinytext NOT NULL,
`smileySet` varchar(48) NOT NULL default '',
`ID_POST_GROUP` smallint(5) unsigned NOT NULL default '0',
`totalTimeLoggedIn` int(10) unsigned NOT NULL default '0',
`passwordSalt` varchar(5) NOT NULL default '',
`t_bookmarks` tinytext NOT NULL,
`messageLabels` text NOT NULL,
`buddy_list` tinytext NOT NULL,
`notifySendBody` tinyint(4) NOT NULL default '0',
`notifyTypes` tinyint(4) NOT NULL default '2',
PRIMARY KEY (`ID_MEMBER`),
KEY `memberName` (`memberName`(30)),
KEY `dateRegistered` (`dateRegistered`),
KEY `ID_GROUP` (`ID_GROUP`),
KEY `birthdate` (`birthdate`),
KEY `posts` (`posts`),
KEY `lastLogin` (`lastLogin`),
KEY `ID_POST_GROUP` (`ID_POST_GROUP`),
KEY `lngfile` (`lngfile`(24))
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
It's an InnoDB table, but it was a "MyISAM" table few hours ago, when I
already had my problem. Here is the record corresponding to my account (not
in the whole) :
INSERT INTO `smf_members` VALUES
('2','Lunatic','1021746519','8321','1','french','1136564813','Lunatic','159','0','','***password***','lunatic@xxxxxxxx'
(etc.));
I hope it's you're asking for :-/
Thanls for your help :-)
Lunatic.
___________________________________________________________________________
Nouveau : téléphonez moins cher avec Yahoo! Messenger ! Découvez les tarifs
exceptionnels pour appeler la France et l'international.
Téléchargez sur http://fr.messenger.yahoo.com
--
DokuWiki mailing list - more info at
http://wiki.splitbrain.org/wiki:mailinglist
Other related posts:
