Dear all, 

we have a running elog installation using SSL (with the self-signed certificate). Generally we use the web interface, but we have been asked if it was possible to automatically insert elog entries via command line. 

elog.exe should be the answer and so I gave it a try.

I was trying the following command line: 

elog.exe. -h server-ip-address -p 8080 -l demo -s -v -u username password -a "Mass=0" This is a test entry

Of course server-ip-address and username / password were proper fields. 

When I was doing this from the server itself, I got the following message:

Successfully connected to host server-ip-address, port 8080
Possibly invalid certificate, continue on your own risk!

and then the entry was inserted, but when I was typing the same from any other PC I got the error message:

Successfully connected to host server-ip-address, port 8080
elogd server does not run SSL protocol

The entry is of course not added and also the server (that is running in very verbose mode) reported a

SSL_accept failed

How can I fix it?  

Thanks for helping,

Antonio

Any news for my problem? 

Your help is very much appreaciated! 

thanks :)

I am using SSL with ELOG and it works fine with the "elog" executable. I am no expert on SSL, but I can provide my two cent what you could try, maybe it helps:

• SSL desires to run on the port 443 - I have no idea if you can force it to run on an arbitrary port, it might be possible. But does it make sense?
• Certificates are checked against the provider of the certificate. I guess this works fine from your web browser? Or did you just add a security exception?
• Has the installed "elog.exe" been compiled with SSL support on?

Dear Andreas,

thanks for your message.

Here are the answers to your questions.

• Tomorrow I will try to restart the server on port 443, at least temporary, to see if it makes any difference
• We don't have a real certificate, but just the self-signed certificate that comes with the standard distribution of elog. Of course, I have to accept an exception when connecting from the browser. When I try to add an entry to via the command line from the server itself, I get the message Possibly invalid certificate, continue on your own risk! but it works. 
• I hope so. This is the elog.exe that comes with the standard distribution, so I have to presume so. It is the same version that is installed on the server, where it works.

Thanks again and more tomorrow...

So as promised, I add some more information. 

Unfortunately changing the port where the server is listening did not make any change. The situation is still the same. If I try directly from the server, I get a warning about the fake certificate and if I do it from elsewhere, I get the error that the server is not running SSL. 

I had a look at the source code of elog.c and found the point where the error is produced. in order to produce this message, the ssl_connect should be returning -1 and this is only possible in two cases: 

So, in the first case, it means that the SSL connection failed completly. In the second case, the peer certificate is invalid. 

Is it possible to discriminate between the two, for example changing the return value? Unfortunately I don't have a windows computer with development tools. So it would be great if you could prepare an executable for me with this small change. 

Thanks in advance for your help,

cheers,

Hello,
I have experienced some inconveniences with the restrict edit time option.

First, it is not possible for admin users to edit an entry after the edit time.
The restrict edit option allows admin users to edit posts from other users,
so I think admins should also be allowed to edit posts after edit time.
As they can edit the config and temporarily disable the restrict edit time option, which is an issue.

Secondly, if a user made a draft and did not submitted it before the edit time runs out,
the draft got stuck as it cannot be edited (and submitted) any more.

Best wishes,
Sebastian

Yes, I agree that cleaning up old Draft entries and correcting/deleting old entries is a job for the administrator. Currently I do what you've said: commenting out "restrict edit time", changing the entry, commenting in "restrict edit time".

There are already some commands specifically for the admin:

• Admin textarea = <cols>,<rows>
• Admin user = <user list>

It would make sense to add more of them, for this specific case:

• Admin restrict edit time = <hours>

If that is set to "-1", then the Admin can edit old entries regardless of their age. Actually there is no option to "unset" restrict edit time inherited from a global config: a negative time would make sense as "disabling" restrict edit time.

Another item for the endless wishlist ;-)

Cheers, Andreas

Hello,

Is it possible to create tags for new entries in elog? I understand it would have to be some kind of mix between Extendable options and moptions. Currently, whatever is entered in extendable options forms one option, while usually for tags, words separated by # form different tags. As usual with tags, I would like to add multiple tags to my new entry and then be able to filter all entries by specific tag or group of tags.

While tags are not explicitly foreseen, you can use moptions and filter with them. Look at this logbook for example: Click on "Find", then select one or more boxes of the "OS" attribute, and you will see the filtering. Another option is to use freetext in the subject for example. I added "#testtag" in this subject, so you can search for the text "#testtag" and will find this entry.

Stefan

Hi, I am trying to calculate two or more Elog fields and then return the value to Elog. I am currently learning Perl to do this. I realize JS can do this.. but so can IBM Basic ;)  I am savy with other db techniques like sql. My question is before I get too far along with this project, is it safe to say the current storage of Elog data is 'Flat File' database? I also want to find out if it would be better to try and grab the data prior OR  after it gets into the Elog database. I see there are other forum messages related to sql interfacing and such, but nothing conclusive.  I will submit my personal progress here. Thanks again, John

Yes elog stores data in a flat file database. Go to your logbook directory and look for files YYMMDDa.log where you find all data. Some people do a post submit call to scripts, other integrate JS directly on each page (e.g. via "bottom text" option where you can load a whole JavaScript file), then pick the fields and do calculations directly in the edit window.

Stefan

Thanks Stefan soo much. As I've said, I will update this post(s) as I make any progress :)

John

How to execute  the batch file  in elogd

Modify the server start command in the Windows Registry. Or start the elogd server directly in a command window with "elogd -x", after "cd" to the elog installation directory.

I tried it but still it gives error like Shell execution not enabled via -x flag 

Stop the old server first, but we told you this already on elog:67770. If you don't follow our suggestions we cannot help you.

From the command mode i am not able to stop and start  (elogd stop). But i can start/stop from services  .Kindly help  me stopping/starting it from command 

May I kindly ask you to Google how to start/stop a service from the command line.

First of all thanx for your kind help. Kindly help me on the following problem.

I have a logbook which keeps the record of all fault booked by different subscriber.this logbook has three attribute downtime,uptime & total duration (date &time format) . I want to calculate the total duration automatically whenevr uptime value is given and if the uptime is not given it should calculate depending upon the system present time.pleas explain it with example.

thanking you 

This is not possible with ELOG. May I suggest that you use a spreadsheet for that.

Sir, how to use that spreadsheet 

can the calculation is possible by running a batch file . 

https://docs.google.com/spreadsheets

Is it as good as Microsoft excel  sheet.

but how can achieve my aim of calculation  how how to integrate it with elog 

Sorry for disturbing yau again and again 

I meant to use it instead of ELOG. Spreadsheets allow calculaiton of dates, etc. So you can achieve what you need. Again: WHAT YOU WANT IS NOT POSSIBLE WITH ELOG.

I have not tried these, but since CKeditor works so well, you may want to consider taking a look at integrating jQuery Calx or jExcel...just for fun.

Dear All,

is it possible to write to the elog instead of the Command line throug a .dll

Best

MK

I presume you want to write from another program. You can call a command line shell (done via the "system()" command under C) which then calls the elog executable. If you absolutely want a DLL, you can einter try to compile one yourself using the fuctions in elog.c, or use the curl DLL with which you can also submit elog entries. See elog:68597 for usage of curl. While curl is usually executed from the command line, there is also a curl library containing the same functionality. See https://curl.haxx.se/windows/

Hi everybody,

sorry if this question has already been posed (I did a quick search but I didn't found anything): elog sorts entry by ID, I wonder if it is possible to pin an entry in order to be always on top of the page independently on its ID.

Thanks

Giuseppe

This is not directly possible, but you can configure it with a trick. Create an attribute "pinned", make it of type "boolean", and set the start page such that it sorts using the "pinned" attribute:

Atributes = ..., Pinned
Options Pinned = boolean
Start page = ?rsort=Pinned

This move all entries where "Pinned" is true to the top of the list.

Stefan

Thank you very much! It worked great!

Beppe

Hello Stefan

Works great and very usefull - but not when you use reverse sort = 1?.

Is there a way to get both. Pinned first and then the rest i reversed order (highest ID on page 1)

Kind Regards Finn

Dear all, 

I have a question about my logbook. I have recently added a new attribute to my logbook and I would like to prefill all previous entries with a fixed value for this field. Is it possible? 

Thanks for your help and best regards,

toto

Find all entries which have this attribute empty. Then click on Select, then select all, then click on Edit, then change all values. There might be a limit how many entries you can select in one go, so you might have to do it in bunches.

Thanks, it worked great!