Re: logbook db size causing very slow response, posted by Etienne Van Caillie on Sat Jan 4 17:55:49 2003
|
> Was wondering if there were any tweaks/suggestions for improving the
> logbooks responsiviness. Our logbook was started 31 July 01. Since that
> time we have went from 1 logbook to 4 logbooks. Logbook 1 having 2651
> entries, logbook 2 having 300 entries, and the last 2 are new logbooks, so
> only a few entries.
>
> When user launches the logbook website, it takes considerable time to bring
> the site up. It seems to be directly related to the number of entries in
> the logbook. If I set up a dummy site with a couple logbooks and only a
> few entries, the logbook is very fast coming up as well as saving entries.
>
> Another thing that seems to slow the site down, is the number of users in
> the elog notification list (those who've subscribed). When you save a log
> entry, it takes around 30sec or longer for it to actually complete the
> save. If I remove the list of users from the notification list and just
> have a few, the save is very fast.
>
>
> Thanks in advance,
>
> Eric
2600 entries is too much for this application as it load the all files
in computer memory
expand the server memory
Are you running on linux or Windows ? I suggest linux (faster)
We are working on the C source to move all data from flat to database like
SQL or mysql
when a parameter flag like 'status' = "OK" for instance
I suggest also to split in several logbook
but this is depend on your 'ELOG' parametrisation and logics
If your data are not 'sensitive' I can check on my linux server
Etienne |
security in find option as a guest, posted by Etienne Van Caillie on Mon Jan 6 19:53:28 2003
|
if you are guest in the find option
select 'all logbook'
it will display all 'attributes' from other logbook
with no option 'guest command ...'
but having the same 'attribute' name
Solution :
**********
I use the copy to command to make a copy to other logbook
with option 'guest command' enabled
in this section I remove some field so the guest user can't no see all field
I suggest to give acces to 'guest' on a second run of elog to another
port or other computer ? |
Re: security in find option as a guest, posted by Etienne Van Caillie on Tue Jan 7 16:04:14 2003
|
> > if you are guest in the find option
> >
> > select 'all logbook'
> >
> > it will display all 'attributes' from other logbook
> > with no option 'guest command ...'
> > but having the same 'attribute' name
> >
> > Solution :
> > **********
> > I use the copy to command to make a copy to other logbook
> > with option 'guest command' enabled
> >
> > in this section I remove some field so the guest user can't no see all
field
> >
> > I suggest to give acces to 'guest' on a second run of elog to another
> > port or other computer ?
>
> I see your problem. I could either disable the "Search all logbooks" switch
> for certain logbooks (like the guest one), or restrict the search to
logbooks
> which have a "guest command" option. What would you prefer?
>
> - Stefan
may be add a parameter
Restrict Search all logboog = 1 or 0
if 1 the switch will not appear |
Re: security in find option as a guest, posted by Etienne Van Caillie on Fri Jan 10 15:10:53 2003
|
> > may be add a parameter
> >
> > Restrict Search all logboog = 1 or 0
> > if 1 the switch will not appear
>
> The flag "Search all logbooks" is already there! (I forgot about it!). So
> just set it to "0" and you should be fine.
>
> - Stefan
I do and it work fine |
Re: 'group' option in conflict with 'guest logic' and 'LogBook Tabs' option , posted by Etienne Van Caillie on Sat Jan 11 19:26:24 2003
|
> From Version 2.2.5 on, the configuration file entries
>
> User = ...
> Group = ...
>
> have been changed to
>
> Usr = ...
> Grp = ...
>
> in order not to conflict with the new "Group = ..." option which is used by
> hierarchical logbooks.
not really a bug
works very fine just remarks : with this example
Group Phone & Adress = Whois, Qui_est_Qui
Group Extranet = Aide, Promos_Clients, Qui_est_Qui, Joke
[whois] is a intranet section for us : [qui_est_qui] is public
I add 'copy to = Qui_est_qui'
so extranet or public can acces to limited information
just remove the attributes and guest user can see only limited info
see example below
small problem :
****************
Logbook Tabs = 0 in the guest logbook will close the group header
may be create a parameter to solve ?
GroupGuest Extranet = ....
;-------------------- intranet info----------------
[Whois]
Comment = MBA & his Partner all your personal info must be here
Subdir = whoiswho
Menu commands = Back, New, Edit, Find, Help, Copy to
Attributes = Partner, AsTo, YourName, SurName, email1, email2, hotmail,Yahoo,
GSMmail, Nickname, phone, fax, portable , home , adress, Remarks, birthday,
QuadroUser, Function, Division
MOptions Partner = Mba, MbaCZ, BusinessCom, Edipax, Ibi, Other
Required Attributes = Parner, CodeName, YourName, email1, phone, birthday
Preset GSMmail = ???@proximus.be
Preset portable = 00 32
Copy to = Qui_est_Qui
Quick filter = Partner, Date, AsTo
;------------------------------------
[Qui_est_Qui]
Comment = MBA et ses collaborateurs à votre service
Subdir = logbooks/whoiswho/public
Attributes = Partner, YourName, SurName, phone, fax ,portable ,email1 ,
hotmail, GSMmail, Nickname, Remarks,Function, Division
MOptions Partner = Mba
Date format = %d/%m/%y
Quick filter = Date
;--------------------pas d'acces au autre menu no acces to main menu
Logbook Tabs = 0
Guest menu commands = Find
Guest find menu commands = Find
;-------------- rectriction on edit if not put 1
Restrict edit = 1
Display mode = full
Help URL = http://www.mba.be
|
call a shell from ELOG / new button [Submit & Notify], posted by Etienne Van Caillie on Sat Jan 11 19:44:29 2003
|
propose to put
[Submit] [Back] [Submit & Notify] button on top/bottom
new parameter 'shell option'
[test]
...
Attributes = NotifyMode, Param1....Param10, Adresse, Subject, ...
Options NotifyMode = mail, SMS, Fax, printer...
; this command will invoque a shell command
; example
ShellCommand = <my shell command> parameters ...
like in WINDOWS 2000
ShellCommand = START.EXE notify.bat $NotifyMode $Param1, $Param2, $Param3
; in this case no necessity to modify the C source
; in windows I suggest the start.exe with a exit command
; so no necessary to wait the return code from the shell |
confused name in the attributes section, posted by Etienne Van Caillie on Tue Jan 21 10:04:46 2003
|
do not use confused name in attributes
**************************************
like
Attributes Type, Type2
the info on Type2 will be placed in the Type also
see attachment 1
Never use confused name like '
Attributes PC_Memory, Memory
If Stephan need more info I can send a exemple of the logbooks
Etienne |
Re: elogd.cfg, posted by Etienne Van Caillie on Thu Feb 27 10:53:09 2003
|
> Stefan and friends,
>
> without breaching your own security, could it be possible to see what the
> elogd.cfg file looks like, also if others would like to post theirs, this
> would be great in building exmaples etc, obviosly an security related or
> mail server entries hashed out.
>
> I am a tad new at this stuff, but eventually would try my hand at getting
> hold of the source code and compiling on AIX and then intergrating into
> shell and error reporting. - OK .. a bit in the furture anyway, if someone
> has already done this please post.
>
> kind regards Aamir
we do recompile a version with ShellOnsubmit and ShellParam
and it works ! actually only on windows
when all test will be finish we'll send the version to Stefan Ritt
Attributes = By, Type, Categorie, Subject, Dossier, Remarks, email1
....
ShellOnSubmit = c:\test\shellTest\Debug\shellTest.exe
ShellParam = /Params %By %Type %Subject %Dossier %Remarks %
email1 /quietMode "test test"
|
|