Forum Thread: Local Database needs long time to sync / Program Highlighting / 3...

You are currently viewing a forum thread in the Secunia Community Forum. Please note that opinions expressed here are not of Secunia but solely reflect those of the user who wrote it.

This thread was submitted in the following forum:
CSI

This thread has been marked as locked.
SmithJoe Local Database needs long time to sync / Program Highlighting / 32 vs. 64 Bit
Contributor 2nd Jan, 2012 11:14
Ranking: 143
Posts: 36
User Since: 14th Jun, 2011
System Score: N/A
Location: DE
Last edited on 2nd Jan, 2012 11:15

Hi,
is it normal that after new scans my database usually needs 30-60mins until the local database state has reached 100%.
I just scanned 4 machines and now it is sitting at 98.16% for about 20 minutes and the machines do not show up in csi.
That has happened a lot in the last days and if i remember correctly this was not happening in the first time after we deployed csi.

The second thing that is pretty strange is the highlighting of programs for which update packages have been created. After checking this option the gui becomes pretty slow and after creating a patch i sometimes have to wait 2-5 minutes in order to continue work. In combination with the auto approval this i very unpleasing.

The third question deals with the distribution of patches for 32/64 Bit versions of i.e. Flash Player. Is it true that i need to create three patches for every iteration of flash?
1. 32 Bit Flash for 32Bit Systems.
2. 32 Bit Flash for 64Bit Systems.
3. 64Bit Flash for 64Bit Systems.
The reason that i think i need to create 3 seperate patches is that depending on the files used for determining the application path i would create an installation loop.
if i use 32bit flash for 32Bit and 64Bit with a single patch they would look for files in "program files" and "program files (x86)" but "program files" could be an 32bit or an 64bit application path and create an installation loop as the 64Bit path would never get the needed files.
Maybe this is just something that my mind made up, but a clarification would be nice.

Thanks

Joe

wmahmood RE: Local Database needs long time to sync / Program Highlighting / 32 vs. 64 Bit
Secunia Official 3rd Jan, 2012 21:11
Score: 0
Posts: 32
User Since: 10th Aug 2011
System Score: N/A
Location: Copenhagen, DK
Hi,

Thanks for posting your questions. I would answer your question in different parts.

1. Database Threashold:

CSI database gets updated according to specific limitations on the size of databse. This means, it all depends upon how many hosts you are scanning with CSI. Below are few categories.

* 0-100 Hosts: Threshold of 1% (meaning that it will always resync the full DB automatically when just a single host is scanned)
* 101-500 Hosts: Threshold of 3% (meaning that it will require from 3-15 hosts to be scanned before a DB sync will occur automatically)
* 501+ Hosts: Threshold 5% (meaning that it will require from 25+ hosts to be scanned before a DB sync will occur automatically)

2. CSI GUI is slow:

It depends upon how much data you have in your databse. It might be that you huge databse and you local database is corrupt. In order to overcome this issue; you can exit CSI completely and find Secunia folder in %localappdata%. You can also delete Secunia folder in appdata/Temp folder.

Start CSI again, and it would build your local database from scratch. This should solve the problem of slow GUI. Secondly, all of the patching information is gathered from your WSUS server. It might also be possible that connection between CSI and WSUS is slow. So, you should also consider looking at this as well. You can test this by installing CSi console on WSUS server and see if it still slows down the GUI.

3. 32 and 64 bit Adobe Reader Patches:

The issue that you have highlighted can be problem if you want to patch a 32 bit application with 64 bit patch. There could be three scenarios like

a. 32 bit Adobe is installed on 32 bit machine in C:/Program files
b. 32 bit Adobe is installed on 64 bit machine in C:/Program files (x86)
c. 64 bit Adobe is installed on 64 bit machine in C:/Program files (x86)

To overcome this issue, you should create two different patches for 32 bit and 64 bit version of program. In SPS, you can also choose to apply this patch to only 32 bit machien and vice versa for 64 bit.

Please let us know if you need any further explation.

Best Regards,

/Waqas

Solution Specialist

Secunia Customer Support

--
Best Regards,

Waqas Mahmood
Flexera Software Support
SmithJoe RE: Local Database needs long time to sync / Program Highlighting / 32 vs. 64 Bit
Contributor 9th Jan, 2012 10:22
Score: 143
Posts: 36
User Since: 14th Jun 2011
System Score: N/A
Location: DE
Hi,
first of all thanks for your support.

1. is there a way to initiate a manual DB sync? We're trying to scan new computer right after the installation process in order to directly (manually) fix missing patches (we've not yet deployed csi full scale).
2. The gui is really only extremly slow if i use the "highliting of programs for which update...". As soon as i deactivate that function everything is pretty fine (but i'll check the console on the wsus...)
3. Basically you're saying that i need 2 patches and not 3 like i feared. My concern were the folder names and that the rule would look for that specific folder and not find an updated version there. To be clear:
The rule for my flash 32Bit deployment would be to look into the folders c:\program files\...
and c:\program files (x64)\...
I thought that it might start to look into c:\program files\ on a 64 bit system and never find the right files as we were going to patch a 32 bit application and therefore allways try to install the patch as the rule might never be successfully fulfilled.
i.e:
1.check folders c:\program files and c:\program files (x86)
2. finds flash files that need an update in c:\program files\... (in this case the wrong folder as we would like to patch the 32bit application)
3. installs 32bit flash to c:\program files (x86)
4. repeat step 1-3 till infinity ;-)

To make a long story short: I guess the folder rules are used with an OR statement and more complex rules than i imagine are used.
Was this reply relevant?
+0
-0
wmahmood RE: Local Database needs long time to sync / Program Highlighting / 32 vs. 64 Bit
Secunia Official 10th Jan, 2012 10:34
Score: 0
Posts: 32
User Since: 10th Aug 2011
System Score: N/A
Location: Copenhagen, DK
Hi,

Thanks for your response. If you want to trigger the syncronization, you can double click on status bar of Secunia CSI located at bottom. The status bar usually vary from "Local datavase updated" and "Checking local database state".

I suggest, you should go ahead and start creating patches for Adobe. If you encounter any problems then you can send us email at csc@secunia.com and we would troubleshoot accordingly.

For Slow GUI, I have opened a bug for our development to look into it. If you can go to Configuration and settings -> enable Logging. Go to Secunia Pacakge System (SPS) and enable the option which you want. Let the CSI running for few minutes and play around with different options. Later, you can send us the log file to csc@secunia.com stating your issue. The log file would be helpful for us to pinpoint the issue.

Best Regards,

/Waqas

Secunia Customer Support

--
Best Regards,

Waqas Mahmood
Flexera Software Support

This thread has been marked as locked.