SMF Bridge 1.1.6 Synch SMF to Joomla does not work

[arekanderu]

Hello,

i have configured the SMF Bridge to use the SMF Registration (only because i wanted that image verification) and created a test account under the name "tester". Of course, if i go at the Joomla User manager and search for the tester it does not exist. I then use the SMF Bridge -> Synch -> SMF to Joomla/Mambo, it detects the account tester and it says that the account is now added at the Joomla DB. I go again at the Joomla User Manager, search for the user but ..it does not exist. If i go however through phpMyAdmin at jos_users and search for the user it exists in there but with password = migrated instead of the md5 hash.

Any ideas what is going on?

[Orstio]

URL?

[arekanderu]

What is the point of the URL? This occurs in the administration part of the site and anyway it is completely disabled atm until this issue is resolved. I believe that I' ve described the problem in detail however.

At admin.smf.php, Line 672 why is the 'migrated' inserted in the Joomla DB instead of the md5 hash?

Code Select Expand

VALUES ('$smf_row[0]','$smf_row[1]','migrated','$smf_row[3]')";

I really do not want to return to the com_registration since SecurityImages does not work properly with it and spam bots are becoming very annoying.

[Kindred]

"migrated" is there because the system can not tell what the actual password is.

So, until the first actual login of the user, using mod_smf_login, the database will read "migrated".   When the user actually logs in, the users information will be updated with the correct password (login is the ONLY time that the SMF password is actually available to the system)

[Orstio]

What is the point of the URL?

I need to see your URL so that I can see the behaviour of the software.  Your explanation is not clear enough to determine what is really happening, so I need a link to your site.

At admin.smf.php, Line 672 why is the 'migrated' inserted in the Joomla DB instead of the md5 hash?

SMF uses a salted SHA1 hash, not a MD5 hash, so the word 'migrated' is inserted as a flag to the bridge to convert the password on the first available opportunity (when there is an unhashed password available, like the event of changing passwords in the SMF profile).

[Orstio]

I registered.  Do I show up in the Joomla users list?

[arekanderu]

Yes you do. It seems that the problem was what you and Kindred said, that the user must log in first in order the password field to be updated. But this causes another problem...what if the user DOES NOT log in...the newsletter component uses the Joomla user DB to create the subscribers list....on the other hand though if the user does not log in he does not really care for the newsletter i guess...

[Orstio]

No, I think your problem was simply that you used a duplicate real name to create a user in SMF.

Or, perhaps you created the user on the stand alone forum, which is not bridged in any way, so that user would not be transferred to Joomla until login on a Joomla page.  If that user had the same real name as another existing Joomla user, it would completely explain the behaviour.

[Xaneth]

I have a very similar issue to this, however, there is no name duplication here.  I have users that have the same name as username, but that has not been a problem for some of the users that did migrate properly.  I have 21 users, but only 17 of them are showing in the backend!  I'm using:

Joomla 1.0.11
SMF 1.1 Final
1.1.6 bridge
Community Builder

This was happening prior to installing CB as well.  The users do exist in phpMyAdmin jos_users table as well, they just don't show up under the user manager (both the default user manager, and CB user manager).  Funny thing is, at the bottom of the user manager it states "Results 1 - 21 of 21" but only shows me 17.

www.mirrorstonemusic.com

[arekanderu]

Xaneth, did you ensure that the users which do not appear at the backened have actually logged in at least once? If not then they will not appear until they do.

Thanks for the help Orstio, everything is much more clear to me now!

[Xaneth]

That's what I was thinking at first too, but all the migrated users show up, even though they haven't logged in yet.  I could reset their passwords, and since I know who they are, I'll probably give that a try and try logging them in to see if it they appear after initial login.  Like I say though, a bunch of other users appear though they haven't logged in yet.

[arekanderu]

Do the following test:

1. Create an account, activate it but DO NOT log in
2. Check at the backened if it's there (it should not appear)
3. Log in
4. Check again at the backened (it should now appear)

Cheers

[Xaneth]

My bridge is set to use CB to process new registration.  When I sign up a new user, either clicking on "register" in the login module on the Joomla site, or within the forum, it redirects me to CB registration.  When I sign up, it shows up in user administration immediately.  The only place it does not show up, because I didn't log in with the new user, is in the forum DB, which is expected.  What I'm getting at, is that I had SMF users that I migrated to Joomla, and CB's user management does not see those users, however, it DOES see 17 of 21 users, as though they are there, just not visible.

[Xaneth]

When I added new contacts, the missing users showed up in the drop down box.  Anyway, resetting one of the user's passwords within SMF and logging in to the front page of Joomla worked.  They showed up after that, and I show 18 of 21.  Wierd eh?

[Jo-bit]

Hi!
Check your Joomla sql-table: _core_acl_aro
and maybe compare it with the sql-table: _users

I guess it should fix in joomla 1.0.12 

[Xaneth]

Yeah, I was fixing issues on another site I've built with somewhat different issues and figured it had everything to do with that.  The missing users were in all the tables they were supposed to be in, but their group_id was set to 0 instead of 18 or 25 in jos_core_acl_groups_aro_map.  Fixed the issue.