On Thu, 17 Apr 2008, plopfun wrote:

> BTW: I can't decompress the archive when i download keystone-
> 0_74_00.tar.gz at http://www.stonekeep.com/keystone.php, anyone who has
> a version that can be uncompresed ?

Do you get different results than these?

bigby@home [10] [12:48pm] >wget
http://www.stonekeep.com/downloads/keystone-0_74_00.tar.gz
--12:48:05--  http://www.stonekeep.com/downloads/keystone-0_74_00.tar.gz
             => `keystone-0_74_00.tar.gz'
Resolving www.stonekeep.com... 64.34.193.47
Connecting to www.stonekeep.com|64.34.193.47|:80... connected.
HTTP request sent, awaiting response... 200 OK
Length: 327,373 (320K) [application/x-gzip]

100%[=====================================================================>]
327,373       34.52K/s    ETA 00:00

12:48:18 (34.39 KB/s) - `keystone-0_74_00.tar.gz' saved [327373/327373]

bigby@home [11] [12:48pm] >gunzip -vt keystone-0_74_00.tar.gz
keystone-0_74_00.tar.gz:          OK
bigby@home [12] [12:49pm] >md5 keystone-0_74_00.tar.gz
MD5 (keystone-0_74_00.tar.gz) = 0232df78a1d176bd7fb953daa04604d6
bigby@home [13] [12:49pm] >cksum keystone-0_74_00.tar.gz
1241158997 327373 keystone-0_74_00.tar.gz



--
What garlic is to food, insanity is to art.

finger://ephemeron.org/bigby
http://www.ephemeron.org/~bigby/
irc://irc.ephemeron.org/#the_pub
news://news.ephemeron.org/alt.lemurs

plopfun wrote:
  > I have inherit a installation of Keystone 0.74 a like to get the mail
working.
  > I installed all of the perl components, and got keymail.pl -h working.
  > But i don't get any mails in keystone, and have the following error
when i do a keymail.pl -debug
  > Keystone.pm: Connecting to 'keystone' on 'localhost'...
  > Keystone.pm: Connected.
  >   (in cleanup) Can't call method "disconnect" on an undefined value
at /work/www/keystone/perl/Keystone.pm line 260 during global destruction.

Keymail was never really completed - it was a bit of a hack one of my
users put together, and I never really did major work on it (and later
abandoned it).  So I don't think I can help that one :)

  > I also get "unknown mailer error 2" in my maillog when i try to mail
keystone.

Is that generating mail from Keystone sending out?  Or something sending
stuff into Keystone?

  > BTW: I can't decompress the archive when i download keystone-
  > 0_74_00.tar.gz at http://www.stonekeep.com/keystone.php, anyone who
has a version that can be uncompresed ?

I just downloaded that version, and it uncompressed fine:

http://pastebin.stonekeep.com/2066

So nothing wrong there :)

Good luck!

      -d

I have inherit a installation of Keystone 0.74 a like to get the mail
working.
I installed all of the perl components, and got keymail.pl -h working.
But i don't get any mails in keystone, and have the following error
when i do a keymail.pl -debug
Keystone.pm: Connecting to 'keystone' on 'localhost'...
Keystone.pm: Connected.
   (in cleanup) Can't call method "disconnect" on an undefined value
at /work/www/keystone/perl/Keystone.pm line 260 during global
destruction.

I also get "unknown mailer error 2" in my maillog when i try to mail
keystone.

Anyone have a solution to that problem, og any suggestion to solve it ?

BTW: I can't decompress the archive when i download keystone-
0_74_00.tar.gz at http://www.stonekeep.com/keystone.php, anyone who has
a version that can be uncompresed ?

David Platt wrote:
> Perhaps you can point me in the right direction. I am using a host that
> has PHP 5.2.3 and Mysql and am running the newest version of Keystone. The
> install went well, however when I go to log in, I am logged in, but when I
> attempt to do anything, such as add slips, I am told that I am not
> currently logged in. Why would this happen? Is there an incompatibility
> with PHP 5?

I haven't tested it completely with PHP5, so I'm going to Cc this back
to the keystone-users mailing list.

This sort of failure is usually due to the cookie expiring in the
browser super-fast.  Either you're not accepting cookies at all, or the
clock between your server and your web browser is skewed more than...
*thinks* I think it's 15 minutes.

Hope that helps!

	 -dbs

seanbcatdurkin wrote:
> Hello.
>
> How does one install KeyStone?
> Where can I find an installation/configuration guide?

The isntallation guide is included with the distribution.  It is also
available here:

http://keystone.stonekeep.com/docs/INSTALL

> Is KeyStone compatible with PHP version 5.2.3 and MySQL version 5.1 ?

Yep.

> Is there a forums web-site or usenet newsgroup?

The keystone-users list is the best place to check for information or
questions.

	 -dbs

Hello.

How does one install KeyStone?
Where can I find an installation/configuration guide?

Is KeyStone compatible with PHP version 5.2.3 and MySQL version 5.1 ?

Is there a forums web-site or usenet newsgroup?

Faithfully,
Sean B. Durkin

Version 0.90.30 has been published on the website.

Here's the changelog for this release...

release-0.90.30
	 * released on 2007-05-30
	 * Changed default 'short date format' to match long format, just
shorter [dbs]
	 * Fixed problems with dates in reports
	 * Fixed contacts reports to do simple address / phone number listings [dbs]
	 * re-enabled Accessories editing and updating [dbs]
	 * Fixed many bugs in Contacts (not showing fields, delete failing, etc)
[dbs]
	 * Took out tons of unused / redundant code in nbrowse [dbs]
	 * Basically rewrote the resources module [dbs]
	 * Replaced menus with new navigation module, removed from nbrowse [dbs]
	 * Updated 'update counters' function to new display model [dbs]
	 * Fixed a problem with Runreports not parsing properly [thanks DLB!]
	 * Fixed non-escaped single quotes in filter editor [dbs]
	 * Fixed search and jump to functions [dbs]

Enjoy!

Kumar, Aseem wrote:
> I downloaded this but when I try to open in WinZip I receive an error:
>
> Error reading header after processing 0 entries.

Winzip has a hard time with the filename.  Rename the file to
'keystone.tar.gz' and it will unpack correctly.

(BTW - this is a good question for keystone-users.  REplying to there)

	 -dbs

Keystone 0.90.20 is now available on http://www.stonekeep.com/.  From
the changelog:

release-0.90.20
	 * re-enabled the 'add child' button in slip zooms [dbs]
	 * added ability to target auto-generated forms to new windows [dbs]
	 * fixed various rendering problems in reports [dbs]
	 * fixed slip editors for bugtrack info, adding followup generation [dbs]
	 * added bugtracking table editors back into maintenance page [dbs]
	 *  fixed formatting of auto-generated email [dbs]
	 * fixed a problem with 'public' settings not sticking [dbs]
	 * redid color by priority into CSS.  now works. [dbs]
	 * fixed problem in stripslashes() views [dbs]
	 * fixed MANY problems in Contacts.  Basically overhauled [dbs]
	 * Added alt tags to many IMG SRC entries [dbs]
	 * Made 'Contacts' pulldown on slips work correctly [dbs]

I'm actively looking for testers on this release, particularly 'older'
keystone users looking to check functionality and looking for new
enhancements.

Anyone still out there?  :)

Jayme wrote:
> I recently did a fresh install of Keystone2 0.9.10
>
> Everything seems to be working ok, but I can't add a contact. Whenever
> I do it just comes out with all blanks. It looks like the form data
> from addcontact.php is not being passed to postcontact.php
>
> Here is some debug output:
>
> --
> :DEBUG:nbrowse.php:IsSet f_process: postcont
>
> :DEBUG:postcontact.php:tag , name
> :DEBUG:db_query:insert into contacts
> (tag,name,company,email,passwd,ctype,comment) values
> ('','','','','','','')
>
> :DEBUG:nbrowse.php:add: 'add' and state is 'contacts'
> --
>
> Any ideas?

Hi Jayme - yes, from  many months in the future, my apologies.

The Contacts system was very very broken in the 0.90 release.  I've jsut
committed some very large changes to bring it up spec, we should have a
posted version within the next few weeks.

I am looking for testers though, so if anyone is up for pretty bleeding
edge, I can post the current cut.  It might not be pretty though :)

	 -dbs

Can graphical screen shots be incorporated into Keystone trouble
tickets?  I am aware that you can cut and paste text into tickets, does
this work for graphics as well?

I recently did a fresh install of Keystone2 0.9.10

Everything seems to be working ok, but I can't add a contact. Whenever
I do it just comes out with all blanks. It looks like the form data
from addcontact.php is not being passed to postcontact.php

Here is some debug output:

--
:DEBUG:nbrowse.php:IsSet f_process: postcont

:DEBUG:postcontact.php:tag , name
:DEBUG:db_query:insert into contacts
(tag,name,company,email,passwd,ctype,comment) values
('','','','','','','')

:DEBUG:nbrowse.php:add: 'add' and state is 'contacts'
--

Any ideas?

On Fri, 2006-02-17 at 17:01 +0000, hayes0830 wrote:
> I recently looked at a demo of the newer keystone product version 2.
> I noticed that there is a search box in the product.  I am curious
> whether this box allows users to search across all text saved in the
> trouble tickets since this is something we are looking for.

This searches the text of the ticket, as well as all followups.

> We currently have the first version.  Is searching across all data in
> this version something that can be done as well?

Yes, this same search input should exist in version 0.74.00 as well, at
least for logged in users.

I don't remember whether it exists for visitors in the default Keystone
0.74.00; I believe I have customized my copy so that it does.
--
Alex L. Mauer
Network Administrator
Banta Global Turnkey Group
Plover  WI  54467-3131
Phone +1 715 343 6980
Fax +1 715 343 7061
http://www.bgt.com/
xmpp:amauer@...

I recently looked at a demo of the newer keystone product version 2.
I noticed that there is a search box in the product.  I am curious
whether this box allows users to search across all text saved in the
trouble tickets since this is something we are looking for.

We currently have the first version.  Is searching across all data in
this version something that can be done as well?

Sandy
hayes0830@...

Hi There,

Not sure if anyone still reads this group, but here goes !

I'm trying to install Keystone 2-0_90_09 on Suse 9.2.
I've got PhP up and running and have MYSQL installed and working too.

However, when I try and access http://servername/keystone2/index.php I get

"
Fatal error: Cannot redeclare Slip::$follow_tech in
/usr/local/apache2/htdocs/keystone2/k2logic.php on line 107"


I'm not sure where to start troubleshooting this problem , but would
gratefully acceept any suggestions.

Thanks,

Peter.

I posted a question here last week, and there does not seem to be
much activity. Is there anybody out there that can help with the
question I posted on January 28? Is there another more active forum
that I can ask a question?


Thanks in advance to anyone who can help!


Mark

Trying out Keystone2 - Started out with 0.90.09, backed it out and
tried 0.90.08. Same error message when you first go in, and when you
pick on various menu choices:


Warning: pg_exec() query failed: ERROR: Attribute "admin" not found
in /var/www/html/keystone2/postgres.php3 on line 47


I set the option for debug up in keystone.conf, and it looks like in
the log file everything is going o.k. - IE it does think it is
getting logged in, etc.etc.etc....

Sort of a newbie on Keystone. Searched this forum for possible
answers before I posted. Any and all help is appreciated.

BTW, this is on RedHat 9 with all patches applied.

Thanks in advance,

Mark

After having not looked at the new code since White PJ's enter the
picture, I am pleasently supprised at the work that has been done. I
like it a lot.

The reason I grabbed the code is that I am setting up a R&D lab here
at my new job, and wanted to use Keystone.  But, I need the
sys_bugtrack stuff to work.  I noticed that it is currently not there.

I was wondering if anyone is working on this currently?  If not, where
can I get read-only access to the CVS tree so I can help add this
feature back in?

Thanks!

don

I just downloaded the latest version of Keystone2. It seems to
working just fine. I was running an earlier versionof keystone2.
When I tried to run a report I got an error that stated it couldn't
open ./reptutils.php3. So I looked in the keystone directory and
found a reputils.php. When I changed this to reputils.php3 another
report page complained that the reptutils.php was missing. So I went
into runreports.php and changed the include statement
to ./reptutils.php and this corrected the issue. Is this just a typo
in runreports or is there some other issue?

I am running Keystone2 0.90.09. The installation went smoothly, and I
have access to the database. I am running into the problem of not
being currently logged in when I log in as admin with password abc123.

Any suggestiom on what the problem might be? I have made some changes
to the php.ini, which were responses on the mailing list.

/tmp/keystone.log

[09/13/2004 11:02]@::1                  :DEBUG:db_query:select
flag,label from status
[09/13/2004 11:02]@::1                  :DEBUG:db_query:SELECT
members.id,members.element,slips.sid,slips.problem FROM slips,members
WHERE members.element = sli
ps.sid AND members.id = 'quickslips'
[09/13/2004 11:02]@::1                  :DEBUG:login.php:Login called.
  Checking
[09/13/2004 11:02]@::1                  :DEBUG:login.php:No cookie
named 'keycookie' found in the browser
[09/13/2004 11:02]@::1                  :DEBUG:login.php:No keycookie
set, -and- login wasn't set??  Somethings wrong
[09/13/2004 11:02]@::1                  :DEBUG:login.php:login has
length 0 and contains ''
[09/13/2004 11:02]@::1                  :DEBUG:login.php:password has
length0 and contains ''
[09/13/2004 11:02]@::1                  :DEBUG:login.php:Are you sure
you have register_globals set in php.ini ?
[09/13/2004 11:02]@::1                  :DEBUG:nbrowse.php:Ping.
[f_func is '',f_process is '']
[09/13/2004 11:02]@::1                  :DEBUG:db_query:SELECT
members.id,members.element,slips.sid,slips.problem FROM slips,members
WHERE members.element = slis.sid AND members.id = 'quickslips'

Any help would be greatly appeciated!

On Wed, 2004-09-08 at 09:27, Brian wrote:
> I know people read this list from time to time and I would hope that
> others believe that the priority color feature is a valuable one.

Hi Brian... sorry we didn't get back to you on the first one.

> Does anyone please have a hint on how to get this feature working in
> version 2? I'd hate to go back to the old version for better
> functionality.

I'll look into this, I believe he priority coloring got disabled in the
change over to the new stylesheet mechanism.  I'll check into it, but
I'm totally swamped under right now with CONGO work...

If someone submits a patch on this, I'll happily integrate it in, but
it'll be a bit before I can realy dig into the problem.

	 -dbs
--
-------------------.                                   .-----------
Dave Belfer-Shevett \  Conference Management Solutions \ Stonekeep
dbs@...    \    http://www.stonekeep.com      \ Consulting
---------------------'         978 239 5902              `------------

I know people read this list from time to time and I would hope that
others believe that the priority color feature is a valuable one.

Does anyone please have a hint on how to get this feature working in
version 2? I'd hate to go back to the old version for better
functionality.

Thanks
Brian

Hi group,

can anyone clarify the working of the full text search on slips?
I get weird results back. E.g. when I search for Oracle in our
database, it returns slips that only contain Oracle with a capital
O. When I search for oracle it returns all slips with oracle in all
minors, but also some slips that only contain Oracle with a starting
capital O, but not all of those are returned. When I search for
ORACLE it als returns some slips, although it is NEVER written in
all caps.
So my main question is: is the search really case sensitive or is
there a known problem?
Or does the search word different in Problem / Text / Follow up?

Thanks for any replies!

The priority colors are not working in my new installation of
Keystone2. They worked great in the older .74 system.

Does anyone have a fix for this?

Thanks
Brian

I see various people have has a problem not being able to login with a
new installation of keystone but I see no posts with the solution.
I've checked the error flag and its set to E_ERROR but I still can not
login the first time. Can someone point me in the right direction?

Running Fedora 2

Thanks
Brian

Matt helped me resolved this by updating a parameter
in the php.ini file.

Thanks.


--- Dave Belfer-Shevett <dbs@...> wrote:
> On Tue, 2004-07-06 at 15:55, Long Nguyen wrote:
> > The first thing that pops up is an error that
> says,
> > "MySQL Error # 1045 in function db_connect Access
> > denied for user: 'apache@localhost' (Using
> password:
> > NO)  & click "OK" to close it.
> >
> >
> > I then get this one line error message displayed
> on
> > the top of the browser:
> >
> > Warning: Access denied for user:
> 'apache@localhost'
> > (Using password: NO) in
> > /var/www/html/keystone2/mysql.php on line 15
>
> I refer you to the FAQ, Question 5:
>
>
---------------------------------------------------------------------
> 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.
> --
> -------------------.
>   .-----------
> Dave Belfer-Shevett \  Conference Management
> Solutions \ Stonekeep
> dbs@...    \    http://www.stonekeep.com
>    \ Consulting
> ---------------------'         978 239 5902
>     `------------
>
>




__________________________________
Do you Yahoo!?
New and Improved Yahoo! Mail - Send 10MB messages!
http://promotions.yahoo.com/new_mail

Greeting keystone-users,

Can you offer a suggestion?

I have inherited a PTS 1.72.00 system used to track computer support.
It has never given us a problem and we are happy with the features,
but it runs on and out-of-date system.  I am trying to port it to
an up-to-date system without success.  Can you help?

The current PTS system runs on an old Linux box with:
PHP/FI 2.0.1
Apache 1.2.6
MySQL Ver 9.15 Distrib 3.21.30, for pc-linux-gnu (i686)

I want to port to a system with:
PHP 4.3.2
Apache 2.0.46
MySQL 3.23.59

The initial symptom is:
After entering the username and password on the Problem Tracking System
login screen, we receive this message:

Parse error: parse error in /var/www/html/pts/login.phtml on line 43

login.phtml is listed below.  Judging by the surrounding lines, I would
guess line 43 could be prefixed by "$" and suffixed with ";".
Making this change yields a parsing error in line 46.
So I feel this would be the beginning of an elaborate process to
detect and change all instances of this type if indeed this were possible.

At this point, we are using all the the PHP/FI *.phtml code.
Last week, in an effort to get this to work, I had run the
PHP "convertor" (http://www.php.net/manual/en/print/migration.php)
to convert PHP 2/FI to PHP3.  The "convertor" gave a parsing error
for eleven of the PHP scripts.  The docs for the "convertor" caution
that syntax checking for the converter is more strict than that in
PHP/FI itself.

Here is the relevant PHP configuration and the
Apache/PHP configuration.

#
# date
Tue Jul  6 11:09:51 EDT 2004
#
# grep "global" /etc/php.ini
; Whether or not to register the EGPCS variables as global variables.
  You may
; want to turn this off if you don't want to clutter your scripts'
global scope
; register_globals to be on;  Using form variables as globals can
easily lead
#register_globals = Off
register_globals = On
; to initialize a session variable in the global scope, albeit
register_globals
#

# cat /etc/httpd/conf.d/php.conf
#
# PHP is an HTML-embedded scripting language which attempts to make it
# easy for developers to write dynamically generated webpages.
#

LoadModule php4_module modules/libphp4.so

#
# Cause the PHP interpreter handle files with a .php extension.
# Added .phtml and .php3 for pts - 040708 - Dick Howard
#
<Files *.php>
     SetOutputFilter PHP
     SetInputFilter PHP
     LimitRequestBody 524288
</Files>

<Files *.php3>
     SetOutputFilter PHP
     SetInputFilter PHP
     LimitRequestBody 524288
</Files>

<Files *.phtml>
     SetOutputFilter PHP
     SetInputFilter PHP
     LimitRequestBody 524288
</Files>

#
# Add index.php to the list of files that will be served as directory
# indexes.
#
DirectoryIndex index.php
#

# ls -gR /var/www/html/pts
/var/www/html/pts:
total 372
-rwxr-xr-x    1 users        1754 Aug 15  1997 addfollow.phtml
-rwxr-xr-x    1 users        3409 Jun  1  1998 add.phtml
-rwxr-xr-x    1 users        3349 Jun  1  1998 add.phtml.org
-rwxr-xr-x    1 users       20922 Mar 22  2002 browse.phtml
-rwxr-xr-x    1 root        19854 Mar 18  2002 browse.phtml.020318
-rwxr-xr-x    1 users       19597 Jul 14  1998 browse.phtml.Jul14
-rwxr-xr-x    1 users       19536 Jul  8  1998 browse.phtml.save
-rwxr-xr-x    1 users       19465 Jun 18  1998 browse.phtmly
-rwxr-xr-x    1 users         945 Aug 15  1997 chpwd.phtml
-rwxr-xr-x    1 users        1682 Aug 15  1997 close.phtml
-rwxr-xr-x    1 users        1917 Dec 23  1997 contadd.phtml
-rwxr-xr-x    1 users        1612 Dec 23  1997 contbrowse.phtml
-rwxr-xr-x    1 users        2764 Dec  8  1997 db.phtml
drwxr-xr-x    2 users        4096 Dec 29  1997 docs
-rwxr-xr-x    1 users        1141 Dec 23  1997 footer.phtml
-rwxr-xr-x    1 users        1166 Nov 20  1997 forcepw.phtml
drwxr-xr-x    2 users        4096 Dec 29  1997 graphics
-rwxr-xr-x    1 users         307 Aug 14  1997 grouplist.inc
-rwxr-xr-x    1 users         280 Jun 17  1997 hcell.phtml
-rwxr-xr-x    1 users        3656 Jul  3 03:20 header.phtml
-rwxr-xr-x    1 users        3652 May  6  1998 header.phtml.org
-rwxr-xr-x    1 users        3649 Aug 20  1998 header.phtml.orig
-rwxr-xr-x    1 users        1193 May  6  1998 index.html
-rwxr-xr-x    1 users        1193 May  6  1998 index.html.org
-rwxr-xr-x    1 users        1620 Aug 15  1997 indextic.html
-rwxr-xr-x    1 users        1186 May  6  1998 login.phtml
-rwxr-xr-x    1 users        1186 May  6  1998 login.phtml.org
-rwxr-xr-x    1 users        1446 May 15  1998 mailtest.phtml.save
-rwxr-xr-x    1 users        1631 Feb  5  1999 mailutils.phtml
-rwxr-xr-x    1 users        1574 May  7  1998 mailutils.phtml.org
-rwxr-xr-x    1 users        1945 Dec 23  1997 maintenance.phtml
-rwxr-xr-x    1 users        1877 Jul  8  1997 mbrowse.phtml
-rwxr-xr-x    1 users         771 Jul  8  1997 mdelete.phtml
-rwxr-xr-x    1 users        2135 Jul  8  1997 medit.phtml
-rwxr-xr-x    1 users         973 Jun 17  1997 memview.phtml
-rwxr-xr-x    1 users        4209 Jul 27  1998 modify.phtml
-rwxr-xr-x    1 users        4048 Jun  1  1998 modify.phtml.org
-rwxr-xr-x    1 users         733 Jul  8  1997 mpdelete.phtml
-rwxr-xr-x    1 users        1537 Jul  8  1997 mpost.phtml
-rwxr-xr-x    1 users        1942 Dec  8  1997 msql.phtml
-rwxr-xr-x    1 users        1917 Dec  8  1997 mysql.phtml
-rwxr-xr-x    1 users        3049 Aug 15  1997 newticket.phtml
-rwxr-xr-x    1 users        3706 Jun  1  1998 padd.phtml
-rwxr-xr-x    1 users        3646 Jun  1  1998 padd.phtml.org
-rwxr-xr-x    1 users         760 Aug 15  1997 pclose.phtml
-rwxr-xr-x    1 users        4829 Dec 23  1997 pmodify.phtml
-rwxr-xr-x    1 users        2521 Jun 17  1998 postadd.phtml
-rwxr-xr-x    1 users        1497 Dec 23  1997 postcadd.phtml
-rwxr-xr-x    1 users        2183 Aug 15  1997 postclose.phtml
-rwxr-xr-x    1 users        1027 Jun 17  1997 postfoll.phtml
-rwxr-xr-x    1 users        3749 Dec  8  1997 postgres.phtml
-rwxr-xr-x    1 users        2417 Dec 23  1997 postmod.phtml
-rwxr-xr-x    1 users        1562 Jul  7  1997 postpadd.phtml
-rwxr-xr-x    1 users        2074 Aug 15  1997 postpmod.phtml
-rwxr-xr-x    1 users         976 Aug 15  1997 postprefs.phtml
-rwxr-xr-x    1 users        2129 Aug 15  1997 prefs.phtml
-rwxr-xr-x    1 users        8881 Dec 23  1997 preview.phtml
-rwxr-xr-x    1 users         653 Jun 17  1997 projlist.inc
-rwxr-xr-x    1 users         794 Jul 10  1998 rdelete.phtml
-rwxr-xr-x    1 users        5165 Jul  7  1998 review.phtml
-rwxr-xr-x    1 users        5165 Jul 14  1998 review.phtml.Jul14
-rwxr-xr-x    1 users         683 Jul 10  1998 rpdelete.phtml
-rwxr-xr-x    1 users         417 Aug 14  1997 statlist.inc
drwxr-xr-x    2 users        4096 Dec 29  1997 struct
-rwxr-xr-x    1 users         660 Jul 14  1998 tasklist.inc
-rwxr-xr-x    1 users         644 Jul 14  1998 tasklist.inc.Jul14

/var/www/html/pts/docs:
total 48
-rwxr-xr-x    1 users        4301 Jun 17  1997 convert
-rwxr-xr-x    1 users        5283 Dec 29  1997 faq
-rwxr-xr-x    1 users        9440 Dec 29  1997 history
-rwxr-xr-x    1 users        5044 Dec 29  1997 install
-rwxr-xr-x    1 users        1675 Jun 20  1997 packinglist
-rwxr-xr-x    1 users        3196 Jun 17  1997 prefs
-rwxr-xr-x    1 users        1491 Jun 20  1997 README

/var/www/html/pts/graphics:
total 60
-rwxr-xr-x    1 users         187 Dec 23  1997 add.gif
-rwxr-xr-x    1 users         211 Jun 17  1997 addtask.gif
-rwxr-xr-x    1 users         208 Dec 23  1997 browse.gif
-rwxr-xr-x    1 users         193 Jun 17  1997 close.gif
-rwxr-xr-x    1 users         211 Dec 23  1997 contacts.gif
-rwxr-xr-x    1 users         210 Jun 17  1997 followup.gif
-rwxr-xr-x    1 users         199 Jun 17  1997 logout.gif
-rwxr-xr-x    1 users         193 Jun 17  1997 maint.gif
-rwxr-xr-x    1 users         203 Jun 17  1997 modify.gif
-rwxr-xr-x    1 users         230 Jun 17  1997 newproject.gif
-rwxr-xr-x    1 users         214 Jun 17  1997 newtask.gif
-rwxr-xr-x    1 users         181 Jun 17  1997 post.gif
-rwxr-xr-x    1 users         191 Jun 17  1997 prefs.gif
-rwxr-xr-x    1 users         201 Jun 17  1997 return.gif
-rwxr-xr-x    1 users         209 Jun 17  1997 update.gif

/var/www/html/pts/struct:
total 100
-rwxr-xr-x    1 users         434 Dec 23  1997 contacts.mysql
-rwxr-xr-x    1 users         450 Aug 14  1997 followups.mysql
-rwxr-xr-x    1 users         391 Aug 14  1997 followups.psql
-rwxr-xr-x    1 users         406 Aug 14  1997 followups.struct
-rwxr-xr-x    1 users         377 Aug 14  1997 groups.mysql
-rwxr-xr-x    1 users         443 Aug 14  1997 groups.psql
-rwxr-xr-x    1 users         454 Aug 14  1997 groups.struct
-rwxr-xr-x    1 users         666 May  6  1998 master.mysql
-rwxr-xr-x    1 users         515 Aug 14  1997 master.psql
-rwxr-xr-x    1 users         515 Aug 14  1997 master.struct
-rwxr-xr-x    1 users         668 Dec 23  1997 people.mysql
-rwxr-xr-x    1 users         690 Aug 14  1997 people.psql
-rwxr-xr-x    1 users         686 Aug 20  1997 people.struct
-rwxr-xr-x    1 users        1353 Dec  2  1997 prefs.mysql
-rwxr-xr-x    1 users        1729 Dec  2  1997 prefs.psql
-rwxr-xr-x    1 users        1718 Dec  2  1997 prefs.struct
-rwxr-xr-x    1 users         630 Aug 14  1997 projects.mysql
-rwxr-xr-x    1 users         582 Aug 14  1997 projects.psql
-rwxr-xr-x    1 users         606 Aug 14  1997 projects.struct
-rwxr-xr-x    1 users         652 Aug 14  1997 status.mysql
-rwxr-xr-x    1 users         652 Aug 14  1997 status.psql
-rwxr-xr-x    1 users         652 Aug 14  1997 status.struct
-rwxr-xr-x    1 users         680 Aug 14  1997 tasks.mysql
-rwxr-xr-x    1 users         632 May 28  1998 tasks.psql
-rwxr-xr-x    1 users         623 May 28  1998 tasks.struct
#

# date
Tue Jul  6 11:12:15 EDT 2004
# cat /var/www/html/pts/login.phtml
<?

         include "db.phtml";

         /* Connect up and get some values */

         db_connect($dbhost);

         $n      =       db_query("select * from people where
login='$login'");
         $nr     =       db_numrows($n);

         $s      =       db_query("select cvalue from master where
flag='serverkey'");
         $serverkey = db_result($s,0,"cvalue");

         if ($nr <= 0) {
                 setcookie("ptsuser","",time());
                 echo "<center><h2>Login incorrect</h2>\n";
                 echo "<a href=\"index.html\">Return</a></center>";
                 exit;
         } else {
                 $dbpw = db_result($n,0,"password");
                 $dbuser = db_result($n,0,"login");
                 $dbfull = db_result($n,0,"fullname");
                 $hpw = md5($password);
                 if ((strlen("$password") == 0) && ($dbuser == "guest")) {
                         $ptsuser=$login;
                 } else {
                         if ($dbpw != $hpw) {
                                 setcookie("ptsuser","",time());
                                 echo "dbpw is $dbpw<br>hpw is
$hpw<br>dbuser is $dbuser<br>strlen of password is";
                                 echo strlen("$password");
                                 echo "<center><h2>Login incorrect</h2>\n";
                                 echo "<a
href=\"index.html\">Return</a></center>";
                                 exit;
                         } else {
                                 $ptsuser=$login;
                         }
                 }
         }

         $clkey = "$login"+"_"+md5("$login:$serverkey:$dbpw");
         setcookie("ptsuser",$clkey,time()+36000)
         $ptsuser="$clkey";
         $curruser=$login;
>
<? include "browse.phtml" >

# date
Tue Jul  6 11:12:38 EDT 2004

Thanks,
Dick

On Tue, 2004-07-06 at 15:55, Long Nguyen wrote:
> The first thing that pops up is an error that says,
> "MySQL Error # 1045 in function db_connect Access
> denied for user: 'apache@localhost' (Using password:
> NO)  & click "OK" to close it.
>
>
> I then get this one line error message displayed on
> the top of the browser:
>
> Warning: Access denied for user: 'apache@localhost'
> (Using password: NO) in
> /var/www/html/keystone2/mysql.php on line 15

I refer you to the FAQ, Question 5:

---------------------------------------------------------------------
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.
--
-------------------.                                   .-----------
Dave Belfer-Shevett \  Conference Management Solutions \ Stonekeep
dbs@...    \    http://www.stonekeep.com      \ Consulting
---------------------'         978 239 5902              `------------

Now when I try to bring up keystone on my browser


The first thing that pops up is an error that says,
"MySQL Error # 1045 in function db_connect Access
denied for user: 'apache@localhost' (Using password:
NO)  & click "OK" to close it.


I then get this one line error message displayed on
the top of the browser:

Warning: Access denied for user: 'apache@localhost'
(Using password: NO) in
/var/www/html/keystone2/mysql.php on line 15

and then a 'Log into Keystone2' one the left side and
a 'View / Create a slip' on the right side

in the middle body of the browser, I get these
messages:


Warning: Access denied for user: 'apache@localhost'
(Using password: NO) in
/var/www/html/keystone2/mysql.php on line 25

Warning: MySQL Connection Failed: Access denied for
user: 'apache@localhost' (Using password: NO) in
/var/www/html/keystone2/mysql.php on line 25

Warning: MySQL: A link to the server could not be
established in /var/www/html/keystone2/mysql.php on
line 25

Warning: Variable passed to each() is not an array or
object in /var/www/html/keystone2/index.php on line
106

Warning: Access denied for user: 'apache@localhost'
(Using password: NO) in
/var/www/html/keystone2/mysql.php on line 25

Warning: MySQL Connection Failed: Access denied for
user: 'apache@localhost' (Using password: NO) in
/var/www/html/keystone2/mysql.php on line 25

Warning: MySQL: A link to the server could not be
established in /var/www/html/keystone2/mysql.php on
line 25

Warning: mysql_numrows(): supplied argument is not a
valid MySQL result resource in
/var/www/html/keystone2/mysql.php on line 37


and at the very bottom, I get 'Browse public slips'









__________________________________
Do you Yahoo!?
Take Yahoo! Mail with you! Get it on your mobile phone.
http://mobile.yahoo.com/maildemo

On Tue, 2004-07-06 at 05:41, Lea Gris wrote:
> Upgrading from keystone 0.71.02 to Keystone2 0.71.02, the conversion
> script schecker.php3 point to a broken URL inside stonekeep web site:
> <http://www.stonekeep.com/structserver.php3>
> as its third step...
>
> and it doesn't exist any more! (Thanks 404 Not Found)
>
> Where is this structserver.php3 gone ?
>
> How should I manage to upgrade without schecker.php3 not working and
> structserver.php3 gone ?

The structure server is not available anymore... you can just skip this
step.  There are no database structure changes from 0.71.02 to K2.

	 -dbs
--
-------------------.                                   .-----------
Dave Belfer-Shevett \  Conference Management Solutions \ Stonekeep
dbs@...    \    http://www.stonekeep.com      \ Consulting
---------------------'         978 239 5902              `------------