Topic: asset-tracker on sme

[nadia678]

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

[David Harper]

Welcome to the forums

The easiest thing to do would be to run the application from an Ibay. See the manual for the basics.

Once you have created the Ibay, you can create the SQL database and upload those SQL files using the graphical PHPMyAdmin tool.

[nadia678]

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

[David Harper]

Sounds like you're on the right track

[nadia678]

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?

[David Harper]

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.

[nadia678]

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

[David Harper]

Make sure it goes in html/settings/

It's a bit unclear what might be going wrong if the screen is just blank.

[nadia678]

sorry, not sure what you mean with Make sure it goes in html/settings/ ?

[David Harper]

Sorry... database_settings.conf belongs in the "html/settings/" subfolder, not in the "html/" root.

[nadia678]

it's in the right folder... but no luck, this is not as easy as i thought it would be !