Feta
From JComServ Documentation
Feta Efficiently Tracks Assets
I wrote Feta because SimpleAssets is too complex, and I don't need to manage Licensing, since I tend not to use non-free software. It basically keeps track of individual parts and systems, as allocated to user-definable storage areas or externally-deployed locations.
Since I've not actually started using it, I have no sense of how useful the interface is or if it is lacking a needed feature.
I've also modified Tiquit to allow assignment of systems to Tiquit users, so that you can view a user's system specs from their incident.
Contents |
Installation
Requirements
Feta requires PHP >= 4.0.3 and either MySQL >= 3.23 or PostgreSQL (works with 8.1, earlier untested). PHP must have the extension available for the DB you intend to use.
Feta has been tested on Linux, but should run on any OS that supports PHP. The DB can be run remotely or locally.
PHP files
Download the tar.gz and unpack into a folder withing the desired place in your webserver's docroot.
Database setup
Create a database on your DB server, and create a DB user with SELECT, INSERT, UPDATE and DELETE permissions. Populate the schema and inital data with mysql -uroot -p YOURDB < feta.sql for MySQL and psql -d tiquit -f feta.pg.sql for PostgreSQL. Be sure to substitute feta_my323.sql if you're running MySQL 3.23.
Edit config.php to contain the proper host, username, password and dbname for your Feta database. Make sure the dbtype variable is set to the type of RDBMS you're using.
Upgrading
To upgrade an existing Feta installation, complete the following steps in the order listed.
- Back up your database(mysql_dump, pg_dump)
- Back up your config.php
- Replace all files in your installation with the files from the new tar.gz
- Migrate settings from old config.php to new config.php
- Edit upgrade.php to include proper DB type, host, DB name and ROOT DB user/password.
- Run php upgrade.php
- Delete upgrade.php
Initial Setup
Initialization
- Point your web browser to the web address of your Feta installation. Click the Login button, then log in with Username admin, password admin.
- Change the password of this account by clicking on Change Password and doing what comes naturally. This documentation is available on the internet, and if you fail to change your password and/or login, your Feta install is now the personal toy of anyone on the internet. You have been warned.
Customize For Your Organization
- Enter the Admin screen.
- Define Storage. Give each location a name and a location, like Cabinet 1 in Basement, or something.
- Define Disposal Methods. By default, everything is Active. You can set up disposal methods, so you can track what happens to hardware, such as sale, trash, donation to charity, RMA, etc.
- Define Part Types. Part types define what attributes a part may have. Not all parts will have all attributes, and you can use this to simplify categorization of optical drives, processors, NICs, etc.
- Define Units. Add in units of speed and capacity. Mhz, Ghz, GB, KB/s, etc.
- Add Users. If others will be using Feta, assign them a login/password.
Begin Using Feta
- Go live. Let your support personnel or all type aware of where to find Feta, and start entering parts and systems. Advise Users to change their password upon first login. This is not enforced, but simply common sense.
