| ID |
Date |
Icon |
Author |
Author Email |
Category |
OS |
ELOG Version |
Subject |
|
67789
|
Thu Jan 29 14:20:13 2015 |
 | Andreas Luedeke | andreas.luedeke@psi.ch | Question | Windows | 3.0.0 | Re: SMTP Host Error and export to CSV question | If you have more than one topic it is better to do more than one post.
I did not understand your first question. You should not have a line "SMTP host= " if you don't want to send any email. Have you tried "Suppress Email to users=1" to get rid of the error message?
If you export in cvs format, then it is the correct behaviour that multiple lines of text in the body are put into quotation marks and printed as multiple lines in the output. Every spreadsheet program (Excel, Openoffice, Libreoffice, ...) should be able to read that into a table. I've tested it, it works fine. If you have a problem, then you'll need to attach your elogd.cfg file and the exported file in the forum and some screenshots of what your MS Excel does with it.
| Banata Wachid Ridwan wrote: |
|
Hello
first of all, congrats for bring back the forum after down for sometimes, :D
but seems my old account is broken, I cant login with that anymore, so I make new account and strangely I can make identical account like the old one ahahahaha
okay first question :
Recently my elog setup got smtp host error, everytime someone submit log, error result that SMTP host is not found in global setting.
I dont't set mail server on my server so I cant use smtp host function, and I use register type 1 to avoid email function, but after sometimes those error occured, it seems some members accidentally check ëmail notification option
so, how to completely disable this function or maybe some work around on this error? I dont have mail server right now,
second
When we export logbook to CSV and open to microsoft excel, html tags still there, how to ommit html tags completely during export? and how to make nice table data from csv in elog? I saw many inconsistency there, especially on comment data
for example if I make more than two lines of logbook, second line will place in first column , not in the last column, just like the first line of comment.
|
|
|
67790
|
Fri Jan 30 03:12:33 2015 |
| Banata Wachid Ridwan | jogjacard@yahoo.com | Question | Windows | 3.0.0 | Re: SMTP Host Error and export to CSV question | sorry for may bad english, not my natives :D
for first question, I'll make it clear,
after sometimes running elog, suddenly SMTP host error occured.
I dont have SMTP host= on my configuration, but that error keep show up.
how to disable email notification completely for my elog? or at least how to disable those SMTP Host error?
I'll try supress email users =1 to my elog.cfg and error still exist. where I should place supress email users flag to make it works?
on the picture attached, it is said there is no smtp host defined in global setting.
could it be because members check automatic email notification on their setting?
for second question I'll attach my csv file, and you will see <p> </p> tags still there, and inconsistency when open it to ms excel (see picture)
you can see that portion of text file (second line of text file and soon, placed in "id pesan")
please help us.
| Andreas Luedeke wrote: |
|
If you have more than one topic it is better to do more than one post.
I did not understand your first question. You should not have a line "SMTP host= " if you don't want to send any email. Have you tried "Suppress Email to users=1" to get rid of the error message?
If you export in cvs format, then it is the correct behaviour that multiple lines of text in the body are put into quotation marks and printed as multiple lines in the output. Every spreadsheet program (Excel, Openoffice, Libreoffice, ...) should be able to read that into a table. I've tested it, it works fine. If you have a problem, then you'll need to attach your elogd.cfg file and the exported file in the forum and some screenshots of what your MS Excel does with it.
| Banata Wachid Ridwan wrote: |
|
Hello
first of all, congrats for bring back the forum after down for sometimes, :D
but seems my old account is broken, I cant login with that anymore, so I make new account and strangely I can make identical account like the old one ahahahaha
okay first question :
Recently my elog setup got smtp host error, everytime someone submit log, error result that SMTP host is not found in global setting.
I dont't set mail server on my server so I cant use smtp host function, and I use register type 1 to avoid email function, but after sometimes those error occured, it seems some members accidentally check ëmail notification option
so, how to completely disable this function or maybe some work around on this error? I dont have mail server right now,
second
When we export logbook to CSV and open to microsoft excel, html tags still there, how to ommit html tags completely during export? and how to make nice table data from csv in elog? I saw many inconsistency there, especially on comment data
for example if I make more than two lines of logbook, second line will place in first column , not in the last column, just like the first line of comment.
|
|
|
| Attachment 1: export.csv
|
"ID pesan";"Tanggal ";"Author";"Category";"Text"
1;Tue 06 Jan 2015 12:12:28 +0700;"Banata Wachid Ridwan";"Rutin";"<p>1. Print form Basis data untuk kegiatan rutin</p>
<p>2. Update T3 Framework plugin untuk web basis data</p>
<p>3. Menyusun artikel web basis data</p>
<p>4. Publish 4 artikel web basis data tahun 2014</p>
<p>5. Setting dan kustomasi logbook</p>
<p>6. Maintenance web rutin (update VPS CentOS)</p>
<p>7. Upgrade versi logbook ke 3.0.0</p>
<p>8. Seleksi Framework Template Joomla untuk persiapan update Joomla 3.x</p>"
|
| Attachment 2: error.jpg
|
|
| Attachment 3: elogd.cfg
|
[global]
port = 8080
Language = indonesia
[SABO]
Theme = default
Comment = Logbook Balai Sabo
Attributes = Author, Category
Options Category = Rutin, Litbang
Required Attributes = Author, Category
Page Title = LOGBOOK
Reverse sort = 1
Quick filter = Date, Category, Author
self register = 1
Time format = %d %B, %Y
Password file = pass.txt
Self register = 1
Admin user = Banata
Allow delete = Banata
Preset Author = $long_name
Locked Attributes = Author
Login expiration = 1000
Restrict edit = 1
Display mode = threaded
Suppress Email notification = 1
|
| Attachment 4: error2.jpg
|
|
|
67794
|
Mon Feb 2 10:13:58 2015 |
| Andreas Luedeke | andreas.luedeke@psi.ch | Question | Windows | 3.0.0 | Re: SMTP Host Error | You need to specify "Suppress Email to users=1" in the [global] section of the configuration. And it does matter if the letters are capitalized on not.
| Banata Wachid Ridwan wrote: |
|
sorry for may bad english, not my natives :D
for first question, I'll make it clear,
after sometimes running elog, suddenly SMTP host error occured.
I dont have SMTP host= on my configuration, but that error keep show up.
how to disable email notification completely for my elog? or at least how to disable those SMTP Host error?
I'll try supress email users =1 to my elog.cfg and error still exist. where I should place supress email users flag to make it works?
on the picture attached, it is said there is no smtp host defined in global setting.
could it be because members check automatic email notification on their setting?
for second question I'll attach my csv file, and you will see <p> </p> tags still there, and inconsistency when open it to ms excel (see picture)
you can see that portion of text file (second line of text file and soon, placed in "id pesan")
please help us.
| Andreas Luedeke wrote: |
|
If you have more than one topic it is better to do more than one post.
I did not understand your first question. You should not have a line "SMTP host= " if you don't want to send any email. Have you tried "Suppress Email to users=1" to get rid of the error message?
If you export in cvs format, then it is the correct behaviour that multiple lines of text in the body are put into quotation marks and printed as multiple lines in the output. Every spreadsheet program (Excel, Openoffice, Libreoffice, ...) should be able to read that into a table. I've tested it, it works fine. If you have a problem, then you'll need to attach your elogd.cfg file and the exported file in the forum and some screenshots of what your MS Excel does with it.
| Banata Wachid Ridwan wrote: |
|
Hello
first of all, congrats for bring back the forum after down for sometimes, :D
but seems my old account is broken, I cant login with that anymore, so I make new account and strangely I can make identical account like the old one ahahahaha
okay first question :
Recently my elog setup got smtp host error, everytime someone submit log, error result that SMTP host is not found in global setting.
I dont't set mail server on my server so I cant use smtp host function, and I use register type 1 to avoid email function, but after sometimes those error occured, it seems some members accidentally check ëmail notification option
so, how to completely disable this function or maybe some work around on this error? I dont have mail server right now,
second
When we export logbook to CSV and open to microsoft excel, html tags still there, how to ommit html tags completely during export? and how to make nice table data from csv in elog? I saw many inconsistency there, especially on comment data
for example if I make more than two lines of logbook, second line will place in first column , not in the last column, just like the first line of comment.
|
|
|
|
|
67798
|
Mon Feb 2 12:44:24 2015 |
| Stefan Ritt | stefan.ritt@psi.ch | Question | Windows | 3.0.0 | Re: SMTP Host Error | That's not correct. Any option in the configuration file is case-insensitive. It should also not matter if the statement is under the logbook or in the [global] section.
What you probably made wrong is to write "supress email to users =1" instead "suppress email to users =1". Note the second "p". So English in the end DOES matter, at least here 
| Andreas Luedeke wrote: |
|
You need to specify "Suppress Email to users=1" in the [global] section of the configuration. And it does matter if the letters are capitalized on not.
| Banata Wachid Ridwan wrote: |
|
sorry for may bad english, not my natives :D
for first question, I'll make it clear,
after sometimes running elog, suddenly SMTP host error occured.
I dont have SMTP host= on my configuration, but that error keep show up.
how to disable email notification completely for my elog? or at least how to disable those SMTP Host error?
I'll try supress email users =1 to my elog.cfg and error still exist. where I should place supress email users flag to make it works?
on the picture attached, it is said there is no smtp host defined in global setting.
could it be because members check automatic email notification on their setting?
for second question I'll attach my csv file, and you will see <p> </p> tags still there, and inconsistency when open it to ms excel (see picture)
you can see that portion of text file (second line of text file and soon, placed in "id pesan")
please help us.
| Andreas Luedeke wrote: |
|
If you have more than one topic it is better to do more than one post.
I did not understand your first question. You should not have a line "SMTP host= " if you don't want to send any email. Have you tried "Suppress Email to users=1" to get rid of the error message?
If you export in cvs format, then it is the correct behaviour that multiple lines of text in the body are put into quotation marks and printed as multiple lines in the output. Every spreadsheet program (Excel, Openoffice, Libreoffice, ...) should be able to read that into a table. I've tested it, it works fine. If you have a problem, then you'll need to attach your elogd.cfg file and the exported file in the forum and some screenshots of what your MS Excel does with it.
| Banata Wachid Ridwan wrote: |
|
Hello
first of all, congrats for bring back the forum after down for sometimes, :D
but seems my old account is broken, I cant login with that anymore, so I make new account and strangely I can make identical account like the old one ahahahaha
okay first question :
Recently my elog setup got smtp host error, everytime someone submit log, error result that SMTP host is not found in global setting.
I dont't set mail server on my server so I cant use smtp host function, and I use register type 1 to avoid email function, but after sometimes those error occured, it seems some members accidentally check ëmail notification option
so, how to completely disable this function or maybe some work around on this error? I dont have mail server right now,
second
When we export logbook to CSV and open to microsoft excel, html tags still there, how to ommit html tags completely during export? and how to make nice table data from csv in elog? I saw many inconsistency there, especially on comment data
for example if I make more than two lines of logbook, second line will place in first column , not in the last column, just like the first line of comment.
|
|
|
|
|
|
67799
|
Tue Feb 3 06:48:32 2015 |
 | Andreas Luedeke | andreas.luedeke@psi.ch | Question | Windows | 3.0.0 | Re: SMTP Host Error | Hey, great: I've learned something new about elog! I always took great care to get the capitalization of the options correct
| Stefan Ritt wrote: |
|
That's not correct. Any option in the configuration file is case-insensitive. It should also not matter if the statement is under the logbook or in the [global] section.
What you probably made wrong is to write "supress email to users =1" instead "suppress email to users =1". Note the second "p". So English in the end DOES matter, at least here
| Andreas Luedeke wrote: |
|
You need to specify "Suppress Email to users=1" in the [global] section of the configuration. And it does matter if the letters are capitalized on not.
| Banata Wachid Ridwan wrote: |
|
sorry for may bad english, not my natives :D
for first question, I'll make it clear,
after sometimes running elog, suddenly SMTP host error occured.
I dont have SMTP host= on my configuration, but that error keep show up.
how to disable email notification completely for my elog? or at least how to disable those SMTP Host error?
I'll try supress email users =1 to my elog.cfg and error still exist. where I should place supress email users flag to make it works?
on the picture attached, it is said there is no smtp host defined in global setting.
could it be because members check automatic email notification on their setting?
for second question I'll attach my csv file, and you will see <p> </p> tags still there, and inconsistency when open it to ms excel (see picture)
you can see that portion of text file (second line of text file and soon, placed in "id pesan")
please help us.
| Andreas Luedeke wrote: |
|
If you have more than one topic it is better to do more than one post.
I did not understand your first question. You should not have a line "SMTP host= " if you don't want to send any email. Have you tried "Suppress Email to users=1" to get rid of the error message?
If you export in cvs format, then it is the correct behaviour that multiple lines of text in the body are put into quotation marks and printed as multiple lines in the output. Every spreadsheet program (Excel, Openoffice, Libreoffice, ...) should be able to read that into a table. I've tested it, it works fine. If you have a problem, then you'll need to attach your elogd.cfg file and the exported file in the forum and some screenshots of what your MS Excel does with it.
| Banata Wachid Ridwan wrote: |
|
Hello
first of all, congrats for bring back the forum after down for sometimes, :D
but seems my old account is broken, I cant login with that anymore, so I make new account and strangely I can make identical account like the old one ahahahaha
okay first question :
Recently my elog setup got smtp host error, everytime someone submit log, error result that SMTP host is not found in global setting.
I dont't set mail server on my server so I cant use smtp host function, and I use register type 1 to avoid email function, but after sometimes those error occured, it seems some members accidentally check ëmail notification option
so, how to completely disable this function or maybe some work around on this error? I dont have mail server right now,
second
When we export logbook to CSV and open to microsoft excel, html tags still there, how to ommit html tags completely during export? and how to make nice table data from csv in elog? I saw many inconsistency there, especially on comment data
for example if I make more than two lines of logbook, second line will place in first column , not in the last column, just like the first line of comment.
|
|
|
|
|
|
|
67414
|
Mon Jan 7 16:39:31 2013 |
| Stefan Ritt | stefan.ritt@psi.ch | Question | Linux | 2.9.2 | Re: SMTP Error: authentication not enabled |
| Satish Desai wrote: |
|
Hi all,
I am trying to set up elog here at the University of Minnesota. It looks very promising for helping to manage a fairly complicated operation. I've got most of what I want set up without too much difficulty. However, I find that I'm having some difficulty to get it working properly with email.
In particular, I have my account set up to email me when log entries are made (subscribe to logbooks option is selected). In the global section of my elogd.conf file I have set up the variables:
SMTP host = factoryserver5
SMTP username = factory
However, when I make a test entry, I get an error at the top:
Error sending Email via <i>"factoryserver5"</i>: 5.5.1 Error: authentication not enabled
I tried setting the password using "elogd -t" but to no avail. I also tried a few different values for SMTP host
Any suggestions as to what I am doing wrong?
Cheers,
Satish
|
There are several SMTP authorisation options, and only a subset is supported by ELOG. Have you tried without the "SMTP username"?
Stefan |
|
1637
|
Fri Jan 27 23:18:07 2006 |
| Stefan Ritt | stefan.ritt@psi.ch | Question | Linux | 2.6.1 CVS | Re: Running elog as ordinnary user |
| G. Vandemoortele wrote: | I've configured elog with some commands running a shell :
Preset R-Date = $shell(/usr/bin/date +"%Y/%m/%d %H:%S")
; for testing :
Preset $text = $shell(whoami && set)
Preset $text = Some fixed text
That worked well when elog was started by root (and falling to user elog),
but later, I moved all the elog tree to /home/my_name/.elog,
(I'd like to start it only when I'm logged, it's only for personnal data)
changed all the attributes/permissions ($chown -R my_name:my_group .elog)
and none of these commands still works ! I use the -x option to allow
shell substitution.
More surprisingly, even the fixed text doesn't work (???) |
First of all, you could use
Preset R-Date = $date
instead of the shell command. Secondly, the command
Preset $text = $shell(whoami && set)
is wrong. Replace it by
Preset text = $shell(whoami && set)
without the "$".
| G. Vandemoortele wrote: | By the way, I also seen that it is necessary to set Usr and Grp to "elog"
via the config file even when it's started by root, because otherwise,
you always get the strings 'Falling back to default group "elog"' and
Falling back to default user "elog" in the output of the shell substitutions. |
There is a good reason for that. If you run elogd as root, this can open a dangerous hole into your system. If there would be any bug in elog, an attacker could gain root access easily. By falling back to a non-root user, the damage can be minimized. As a precaustion, elog falls back to Usr and Grp "elog" if that setting is missing in the config file.
When you run elog under your user name, this fallback is not necessary. Why you got the message 'Falling back' is a mystery to me. I tried to reproduce that, so I run under a non-root account with following config:
[global]
port = 1234
[demo]
Attributes = Subject
Preset Subject = $shell(date +"%Y/%m/%d %H:%S")
and correctly got the date in the "Subject" field with ELOG V2.6.1-1640. |
|
1638
|
Sat Jan 28 10:40:18 2006 |
| G. Vandemoortele | gvdmoort@skynet.be | Question | Linux | 2.6.1 CVS | Re: Running elog as ordinnary user |
| Stefan Ritt wrote: |
First of all, you could use
Preset R-Date = $date
instead of the shell command. Secondly, the command
Preset $text = $shell(whoami && set)
is wrong. Replace it by
Preset text = $shell(whoami && set)
without the "$".
|
I'm sorry ; even with this correction, none of the preset strings created with
a substitution mechanism (shell or built-in) works when elogd is started as
ordinnary user. I've tried the same config file /home/gv/.elog/elogd.cfg :
port = 8080
Language = french
Main Tab = Accueil
Usr = gv
Grp = users
Logbook dir = /home/gv/.elog/logbooks
[gauthier]
Self register = 1
Password file = passwd
Theme = default
Comment = Logbook personnel
Default encoding = 1
Time format = %a, %d/%m/%Y %H:%M
Attributes = Type, Statut, Priorité, Sujet, R-Date
Preset R-Date = $shell(/usr/bin/date +"%Y/%m/%d %H:%S")
Preset text = $shell(whoami && set)
;Preset text = Blablabla
;Preset text = $date
Start page = ?rsort=Record date
List display = R-Date, Type, Statut, Priorité, Sujet
Options Type = Divers, Lectures, Musique, Aca, Finances, Santé
Options Statut = A faire, Exécuté, Journal
Options Priorité = 0, 1, 2, 3
Preset Priorité = 0
Extendable Options = Type
Thread display = $sujet ($entry time)
Required Attributes = Type, Sujet
Page Title = ELOG - $subject
Reverse sort = 1
Quick filter = R-Date, Statut, Type
Sort Attributes = Priorité, R-Date
Started via root (# /usr/sbin/elogd -c /home/gv/.elog/elogd.cfg -x), it works,
but via "gv" ($ /usr/sbin/elogd -c /home/gv/.elog/elogd.cfg -x), it doesn't.
Regards,
Gauthier |
|