November 28, 2017 at 12:45 pm
I'm hoping someone can point me to some non-marketing links that explain what RStudio and Domino are. This subject recently came up in the workplace when someone from another team tried connecting to one of our database servers and received an error.
Since I'd never heard of either of them before this point, I can't help troubleshoot the issue. But as I am a member of the DBA team, I need to. This is a server the user has access to. I just don't know where to start.
Can someone provide links? Perhaps connection advice?
This is the error:
library(RJDBC)
drv <- JDBC("com.microsoft.sqlserver.jdbc.SQLServerDriver","/tmp/sqljdbc4.jar")
conn <- dbConnect(drv, "jdbc:sqlserver://MySQLServer;integratedSecurity=true;")Error in.jcall(drv@jdrv, "Ljava/sql/Connection;", "connect",as.character(url)[1], :
com.microsoft.sqlserver.jdbc.SQLServerException:This driver is not configured for integrated authentication.ClientConnectionId:caf689a6-79cc-46d2-896e-cbd918a931b0
[/quote]
November 28, 2017 at 4:32 pm
RStudio is a standalone server for R that you use to manage queries against your database rather than let them go through the built in R servicing architecture that's built into SQL Server (and is a bit of a memory pig). I'm not sure what exactly Domino is. I think it might be a build or maybe it's the web server for Rstudio. Just not sure on that one.
Your RStudio isn't set up for AD connections. Now, how to do that? I don't know.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
November 29, 2017 at 4:07 am
Thanks, Grant. I'll do more research. Hopefully Google will come up with more than the marketing stuff this time around.
November 29, 2017 at 5:50 am
I was wrestling with RStudio just yesterday. I made the mistake of installing both the Stand Alone server and the internals on the same machine. Don't do that. (for those interested, this is 2016 & 2017).
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
November 29, 2017 at 5:54 am
Fortunately the end user in question doesn't have the ability to do installs. They are pushed by corporate.
Then again... Corporate does have individuals who don't understand how to avoid patching a production server in the middle of the day so... maybe I'd best double-check.
November 29, 2017 at 11:27 am
November 29, 2017 at 11:33 am
Awesome! Thank you for that link.
November 29, 2017 at 11:54 am
The error is a jdbc error. Every time I've ever seen this, it's been due to the file sqljdbc_auth.dll missing or in the wrong location.
If you google the error (sqlserver.jdbc.SQLServerException:This driver is not configured for integrated authentication), you should be able to find a lot of articles about it as it's not unusual.
Sue
November 29, 2017 at 12:15 pm
Sue_H - Wednesday, November 29, 2017 11:54 AMThe error is a jdbc error. Every time I've ever seen this, it's been due to the file sqljdbc_auth.dll missing or in the wrong location.
If you google the error (sqlserver.jdbc.SQLServerException:This driver is not configured for integrated authentication), you should be able to find a lot of articles about it as it's not unusual.Sue
Thank you for verifying that, Sue. I saw the JDBC stuff when I initially started looking but disregarded it because I was looking for an RODBC article. I'll go back to the JDBC stuff.
December 27, 2020 at 2:22 pm
Domino comes pre-configured with optimized computing stacks for research. They include popular languages, tools, and packages such as R, Python, SAS, Jupyter, RStudio, Tensorflow, and H2O.
In the context of your runs, the RStudio user preferences (such as theme) are stored in a file located at /home/ubuntu/.rstudio/monitored/user-settings/user-settings. You can launch RStudio with custom preferences by modifying this file via the pre-setup script of a custom compute environment.
Method 1: Write lines to the settings file
If you know the line you need to add to the settings file, you can write it directly in the pre-setup script. For example:
mkdir -p /home/ubuntu/.rstudio/monitored/user-settings/
echo 'uiPrefs={"theme" : "Mono Industrial"}' >> /home/ubuntu/.rstudio/monitored/user-settings/user-settings
chown -R ubuntu:ubuntu /home/ubuntu/.rstudio
if [ -f .domino/launch-rstudio-server ]; then
sed -i.bak 's# > ~/.rstudio/monitored/user-settings/user-settings# >> ~/.rstudio/monitored/user-settings/user-settings#' .domino/launch-rstudio-server
chown ubuntu:ubuntu .domino/launch-rstudio-server
fi
Here’s what each line is doing:
The mkdir statement creates the encompassing directory.
The echo statement writes the theme to the file. This can be replaced with a copy operation if you’d prefer to store a file in your project (see next section).
The chown statements are needed to avoid a permissions error.
The sed statement modifies a Domino script that would otherwise overwrite this settings file.
I hope this answers your question.
Viewing 10 posts - 1 through 9 (of 9 total)
You must be logged in to reply to this topic. Login to reply