Keystone Frequently Asked Questions http://keystone.stonekeep.com/docs/FAQ --------------------------------------------------------------------- This document is (c)2004 Stonekeep Consulting, Inc see http://www.stonekeep.com/license.html for licensing information --------------------------------------------------------------------- $Id: FAQ 180 2004-05-21 17:15:36Z dbs $ --------------------------------------------------------------------- Q1: In PTS, there were projects and tasks. Now there are just slips. What gives? A: Correct. Keystone makes no distinction between a task with subtasks, and a project. The seperation of them in PTS was a limitation, since tasks couldn't have children, etc. Any slip can have child slips, that can be dependent on the closing of another task, or have child tasks of their own. --------------------------------------------------------------------- Q2: What is a Filter? A: A filter is a certain rule applied to a table that can limit the number of rows you see from that table. For instance, you can set a filter to only show you open slips, or ones you opened, or ones opened by a certain technician between two dates. Filters can be set up by the system adminstrator, so any user can select one of tyhe publically defined filters, or users can generate their own. Filters may be turned on and off by just clicking on the 'ON' or 'OFF' graphic next to the 'Filters are...' pick on the menu. To view/add/edit filters, select 'Filters' under the 'Other' menu. --------------------------------------------------------------------- Q3: I added in a new user, but they can't log in? What gives? A: The tool used to add users is a generic table browser, and knows nothing about encrypted passwords. It stored the password away for the user without encrypting it. Go to the Maintenance functions, and click on 'Change Password'. Change the username to the name of the user just added, and type in their new password. This will encrypt their password and store it in the table. --------------------------------------------------------------------- Q4: When I'm installing Keystone for the first time, I'm able to see the login screen, but anything after that either comes up with a 'not logged in' screen, or a 'mysql' error, or the like. A: There are many reasons this can happen. The first is that PHP is not configured properly, or MySQL hasn't been configured right. Run down this checklist to confirm your installation: 1) create a file called 'test.php3', and put in it. Point your web browser at it, and make sure you have the database support you need in it. 2) Make sure you have the 'keystone' database created in your system, and that your server has all the tables required from the 'struct' directory. 3) The best way to debug these problems is to turn on full debugging in the logfile (see Q11) and watch a normal login attempt. --------------------------------------------------------------------- Q5: I've installed MySQL, but I keep getting "you have no permission to access this table" or some similar security issue. How do I get it working? A: MySQL is very touchy about access configurations in its 'grant' tables, and they can be very difficult to get right. If your security model allows it, try running 'mysqld' with '--skip-grant-tables'. If that works, then everything but your grant tables is configured properly. Another issue that comes up is that the MIT pthreads library frequently doesn't allow 'localhost' as a target host for the connect function. Put in a FQDN, and try again. --------------------------------------------------------------------- Q6: I'm still getting "You have no permission to access this table" but I don't want to run using '--skip-grant-tables'. Is there any hope? A: Yup. Matt Barnson (matt_barnson@singletrac.com) wrote a good blurb on how to set up the grant tables correctly. It's in 'grant_tables.txt' in your 'docs' directory where you installed Keystone. --------------------------------------------------------------------- Q7: When I select Slips->Properties (or Contacts->Properties), the instructions under "Main Slips View" says "Check the columns you want to appear in the normal slips view." but there is nothing to check. I'm using Postgres as the database engine. A: The current Postgres query in properties.php3 will not list anything under the "Main Slips View" column the first time a user attempts to edit their properties. This is because (1) Postgres version < 6.5 does not support outer joins and (2) the query being used by Postgres does an inner join only finding previous user settings. Fortunately, there is a bug in the properties update that inserts rows into propdisp even if the user does not change/set anything. So, if the user selects Slips->Properties then hits the "Post Changes" button they can Slips->select Slips->Properties a second time and see the full Slips->list. Once Postgres 6.5 is released (it will probably go beta in February 1999), outer joins will supposedly be supported (maybe, the programmer working on that isn't as far along as he would like). Once outer joins are part of Postgres, an upgrade to 6.5 will be mandatory.... I am reluctant to "fix" this with an elaborate set of queries since the real fix will be when Postgres supports outer joins and that is already on the radar screen.... --------------------------------------------------------------------- Q8: I've just installed Keystone, and I hit my first page. I get the following error: Fatal error: Call to unsupported or undefined function mysql_pconnect() in mysql.php3 on line 16 A: You're either running an older version of PHP (you should be running 3.0.6 or later), or you do not have MySQL support compiled into your PHP. Recompile --with-mysql, and try again. --------------------------------------------------------------------- Q9: I can't seem to get more than one person to appear as a member of the 'Tech' or 'Admin' groups. What gives? A: Certain browsers don't handle the Maintenance->Group lists functions correctly. You need to highlight -all- the members of the group and then click "Post Listing". You may need to hold down the Control key when selecting more than one person, depending on the browser. --------------------------------------------------------------------- Q10: I'm running IE, and get the following error when working with slips: MySQL error #1064 in function db_query parse error near 'xpent=' at line 1 A: This is a problem that comes up in international versions of Internet Explorer, where '&time;' is a keyword. The current CVS version of Keystone has this fixed, or yoiu can manually edit 'slips.php3', looking for 'timespent', and changing it to read &timespent. Should be around line 201. --------------------------------------------------------------------- Q11: How do i turn on or off debugging so I can figure out a problem? A: Keystone generates a logfile while running in /tmp/keystone.log. To turn on logging to this file, edit your conf/keystone.conf file and change these lines: # Where should the logfile be? $sys_logfile = "/tmp/keystone.log"; $sys_loginfo = 1; $sys_logerr = 1; $sys_logdebug = 1; Note that logging should be turned off when not in use. It generates a lot of output, and may contain information you may not want in a public directory.