我目前正在安装 Joomla 1.6,需要从完全独立的数据库导入大约 500 多个用户。这是我的困境:
我将数据库下载为 CSV 文件,但密码都只是标准密码,没有加密。我知道存储在 joomla 用户表中的密码是 md5 + salt 加密的,所以我想知道如何使用正确的加密密码将此 CSV 导入 PHPMyAdmin 或通过某种扩展运行 CSV(没有找到很多) 1.6 的用户迁移/导入扩展)。
有人有什么想法吗?这是阻止我继续这个项目的最后一件事。
谢谢!
菲尔
I am currently working with a Joomla 1.6 install and need to import about 500+ users from a completely separate database. Here's my dilemma:
I downloaded the DB as a CSV file, but the passwords are all just standard passwords, no encryption. I know that the passwords stored in the joomla user table is md5 + salt encrypted, so I am wondering how I could go about either importing this CSV into PHPMyAdmin with the correct encrypted password or run the CSV through some sort of extension (not finding many user migration/import extentions for 1.6).
Anyone have any ideas? This is the last thing holding me back from continuing with this project.
Thanks!
Fil
发布评论
评论(1)
实际上,您可以将密码作为简单的 MD5 哈希值插入,它仍然可以让用户登录,但建议通过前端系统更改密码,因为加盐密码更安全。这适用于 1.5 和 1.6。
http://docs.joomla.org/How_do_you_recover_your_admin_password
http://docs.joomla.org/Resetting_a_user_password
Actually, you can insert the passwords as a simple MD5 hash, it will still work for letting the user login, though it is recommended to then change the password through the front end system as the salted passwords are more secure. This works for 1.5 and 1.6.
http://docs.joomla.org/How_do_you_recover_your_admin_password
http://docs.joomla.org/Resetting_a_user_password