LinuxQuestions.org
Review your favorite Linux distribution.
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Software
User Name
Password
Linux - Software This forum is for Software issues.
Having a problem installing a new program? Want to know which application is best for the job? Post your question in this forum.

Notices


Reply
  Search this Thread
Old 01-07-2008, 05:18 AM   #1
stripe21
LQ Newbie
 
Registered: Jan 2008
Location: Dorking, surrey
Distribution: ubuntu, puppy, suse
Posts: 19

Rep: Reputation: 0
Smile database for stock


This is a general Q. I have got a small stock load that comes in and goes out. I have got a member of staff to sort out some sort of spread sheet, but its hard to see what we have got in stock and what is out.

Is there something that we can use like a DB (mysql or openoffice database) that we can type in what is in and what is out. It dosen't have to be flashy simple is nice.

I nice to have would be some sort of back up. some sort of user access control (reader or admin)

Any help would be nice.
 
Old 01-07-2008, 07:33 AM   #2
tronayne
Senior Member
 
Registered: Oct 2003
Location: Northeastern Michigan, where Carhartt is a Designer Label
Distribution: Slackware 32- & 64-bit Stable
Posts: 3,541

Rep: Reputation: 1065Reputation: 1065Reputation: 1065Reputation: 1065Reputation: 1065Reputation: 1065Reputation: 1065Reputation: 1065
This sounds like you're looking for an inventory application? If so, a combination of MySQL and PHP might just work for you -- Google for "linux php inventory" and there are quite a few (well, millions) of possibilities and it might be worth looking through the first couple of pages to see what's available.

Broadly, you'd probably want to have an inventory system built in a data base management system (that would be MySQL) with an interactive front end (that would be PHP) to view and alter the information in the data base's tables; you want PHP so you can have browser-based forms to view and alter information.

Take a look and see if something fits your needs.
 
Old 01-08-2008, 11:07 AM   #3
stripe21
LQ Newbie
 
Registered: Jan 2008
Location: Dorking, surrey
Distribution: ubuntu, puppy, suse
Posts: 19

Original Poster
Rep: Reputation: 0
thanks for the post i have been looking around to find something that looks like its a gower.
I have got
Apache2
PHP
mysql
all running, the problem i have now is that i need Perl.

How do i install that as i have had a look about the docs for ubuntu and can not find it?
 
Old 01-08-2008, 11:33 AM   #4
Emerson
LQ Sage
 
Registered: Nov 2004
Location: Saint Amant, Acadiana
Distribution: Gentoo ~amd64
Posts: 7,661

Rep: Reputation: Disabled
Perl comes usually with base system, no need to install it.
 
Old 01-09-2008, 05:19 AM   #5
stripe21
LQ Newbie
 
Registered: Jan 2008
Location: Dorking, surrey
Distribution: ubuntu, puppy, suse
Posts: 19

Original Poster
Rep: Reputation: 0
Question

i have found (what looks like) a better tracker, but i am getting problems with the install.

This is the install page

http://sourceforge.net/projects/asset-tracker/

i have followed the install txt file but all i get is .............

Warning: mysql_connect() [function.mysql-connect]: Access denied for user 'www-data'@'localhost' (using password: NO) in /var/www/asset-tracker/wwwroot/functions/variables.php on line 184

Warning: mysql_select_db(): supplied argument is not a valid MySQL-Link resource in /var/www/asset-tracker/wwwroot/functions/variables.php on line 185

Warning: mysql_query() [function.mysql-query]: Access denied for user 'www-data'@'localhost' (using password: NO) in /var/www/asset-tracker/wwwroot/functions/sql.php on line 460

Warning: mysql_query() [function.mysql-query]: A link to the server could not be established in /var/www/asset-tracker/wwwroot/functions/sql.php on line 460

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /var/www/asset-tracker/wwwroot/functions/display.php on line 112

Warning: mysql_query() [function.mysql-query]: Access denied for user 'www-data'@'localhost' (using password: NO) in /var/www/asset-tracker/wwwroot/functions/sql.php on line 460

Warning: mysql_query() [function.mysql-query]: A link to the server could not be established in /var/www/asset-tracker/wwwroot/functions/sql.php on line 460

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /var/www/asset-tracker/wwwroot/functions/display.php on line 120

Warning: mysql_query() [function.mysql-query]: Access denied for user 'www-data'@'localhost' (using password: NO) in /var/www/asset-tracker/wwwroot/functions/sql.php on line 460

Warning: mysql_query() [function.mysql-query]: A link to the server could not be established in /var/www/asset-tracker/wwwroot/functions/sql.php on line 460

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /var/www/asset-tracker/wwwroot/functions/display.php on line 128

Warning: mysql_query() [function.mysql-query]: Access denied for user 'www-data'@'localhost' (using password: NO) in /var/www/asset-tracker/wwwroot/functions/sql.php on line 460

Warning: mysql_query() [function.mysql-query]: A link to the server could not be established in /var/www/asset-tracker/wwwroot/functions/sql.php on line 460

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /var/www/asset-tracker/wwwroot/functions/display.php on line 136

Warning: mysql_query() [function.mysql-query]: Access denied for user 'www-data'@'localhost' (using password: NO) in /var/www/asset-tracker/wwwroot/functions/sql.php on line 460

Warning: mysql_query() [function.mysql-query]: A link to the server could not be established in /var/www/asset-tracker/wwwroot/functions/sql.php on line 460

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /var/www/asset-tracker/wwwroot/functions/display.php on line 144

Warning: mysql_query() [function.mysql-query]: Access denied for user 'www-data'@'localhost' (using password: NO) in /var/www/asset-tracker/wwwroot/functions/sql.php on line 460

Warning: mysql_query() [function.mysql-query]: A link to the server could not be established in /var/www/asset-tracker/wwwroot/functions/sql.php on line 460

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /var/www/asset-tracker/wwwroot/functions/display.php on line 152
go to page: main
logged in as:

Warning: mysql_query() [function.mysql-query]: Access denied for user 'www-data'@'localhost' (using password: NO) in /var/www/asset-tracker/wwwroot/functions/sql.php on line 460

Warning: mysql_query() [function.mysql-query]: A link to the server could not be established in /var/www/asset-tracker/wwwroot/functions/sql.php on line 460

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /var/www/asset-tracker/wwwroot/functions/sql.php on line 209

No "view assets" permission allowed

Warning: mysql_query() [function.mysql-query]: Access denied for user 'www-data'@'localhost' (using password: NO) in /var/www/asset-tracker/wwwroot/functions/sql.php on line 460

Warning: mysql_query() [function.mysql-query]: A link to the server could not be established in /var/www/asset-tracker/wwwroot/functions/sql.php on line 460

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /var/www/asset-tracker/wwwroot/functions/sql.php on line 209

No "add assets" permission allowed

Warning: mysql_query() [function.mysql-query]: Access denied for user 'www-data'@'localhost' (using password: NO) in /var/www/asset-tracker/wwwroot/functions/sql.php on line 460

Warning: mysql_query() [function.mysql-query]: A link to the server could not be established in /var/www/asset-tracker/wwwroot/functions/sql.php on line 460

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /var/www/asset-tracker/wwwroot/functions/sql.php on line 209

No "modify assets structure" permission allowed

I have looked at the PHP file to make sure that all the information is in there, but im not up to speed with what should / shouldn't be in there.
 
Old 01-18-2008, 05:48 AM   #6
stripe21
LQ Newbie
 
Registered: Jan 2008
Location: Dorking, surrey
Distribution: ubuntu, puppy, suse
Posts: 19

Original Poster
Rep: Reputation: 0
I have not got it all up and running. its a very good system, some lacking in backups/restores and the passwords are not working.

its "ronsil" dose what it said on the tin
 
  


Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off



Similar Threads
Thread Thread Starter Forum Replies Last Post
(my)sql: drop database doesn't remove database kpachopoulos Programming 3 09-19-2007 01:32 PM
Database Programming (database to database transaction) johncsl82 Programming 7 02-02-2007 08:20 AM
LXer: A database solution is more than database software LXer Syndicated Linux News 0 09-25-2006 08:54 AM
Upgrading stock 2.4.22 kernel to 2.5.x then to 2.6.6 with existing stock .config file Kyl3 Slackware 8 06-09-2004 05:34 PM
Stock software shelby General 2 02-28-2003 12:14 PM

LinuxQuestions.org > Forums > Linux Forums > Linux - Software

All times are GMT -5. The time now is 06:25 AM.

Main Menu
Advertisement
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Open Source Consulting | Domain Registration