Free mysql administrator software for linux

Sorcerer is a source-based Linux distribution for system administrators. The sources are downloaded directly from software authors homepages and mirrors.

Then, they are compiled with the architecture and optimizations that the system administrator specifies.

Finally, it is installed, tracked, and archived for easy removal and upgrades. Sorcerer has both command line and menu driven source mangement programs.

User manager for PureFTPd allows administrators to easily create, change, or delete virtual PureFTPd users. It comes with a set of very good documentation to help with the setup of PureFTPd, Apache, PHP and MySQL.
This web application allows you as administrator to manage your ftp users in a web browser. With the user-friendly interface you can add, change, remove, lock or unlock ftp users.
Main features:
- Username and Password
- Choose the UNIX user and group rights for the ftp user.
- Choose a home directory with the embedded file browser.
- Select capture limits for there upload and download traffic.
- Restrict there number of files and total size of files with the quota option.
- Select a ratio for there upload and download sessions.
- Give an ip address restriction.
- Add personal notes about the ftp user.

YaBook is a simple but powerful guestbook running on PHP 5. YaBook project features easy installation and customization, multi-language support, an administration interface, and email notifications on new postings. YaBooks design uses a template system so it can be easy integrated into your page.
YaBook ist built on the Sourdough framework, a web application framework for PHP 5. Various database systems are currently supported, e.g. MySQL, PostgreSQL, MSSQL, SQLite.
Main features:
- Fully customizable layout and interface (skins support, template based)
- Disallow HTML Code, BBcode support
- Email notification on new entries
- URLs will be transformed into links
- Multipages. Browsable entries with previous/next bar.
- User administration interface
- multi-language support with automatic language detection
- Ability to create multiple moderator and administration users
- Moderators are able to hide/unhide, delete, or edit an entry
- Administrator approvement of new entries if required
- Anti-flood spambot protection by Captcha image verification.

MySQL Activity Report is a valuable database tuning aid.

The MySQL Activity Report package is a tool to help MySQL database administrators to collect several database parameters and variables. These collected values can be used for server monitoring or performance tuning purposes.

The most important component of the MySQL Activity Report is mysqlard. This daemon collects the data from a MySQL server and stores these values in a Round Robin Database.

The mysqlard package also contains example graphing, cron and php scripts. The cron scripts can be used to keep archives of the generated graphics and the php script shows the generated graphics and tries to give some tuning tips.

MySQL PHP to PostgreSQL is an application that takes a php page that uses mysql calls and changes them into PostgreSQL calls.
This allows any website (if it converts properly) that was written in PHP for MySQL to run as a website written to run on PostgreSQL.
- Step 1: Download and uncompress
To uncompress simply type: tar xvzf mysqlphp2postgres.tar.gz
If youre on a non-GNU system you might have to type: gzip -dc mysqlphp2postgres.tar.gz | tar xvf -
- Step 2: Compile
To compile simply type: make
If youre on a non-GNU system youll have to edit the make file to change the compiler to cc instead of gcc
- Step 3: Install
Type: make install
This will simply copy the binary file to /usr/local/bin/
- Step 4: Convert
Type: mysqlphp2postgres inputfile.php outputfile.php
The input file is the php page that uses mysql. The outfile is the page you want to create. You will probably need to tell mysqlphp2postgres the name of the postgreSQL database since mysql_select_db doesnt translate. You can do this by using a -d switch. So if, for example, the database youre connecting to is called blah, you could type: mysqlphp2postgres -d blah inputfile.php outputfile.php
Problems:
I have had the following problems from using this program:
MySQL has a lot more functions in PHP than PostgreSQL that do more things. I havent had a problem with any unsupported functions in my programs, but someone probably will. If you want to help write code for this to support those functions (if thats even possible) feel free to help.
Enhancements:
- Fixed some stuff.
- Cleaned up some code.
- This program now produces code optomized for PHP 4.1.0 and above.

Chaussette is a MySQL/PHP Web group calendar using Ajax.

With it, friends can share events and chat together.

YALA is a web-based LDAP administration GUI. The idea is to simplify the directory administration with a graphical interface and neat features, though to stay a general-purpose program (unlike some LDAP browsers written specifically for managing users on the system).
Yet Another LDAP Administrator goal is to simplify the administration but not to make the YALA user stupid: to achieve this, we try to show the user what YALA does behind the scenes, what it sends to the server (unlike Microsoft Active Directory, for example).
Main features:
- Clear and Simple interface
- Cross-Platform: YALA can be accessed from any platform using any modern browser
- Cute javascript to improve the web-interface, which can be set off if you would like
- Theoretically works with any LDAP server, see README file for list of supported LDAP servers.
- Reads the schema from the LDAP server and gets lots of useful information off there.
- Entry Types recognition: You can configure YALA to recognize an entry of objectclasses X & Y, for example, as a user entry, have a special icon for it, and allow simple creation of new entries of this type (i.e. add a new user).
- Its free (under the GPL)