Free phpmyadmin software for linux

phpSQLiteAdm is an application to provide Web based management and administration for SQLite databases.
phpSQLiteAdm project is meant to be similar to phpMyAdmin. It provides functionality to view data, to add and drop tables, views, and indexes, to export data, to add and delete rows, and to query the database.
Enhancements:
- This is the initial release.
- Code cleanup and bugfixes were done.

Wifiadmin is a free php graphical interface to mainly hostap, and wireless tools in general, although most of this code has been debugged only under a hostap environment.

Please submit errors found when running with other linux wireless drivers, that support wireless extensions. We are trying so that wifiadmin is as self-configuring and distribution-independent as possible.

Installation:

1) Decompress in a directory reachable from your web server(htdocs), keeping in mind the directory structure.
2) If you disable mysql usage($use_mysql variable in the include/config.php file):

Give write access to the user that you are running PHP, to the file include/passwd .For example, from wifiadmin root directory type chown apache:/ include; chown apache:/ include/passwd, depending on your local configuration.

If you enable mysql usage:

Within the directory, youll find a a file named "mysql.sql". Contained in this file are the SQL statements necessary to create the WiFiAdmin database. Log onto your database server under the root account (or other account allowed to create databases), create a database for wifiadmin, and then run the contents of mysql.sql to create the tables and initial data.

For example:

mysqladmin -u [user] -p create [database-name]
mysql -u [user] -p [database-name] < mysql.sql

Or you can use phpMyAdmin to do the same.

In either case, you have to edit the include/config.php file and edit the following variables:

$USERS_DBHOST = "localhost"; host where mysql is running
$USERS_DB = "wifiadmin"; [database-name]
$USERS_DBUSER = "wifiadmin"; [user]
$USERS_DBPASS = "wifiadmin"; the password of [user]

3) Change your sudo configuration. Wifiadmin needs superuser access to specific executables. For the moment, this is done by giving superuser access to the user apache runs with, using the sudo mechanism. You can find out the user that apache runs with, by:

ps aux | grep http or ps aux | grep apache

You should use the visudo executable, or manually edit the file sudoers. Add the following lines, replace www-data with the user apache runs with.

# Cmnd alias specification
Cmnd_Alias WIFIADMIN = /sbin/iwconfig, /sbin/ifconfig, /sbin/iwlist,
/sbin/iwpriv, /sbin/route, /usr/bin/host, /usr/sbin/arp

# User privilege specification
www-data ALL=(ALL) NOPASSWD: WIFIADMIN

Change the paths if iwconfig, ifconfig etc executables are located
elsewhere in your system.

WARNING
This configuration, gives superuser priviledges for the specific commandsto the user your web server runs with. This might have implications on system security.

4) Add the following lines at the end of your crontab (you can use the crontab -e command, or edit your /etc/crontab directly)

*/2 * * * * root php /path/to/wifiadmin/create-update-rrds.php > /dev/null 2>&1
*/10 * * * * root php /path/to/wifiadmin/create_graphs.php > /dev/null 2>&1

The first line creates(for the first time) and updates the rrd databases. The second
creates the updated png graphs from the databases. RRD updates happen every 2 minutes, and graphs are crated every 10 minutes.

Change these values to suit your needs. Mind space characters from copy-pasting into your crontab!!

5) Wifiadmin can send emails to confirm new user accounts, or remind user passwords.
If $send_emails = true; in config.php file, wifiadmin will send emails.
If you set $confirm_new_account = false; while $send_emails = true;, wifiamdin will
send emails to remind passwords, but no email confirmation will be needed in order
to set up an account.

6) Fire up your favorite browser, and point to http://target-hostname/wifiadmin/
ATTENTION: WIFIADMIN HAS A DEFAULT ADMIN PASSWORD. Change the admin
password as soon as possible, by logging in as user admin with password wifiadmin.

Go to user management, choose admin, and type a different password. You can LOOSE complete network access to your box if you are careless enough...

DB2-JMIN is a Web-Based/Desktop DB2 client (general-purpouse), inspired on phpMyAdmin. DB2-JMIN runs on Tomcat 5.5 or SWING with JDK 1.5 (Multi-plataform, Schema Browsing , Multiple DB2 OS support, Tables Browsing, Tables Structure, SQL Query editor)

Mailing List project is a Web-based, full-featured mailing list and newsletter system. Users can subscribe and unsubscribe themselves.
Email confirmation is used for new subscriptions. The list of subscribers to a list can be imported and exported.
Installation:
- copy all files to your web host
- use phpmyadmin or your mysql interface to run site.sql against your database.
- open site.xml and edit the database section with your database details.
- go to index.php and login with username of admin with a password of test.
Setup the site.xml file with your database settings as follows.
< database type="mysql" >
< server >database server address< /server >
< login >database login< /login >
< password >database password< /password >
< default >mysql database name< /default >
< /database >
Add this to your ".htaccess" file to prevent viewing of the xml config file.
< Files ~ ".xml" >
Order allow,deny
Deny from all
Satisfy All
< /Files >
Enhancements:
- A problem with the SQL setup file which caused the setup to fail on some systems was fixed.

PhpBibliography allows you to publish your bibliography online (and to edit it via web). PhpBibliography is implemented in Php and uses MySql.
These instructions assume you already have a working web server/php/MySql system.
1. Create a database called bibliography (this is the default but you can choose the name you want, provided you update config.php accordingly, see below; for instance some providers already set up some databases for you, with specific names: you should choose one of these and then update config.php accordingly, see below)
2. (Optional) assign user and password to the created database
3. upload the file bibliography.sql you find in the zip file (this will create the table structures); in order to do this you can either use the following mysql command, where should be replaced with the user you assigned to the database (default: root) and is the name of the database you created (default: bibliography):
mysql -u -p < bibliography.sql
Alternatively you can use your favorite mysql management system, e.g., phpMyAdmin.
Note: phpbibliography relies on InnoDB tables for the database, but it should work even with standard MySql table types (I havent tested this) but you lose referential integrity.
4. Edit the config.php file in the html directory according to your configuration:
$dbhost = "localhost";
This is the address of the MySql server (by default it is the same of your web server - thus, localhost - but it might not always be the case)
$dbuname = "root";
The user owner of the database you created (default: root)
$dbpass = "pippo";
The password of the owner of the database you created (default: pippo, but you should change it as soon as possible!)
$dbname = "bibliography";
The name of the database you created (see above)
$mysite = "http://yoursite/yourphpbibliographypath";
This is the public URL of your phpbibliography site; it depends on where you upload the phpbibliography files (see below)
$filedir = "files";
This directory will store the papers you upload via phpbibliography. You can keep the default value (see below for setting up this directory)
$maintitle = "Bibliography Site";
This will be the title of the html pages generated by phpbibliography
copy all the contents (including the subdirectories) of the html directory to the desired directory in your web server (make sure that the subdirectory files is writable from the web server user - you can make it writable and accessible from anyone. This directory will store the papers you upload via phpbibliography)
If everything was setup correctly you should be able to access to your bibliography site with a browser.
Enhancements:
- Papers can be classified according to several criteria (decided by the users).
- The order of authors in a bib item is respected.
- A paper can be modified using a bibtex.
- An entire bib file can be uploaded to insert or modify the papers.
- An authentication problem with PHP 5 has been fixed.
- Formatting of papers can be customized by passing parameters in the URL.

MyJgui is a light-weight graphical user interface for MySQL databases. It aims to be easy to use for new users as well as experts.
Motivation:
After the MySQL Front project went commercial, there was no light weight, feature rich and free mysql gui application that I considered worth running.
So I got stuck to the mysql binary and console front end. After awhile I realised that there is too much typing involved, and that many of the tasks could be automated and quickened only if a free mysql front application could be run.
I like the phpMyAdmin project, but first - its not always available, and because of the need to install it on every server, I dont consider it lightweight.
Java was chosen as the programming language because of its portability.
As a programmer I try to enhance the gui with the application development in mind, so many features added in the furure will be driven towards application development, even though many administration features are going to be included as well.
Main features:
- Automaticaly expanded database tree showing all the databases.
- The middle right pane shows the output of show table status when clicked on the database in the tree
- The middle right pane automaticaly moves to the results of sql command when a command is triggered
- SQL command textarea supports triggering of marked commands
- Detailed sql command details and history at the bottom of the right pane as well as showing of all the possible errors and response values
- Clearing of the sql command history

OAMP stands for (O)penBSD + (A)pache + (M)ySQL + (P)ostgreSQL + PHP. The project is the OpenBSD cousin of LAMP, except that it also provides the SQlite database engine, Perl, Ruby, and Python.

In addition, OAMP provides phpMyAdmin and phpPgAdmin for easy administration of MySQL and PostgreSQL over the Web.

OpenBSD is widely regarded as the most secure operating system in existence and its features can be used to satisfy all aspects of information assurance (i.e. confidentiality, integrity, availability). For instance, as of version 4.0 OpenBSD encrypts the swap partition by default and puts the Apache server in a "jail" environment, so if it is compromised the damage will be contained. In addition, all applications that come with OpenBSD have undergone source code audit and have been hardened accordingly. OAMP also provides the SQLite database, Perl, Python and Ruby.