Archive for February, 2006

Mambo user management

Saturday, February 11th, 2006

Get thhis somewhere from the Web. Need to test and verify it.

User Synchronization on multiple mambo sites PDF Print E-mail

User account management in Mambo is a hassle especially if you have multiple sites maintained by the same people. For exampe, www.pregi.net, portal.pregi.net and npm2.pregi.net have the same people maintaining the site.

To remedy this, I have went down to the database files maintained by mysql and made my modifications there. I know that there are three tables (each with three files, ~.frm, ~.MYI, ~.MYD) concerned with the users, namely:

* mos_core_acl_aro
* mos_core_acl_groups_aro_map
* mos_users

I simply deleted the files pertaining to these three tables on two of the databases, portal and npm2. Then, I made some soft links to the copy found in the project database.

Here is what i did:

cd mysql/var

rm mos_core_acl_aro.*
rm mos_core_acl_groups_aro_map.*
rm mos_users.*

ln -s ../project/mos_core_acl_aro.frm .
ln -s ../project/mos_core_acl_aro.MYI .
ln -s ../project/mos_core_acl_aro.MYD .

ln -s ../project/mos_core_acl_groups_aro_map.frm .
ln -s ../project/mos_core_acl_groups_aro_map.MYI .
ln -s ../project/mos_core_acl_aro.MYD .

ln -s ../project/mos_users.frm .
ln -s ../project/mos_users.MYI .
ln -s ../project/mos_users.MYD .

Footer

Bookmark this:
BlinkBits
BlinkList
Blogmarks
Buddymarks
CiteUlike
Connotea
del.icio.us
Digg it
Earthlink
FeedMarker
Flog this!
feedmelinks
Furl
Give a Link
Gravee
igooi
Lilisto
Linkagogo
Linkroll
ma.gnolia
Maple.nu
My-Tuts
Netvouz
Newsvine
Onlywire
RawSugar
reddit
Scuttle
Shadows
Simpy
Spurl
Taggly
tagtooga
TalkDigger
Wink
Yahoo MyWeb
Google
Diigo
Netscape
DZone
Squidoo
Looklater
RecommendzIt
Segnalo
StumbleUpon
Mr. Wong
| BlinkList del.icio.us Digg it Furl ma.gnolia Netvouz RawSugar Shadows Simpy Spurl Yahoo MyWeb Google DZone StumbleUpon