Demo Discussion
Forum Config Examples Contributions Vulnerabilities
  Discussion forum about ELOG, Page 232 of 806  Not logged in ELOG logo
ID Date Icon Author Author Email Categorydown OS ELOG Version Subject
  66110   Fri Dec 12 08:57:41 2008 Question Stefan Kanitzskmainz@web.deQuestionWindowslatestmysql in execute

Hello all,

 

i have a question to mysql inexecute:

This works:

Execute new = mysql -h localhost -u root -D test1 -e "insert into `test1` (author, type) values ('$Author', '$Type')"

This doesn't work:

Execute new = mysql -h localhost -u root -D test1 -e "insert into `test2` (Autor, Adressat, Teil1, Teil2, Teil3,
Teil4, Teil5, Teil6, Teil7, Teil8 )  values ('$Autor', '$Adressat' ,  '$Teil1', '$Teil2', '$Teil3', '$Teil4', '$Teil5',
'$Teil6', '$Teil7', '$Teil8' )"

 

db is okay, i have all checked this. My question is: can the execute-command take a multiline argument? Or perhaps does somebody see a mistake i have made in the execute-line?

 

Thanks!

Steve


 

  66111   Fri Dec 12 09:16:19 2008 Reply Stefan Rittstefan.ritt@psi.chQuestionWindowslatestRe: mysql in execute

 

Stefan Kanitz wrote:

This doesn't work:

Execute new = mysql -h localhost -u root -D test1 -e "insert into `test2` (Autor, Adressat, Teil1, Teil2, Teil3,
Teil4, Teil5, Teil6, Teil7, Teil8 )  values ('$Autor', '$Adressat' ,  '$Teil1', '$Teil2', '$Teil3', '$Teil4', '$Teil5',
'$Teil6', '$Teil7', '$Teil8' )"

 

In the elogd.cfg file, you cannot have multi-line options. Either you put everything on a single line (I guess there is also some limit at a few hundred characters) or you call a batch file which then calls the mysql command. 

  66113   Sat Dec 13 14:31:53 2008 Reply Stefan Kanitzskmainz@web.deQuestionWindowslatestRe: mysql in execute

Stefan Ritt wrote:

 

Stefan Kanitz wrote:

This doesn't work:

Execute new = mysql -h localhost -u root -D test1 -e "insert into `test2` (Autor, Adressat, Teil1, Teil2, Teil3,
Teil4, Teil5, Teil6, Teil7, Teil8 )  values ('$Autor', '$Adressat' ,  '$Teil1', '$Teil2', '$Teil3', '$Teil4', '$Teil5',
'$Teil6', '$Teil7', '$Teil8' )"

 

In the elogd.cfg file, you cannot have multi-line options. Either you put everything on a single line (I guess there is also some limit at a few hundred characters) or you call a batch file which then calls the mysql command. 

 Thanks!

 

  66114   Sun Dec 14 17:04:24 2008 Question mike ciancimike2.cianci@comcast.netQuestionWindows2.7.5-2140Grouping Logbooks

I really appreciate your help and I hope that my questions warrant your time.

What I am trying to accomplish is two totally separate groups of logbooks that share a common logbook.

Three logbooks

Logbook A

Logbook B

Logbook C (just informational, write protected)

Two Groups

Top Group 1 = Logbook A, Logbook C

Top Group 2 = Logbook B, Logbook C

What is happening is everything looks good until you try to enter Logbook C from Group 1. You end up in Logbook C (the right logbook) but you are now in Group 2.

Actual Code:

;Groupings
Top Group Central = Centaur, On-LineHelps
Top Group Good Sam = GSH, On-LineHelps

 

 

  66115   Mon Dec 15 09:01:35 2008 Reply Stefan Rittstefan.ritt@psi.chQuestionWindows2.7.5-2140Re: Grouping Logbooks

 

mike cianci wrote:

I really appreciate your help and I hope that my questions warrant your time.

What I am trying to accomplish is two totally separate groups of logbooks that share a common logbook.

Three logbooks

Logbook A

Logbook B

Logbook C (just informational, write protected)

Two Groups

Top Group 1 = Logbook A, Logbook C

Top Group 2 = Logbook B, Logbook C

What is happening is everything looks good until you try to enter Logbook C from Group 1. You end up in Logbook C (the right logbook) but you are now in Group 2.

Actual Code:

;Groupings
Top Group Central = Centaur, On-LineHelps
Top Group Good Sam = GSH, On-LineHelps

You cannot put the same logbook into two groups. All you can do is to define two logbooks C1 and C2, and force their data directories to be the same (via the "Subdir = ..." directive), so they will actually look at the same data.

  66116   Wed Dec 17 19:43:25 2008 Question Dan C.chaospry@gmail.comQuestionLinux2.7.5-1Display Revisions field in single entry but not in list view
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
  66121   Fri Dec 19 14:15:28 2008 Question Ben Shepherdbjs54@dl.ac.ukQuestionLinux2.7.5-2137Tooltips for MOptions - not working?

Hi,

One of my logbooks is a fault reporting system; it emails a group of people when a fault is reported. There is an MOption 'Technical Groups', and I want to have a tooltip for each checkbox which shows who is referred to by each group name. However, individual tooltips for each MOption attribute don't seem to work. I've looked at the HTML code, and there's no 'title' attribute for the checkboxes, so it's not a browser problem. I've attached my config file. Any idea what's going wrong?

ben

Attachment 1: elogd.cfg
Data dir = /web/Elog/ERLP/logbooks/erlpfaults
Summary page title = ALICE Faults
List page title = ALICE Faults
Page title = ALICE Faults: $Title
RSS title = $message ID: $Title
Comment = ALICE Faults
Menu commands = List, New, Edit, Reply, Delete, Find, Config, Admin, Logout, Help
Guest Menu commands = List, Find, Login, Help
Find Menu commands = List, New, Select, Find, Config, Admin, Logout, Help
Guest Find Menu commands = List, Find, Login, Help
Attributes = Submitted by, Title, Personnel, Technical Groups, Cc, Machine Areas, Priority
MOptions Technical Groups = Accelerator Physics, Magnets, RF, Vacuum, Cryogenics, Power Supplies, Controls, Diagnostics, Photoinjector, Engineering, Health & Safety, Services, Personnel Safety System
Comment Technical Groups = Emails will be sent out<BR>to the specified groups.
Comment Cc = Additional email addresses;<BR>separate using commas.
MOptions Machine Areas = laser, gun, transfer line 1, booster, transfer line 2, linac, arc 1, compressor, FEL, arc 2, dump
ROptions Priority = critical, high, normal, low, fixed
Extendable Options = Personnel

Use Email From = dlerlp@example.com
#email goes to each of the people listed here, for entries where the technical group is specified
Email "Technical Groups" "Accelerator Physics" = susan.smith@example.com, yuri.saveliev@example.com
Tooltip "Technical Groups" "Accelerator Physics" = "Susan Smith, Yuri Saveliev"
Email "Technical Groups" Magnets = neil.thompson@example.com, ben.shepherd@example.com
Email "Technical Groups" RF = peter.mcintosh@example.com, andrew.moss@example.com
Tooltip "Technical Groups" RF = "Pete McIntosh, Andy Moss"
Email "Technical Groups" Vacuum = thomas.weston@example.com, keith.middleman@example.com
Email "Technical Groups" Cryogenics = shrikant.pattalwar@example.com, bob.bate@example.com, andy.goulden@example.com
Email "Technical Groups" "Power Supplies" = stephen.griffiths@example.com, chris.white@example.com
Email "Technical Groups" Controls = adrian.oates@example.com, ralph.rotheroe@example.com
Email "Technical Groups" Diagnostics = rob.smith@example.com, steven.jamison@example.com
Email "Technical Groups" Photoinjector  = susan.smith@example.com, rob.smith@example.com
Email "Technical Groups" Engineering = phil.atkinson@example.com, paul.hindley@example.com
Email "Technical Groups" "Health & Safety" = andy.goulden@example.com, stephen.hill@example.com
Email "Technical Groups" Services = andy.goulden@example.com, rachael.buckley@example.com
Email "Technical Groups" "Personnel Safety System" = john.alexander@example.com, christopher.chorlton@example.com
Email All = $Cc, $user_email
Use Email Subject = $Title (ALICE Fault Notification)
Preset Submitted by = $long_name
Preset on reply Submitted by = $long_name
Preset Priority = normal
Locked Attributes = Submitted by
Quick filter = Date, Technical Groups, Machine Areas, Priority

List display = ID, Date, Title, Technical Groups, Machine Areas, Priority
Summary lines = 0
  66122   Fri Dec 19 14:59:29 2008 Blink riboribo1@hispeed.chQuestionLinux2.7.4lost elogd.cfg

 

Hi
I’m running SLES Linux Box with Elog 2.7.4, until yesterday everything was running perfectly. Now elog is not running anymore, because the elogd.cfg where i made changes for my use is lost.....(arghhhhh......) The logbooks ar still under /usr/local/elog/logbooks aviable.
Now i would like to upgrade to the latest version of elog. How to i made my logbooks available ?
thanks for your feedback.
ribo
ELOG V3.1.5-3fb85fa6