Opensource LDAP

LDAP has been around for decades and openldap is the only opensource ldap in town until few years ago.

I think openldap is great but it is just too complicated & operationally inconvenience to implement. Along, I have discovered 2 alternative opensource ldap that possible to fit our project requirements.


Alternative 1:-
389 Directory Server aka RedHat Directory Server is available for linux distro but it also work on HPUX, Solaris, etc. It share the common root with openldap with base branch from University of Michigan. It has all the features that openldap offered & it has we admin interface that make the administration easy


Alternative 2:-
OpenDJ/OpenDS is Java based ldap that started by SUN. It probably is the most effortless to setup. On performance, it has reported it can handle millions of search requests per second.

Verdict:-
My choice of opensource ldap is 389 Directory Server as our server farm is mostly RedHat Linux based & our administrators are very much comfortable with it

Setup MySQL on OpenSUSE 11.1

This is the guide to setup mysql on OpenSUSE 11.1, the steps will be slightly different if you are using other Linux distros, It also assuming you are using KDE 

1. Application Launcher → Applications → System → Configuration → Install Software
2. search “mysql”
3. click on “mysql” and “mysql-gui-tools”, click Accept to install
4. Open “Terminal”
5. su -
6. cp /usr/share/mysql/mysql.servera mysql
7. chkconfig --add mysql
8. You should see this:
   mysql 0:off 1:off 2:on 3:on 4:on 5:on 6:off
9. if not, the run the command below to make mysql run on runlevel 2,4,5:
   chkconfig --level 245 mysql on
10. chown mysql:mysql mysql
11. ls -al mysql
12. You should see the below:
    -rwxr-xr-x 1 mysql mysql 11960 Aug 18 17:42 mysql
13. cd /etc/
14. cp my.cnf my.cnf.bak
15. vim my.cnf
16. Add in new lines under the
    [mysqld]:
    datadir=/home/mysql
    user=mysql
17. cd /home/
18. mkdir mysql
19. chown mysql:mysql mysql
20. mysql_install_db --datadir=/home/mysql/ --user=mysql
21. cd /home/mysql/
22. chown mysql:mysql -R *
23. mysqladmin -u root password 'password'
24. Now, you should able to log on via MySql Database Administrator gui to create new users & database.
25. In the, Database Administrator gui, creatre schema; then create user and password “ermpassword”. Assigned all privileges in new schema to the user created
26. Now you are goto go