ID |
Date |
Icon |
Author |
Author Email |
Category |
OS |
ELOG Version |
Subject |
68989
|
Sat Jun 22 06:52:32 2019 |
| John | secondcomingtechnologies@fastmail.com | Other | Linux | Windows | Mac OSX | All | Other | ELOG V3.1.2-bd7 | Calculations & Interfacing a DataBase with Elog. |
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 |
68991
|
Sat Jun 22 10:21:39 2019 |
| John | secondcomingtechnologies@fastmail.com | Other | Linux | Windows | Mac OSX | All | Other | ELOG V3.1.2-bd7 | Re: Calculations & Interfacing a DataBase with Elog. |
Thanks Stefan soo much. As I've said, I will update this post(s) as I make any progress :)
John
Stefan Ritt wrote: |
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
John wrote: |
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
|
|
|
69024
|
Tue Oct 8 06:47:27 2019 |
| John | secondcomingtechnologies@fastmail.com | Question | Linux | 3.1.4 | Re: Cannot connect to server of Gmail SMTP |
This is a local issue on your network, if you have a mail server setup. SMTP is not handled directly by Elog and neither is any other mail protocal. Elog just sends the requested email to your server for processing to the recipients afaict. And whatever server (or service) you use to handle email sending needs to be able to accept them from your mail server. So after verifying which ones you want to use; (like OutLook, or gmail, or whatever), then have your local email server set up to work with them. You can prol have a 3rd party do this was well (instead of your own local one) but then they would STILL need to be able to work with whatever guidlines the actual sender (gmail, hotmail..) requires to have mail sent. Email is a lonnng trail of different providers, servers, and other actors..
Halvy
Kevin Wang wrote: |
Hi Stefan,
Thank you very much for your reply. So which SMTP type can I use now? Is outlook OK?
Kevin
Stefan Ritt wrote: |
Gmail uses a type of SMTP authentication which is currently not supported by elog. It's however on the todo list.
Stefan
Kevin Wang wrote: |
Hi all,
When I tried to set SMTP server of Gmail in the global configuration file, I get the message "Error sending Email via <i>"smtp.gmail.com"</i>: Cannot connect to server" after I tried to receive the Email notification. Is there anyone gives help to solve this issue?
Thanks!
Kevin
|
|
|
|
69039
|
Wed Oct 16 09:45:41 2019 |
| John | secondcomingtechnologies@fastmail.com | Question | Linux | V3.1.2-bd75964 | How to get Elog server to produce web server log files in Linux. |
Hi, I have been trying for a long time to get my web server logs to record when someone accesses my Elog server. I've tried Apache2, Lighttpd, and others, all with no luck. Either the web servers complain that the port I have Elog on is in use, or I just don't get any readings. I need to see who is accessing my Elog from the web, and I hope there is a way.
Thanks again for such a wonderful program,
John |
69042
|
Wed Oct 16 10:19:42 2019 |
| John | secondcomingtechnologies@fastmail.com | Comment | Linux | V3.1.2-bd75964 | Re: How to get Elog server to produce web server log files in Linux. |
Thanx soo much Stefan.. I feel so stupid for not looking at the admin guide more :( But you how us nerds are-- read the manul last!
John :)
Stefan Ritt wrote: |
Have you tried
Logfile = ...
Logging level = 3
John wrote: |
Hi, I have been trying for a long time to get my web server logs to record when someone accesses my Elog server. I've tried Apache2, Lighttpd, and others, all with no luck. Either the web servers complain that the port I have Elog on is in use, or I just don't get any readings. I need to see who is accessing my Elog from the web, and I hope there is a way.
Thanks again for such a wonderful program,
John
|
|
|
69046
|
Thu Oct 17 21:29:25 2019 |
| John | secondcomingtechnologies@fastmail.com | Question | Linux | V3.1.2-bd75964 | Re: How to get Elog server to produce web server log files in Linux. |
Hi again everyone; a Sebastian suggested I use a reverse proxy to complete my need to have logs show up when someone 'lands' on my first entry page. I see that Elog will only start recording logs when someone has actually started to do some work.. like login, read a post, etc... but NOT when they first enter the login page or 'listings' pages. I have tried fowarding from my router (both lighty and Apache) but so for no good. I will also look into a vhost option and shareing the same port (very difficult- if even possible) to solve my dilema.
John :)
Stefan Ritt wrote: |
Have you tried
Logfile = ...
Logging level = 3
John wrote: |
Hi, I have been trying for a long time to get my web server logs to record when someone accesses my Elog server. I've tried Apache2, Lighttpd, and others, all with no luck. Either the web servers complain that the port I have Elog on is in use, or I just don't get any readings. I need to see who is accessing my Elog from the web, and I hope there is a way.
Thanks again for such a wonderful program,
John
|
|
|
69052
|
Mon Oct 21 19:31:17 2019 |
| John | secondcomingtechnologies@fastmail.com | Question | Linux | V3.1.2-bd75964 | Re: How to get Elog server to produce web server log files in Linux. |
Thank you soo much Sebastian once again for helping me!! This is something that will help me very much in the future with other situations similiar!
John :)
Sebastian Schenk wrote: |
Hi,
that Sebastian would be me. I replied to the first entry, as it was a draft (site reloaded incorretly...) and now I can't see the post anywhere. But this is off topic.
We have elog running on port 8000 and forward the traffic via Apache to it. Apache handles the SSL and other sites on the server.
All you need is a apache site configuration like the following. The parameter you want is CustomLog. (Have a look in the internet for options.)
I have also used nginx as webserver and know it can also handle this proxy setup.
If you use the following config, the elog config needs the URL attribute in the (global) config.
Best wishes,
Sebastian
<VirtualHost *:443> # change 443 to 80, if you don't use SSL
ServerName your.server.name
# delete the next 3 lines, if you don't use SSL
SSLEngine on
SSLCertificateFile /path/to/your/ssl.crt
SSLCertificateKeyFile /path/to/your/ssl.key
ProxyPreserveHost On
ProxyPass / http://127.0.0.1:8000/
ProxyPassReverse / http://127.0.0.1:8000/
# Possible values include: debug, info, notice, warn, error, crit, alert, emerg.
LogLevel warn
CustomLog ${APACHE_LOG_DIR}/access.log combined
ErrorLog ${APACHE_LOG_DIR}/error.log
</VirtualHost>
John wrote: |
Hi again everyone; a Sebastian suggested I use a reverse proxy to complete my need to have logs show up when someone 'lands' on my first entry page. I see that Elog will only start recording logs when someone has actually started to do some work.. like login, read a post, etc... but NOT when they first enter the login page or 'listings' pages. I have tried fowarding from my router (both lighty and Apache) but so for no good. I will also look into a vhost option and shareing the same port (very difficult- if even possible) to solve my dilema.
John :)
Stefan Ritt wrote: |
Have you tried
Logfile = ...
Logging level = 3
John wrote: |
Hi, I have been trying for a long time to get my web server logs to record when someone accesses my Elog server. I've tried Apache2, Lighttpd, and others, all with no luck. Either the web servers complain that the port I have Elog on is in use, or I just don't get any readings. I need to see who is accessing my Elog from the web, and I hope there is a way.
Thanks again for such a wonderful program,
John
|
|
|
|
|
69071
|
Wed Dec 4 03:06:50 2019 |
| John | secondcomingtechnologies@fastmail.com | Info | Linux | Windows | ELOG V3.1.4-ead | How to selectively use Top/Bottom Text JavaScript. |
I think I know what the answer(s) will be already.. that I will need to address this in JS. I don't want each screen to run/show the same code, other than the ones I want to. AND I do not want to have to create a custom form for each 'menu option' to achieve this (if possible).
Thanx,
John |