Syncronise Unix users with a MySql DB

Discussion in 'Server Operation' started by staticanime, Aug 11, 2008.

  1. staticanime

    staticanime New Member

    Is it possible to do such a thing?

    I'm setting up a new server (CentOS 5.2) using the perfect server guide, adding webmin, and a few other things, including an Invision Power Board forum.

    Basically, what I want (I know this seems strange), but I want to syncronise the IPB forum users, and the UNIX users (for Webmail & Apache Basic-Auth & UserMin), so that when users register in IPB, they'll automatically be registered as Webmin users (for webmail, etc), and therefore, synced with the UNIX users.

    I also want to tie TorrentFlux with Apache Basic-Auth into the equation.

    Just wondering if that's even possible, and if anyone can help. If someone can help, and it's a matter of money, please PM me a qoute of some sort, and I'll see if it's worth it
  2. falko

    falko Super Moderator ISPConfig Developer

    It is possible, but you'd need to write a script for it (can be run by cron) that checks the users in the database and compares them with the users in /etc/passwd.
  3. staticanime

    staticanime New Member

    How hard would it be to write said script, or how much would it be to pay someone to write it for me?
  4. falko

    falko Super Moderator ISPConfig Developer

    Not that hard, but I don't have the time to do it.
  5. staticanime

    staticanime New Member

    No problem, it'll be a while before I need/want this done, having issues getting a new webserver, our existing host is asking for a few too many personal details, and I just don't trust it :S
  6. martien

    martien New Member

    I don't want to make another thread for that, but I'm wondering is it possible the unix users to use a md5 or sha1 passwords?
    It also can be helpful fo the author, because it will be easy to make such a script. The script can be done also with php. You must check for new users and add system account for them (just one for loop). I think it's better to make another table in your ipb database and when the user done his registration to add a record in the second table filled with the username, the password, and maybe the group (if you want to assign all your users into one or few groups). When it creates the unix user then the script deletes the record into the second database and it's done. You should think about recovering account (if the password is lost for example).

Share This Page