Koozali.org: home of the SME Server

Obsolete Releases => SME Server 7.x => Topic started by: nadia678 on April 01, 2009, 09:06:50 AM

Title: asset-tracker on sme
Post by: nadia678 on April 01, 2009, 09:06:50 AM
Hi All, i would like to run the following web application on sme 7.4 and don’t know how to do this. I found it on sourceforge and its called Asset-Tracker http://sourceforge.net/projects/asset-tracker/
It requires php, php mysql extensions, mysql, and a web server. Ive got the instructions for installation but need some help please!

Quick install instructions:
---------------------------
make sure you already have php, php mysql extensions, mysql, and a web server installed
unpack archive into a directory where your web server can see/execute it
make sure everything in the wwwroot and config directories is readable by the web server
make wwwroot the root directory for your Asset-Tracker web server
(see example in docs/web_configs)
ensure that your web server has enabled http authentication on asset-tracker
(see examples in docs/web_configs)
create a database in mysql for Asset-Tracker data to live in
I recommend you create a mysql user specifically for access to this database
add database connection information to settings/database_settings.conf
Modify docs/mysql_dumps/system-setup to contain your uid (see comments in the system-setup file for details)
import the mysql dump in docs/mysql_dumps/system-setup
import the mysql dump in docs/mysql_dumps/sample_assets so you can see an example of a working/correct setup
Title: Re: asset-tracker on sme
Post by: David Harper on April 01, 2009, 10:09:41 AM
Welcome to the forums :)

The easiest thing to do would be to run the application from an Ibay. See the manual (http://wiki.contribs.org/SME_Server:Documentation:Administration_Manual:Chapter14) for the basics.

Once you have created the Ibay, you can create the SQL database and upload those SQL files using the graphical PHPMyAdmin (http://wiki.contribs.org/PHPMyAdmin) tool.
Title: Re: asset-tracker on sme
Post by: nadia678 on April 01, 2009, 10:51:29 AM
thanks, if i got this right...
add ibay
Information bay name     :assettracker
Description                    :asset-tracker
Group                    :everyone
User access via file sharing or user ftp write = group, read = group    
Public access via web or anonymous ftp    entire internet (no password)
Execution of dynamic content (CGI, PHP, SSI)     enabled

do i copy the files to the html folder under the ibay name?

install phpmyadmin and greate database
Title: Re: asset-tracker on sme
Post by: David Harper on April 01, 2009, 10:56:34 AM
Sounds like you're on the right track ;)
Title: Re: asset-tracker on sme
Post by: nadia678 on April 01, 2009, 12:11:48 PM
not sure what to do next  :?

created ibay, copied files from wwwroot to ibay called "at"  /home/e-smith/files/ibays/at/html
created mysql db using phpmyadmin called asset-tracker with user asset-tracker
restored mysql dump (sample data) and it looks fine
but...
i'm not sure where to put the database_settings.conf and web_configs files?
Title: Re: asset-tracker on sme
Post by: David Harper on April 01, 2009, 12:14:52 PM
Open /home/e-smith/files/ibays/at/html/settings/database_settings.conf and enter the MySQL connection details. The server is localhost, and the username and password are whatever you created in PHPMyAdmin.
Title: Re: asset-tracker on sme
Post by: nadia678 on April 01, 2009, 12:26:54 PM
do i connect to the web interface using http://smeserver/at/index.php ?
it just stays blank. i coppied the settings folder to the ibay html folder and made the changes as needed
$database_name = "asset-tracker";
$database_server = "localhost";
$database_user = "asset-tracker";
$database_password = "pass12$";

thank you for helping
Title: Re: asset-tracker on sme
Post by: David Harper on April 01, 2009, 12:35:13 PM
Make sure it goes in html/settings/

It's a bit unclear what might be going wrong if the screen is just blank.
Title: Re: asset-tracker on sme
Post by: nadia678 on April 01, 2009, 01:08:49 PM
sorry, not sure what you mean with Make sure it goes in html/settings/ ?
Title: Re: asset-tracker on sme
Post by: David Harper on April 01, 2009, 02:30:44 PM
Sorry... database_settings.conf belongs in the "html/settings/" subfolder, not in the "html/" root.
Title: Re: asset-tracker on sme
Post by: nadia678 on April 01, 2009, 02:57:57 PM
it's in the right folder... but no luck, this is not as easy as i thought it would be !  :sad: