This is a newbie question. We have 0.50.01 up and running with MySQL on a Sun. Most of it works, but we're having a problem adding a slip. In the "Assigned...
Byron Davies
bxd@...
Apr 5, 1999 11:02 pm
516
Yup - got confused by this myself. 1) The 'group' field in the 'user' table isn't related to the 'groups' table. 2) Neither of the above is related to the...
Chris Shaffer
shaffer@...
Apr 5, 1999 11:47 pm
517
I get the following error when I try to login to the system with the admin account. Fatal error: Call to unsupported or undefined function mysql_pconnect() in ...
lsrice@...
Apr 7, 1999 9:42 pm
518
You PHP3 is not built with mysql support. If you are running on Red Hat Linux you need to rebuild the mod_php3 RPM to include MySQL support. It's not hard to...
Lance A. Brown
brown9@...
Apr 8, 1999 12:58 am
519
... And we should perhaps report this annoyance to RedHat. Compiling PHP to include mysql support can't hurt much, and increases the utility of the system...
Charlie Brady
charlieb@...
Apr 8, 1999 1:46 am
520
I am running the latest CVS (taken last night) of Keystone with Postgresql 6.3.2. I am trying to get the keymail program to work, but I noticed its DBI syntax...
Brian
signal@...
Apr 13, 1999 1:52 pm
521
Another thing I have found: If you set in the keystone.conf file, something like: $sys_server = "postgresql"; /* database server type */ This is...
Brian
signal@...
Apr 13, 1999 1:53 pm
522
I submitted a change to the cvs tree to convert 'postgresql' to 'Pg' on the sys_server field in Keymail when it reads the conf file. If you do a cvs update...
Jonathan Roy
roy@...
Apr 13, 1999 2:27 pm
523
The documentation should be updated to say that you should have "libnet (perl module)" installed, since Net/Domain.pm is used and thus needed. I have libnet...
Brian
signal@...
Apr 13, 1999 2:48 pm
524
This change was also added and is in the cvs tree now. However, I didn't add port= syntax since there is no port setting on the conf file (that I know of). ...
Jonathan Roy
roy@...
Apr 13, 1999 3:08 pm
525
... actually yes, the conf file has: $sys_pg_port = "5432"; /* PostgreSQL port number */ $sys_pg_options = ""; /* PostgreSQL...
Brian
signal@...
Apr 13, 1999 3:14 pm
526
Dave, should the pg_port be made just _port and have one port variable for all databases? -Jonathan ... -- Jonathan Roy - roy@... - Idle Communications,...
Jonathan Roy
roy@...
Apr 13, 1999 3:18 pm
527
This one I can't explain. 'grep mailhost *' in perl/ doesn't match anything. And all 4 smtpsend calls: Keystone.pm: $rply->smtpsend( Host =>...
Jonathan Roy
roy@...
Apr 13, 1999 3:22 pm
528
... Didn't we need to define this somewhere? I thought we hit the 'no such host mailhost' somewhere along the line when we were debugging, roy. Perhaps it's...
Dave Belfer-Shevett
shevett@...
Apr 13, 1999 3:25 pm
529
... The thing is, the "mailhost" came from Net::SMTP I believe........ ... Brian Feeny (BF304) signal@... 318-222-2638 x 109...
Brian
signal@...
Apr 13, 1999 3:34 pm
530
Their was a message/ticket on the keystone site about how to access the cvs, and I can't seem to find it, does anyone remember the id number for the ticket...
Brian
signal@...
Apr 13, 1999 3:34 pm
531
... CVS instructions are on the website itself. http://www.stonekeep.com/download.php3 ... Dave Belfer-Shevett...
Dave Belfer-Shevett
shevett@...
Apr 13, 1999 3:41 pm
532
... no it doesn't. So I can fix it by CNAMEing mailhost to mail, which like I said I think is a good idea, but that doesn't change that I think keymail is...
Brian
signal@...
Apr 13, 1999 4:05 pm
533
CVS still has an error: $self->{dbh} = DBI->connect( "DBI:$KEY_SYS::server:dbname=$KEY_SYS::dbname:host=$KEY_SYS::dbhost", $KEY_SYS::dbuser,...
Brian
signal@...
Apr 13, 1999 4:07 pm
534
ok, thanks ... Brian Feeny (BF304) signal@... 318-222-2638 x 109 http://www.shreve.net/~signal Network Administrator ShreveNet Inc. (ASN 11881)...
Brian
signal@...
Apr 13, 1999 4:16 pm
535
Another possible bug: When a new slip is opened via email, the user gets a reply that looks like this: Date: Tue, 13 Apr 1999 11:21:30 -0500 From:...
Brian
signal@...
Apr 13, 1999 4:26 pm
536
Added. :) I didn't add the port support yet pending Dave's decision on what he wants to do. (One variable per type of database, or what.) -Jonathan ... -- ...
Jonathan Roy
roy@...
Apr 13, 1999 4:36 pm
537
In my programs, I use my $insertid = $self->{dbh}->func("_InsertID"); so I changed the cvs tree to that. (The old code was from the ksb stuff.) Try that and...
Jonathan Roy
roy@...
Apr 13, 1999 5:04 pm
538
As far as that last CVS commit: my $insertid = $self->{dbh}->func("_InsertID"); is _InsertID suppose to be a function somewhere? I don't have it in my schema...
Brian
signal@...
Apr 13, 1999 5:21 pm
539
Just wondering. Thanks, Andreas Wehler -- CAD/CAM straessle GmbH Tel.: (+49) 211 - 52740 - 228 Dr.-Ing. Andreas Wehler Fax.: (+49) 211 - 52740 - 280 ...
Dr. Andreas Wehler
Andreas.Wehler@...
Apr 14, 1999 9:10 am
540
... Well, you can just put http://www.foo.com, but I think that's not what you're asking. :) You'd like the summary and/or description to have a clickabla...
Dave Belfer-Shevett
shevett@...
Apr 14, 1999 2:46 pm
541
Hi, Before I add these to the wishlist, I thought I would do a "How do I ?" question... I have just downloaded and installed Keystone onto our system and will ...
Graham Hart
graham@...
Apr 14, 1999 2:52 pm
542
In case you missed it: my $insertid = $self->{dbh}->func("_InsertID"); Is not valid that I can see, unless you have a function called _InsertID, which I didn't...
Brian
signal@...
Apr 14, 1999 5:45 pm
543
It is built in to MySQL. How do you get the ID for a new row inserted to PostGres in a table with an auto incremeting/counter field, unique row id, or whatever...
Jonathan Roy
roy@...
Apr 14, 1999 7:16 pm
544
... postgres assigns each row an "OID", and you just grab name "OID" to get that uniq row id. You can also create a sequence in postgres like this: postgres=>...