Toner inventory Database

[webman]

Nope, shouldn't need that mcrypt for printmaster. Even though those permissions are on wwwroot; please check that the IIS user has write permissions (specifically, to be able to create files) on the session folder itself. That's the only issue that the error messages relate to, so is all I can think it is.

[pritchardavid]

Ok it seems iis user is the wrong user to set

 

I tried Authenticated user, was just gussing and that seems to work

 

 

Ok next question how to we get a security logon for this?

Want to try and get the new web server a bit more secure, last time our iss root folder had full rights for everyone

[webman]

PrintMaster doesn't come with any security built-in. Use the functionality included with your web server (IP restrictions, Directory security - IIS: Authentication settings, Apache: htaccess/htpasswd etc) - but this is beyond the scope of what I can help with

[jonathon28]

Still no joy webman. I'm pretty sure I have followed instructions as stated. I get the index of still when i navigate to local host. then the webpage cannot be found when i navigate to localhost/printmaster.

[webman]

Did you extract the downloaded zip file to a folder called 'printmaster'?

[jonathon28]

The zip file I extracted to c:\program files\apache group\apache2\htdocs, created an empty folder in htdocs with the name session. Imported printmaster.sql into heidisql, changed init.php to match database name and username password etc.

[webman]

When you go to http://localhost/index.php, you should see the PrintMaster interface.

[jonathon28]

nope. getting a file download window :s sorry to be a pain!

[webman]

In that case, PHP is not installed correctly.

[zag]

p-dave: Ensure the session folder is created and writeable by the webserver.

 

Others: Re: costs. At the moment, I'm not looking at developing the costs feature due to higher priorities (private work, Classroombookings). I agree it would be a good feature to have, and probably one day I'll do it; just not right now

 

Thanks for the reply

 

I'll wait.

[pritchardavid]

nope. getting a file download window :s sorry to be a pain!

 

Best way to see if php is working mate

 

open notepad and type this in...... phpinfo()

 

and save the file has phpinfo.php

 

copy or save that in you webserver folder route

 

and go to Internet Explorer and type in localhost/phpinfo.php

 

If thats does not display a page of information php is not working correctlly

 

Best bet is to install php via the Microsoft Web Platform if your using a Windows Server, always seems to work doing it that way

[zag]

Might want to check everyone has permissions to the directory as well.

[RabbieBurns]

i dont use phpmyadmin, i do it all on the CLI.. but Im not sure how to import the .sql file into the new database I created...

 

Can anyone tell me how its done please?

[webman]

Replace printmasteruser and printmasterdb with your own details, and obviously the path to the file as well.

 

mysql -u printmasteruser -p printmasterdb < /path/to/printmaster.sql

 

Enter printmasteruser's password when prompted

[RabbieBurns]

Thanks.. I thikn I might have messed up something else coz im getting

ERROR 1044 (42000): Access denied for user 'printers'@'localhost' to database 'printers'

 

After I created the user and the database i did this:

 

GRANT ALL PRIVILEGES ON printers TO 'printers'@'localhost' WITH GRANT OPTION;

 

Is there something else I need to do?

[webman]

To create a DB and user, just do:

 

CREATE DATABASE printers;
GRANT ALL PRIVILEGES ON printers to 'printers'@'localhost' IDENTIFIED BY 'password';

[RabbieBurns]

mysql> SHOW GRANTS FOR 'printers'@'localhost';
+-----------------------------------------------------------------------------------------------------------------+
| Grants for printers@localhost                                                                                          |
+-----------------------------------------------------------------------------------------------------------------+
| GRANT USAGE ON *.* TO 'printers'@'localhost' IDENTIFIED BY PASSWORD '*D8DECEC305209EEFEC43008E1D420E1AA06B19E0' |
| GRANT ALL PRIVILEGES ON `mysql`.`printers` TO 'printers'@'localhost'                           |
+-----------------------------------------------------------------------------------------------------------------+

 

does that look right?

 

edit: I found my mistake.. I had to change it to

GRANT ALL PRIVILEGES ON `printers`.* TO 'printers'@'localhost'

 

Thanks for the quick way of adding too

Edited November 3, 2010 by RabbieBurns
found my mistake

[RabbieBurns]

And also, im not sure what to change on this line in the init.php file

 

$db = new fDatabase('mysql', 'printmaster', 'root', '', 'localhost');

 

sorry for all the dumb questions

 

edit: figured it out...

 

Its database type, database name, username, password, host...

 

Sorted now cheers!

Edited November 3, 2010 by RabbieBurns

[browolf]

Depending on what you pay on delivery of toner cartridges (none for us since our printers are all on a contract), our printers (HP) are set to email helpdesk when toner is low and then we order a new one straight away. we have some stock in case they doesn't come in time. We don't need to track what we have as the system is self-replenishing.

[webman]

RabbieBurns has created some nice instructions for installing on Linux - now available on the project wiki: Installation on Linux.

[RabbieBurns]

Also set up a demo site if anyone wants to have a look at a live install:

 

Home - PrintMaster

[pritchardavid]

Also set up a demo site if anyone wants to have a look at a live install:

 

Home - PrintMaster

 

sorry for me being dumb but how to you get that on a subdomain?

[RabbieBurns]

sorry for me being dumb but how to you get that on a subdomain?

 

Using apache with virtual hosts.. Basically you have a main generic apache config, and then you have a seperate config for each domain/subdomain.

 

Its a way of running multiple websites on 1 static IP.

 

Configuring and Using Virtual Hosts in Apache

[fawkers]

Hello Everyone;

 

Please find attached my 'patched' printer master whith a facility to monitor costs.

 

Known Bug: When quiering the costs table if the same row is returned multipule times the cost will only to be summed once.

Here is the offeding code

"SELECT SUM(`cost`)
			FROM `costs`
			WHERE `id` in (
				SELECT `cost_id`
				FROM `events`
				WHERE `printer_id` = $printer_id AND DATE_SUB(CURDATE(),INTERVAL 30 DAY) <= `date` 
			)"

Any Ideas?

 

printmastertest.zip

 

Your have to create your database using the printmastertest.sql in the zip file.

[round2it]

Could an export data option be added to this project?

 

this project is ideal for use in our school one thing missing for us is the ability to export data to CSV or some form to edit in Excel

 

would this be hard to impliment

 

 

big thank you goes out to the creator and all the people who have added little extras.