ID |
Date |
Icon |
Author |
Author Email |
Category |
OS |
ELOG Version |
Subject |
65858
|
Fri Apr 25 19:33:24 2008 |
| Chuck Brost | Brost_chuck@solarturbines.com | Question | Windows | 2.7.3 | Re: Increment a field automatically on a new thread vs every entry | Ok, nevermind that one, Dumb Question I think, now that I have figured out that the field I was concerned with does not increment in a reply already. So.. that only leaves my one question, is there somewhere that I can change the text, not the action, on the menu so that I can do a reply, but have the link list as something like "New Item".?
Chuck Brost wrote: |
I may have missed it when reading the logs, if so, sorry about that, but I would like to know if there is a way to set a field, let us call it "process run" Ok let me give you some details on this.
a process run may have several "work orders" or sets of parts/items in it, so it will have several separate entries in the log such as:
date##, run123, part 1, quantity, comment
date##, run123, part2, quantity, comment
date##, run123, part3, quantity, comment
date##, run123, part4, quantity, comment
I thought perhaps to have them use the reply function to add the other 3 items of the same run, and that would work if I could find a way to set 'process run' to auto increment, say perhaps, when the next 'New' entry was entered. Is there something in place that can already do this? If this is possible, I thought I would see if I can change the button for 'New' to something like 'New Run' and reply to 'Add Workorder' or something along that line so there is no confusion when entering the data.
Any suggestions you might provide are greatfully accepted.
Chuck
|
|
66545
|
Wed Sep 16 16:37:35 2009 |
| Chuck Brost | Brost_chuck@solarturbines.com | Question | Windows | 2.7.6-2236 | Elog & SSL Export to CSV , Problem |
We use eLOG with IE. Once we turned on SSL, it is no longer possible to "Export to CSV" and save the output.
The error that we get is:
Internet Explorer was not able to open this Internet site. The requested site is either unavailable or cannot be found. Please try again later.
This is documented on Microsoft's site: http://support.microsoft.com/kb/316431
It is considered a feature with no fix. Basically the browser is honoring a request from the server which is "Pragma: no-cache". Problem can be reproduced in IE versions 6 through 8.
|
66549
|
Thu Sep 17 18:31:44 2009 |
| Chuck Brost | Brost_chuck@solarturbines.com | Question | Windows | 2.7.6-2236 | Re: Elog & SSL Export to CSV , Problem |
Stefan Ritt wrote: |
Chuck Brost wrote: |
We use eLOG with IE. Once we turned on SSL, it is no longer possible to "Export to CSV" and save the output.
The error that we get is:
Internet Explorer was not able to open this Internet site. The requested site is either unavailable or cannot be found. Please try again later.
This is documented on Microsoft's site: http://support.microsoft.com/kb/316431
It is considered a feature with no fix. Basically the browser is honoring a request from the server which is "Pragma: no-cache". Problem can be reproduced in IE versions 6 through 8.
|
I see the same problem with IE. The knowledge base says that one should remove the "no-cache" statement from the header, but that has strange side effects: Assume you export a logbook to a CSV file, and a few days later you export it again, since many things changed. But you browser will in that case not retrieve the new logbook, but read the old CSV file from the cache. But the browser does not tell you this, so you see an old version of the logbok without knowing this, which can be dangerous. So I better leave the "no-cache" in the header. The workaroung is not to click on "Save" on the file download dialog, but on "Open". You see then the CSV data inside the browser and can copy/paste it into a notepad document, then save it.
|
Ah, now this is humorous, when the client first came to me, that was almost exactly the work around I gave him, open it, CTRL-A to highlight it all, CTRL-C to copy it, Move to the excel spreadsheet, CTRL-V to paste it into Excel. Select Data, Text to Columns, and you have an Excel Spreadsheet. They wanted me to post the change in function anyway, though I told Vamsi, "just watch, someone will post the same workaround that I already gave to the clients". So you see why I find it amusing. I would say Great Minds Think Alike, but that would be giving myself a bit too much credit (grin). First, thank you for proving me right on my prediction and if you should happen to make a change that would get around this SSL change in behavior, it would make a group of manufacturing types that are not quite as comfortable with computers as we are, very happy. Please let us know. |
66552
|
Thu Sep 17 20:46:51 2009 |
| Chuck Brost | Brost_chuck@solarturbines.com | Question | Windows | 2.7.6-2236 | Re: Elog & SSL Export to CSV , Problem |
Stefan Ritt wrote: |
Chuck Brost wrote: |
Ah, now this is humorous, when the client first came to me, that was almost exactly the work around I gave him, open it, CTRL-A to highlight it all, CTRL-C to copy it, Move to the excel spreadsheet, CTRL-V to paste it into Excel. Select Data, Text to Columns, and you have an Excel Spreadsheet. They wanted me to post the change in function anyway, though I told Vamsi, "just watch, someone will post the same workaround that I already gave to the clients". So you see why I find it amusing. I would say Great Minds Think Alike, but that would be giving myself a bit too much credit (grin). First, thank you for proving me right on my prediction and if you should happen to make a change that would get around this SSL change in behavior, it would make a group of manufacturing types that are not quite as comfortable with computers as we are, very happy. Please let us know.
|
I can easily remove the "no-cache" from the header, but as I wrote you, people can then shoot themselves into the foot by getting an old document, and I guess they become even less happy then. So you tell me which way you prefer.
|
Trust me, I don't want them getting old data either.. that would be a nightmare..
of course, the little voice at the back of my head (note, not IN the back of my head) has offered up this tidbit for you to consider.
Stefan, would it be possible to make the following change so that the document is not cached and at the same time it is possible to save it.
The change would entail replacing the "Pragma: no-cache" directive with an "Expires: " <HTTP-date> where <HTTP-date> is the same as Date header value. Please see section 14.21 of http://www.w3.org/Protocols/rfc2616/rfc2616-sec14.html
Hopefully there are no other side effects to this change.
|
66857
|
Thu Jul 22 16:59:00 2010 |
| Chuck Brost | Brost_chuck@solarturbines.com | Bug report | Windows | 2.7.8 | More adventures with SSL | Stefan,
Everything has been working great since we last spoke (Version 2.7.8), until InfoSec decided to change how the Certs were created. Now they come with a little bit of code in the .key file before the Hash.. when I put the new .CRT and .KEY in the SSL folder I am asked on starting Elogd to provide a "PEM PassPhrase". As you can expect, if you do not enter one, or the incorrect one, it does not just turn off SSL, it exits the program. The key begins like this in the new versions:
-----BEGIN RSA PRIVATE KEY-----
Proc-Type: 4,ENCRYPTED
DEK-Info: DES-EDE3-CBC,ACF4A8B263EAA51D
(that little encode piece on the end is not the actual one in the key. I am assuming it is a passphrase key so it will know what the right passphrase is that should be entered.
We are assuming that this is the "Install password" they have set up to use to install the certs on all of the IIS servers we have. If that is indeed the case.. Does elog save this passphrase somewhere? does Elog save it in the registry? does it save it encrypted? Or with access security permissions set on the keys? I have a feeling that the answer to most of this is probably "no", but to know where we go from here, that is the place to start.
Thanks
Chuck |
67688
|
Wed Jun 11 19:18:06 2014 |
| Chuck Brost | brost_chuck@solarturbines.com | Bug report | Windows | 2.9.1-2435 | Strange Error, Service hangs when record is deleted. | I have 4 services running on a Windows Server 2008 R2 machines, 4 separate logs, only one of them is doing this, but that could be because only one of them is trying to delete records once they are posted, I cannot say.
On that one log, everything runs fine until they try to delete a record, and they are doing it under the admin login, but the service hangs. anyone trying to log in get the 404 error that the page is not available. to clear it I have to open Manage/Services and then Task Manager. First I kill the process for that log book, then I can restart the service and everything is back.. trying to stop the service and then start it, or just restart the service, this does no good, in fact, it will hang at stopping the service.. it is not responding at all. this happened to the same log when I had this on the original Windows Server 2003, so it is not new.. they just don't delete things for a long time, then they seem to do it every week, more than once.. and usually at night or on the weekend. (are they just doing it to mess with me? Maybe, but I do not think so since it would not get me in trouble if I were busy, out of town or just not home and could not get to it until the next business day and they know this..
Any ideas what could cause this?
My Configuration is as follows, with only the names changed to protect the guilty:
[global]
port = 8081
SSL = 1
css = solar.css
password file = PWFILE
self register = 0
login expiration = 0
restrict edit = 1
Allow Password change = 0
List Menu Commands = New, Find, Select, Config, Help
Menu Commands = List, New, Edit, Delete, Reply, Help
Enable Attachments = 0
show attachments = 0
display mode = summary
admin users = admin,ME
login users = user,ME,user2,user3
deny config = user,ME,user2,user3
deny delete = user,ME,user2,user3
deny edit = user,ME,user2,user3
Welcome Title = <p><font size=6 color=white> S---- T------ Furnace Logs</font><br><font size=3 color=white> These logs are C---------- Confidential: </font> <font size=3 color=55ff55> Green </font>
Attributes = Badge, Run, Recipe, Mod, Rebraze, W.O., Operation, Item, Qty
Options Mod = Boolean
Options Rebraze = Boolean
list display = date, Badge, Run, Recipe, Mod, Rebraze, W.O., Operation, Item, Qty
Options Recipe = AN001, AN002, AN003, AN004
Extendable Options = Recipe
Required Attributes = Badge, Recipe, W.O., Operation, Item, Qty
default encoding = 1
allowed encoding = 1
allow HTML = 0
suppress default = 3
suppress email on edit = 3
display email recipients = 0
[V8]
Theme = default
Comment = V8 Furnace Log Data Owner: B. Sands
Preset Run = V8-%Y-####
Locked Attributes = Run
Page Title = ELOG - $subject
Reverse sort = 1
Quick filter = Date
[V9]
Theme = default
Comment = V9 Furnace Log Data Owner: B. Sands
Preset Run = V9-%Y-####
Locked Attributes = Run
Page Title = ELOG - $subject
Reverse sort = 1
Quick filter = Date
[V10]
Theme = default
Comment = V10 Furnace Log Data Owner: B. Sands
Preset Run = V10-%Y-####
Locked Attributes = Run
Page Title = ELOG - $subject
Reverse sort = 1
Quick filter = Date
[V11]
Theme = default
Comment = V11 Furnace Log Data Owner: B. Sands
Preset Run = V11-%Y-####
Locked Attributes = Run
Page Title = ELOG - $subject
Reverse sort = 1
Quick filter = Date
[V12]
Theme = default
Comment = V12 Furnace Log Data Owner: B. Sands
Preset Run = V12-%Y-####
Locked Attributes = Run
Page Title = ELOG - $subject
Reverse sort = 1
Quick filter = Date
[V13]
Theme = default
Comment = V13 Furnace Log Data Owner: B. Sands
Preset Run = V13-%Y-####
Locked Attributes = Run
Page Title = ELOG - $subject
Reverse sort = 1
Quick filter = Date
[Freezer]
Theme = default
Comment = Freezer Furnace Log Data Owner: B. Sands
Preset Run = Fre-%Y-####
Preset recipe = None
Locked Attributes = Run
Page Title = ELOG - $subject
Reverse sort = 1
Quick filter = Date
[MyTest]
Theme = default
List Menu Commands = New, Find, Select, Config, CSV Import, Help
Comment = MyTest Log
Preset Run = MT-%Y-####
Locked Attributes = Run
Page Title = ELOG - $subject
Reverse sort = 1
Quick filter = Date
|
67692
|
Fri Aug 1 22:46:09 2014 |
| Chuck Brost | brost_chuck@solarturbines.com | Question | Windows | Elog V2.9. | Elog and Certs | Elog V2.9.1-2435 if it matters.
It is time again to install the certs for SSL in Elog, and the standard openssl command line does not seem to produce the files that I need in order to get it working on my system.
I copied the file to my trusty linux server and ran the command "openssl pkcs12 -in cert.p12 -clcerts -out cert.pem " as I did last time, last time I got a nice little .crt and .key file.. this time.. no such luck.. I can get by with the guys just hitting the continue and go past the expired cert notice for a bit.. but if I cannot fix it reasonably soon.. well, it won't be pretty for me.. <grin>
Any ideas that anyone can give will be appreciated.. this is a bit outside my usual duties around here.. |
67696
|
Mon Aug 11 22:21:43 2014 |
| Chuck Brost | brost_chuck@solarturbines.com | Question | Windows | Elog V2.9. | Re: Elog and Certs |
Andreas Luedeke wrote: |
Chuck Brost wrote: |
Elog V2.9.1-2435 if it matters.
It is time again to install the certs for SSL in Elog, and the standard openssl command line does not seem to produce the files that I need in order to get it working on my system.
I copied the file to my trusty linux server and ran the command "openssl pkcs12 -in cert.p12 -clcerts -out cert.pem " as I did last time, last time I got a nice little .crt and .key file.. this time.. no such luck.. I can get by with the guys just hitting the continue and go past the expired cert notice for a bit.. but if I cannot fix it reasonably soon.. well, it won't be pretty for me.. <grin>
Any ideas that anyone can give will be appreciated.. this is a bit outside my usual duties around here..
|
I'm not an expert in this field, but I think openssl is not meant to create a certificate for you, it is meant to create a certificate request form (CSR) and then you buy the certificate with that form from a vendor. Once you have the certificate then you just need to copy it to the right place for ELOG (or Apache) to use it, you don't need openssl for that.
⇄
English (auto-detected) » English
You can have a look at: http://www.rackspace.com/knowledge_center/article/generate-a-csr-with-openssl
Good luck!
PS: This is of course an openssl question: another forum could may be more helpful?
|
for what it is worth, if anyone else is doing this.. try
openssl pkcs12 -in file.pkx -nodes -out file.pem
I have what I need and all is well! |
|