Login Error

Hi,

i have some strange trouble doing login, for some reason when i try to login, system says "user/pass not found",

but user/pass is correct in the database.

i have a second database with same login details, and when i change it in header.inc.php, i can acccess the site without troubles.

so, there is some restriction or blocking in some table of boonex that is checked in the login process and i dont know, does some one know what can be blocking? maybe some ip filter? dns?

Thanks.

Try to disable the following settings:

Enable DNS Block Lists

Enable "Stop Forum Spam"

in admin panel > tools > antispam tools > settings

it maybe your IP is listed somewhere

Hi,

i edited the database and manually emptied the cache directories, but still the system rejects the login for any user combination i try.

sys_dnsbl_enable

sys_stopforumspam_enable

what else can i try? 

Thanks.

Have you verified that the account you have in the database that works has the exact same password and hash as the one in the database that does not work?

Normally when switching databases, you also have to clear the cache folder as well. Did you do that?

If your sure the databases are exact, then perhaps the profiles table is damaged. Have your tried repairing it.

It's been 3 weeks between your first post and your next reply so you really don't seem to be all that interested in getting this fixed. So why don't you just use the database that works.

Hi deano,

im migrating a system to boonex, i do want to fix this, but cant find the error.

the user password and hash are exactly in both databases.

i manually delete all files from /cache /cache_public and /tmp

i also have tried to change the password using the method from here:

http://www.boonex.com/forums/topic/Reset-Admin-Password.htm

and the system still block the login, so, i assume that there is some kind of checking the system does that is blocking the request, is not in the files, because changing the database solve the problem...

Thanks.

Your assumption is incorrect. If changing the database solves it, then how could it possibly be some other check. If you have cleared the cache, and i mean after you swap the database and the problem persists with one database and not the other then there is only one obvious and logical answer. The database is damaged.

I have now repaired the table Profiles and sys_options (without any error), and cleaned the cache (manually).

the login was still blocked. After that, i swap databases, cleaned the cache again, and was able to login.

which tables you think can be corrupted? o what part of database damaged?

Every time i clean the databases and start the migration, at some point it block the login.

the Profiles database is allright, even if i reset the password it keeps blocking login, no apparent reason.

I spend a lot of money on Dolphin and cant use it, really a shit.

 ?? Migration?

That was not mentioned in any of your previous posts. Perhaps you need to explain that a bit more.

Can you also post a record. A database export of one profile record. The same one from each database that works in one but not the other so we can see if there are any differences.

Im moving a social site to boonex, thats what i mean with migration.

it works fine for some time, but at some point when copying users it begin to block login, some times of admin user, and other times of many or all users. I have cleaned and started the migration several times.

Didnt find changes to the fields in the database

working database:

INSERT INTO `Profiles` (`ID`, `NickName`, `Email`, `Password`, `Salt`, `Status`, `Role`, `Couple`, `Sex`, `LookingFor`, `Headline`, `DescriptionMe`, `Country`, `City`, `DateOfBirth`, `Featured`, `DateReg`, `DateLastEdit`, `DateLastLogin`, `DateLastNav`, `aff_num`, `Tags`, `zip`, `EmailNotify`, `LangID`, `UpdateMatch`, `Views`, `Rate`, `RateCount`, `CommentsCount`, `PrivacyDefaultGroup`, `allow_view_to`, `UserStatus`, `UserStatusMessage`, `UserStatusMessageWhen`, `Avatar`, `Height`, `Weight`, `Income`, `Occupation`, `Religion`, `Education`, `RelationshipStatus`, `Hobbies`, `Interests`, `Ethnicity`, `FavoriteSites`, `FavoriteMusic`, `FavoriteFilms`, `FavoriteBooks`, `FirstName`, `LastName`, `dbcsFacebookProfile`, `interestes`) VALUES

(1, 'admin', 'no-reply@xxxxx.com', '1f7e9e4405467cbcd2b4a5f7fc0de557a40ebe5b', 'gf7uA,M,', 'Active', 3, 0, '', '', '', '', '', '', '0000-00-00', 0, '2014-02-21 20:05:58', '0000-00-00 00:00:00', '2014-08-05 22:19:12', '2014-08-07 00:07:48', 0, '', '', 1, 3, 1, 14, 5, 2, 0, 3, 3, 'online', '', 0, 0, '', '', '', '', '', '', NULL, '', '', '', '', '', '', '', '', '', 0, '');

not working database:

INSERT INTO `Profiles` (`ID`, `NickName`, `Email`, `Password`, `Salt`, `Status`, `Role`, `Couple`, `Sex`, `LookingFor`, `Headline`, `DescriptionMe`, `Country`, `City`, `DateOfBirth`, `Featured`, `DateReg`, `DateLastEdit`, `DateLastLogin`, `DateLastNav`, `aff_num`, `Tags`, `zip`, `EmailNotify`, `LangID`, `UpdateMatch`, `Views`, `Rate`, `RateCount`, `CommentsCount`, `PrivacyDefaultGroup`, `allow_view_to`, `UserStatus`, `UserStatusMessage`, `UserStatusMessageWhen`, `Avatar`, `Height`, `Weight`, `Income`, `Occupation`, `Religion`, `Education`, `RelationshipStatus`, `Hobbies`, `Interests`, `Ethnicity`, `FavoriteSites`, `FavoriteMusic`, `FavoriteFilms`, `FavoriteBooks`, `FirstName`, `LastName`, `dbcsFacebookProfile`, `interestes`) VALUES

(1, 'admin', 'no-reply@xxxxx.com', '1f7e9e4405467cbcd2b4a5f7fc0de557a40ebe5b', 'gf7uA,M,', 'Active', 3, 0, '', '', '', '', '', '', '0000-00-00', 0, '2014-02-21 20:05:58', '0000-00-00 00:00:00', '2014-09-14 18:40:23', '2014-09-14 18:40:31', 0, '', '', 1, 3, 1, 13, 5, 2, 0, 3, 3, 'online', '', 0, 0, '', '', '', '', '', '', NULL, '', '', '', '', '', '', '', '', '', 0, '');

I offer a service for migrating existing websites to Dolphin. Not just profiles, but also avatars, photo's, forums and friend lists.

http://www.boonex.com/m/denre-s-migration-service

I would take Denre up on the migration service.

What is the code you are using to generate the password and salt for each profile before it is inserted into the Dolphin Profiles table?  That has to be done by Dolphin method or you will have logon issues.

Deano does have a module where you can use different password encryption methods; not sure how that would be used when migrating Profiles, it would depend on how the site you are migrating does the password encryption.

Only thing i can think of that may be a problem is if during your migration you end up with duplicates of the NickName or Email fields which may result in dolphin trying to pull the wrong one.

Those database entries you posted look fine, so check your non working database for a duplicate nickname or email address.

Also. Dolphin logins can be done with member id, nickname or email as a username when logging in. Not sure which your trying to log in with, but try all 3 methods and see if any of them work.

Hi deano,

i checked for duplicates before and thats not the problem, no duplicates on email, nickname or (autoincrement) id.

i tried to login using email/nickname, i also changed manually on database the nickname or email of admin, cleaned the tmp/cache/cache_public directories, and still blocked.

even i can copy salt and password from other user and not work, but still log with other user.

Really strange issue.

Hi geekgirl,

i use the boonex method to make password and salt, it works, but at certain moment, when i migrate users it block me from some logins, the database is ok, has no apparent reason to do so...

even if i reset password directly from database, or copy other password/hash it fails.

boonex code:

// Generate Random Password

function genRndPwd($iLength = 8, $bSpecialCharacters = true)

{

    $sPassword = '';

    $sChars = "abcdefghijkmnpqrstuvwxyzABCDEFGHJKLMNPQRSTUVWXYZ23456789";

    if($bSpecialCharacters === true)

        $sChars .= "!?=/&+,.";

    srand((double)microtime()*1000000);

    for($i = 0; $i < $iLength; $i++) {

        $x = mt_rand(0, strlen($sChars) -1);

        $sPassword .= $sChars{$x};

    }

    return $sPassword;

}

// Generate Random Salt for Password encryption

function genRndSalt()

{

    return genRndPwd(8, true);

}

function encryptUserPwd($sPwd, $sSalt)

{

    return sha1(md5($sPwd) . $sSalt);

}

Hi denre,

i have a complex and extended database to migrate, if i cant find the issue myself is cheapest for me to lookup for the issue with a freelance than to buy a migration that is almost done. (just for this fucking fail)

Thanks.

I found the error on this shit.

if you have an user with a numeric nickname, for example nickname "1", when you do a login, using nickname/email in this case "admin" that is user ID 1, the system retrieves the info for nickname = 1 instead of looking for ID = 1.

so, nicknames can be only alphanumeric, or modify code to not mix ID field with nickname.