Free Asset Management Database

If you are not aware, I work in IT. Recently, my company was looking for a good asset management software. In my research I came across a large choice of free solutions. In that free allotment I came across one that would be perfect for a small office business or even home office; it’s called IT Items Database and can be found here. The only issue is that it is web based and requires a web server to be running at all times. Luckily for me that was not an issue. I have a media PC I use for watching movies, mostly, that is up all the time and not used on a daily basis and on this machine I run VMware Server. I believe the product has reached end of life but I am sure it can still be found somewhere on the internet. Well on that machine I have a dedicated Linux Mint server. I use Linux Mint 12 on a daily basis on my home desktop machine also but I use the virtual server within VMware for dedicated services, like a web server. Well, because I have so many devices in my home (what home doesn’t these days?) that I decided to test out the ITDB for my own assets. Here is what I did.

First, I followed this guide to install LAMP (Linux, Apache, MySQL, PHP). Basically, in Linux Mint, at the terminal you type:

sudo apt-get install lamp-server^

Then, if you want to manage MySQL, install phpmyadmin by typing:

sudo apt-get install libapache2-mod-auth-mysql phpmyadmin

For a complete guide just check out the link above.

Next, I went to Sivann’s software and downloaded IT Items Database and followed his installation instructions. For Linux Mint I copied the ITDB folder to /var/www and renamed the database file per his instructions. Thereafter I had to give the database file and the directory permissions so that Apache could have access to it. Here is what I performed:

sudo chown www-data itdb.db; chmod u+w itdb.db
sudo chmod u+w itdb.db
sudo chown www-data /var/www/itdb/data
sudo chmod u+w /var/www/itdb/data/
sudo chown www-data /var/www/itdb/data/files/
sudo chmod u+w /var/www/itdb/data/files/

Once that was completed I then browsed to http://localhost/itdb within my browser. The web page didn’t load for me due to an error, this is what I got:

Open database Error!: could not find driver

After further research I found I needed to install sqlite and php5-sqlite. I did so with the following command at the terminal:

sudo apt-get install sqlite php5-sqlite

Then restarted Apache with the following command:

sudo /etc/init.d/apache2 restart

Hit refresh on my browser and all was working.

So far, I have been really impressed with IT Items Database. It’s super easy to use and very effective for keeping track of all your devices. I highly recommend it.

Advertisements

24 thoughts on “Free Asset Management Database”

  1. I believe it should work as long as you have the Windows version of LAMP installed. I believe his site even mentions that someone had it running in Windows but no detailed information. There really isn’t an install guide, specifically for Windows.
    I’m a Windows admin and know more about Windows than I do about Linux. Maybe one of these days I will throw LAMP on my test Windows 2003 virtual machine to see if I can get this asset database running and post it here on my blog.

      1. Before going through with implementing this for my company, I wanted to know the amount of hard drive space I should allocate for ITDB and everything needed to make it run smoothly.

      2. I think it mostly depends on how many assets you plan on adding.
        My Example: I setup a Linux Mint VM with 20GB of space and it has barely scratched the surface. I have a little over 100 assets entered and the ITDB database file is only about 200MB.
        I don’t think you will require much. I hope that helps.

  2. I have another question for you. My department and I have decided to go ahead and implement ITDB for our use. Which Linux Mint edition did you use? (Cinnamon, MATE, KDE, Xfce). Does it matter? We are trying to use your process as a guide to get ITDB up and running. Thanks for helping me out!

    1. it doesn’t matter. It’s all a matter of preference. I love and use Cinnamon for my own personal use at home so I use ITDB on that distro at home and work.

  3. Thanks for the amazing guide. I was frustrated the first time I went to install ITDB. I’m happy I found and remembered this site for the second time around. Thanks again!

  4. I am testing this out from a Windows 8 PC… I have XAMPP installed already for testing and playing with Joomla and WordPress, so I created a database in phpmyadmin, copied the files to the C:\xampp\htdocs folder and now I can just browse to localhost/itdb or from the network to 192.169.1.50:80/itdb and there it is. Very simple…

  5. i can’t able to import items to database. i am getting error message as ”
    Deprecated: preg_replace(): The /e modifier is deprecated, use preg_replace_callback instead in /opt/lampp/htdocs/itdb/functions.php on line 47

    Please check fields for consistency before submiting
    Error: field count in line 1 is 1, 16 is expected”

    Please help me to solve this issue

  6. Hi there, I need some help. When I enter the

    sudo chown www-data itdb.db; chmod u+w itdb.db

    it tells me that it can’t access ‘itdb.db’ and says that there is no such file or directory.

    1. And you ‘ls -l’ that directory to confirm that ‘itdb.db’ file is there? Also, I would try separating the file permission change commands. Complete a ‘sudo chown www-data itdb.db’, hit enter then complete a ‘sudo chmod u+w itdb.db’, hit enter.

  7. Hoping you might could help me out here, I ran through the above steps and Apache says “The requested URL /itdb was not found on this server.”

    I changed permissions as you instructed, any thoughts on what I’m doing wrong here?

  8. I wanted to know ITDB software is totally freeware ? We are working of small organisation. As per there requirement i am looking freeware or opensource Asset Management tool.

    Kindly revert ASAP.

    Thanks in Advance.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s