Re[2]: [RBASE-L] - Tip of the Day: Scrutinize Security Software with R:BASE X/X Enterprise
Thank you, Steve! That just cleaned up a situation which made me look - and feel - like a dinosaur. Bruce -- Original Message -- Sent: 8/15/2018 6:49:35 PM Subject: RE: [RBASE-L] - Tip of the Day: Scrutinize Security Software with R:BASE X/X Enterprise From: "Steve Johnson" To: rbase-l@googlegroups.com Cc: To All, It might be useful for those of you operating in simpler networks (primarily those operating without a domain server), Microsoft has deprecated the ability to see the entire network through file explorer. This is related to the SMB1 protocol which enabled the original Network Neighborhood in Win 98 and had become a serious security issue in today’s environment. I discovered this change following a recent version upgrade in Windows 10 to build 1803 on one desktop where I could no longer see or connect to our NAS/file server. This should also occur if one replaces a desktop with a new Win10 machine. Supposedly SMB1 had been deprecated in earlier builds of Win10, but SMB1 could be turned on/off. Build 1803 simply removed the ability all together. However, I have found that the results of the deprecated SMB1 is inconsistent between individual machines and both Win7 and Win10 probably due to existing settings/files already in place. If you run into a situation where you suddenly can’t see or reach a file destination on the network that was available before, especially following an OS upgrade or new desktop/laptop using WIN10, this may very well be the cause. The solution is using UNC Path (with appropriate permissions in place) as noted by Mike and Dan. Steve Johnson From:rbase-l@googlegroups.com [mailto:rbase-l@googlegroups.com] On Behalf Of Dan Goldberg Sent: Friday, August 10, 2018 1:18 PM To:rbase-l@googlegroups.com Subject: RE: [RBASE-L] - Tip of the Day: Scrutinize Security Software with R:BASE X/X Enterprise I switched to unc paths a while ago. They work good. Also good for malware/ransomware protection as they scan mapped drives to put their bugs in. Dan Goldberg From:rbase-l@googlegroups.com On Behalf Of mike.rams...@aksteel.com Sent: Friday, August 10, 2018 9:06 AM To:rbase-l@googlegroups.com Subject: Re: [RBASE-L] - Tip of the Day: Scrutinize Security Software with R:BASE X/X Enterprise Thank you, Razzak, for this very timely information. Our company upgraded our corporate security software to the most recent version and it created some havoc for me. This also coincided with some recent Windows Updates. Configuring the software per Razzak's recommendations has greatly improved the performance of my databases and programs. I'm using R:BASE X Enterprise One issue that came up involved references to mapped network drives (such as T:\, U:\, etc.) versus referring to them by their full UNC. I've had to replace references to mapped drives with the full UNC (\\host-name\share-name\file_path . Before doing this I was getting errors like: Invalid file spec, or unable to access directory. (2561) Invalid destination filespec (2282) Invalid source filespec (2281) Hopefully my experience and solution may help someone else. Kind regards. Mike Ramsour AK Steel Coshocton Works Quality Department Phone: 740-829-4340 Cell: 740-502-1659 From:"A. Razzak Memon" To:rbase-l@googlegroups.com, Date:07/26/2018 11:21 AM Subject:[RBASE-L] - Tip of the Day: Scrutinize Security Software with R:BASE X/X Enterprise Sent by:rbase-l@googlegroups.com Thursday, July 26, 2018 Tip of the Day: Configuring Security Software with R:BASE X/X Enterprise Product...: R:BASE X and R:BASE X Enterprise (Version 10) Build.: 10.0.3.20710 or higher Keywords..: Environment, Multi-User, Network Configuration Section...: General Client and server computers may have one or more security-based software (anti-virus, anti-malware, anti-spyware) utilities installed. Common to security programs is the ability to define "exceptions" for program files and folders where scans should be ignored. Including R:BASE within the exception area is required in order maintain performance. If R:BASE itself is scanned each time it is launched, and the contents of the database and temporary files are halted and scanned each time they are created/accessed, users will see much slower response times when running R:BASE, making connections, and accessing files. It is important to add exceptions to three areas of the R:BASE program: 01. - Program Executable For R:BASE X Enterprise, the executable name is RBGXE.exe. The default installation folder is "C:\RBTI\RBGXE". For R:BASE X, the executable name is RBGX.exe. The default installation folder is "C:\RBTI\RBGX". For R:Compiler/Runtime for R:BASE applications, the compiled executable, Runtime executables, and DLLs (all of which are usually
RE: [RBASE-L] - Determining operating condition -- Standalone vs. Scripted
Razzak,
You sneaky dog, this is very cool. I will start using this right away.
Thanks,
Paul Buckley
-Original Message-
From: rbase-l@googlegroups.com On Behalf Of A.
Razzak Memon
Sent: August 17, 2018 11:12 AM
To: rbase-l@googlegroups.com
Subject: Re: [RBASE-L] - Determining operating condition -- Standalone vs.
Scripted
Mike,
You may also use the "-Txxx" executable option to add an additional text label
to an R:BASE instance, where xxx is a custom text (e.g.
Development) or "RandomID".
The label will allow you to identify the running the instance in the Task
Manager, which is useful in your case with multiple instances of R:BASE running.
Examples:
C:\RBTI\RBGX\RBGX.EXE "-TSuchAndSuch"
C:\RBTI\RBGXE\RBGXE.EXE "-TNewDataImport"
C:\RBTI\RBGXE\RBGXE.EXE "-TLogEnvChanges"
To use a random value, specify "-T RandomID" to use the operating system
TickCount value, which returns the number of milliseconds elapsed since the
system started.
Example: C:\RBTI\RBGXE\RBGXE.EXE "-T RandomID"
[]
Very Best R:egards,
Razzak
At 10:19 AM 8/17/2018, mike.rams...@aksteel.com wrote:
>Good morning:
>
>Is there a way to determine the operating condition that R:BASE
>programs are running in? I didn't see a CVAL function that would match
>what I'm thinking of.
>
>For example, I have a set of 300+ programs that run daily in a set
>sequence over a 3-hour time period. For various reasons any of these
>programs may need to be run individually from the R>.
>
>For example at the R>: RUN SuchAndSuch.RMD
>
>There are situations where it would helpful to be able to determine
>whether the program was launched separately with the RUN command vs.
>running in a sequence of programs.
>
>Something like:
>
>IF (CVAL("Standalone")) = 1 THEN
>
>Do something
>
>ELSE
>
>Do something else
>
>ENDIF
>
>Is there something already in place that would let me test for this
>situation?
>
>If not I might be contacting the Dream Team soon.
>
>Thanks for sharing any thoughts or suggestions.
>
>
>Mike Ramsour
>AK Steel Coshocton Works
>Quality Department
>Phone: 740-829-4340
>Cell: 740-502-1659
>Confidentiality Notice
>This message is intended exclusively for the individual or entity to
>which it is addressed and may contain privileged, proprietary, or
>otherwise private information.
>If you are not the named addressee, you are not authorized to read,
>print, retain, copy or disseminate this message or any part of it.
>If you have received this message in error, please notify the sender
>immediately by e-mail and delete all copies of the message.
--
For group guidelines, visit
http://www.rbase.com/support/usersgroup_guidelines.php
---
You received this message because you are subscribed to the Google Groups
"RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to rbase-l+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
--
For group guidelines, visit
http://www.rbase.com/support/usersgroup_guidelines.php
---
You received this message because you are subscribed to the Google Groups
"RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to rbase-l+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
Re: [RBASE-L] - Determining operating condition -- Standalone vs. Scripted
Mike,
You may also use the "-Txxx" executable option to add an additional
text label to an R:BASE instance, where xxx is a custom text (e.g.
Development) or "RandomID".
The label will allow you to identify the running the instance in the
Task Manager, which is useful in your case with multiple instances of
R:BASE running.
Examples:
C:\RBTI\RBGX\RBGX.EXE "-TSuchAndSuch"
C:\RBTI\RBGXE\RBGXE.EXE "-TNewDataImport"
C:\RBTI\RBGXE\RBGXE.EXE "-TLogEnvChanges"
To use a random value, specify "-T RandomID" to use the operating
system TickCount value, which returns the number of milliseconds
elapsed since the system started.
Example: C:\RBTI\RBGXE\RBGXE.EXE "-T RandomID"
[]
Very Best R:egards,
Razzak
At 10:19 AM 8/17/2018, mike.rams...@aksteel.com wrote:
Good morning:
Is there a way to determine the operating condition that R:BASE
programs are running in? I didn't see a CVAL function that would
match what I'm thinking of.
For example, I have a set of 300+ programs that run daily in a set
sequence over a 3-hour time period. For various reasons any of
these programs may need to be run individually from the R>.
For example at the R>: RUN SuchAndSuch.RMD
There are situations where it would helpful to be able to determine
whether the program was launched separately with the RUN command vs.
running in a sequence of programs.
Something like:
IF (CVAL("Standalone")) = 1 THEN
Do something
ELSE
Do something else
ENDIF
Is there something already in place that would let me test for this
situation?
If not I might be contacting the Dream Team soon.
Thanks for sharing any thoughts or suggestions.
Mike Ramsour
AK Steel Coshocton Works
Quality Department
Phone: 740-829-4340
Cell: 740-502-1659
Confidentiality Notice
This message is intended exclusively for the individual or entity to
which it is addressed and may contain privileged, proprietary, or
otherwise private information.
If you are not the named addressee, you are not authorized to read,
print, retain, copy or disseminate this message or any part of it.
If you have received this message in error, please notify the sender
immediately by e-mail and delete all copies of the message.
--
For group guidelines, visit
http://www.rbase.com/support/usersgroup_guidelines.php
---
You received this message because you are subscribed to the Google Groups "RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to rbase-l+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
Re: [RBASE-L] - Determining operating condition -- Standalone vs. Scripted
Mike,
Would (CVAL('CONNECTIONS')) help?
(CVAL('CONNECTIONS'))
Returns the number of users currently connected to the current
database or 0 if not connected. In the event of a non-graceful
disconnect R:BASE will not be able to decrement the connections
count. This can occur if the network session terminates unexpectedly,
or if the users operating system crashes. If this happens the count
will be inaccurate until all users disconnect from the database. This
works because the last session of R:BASE will be able to tell that NO
users are connected and will reset the count to zero. Unfortunately,
due to file system limitations, R:BASE is only able to tell if a
database is open by any users or not at all, and is not able to tell,
except by this count, how many users are connected
Very Best R:egards,
Razzak
At 10:19 AM 8/17/2018, mike.rams...@aksteel.com wrote:
Good morning:
Is there a way to determine the operating condition that R:BASE
programs are running in? I didn't see a CVAL function that would
match what I'm thinking of.
For example, I have a set of 300+ programs that run daily in a set
sequence over a 3-hour time period. For various reasons any of
these programs may need to be run individually from the R>.
For example at the R>: RUN SuchAndSuch.RMD
There are situations where it would helpful to be able to determine
whether the program was launched separately with the RUN command vs.
running in a sequence of programs.
Something like:
IF (CVAL("Standalone")) = 1 THEN
Do something
ELSE
Do something else
ENDIF
Is there something already in place that would let me test for this
situation?
If not I might be contacting the Dream Team soon.
Thanks for sharing any thoughts or suggestions.
Mike Ramsour
AK Steel Coshocton Works
Quality Department
Phone: 740-829-4340
Cell: 740-502-1659
Confidentiality Notice
This message is intended exclusively for the individual or entity to
which it is addressed and may contain privileged, proprietary, or
otherwise private information.
If you are not the named addressee, you are not authorized to read,
print, retain, copy or disseminate this message or any part of it.
If you have received this message in error, please notify the sender
immediately by e-mail and delete all copies of the message.
--
For group guidelines, visit
http://www.rbase.com/support/usersgroup_guidelines.php
---
You received this message because you are subscribed to the Google
Groups "RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it,
send an email to rbase-l+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
--
For group guidelines, visit
http://www.rbase.com/support/usersgroup_guidelines.php
---
You received this message because you are subscribed to the Google Groups "RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to rbase-l+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
Re: [RBASE-L] - Determining operating condition -- Standalone vs. Scripted
I can only think of the really low-tech way that I do it (because I do the
exact same thing you do)
When running a routine from another place (like calling from another program or
from a menu system), I would do this:
SET VAR vFromProgram = 'Overnightrun'
RUN whatever.rmd
CLEAR VAR vFromProgram
Then whatever.rmd would do
SET VAR vFromProgram TEXT
IF vFromProgram IS NULL (or '= Overnight') THEN
do whatever
ENDIF
Karen
-Original Message-
From: mike.ramsour
To: rbase-l
Sent: Fri, Aug 17, 2018 9:19 am
Subject: [RBASE-L] - Determining operating condition -- Standalone vs. Scripted
Good morning:
Is there a way to determine the operatingcondition that R:BASE programs are
running in? I didn't see a CVALfunction that would match what I'm thinking of.
For example, I have a set of 300+ programsthat run daily in a set sequence over
a 3-hour time period. For variousreasons any of these programs may need to be
run individually from theR>.
For example at the R>: RUNSuchAndSuch.RMD
There are situations where it wouldhelpful to be able to determine whether the
program was launched separatelywith the RUN command vs. running in a sequence
of programs.
Something like:
IF (CVAL("Standalone")) =1 THEN
Do something
ELSE
Do something else
ENDIF
Is there something already in placethat would let me test for this situation?
If not I might be contacting the DreamTeam soon.
Thanks for sharing any thoughts or suggestions.
Mike Ramsour
AK Steel Coshocton Works
Quality Department
Phone: 740-829-4340
Cell: 740-502-1659
Confidentiality Notice
This message is intended exclusively for the individual or entity to which it
is addressed and may contain privileged, proprietary, or otherwise private
information.
If you are not the named addressee, you are not authorized to read, print,
retain, copy or disseminate this message or any part of it. If you have
received this message in error, please notify the sender immediately by e-mail
and delete all copies of the message.
--
For group guidelines, visit
http://www.rbase.com/support/usersgroup_guidelines.php
---
You received this message because you are subscribed to the Google Groups
"RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to rbase-l+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
--
For group guidelines, visit
http://www.rbase.com/support/usersgroup_guidelines.php
---
You received this message because you are subscribed to the Google Groups
"RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to rbase-l+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
[RBASE-L] - Determining operating condition -- Standalone vs. Scripted
Good morning:
Is there a way to determine the operating condition that R:BASE programs
are running in? I didn't see a CVAL function that would match what I'm
thinking of.
For example, I have a set of 300+ programs that run daily in a set
sequence over a 3-hour time period. For various reasons any of these
programs may need to be run individually from the R>.
For example at the R>: RUN SuchAndSuch.RMD
There are situations where it would helpful to be able to determine
whether the program was launched separately with the RUN command vs.
running in a sequence of programs.
Something like:
IF (CVAL("Standalone")) = 1 THEN
Do something
ELSE
Do something else
ENDIF
Is there something already in place that would let me test for this
situation?
If not I might be contacting the Dream Team soon.
Thanks for sharing any thoughts or suggestions.
Mike Ramsour
AK Steel Coshocton Works
Quality Department
Phone: 740-829-4340
Cell: 740-502-1659
Confidentiality Notice
This message is intended exclusively for the individual or entity to which it
is addressed and may contain privileged, proprietary, or otherwise private
information.
If you are not the named addressee, you are not authorized to read, print,
retain, copy or disseminate this message or any part of it. If you have
received this message in error, please notify the sender immediately by e-mail
and delete all copies of the message.
--
For group guidelines, visit
http://www.rbase.com/support/usersgroup_guidelines.php
---
You received this message because you are subscribed to the Google Groups
"RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to rbase-l+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
