Can you generate the QR-code in "/tmp" folder?
QR-Code on 2021.1 uses java, so you need to have java installed.
Or -- upgrade to 2023.1. QR-code module there does not need java
I believe IRIS already can GRANT privileges on schema:
You can use SCHEMA schema-name as the object-list value to grant the object-privilege to all of the tables, views, and stored procedures in the named schema, in the current namespace. The following example grants this user SELECT privilege for all objects in the Sample schema.
"Apache Worker Process Close Down: PID=11330; Configuration=0x7fe92f816000;"
It looks like the connection is closed because Apache decides to recycle the worker, therefore the connection is terminated. It's rather a question to Apache configuration, why it decided to recycle a worker process
I don't know what happens in your particular case. What you can do -- set logging level in the Web Gateway to "ev2"
"V2" incudus the following information: "Information regarding basic connection management between the Web Gateway and InterSystems IRIS (Start and Close points for each connection)"
Let the Web Gateway run for some time, then hopefully in the csp.log you'll see the details on how new connections are created and old ones are terminated
Also you should be able to open any journal file from the Management Portal View Journal -- replace path to a journal file in the URL and you should see its contents
<NAMESPACE> is thrown when you try to switch to the non-existing namespace. So check to which namespace the project is connected and if this namespace exists
See documentation for $listnext. It stores a pointer to the current element of the list, thus avoiding recalculating it with each list element access. $List or $Listget has O(n) time complexity. $Listnext has O(1)
This is a standard Windows error with the code 64:
C:\>net helpmsg 64
The specified network name is no longer available.
Some Caché code called some OS system function that returned this error and for some reason it was logged.
To investigate this further -- check what process logged the error message. Find in the Caché Audit a Login event with the corresponding process. Perhaps it might give you some hint
Generally, messages with severity 0 are informational, 1 -- warnings, 2 -- error, 3 -- critical
No. If you have Windows NT authentication enabled to connect to SQL Server then SQL Server ODBC driver uses OS user that executes irisdb.exe process. That's the same use as configured to run service IRIS.
If you'd like to use different user for authentication , then choose SQL Server authentication and specify that user and its password in SQL Gateway connection settings
go to post
Try also the opposite -- adding quotes before the filename
d $ZF(-100,"/SHELL /LOGCMD /STDOUT=""/archive/logs/failover-intengtest-vip.log""",cmd)
go to post
There was a following directive in the Private Apache -- add it to your web server and it redirects documentation to docs.intersystems.com
Redirect /csp/docbook/ http://docs.intersystems.com/irisforhealth20231/csp/docbook/
go to post
Can you please provide here a small sample showing the issue.
go to post
Can you generate the QR-code in "/tmp" folder?
QR-Code on 2021.1 uses java, so you need to have java installed.
Or -- upgrade to 2023.1. QR-code module there does not need java
go to post
I did not.
go to post
Even better -- use System Manager Machine field (it's also on John's screenshot) to restrict access by IP also
go to post
I believe IRIS already can GRANT privileges on schema:
You can use SCHEMA schema-name as the object-list value to grant the object-privilege to all of the tables, views, and stored procedures in the named schema, in the current namespace. The following example grants this user SELECT privilege for all objects in the Sample schema.
GRANT SELECT ON SCHEMA Sample TO Deborah
https://docs.intersystems.com/irislatest/csp/docbook/DocBook.UI.Page.cls...
go to post
"Apache Worker Process Close Down: PID=11330; Configuration=0x7fe92f816000;"
It looks like the connection is closed because Apache decides to recycle the worker, therefore the connection is terminated. It's rather a question to Apache configuration, why it decided to recycle a worker process
go to post
I don't know what happens in your particular case. What you can do -- set logging level in the Web Gateway to "ev2"
"V2" incudus the following information: "Information regarding basic connection management between the Web Gateway and InterSystems IRIS (Start and Close points for each connection)"
Let the Web Gateway run for some time, then hopefully in the csp.log you'll see the details on how new connections are created and old ones are terminated
https://docs.intersystems.com/irislatest/csp/docbook/DocBook.UI.Page.cls...
Other idea -- check Apache settings. Which MPM does it use, what recycle settings for worker does it have?
Also, some notes on MPM models of Apache:
https://docs.intersystems.com/iris20232/csp/docbook/Doc.View.cls?KEY=GCG...
go to post
If you use IIS -- enable passThrough
https://docs.intersystems.com/iris20232/csp/docbook/DocBook.UI.Page.cls?...
go to post
Also you should be able to open any journal file from the Management Portal View Journal -- replace path to a journal file in the URL and you should see its contents
go to post
<NAMESPACE> is thrown when you try to switch to the non-existing namespace. So check to which namespace the project is connected and if this namespace exists
go to post
See documentation for $listnext. It stores a pointer to the current element of the list, thus avoiding recalculating it with each list element access. $List or $Listget has O(n) time complexity. $Listnext has O(1)
go to post
Very nice report. Thank you!
go to post
For already running backup or restore you can check "7) Monitor progress of backup or restore" menu in
do ^BACKUP
routinego to post
Generally, if performance matters -- consider using $Listnext instead of $List or $ListGet
go to post
This is a standard Windows error with the code 64:
C:\>net helpmsg 64 The specified network name is no longer available.
Some Caché code called some OS system function that returned this error and for some reason it was logged.
To investigate this further -- check what process logged the error message. Find in the Caché Audit a Login event with the corresponding process. Perhaps it might give you some hint
Generally, messages with severity 0 are informational, 1 -- warnings, 2 -- error, 3 -- critical
go to post
No. If you have Windows NT authentication enabled to connect to SQL Server then SQL Server ODBC driver uses OS user that executes irisdb.exe process. That's the same use as configured to run service IRIS.
If you'd like to use different user for authentication , then choose SQL Server authentication and specify that user and its password in SQL Gateway connection settings
go to post
Yes. See privileged routines
https://docs.intersystems.com/iris20223/csp/docbook/DocBook.UI.Page.cls?...
go to post
Did you try to run this after failed
set x509 = ##class(%SYS.X509Credentials).GetByAlias("foo")
?