Great software.

Okay, so I've done my reading through the forum and got a couple of nuggets along the way but I am still unable
to get the e-mail function to work.  I am using Windows IIS to make an SMTP virtual server to shimmy around the
IT firewall.  That appears to work as I can see the response from the external SMTP server while running elogd
with the -v flag.  The elogd -v details are below:  

Email from xxxxxxxxxxxx@xxxxxxxxxxxx.com to xxxxxx.XXXXXXX@XXXXX.com,XXXXX.XXXXX X@XXXXX.com, SMTP host
XXXXXXXXXXXXXX.XXXX.XXXXX.com: 
220 smtp.xxxxx.com Microsoft ESMTP MAIL Service, Version: 6.0.2600.2180 ready at   Mon, 26 Jan 2009 10:56:35 -0500 
EHLO xxxxxxxxxxxxxx.xxxx.xxxxx.com 
250-smtp.xxxxx.com Hello [xxx.xxx.xxx.xxx] 
250-AUTH=LOGIN 
250-AUTH LOGIN 
250-SIZE 2097152 
250-PIPELINING 
250-DSN 
250-ENHANCEDSTATUSCODES 
250-8bitmime 250-BINARYMIME 
250-CHUNKING 250-VRFY 
250 OK AUTH LOGIN 
Username: 
xxxxxxxxxxxx@xxxxxxxxxxxx.com 
Password: cm9jaGVsb2dib29r 
535 5.7.3 Authentication unsuccessful 
==== Return ================================  

From the SMTP server response it is not logging in, but I don't know why.  I can log in to the webmail app with
the username/password provided to ELOG, but it doesn't appear to work through ELOG. The SMTP provider includes
the following info to setup e-mail accounts via SMTP: "Please note: To send e-mail using the SMTP-Server,
activate SMTP Authentication. Please do not use the Secure Password Authentication (SPA) option. Optionally,
port 587 can also be used in addition to the default port (25) RFC 2476." 

For authentication via the Windows IIS I have "basic authentication" with no TLS encryption required - I'm not
sure if that meets the provider's "SMTP authentication" requirement.  When I was using the previous version of
ELOG (sorry, I did not note the version number) the username was encrypted along with the password.  With the
2168 build, the password is still encrypted but the usernamer is not; should the password be in "plain text" as
well?  

I can provide you with a username/password for the SMTP provider I'm using if that will help.  Please send me a
separate e-mail and I will reply with the information.  

Thank you,  

Topher Congdon

> For authentication via the Windows IIS I have "basic authentication" with no TLS encryption required - I'm 
> not sure if that meets the provider's "SMTP authentication" requirement.  When I was using the previous version 
> of ELOG (sorry, I did not note the version number) the username was encrypted along with the password.  With 
> the 2168 build, the password is still encrypted but the usernamer is not; should the password be in "plain 
> text" as well?  

I changed only the screen output. The username is printed not not encrypted, to be able to check it by eye. The 
username sent over the network is and was always encrypted.

The only clue I have is to compare the network traffic you get with an email client (outlook, thunderbird ??) 
with the network traffic you get from elogd. To monitor the traffic, I use normally WireShark (formerly Ethereal, 
www.wireshark.org). You have to filter for "tcp.port == 25" which is SMTP, then capture your traffic, right-
click on it and select "Follow TCP stream". The result you see in the attachment. The strings produced by elogd 
are pink, the strings from the SMTP server are blue. In my case I don't have authentication (our SMTP server does 
not support this). In you case, you have to compare the traffic from a functioning email client with elogd.

hi there,

Is it possible to attach a default value for a radio button when submitting a new form/record, for example: 
I now have an item "Confirmed" Yes/No, and I want the "no" option to be selected by default when a new form/record is created.
Does anyone know how to arrange this?

Thanks in advance!

RJ

You need something along these lines:

Attributes = ..., Confirmed
Options Confirmed = boolean
Preset Confirmed = 1 

Attributes = ..., Confirmed
Options Confirmed = boolean
Preset Confirmed = 1 

 Good Morning Stefan,

This was very helpful, it works as aspected! Thank you :-)

With regards, Robert-Jan.

Is it possiblet to restrict a field so that when a new record is added, whatever the user types is automatically converted to lower case?

Thanks!

No, this is not possible. 

Hello,

i have problems with importing csv files. What i want to do is the following:

Import a list of log entries from a csv file with another date like the actual date

I tried to do this but the only thing which happend was that all the entries have the actual date in elog. Then i created a seperate Date column in the csv file an tried to import this.

It worked but in the default date column i have the import date and in a second date column i have the date from the csv file.

Is there a chance to get the csv column imported in the standard Date field? 

Or is there a possibility to hide/supress the default date field and only display the imported date field?

Thanks

Michael

Importing dates from CSV files was not implemented for a good reason: There are dozens of date formats (such as "1/22/09", "Jan 1 2009", "Mon 1 January '09") and it is almost impossible to handle all formats. I changed now the code to catch at least some formats, such as the internal RFC2822 compliant date which is also used internall by elog. An example of this format is "Thu, 22 Jan 2009 09:26:00". This date format will also be used if you export a logbook via a CSV file. Another format I added is "1/22/09". So give a try to the new code (I made an intermediate release for windows V2.7.5-3) and see if it works for you.

Hello, I'm having problems with e-mail notifications.

When I try submitting a new post, I get the following error:

Error sending Email via "smtp.glocalnet.net"

The error message doesn't give a lot of hints...

My config file contains the following lines:

[global]
SMTP host = smtp.glocalnet.net
SMTP username = rhj764h@tninet.se
SMTP Password = xxx

...

[BugZ]

...

Email All = somebody@gmail.com
Use Email From = theproject@kato.homelinux.org

The password was created by invoking elogd with the -t option containing the true password. I've tried enter the correct password manually in the config, but the error message is the same.

Below follows a cut&paste of the console output when invoking with the -v option (addresses manually edited to avoid spam):

Email ALL to somebody@gmail.com

timezone: -3600, offset: 3600


Email from theproject@kato.homelinux.org to somebody@gmail.com, SMTP host smtp
.glocalnet.net:
220 mta3.glocalnet.net ESMTP Service ready
EHLO kato.homelinux.org
250-mta3.glocalnet.net
250-DSN
250-8BITMIME
250-PIPELINING
250-HELP
250-AUTH=LOGIN
250-AUTH LOGIN CRAM-MD5 PLAIN
250-X-CP-DELIVER-AFTER
250-DELIVERBY 300
250 SIZE
==== Return ================================
HTTP/1.1 302 Found
Server: ELOG HTTP 2.6.3-1762
Connection: Keep-Alive
Keep-Alive: timeout=60, max=10
Location: http://kato.homelinux.org/elog-tinker/BugZ/6?error=Error+sending+Email
+via+<i>"smtp.glocalnet.net"</i>
Content-Length: 20

I can't make any sense of this. Please advise.

Regards

/Michael Ambrus

An update:

I got rid of the version from the Ubuntu repo and installed the latest source release instead (2.7.5-2130).

The error is now a little bit different:

Error sending Email via "smtp.glocalnet.net": Syntax error in parameters or arguments to MAIL command

A snippet from the console output:

250-DELIVERBY 300
250 SIZE
AUTH LOGIN
`±è·    ♦Username:
cmhqNzY0aEB0bmluZXQuc2U=
Password:
ajh6N2E4
235 LOGIN authentication successful
MAIL FROM: theproject@kato.homelinux.org
501 Syntax error in parameters or arguments to MAIL command
==== Return ================================

BR /Michael

I think I found out what the problem was and e-mail notification now works.

Apparently 'MAIL FROM' syntax used by my ISP expects the address to be within <>.

Adding those in the config file fixes the problem:

Use Email From = <user@domain>

Note that the documentation indicates that the brackets should not be there and I'm not sure if this is a bug or not yet. According to this link the brackets should be there but I think to be consistent with other e-mail related attributes in the config file, they should be added by ELOG.

The 'Email' attibute however seems to work fine without the brackests. I.e.

Email All = user@doman

is OK.

I'm not very familiar with SMTP but I was fiddling around with this some time ago setting up a postfix MT. I eventually succeeded with my ISP, but not with gmail's SMTP. Apperently there are differences with the log-in procedure.

Maybe various differences in login procedure could be handled by allowing ELOG to optionally to use an external program like mailto to handle it's mailing?

SMTP external = 0|1

I think I understand (and actually appreciate) the policy of not depending on external programs. Just a suggestion...

BR

/Michael

I added some code to elogd which always places <> around the "MAIL FROM:" in the SMTP communication. So I hope that problem should be solved from now on. Thank you for your detailed analysis and your hints. 

Having "Top group" in a config-file for Windows will cause:

GET / HTTP/1.1
Host: eudr6j03j:8084
User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; sv-SE; rv:1.9.0.5) Gecko/20
08120122 Firefox/3.0.5
Accept: text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8
Accept-Language: sv-se,sv;q=0.8,en-us;q=0.5,en;q=0.3
Accept-Encoding: gzip,deflate
Accept-Charset: ISO-8859-1,utf-8;q=0.7,*;q=0.7
Keep-Alive: 300
Connection: keep-alive
Cookie: unm=mambrus; upwd=U2lzc2kx; urem=0
Cache-Control: max-age=0


Internal error, no valid header!

Removing "top group" makes elogd.exe work. The error is repeatable and the same config file works on the same version of Elog on Linux. Elog was compiled with Cygwin.

Please supply your full configuration file for error analysis. 

 File attached. SMTP password removed, otherwise as original.

 Windows binaries took care of this problem as with Message ID: 66157.

Problem solved, thanks!

• A bug which has been fixed in meantime. If you can give a try to 2.6.2-1750 or so that could help. I'm not sure if this version is already in the Debian distribution since I'm not the maintainer there.
  
• A corrupted log file. If one of the YYMMDDa.log file get some garbage (maybe due to hard disk problems etc.) the elogd server can run into an infinite loop. In that case examine all log files to see if there is anything wrong. If so, edit it manually and restart elogd.
  
• Some not yet found bug. One never can exclude this of course, but at this forum I have elogd running under similar conditions like you, and it runs for months without problems.
  

Hello,

   Thank you for such a great software package!

   I would like to ask how I can display the Revisions field in the single entry view but not in the list view. I followed the FAQ instructions and added the following to my elodg.cfg:

   Attributes = Author, Type, Category, Subject, Revisions
   Locked attributes = Revisions
   Subst on Edit Revisions = $Revisions
$date by $long_name

   This configuration shows the Revisions field in both the list view and the single entry view. This was a problem because certain entries are changed a lot so they took up a lot of horizontal space in the list view. I tried to remove the Revisions field in the list view but keep them in the single entry view with the following:

   Attributes = Author, Type, Category, Subject
   Show Attributes = Author, Type, Category, Subject, Revisions
   Locked attributes = Revisions
   Subst on Edit Revisions = $Revisions
$date by $long_name

   This took the Revisions field out of the list view and also the single entry view. However, the fields that were shown in the single entry view ended up as Author, Type, Category, Subject, Author (again).

   The last attempt were with the following configuration lines:

   Attributes = Author, Type, Category, Subject
   Show Attributes = Revisions
   Locked attributes = Revisions
   Subst on Edit Revisions = $Revisions
$date by $long_name

   This showed Author, Type, Category, Subject in the list view but only the Author field in the single entry view.

   How can I configure Elog to show the Revisions field in the single entry view but no the list view?

Thanks,
   - Dan

Attributes = Author, Type, Category, Subject
Show Attributes = Revisions
Locked attributes = Revisions
Subst on Edit Revisions = $Revisions $date by $long_name
List Display = ID, Date, Author, Type, Category, Subject

Attributes = Author, Type, Category, Subject, Revisions
Show Attributes = Author, Type, Category, Subject, Revisions
Locked attributes = Revisions
Subst on Edit Revisions = $Revisions $date by $long_name
List Display = ID, Date, Author, Type, Category, Subject

Attributes = Author, Type, Category, Subject
Show Attributes = Revisions
Locked attributes = Revisions
Subst on Edit Revisions = $Revisions $date by $long_name
List Display = ID, Date, Author, Type, Category, Subject