Demo Discussion
Forum Config Examples Contributions Vulnerabilities
  Discussion forum about ELOG, Page 292 of 806  Not logged in ELOG logo
ID Date Icon Author Author Email Category OS ELOG Version Subject
  67476   Fri Apr 5 10:07:57 2013 Reply Stefan Rittstefan.ritt@psi.chBug reportLinux2.9.2Re: Checking logging before posting

Daniel Campora wrote:

Hi there,

 

Here's a bit of a special scenario. There's no server-side check the user is logged in upon posting, but it rather seems the server relies on the post data sent from the form.

An example of this can be triggered on a write restricted elog, by hitting on New and logging out in another tab. Then posting, from the first tab, will post as if the user was logged on. Hitting back and posting again also works.

 

Cheers

Yes the credentials are stored in the form where you enter your text. This has following reason: In a shared environment (several people sitting around a computer) we want to identify who submits an elog entry, but not bother the person to enter his/her password every few minutes. So in our experiment I set the time-out to 15 min, meaning after 15 minutes of inactivity a user gets logged out. If the user accesses ELOG every ten minutes or so, he/she stays logged in for a whole shift, which is what you want. Now the problem is that one starts an elog entry, waits twenty minutes, then wants to submit it, but you are bought back to the login screen and your entry is gone. Therefore I store the credentials (encrypted) in the form, so that the form can even be submitted after 20 minutes. Users at our lab are pretty happy with this solution.

In fact there is no way you can 100% ensure that the logged in user submits an entry without asking for his/her password during the submit. Even if the time span above is only very short, it still can happen that someone starts an entry, leaves the room, and someone else submits it. So people got used to the good practice not to leave any unfinished elog entry open when they go or leave the browser (to another tab for example). If I would implement to password request during the submit, there would be two problems: 1) Users will heavily complain and 2) I have to store the form data temporary (together with some optional attachments) on the server side, start a password query, and only if that succeeds submit the entry. This is somehow complicated to implement since I cannot use the normal elog database. Then I have to care about dangling entries (like if the password was wrong I should delete the temporary data???) and so on.

I plan for the future a kind of "draft" mode, where entries can be stored as "drafts" (like in most email systems). You get an auto-save every few minutes, and can work on the draft before actually submitting it. In that case your password query could be implemented more easily. But implementing the draft mode needs a change of the database system, so I have to find time to do that.

Best regards,

Stefan 

  67475   Thu Apr 4 17:54:23 2013 Reply UlfOulf.olsson@dynamate.seQuestionWindows2.9.2-2456Re: Calculate with dates

Stefan Ritt wrote:

UlfO wrote:

Hi,

Is it possbile to compare dates in E-log?

And based on that calculation have conditonal formats on certain attributes.

We have a need to monitor a date attribute named "Preferred finished date" on records placed in E-log.

And if SYSDATE is greater than the "Preferred finished date" we want to mark certain attibutes with a color.

Regards
/UlfO

 

This is a good idea, but not implemented. I will put this on the wishlist.

/Stefan 


Thanks

 Give it a vote from me.

  67474   Thu Apr 4 17:47:12 2013 Question Daniel Camporadcampora@cern.chBug reportLinux2.9.2Checking logging before posting

Hi there,

 

Here's a bit of a special scenario. There's no server-side check the user is logged in upon posting, but it rather seems the server relies on the post data sent from the form.

An example of this can be triggered on a write restricted elog, by hitting on New and logging out in another tab. Then posting, from the first tab, will post as if the user was logged on. Hitting back and posting again also works.

 

Cheers

  67473   Wed Apr 3 19:08:22 2013 Reply David PilgramDavid.Pilgram@epost.org.ukQuestionWindows2.9.2-2456Re: Calculate with dates

Stefan Ritt wrote:

UlfO wrote:

Hi,

Is it possbile to compare dates in E-log?

And based on that calculation have conditonal formats on certain attributes.

We have a need to monitor a date attribute named "Preferred finished date" on records placed in E-log.

And if SYSDATE is greater than the "Preferred finished date" we want to mark certain attibutes with a color.

Regards
/UlfO

 

This is a good idea, but not implemented. I will put this on the wishlist.

/Stefan 

 Please add my vote for this on the wishlist.

  67472   Wed Apr 3 17:11:06 2013 Reply Stefan Rittstefan.ritt@psi.chBug reportLinux2.9.2Re: Incomplete SSL proxy instructions, insecure result.
> The instructions for securing elogd using an SSL proxy are incomplete.
> http://midas.psi.ch/elog/adminguide.html#secure
> http://midas.psi.ch/elogs/contributions/11
> 
> If you follow these instructions, elogd will still listen for and accept non-SSL connections on it's own TCP port bypassing the SSL proxy.
> 
> (True, the elogd TCP port number is somewhat secret, so there is some security-by-obscurity here).
> 
> To secure the elogd TCP port against connections that bypass the SSL proxy, elogd has to be started
> with the "-n localhost" command line options.
> 
> To add this option, one has to edit /etc/init.d/elogd. I do not know if this change will be lost when the elog rpm package is updated.
> 
> It would be better if this option could have been specified through elogd.conf.
> 
> The "-n" command line option is not documented here
> http://midas.psi.ch/elog/adminguide.html#config
> but is visible if you run "elogd -h".
> 
> P.S. Even with "-n localhost", users of the local machine can bypass the SSL proxy.
> 
> K.O.

I added the option "interface" to the config file. So you could do

[global]
...
interface = localhost


It was not there originally since most people who care about security use a firewall. The firewall (either locally or one another machine), opens only port 443 for the secure connection and 
not the non-secure one (typically 80 or 8080). This way this has not been an issue in the past. As you guessed correctly the -n option would be overwritten by an rpm package update, so 
that's why I added the "interface" option.
  67471   Wed Apr 3 15:09:09 2013 Reply Stefan Rittstefan.ritt@psi.chQuestionWindows2.9.2-2456Re: Calculate with dates

UlfO wrote:

Hi,

Is it possbile to compare dates in E-log?

And based on that calculation have conditonal formats on certain attributes.

We have a need to monitor a date attribute named "Preferred finished date" on records placed in E-log.

And if SYSDATE is greater than the "Preferred finished date" we want to mark certain attibutes with a color.

Regards
/UlfO

 

This is a good idea, but not implemented. I will put this on the wishlist.

/Stefan 

  67470   Wed Mar 27 10:30:01 2013 Question UlfOulf.olsson@dynamate.seQuestionWindows2.9.2-2456Calculate with dates

Hi,

Is it possbile to compare dates in E-log?

And based on that calculation have conditonal formats on certain attributes.

We have a need to monitor a date attribute named "Preferred finished date" on records placed in E-log.

And if SYSDATE is greater than the "Preferred finished date" we want to mark certain attibutes with a color.

Regards
/UlfO

 

  67469   Fri Mar 22 19:41:31 2013 Warning Konstantin Olchanskiolchansk@triumf.caBug reportLinux2.9.2Incomplete SSL proxy instructions, insecure result.
The instructions for securing elogd using an SSL proxy are incomplete.
http://midas.psi.ch/elog/adminguide.html#secure
http://midas.psi.ch/elogs/contributions/11

If you follow these instructions, elogd will still listen for and accept non-SSL connections on it's own TCP port bypassing the SSL proxy.

(True, the elogd TCP port number is somewhat secret, so there is some security-by-obscurity here).

To secure the elogd TCP port against connections that bypass the SSL proxy, elogd has to be started
with the "-n localhost" command line options.

To add this option, one has to edit /etc/init.d/elogd. I do not know if this change will be lost when the elog rpm package is updated.

It would be better if this option could have been specified through elogd.conf.

The "-n" command line option is not documented here
http://midas.psi.ch/elog/adminguide.html#config
but is visible if you run "elogd -h".

P.S. Even with "-n localhost", users of the local machine can bypass the SSL proxy.

K.O.
ELOG V3.1.5-3fb85fa6