RStudio and Domino?

  • 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]

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

  • 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

    The Scary DBA
    Author of: SQL Server 2017 Query Performance Tuning, 5th Edition and SQL Server Execution Plans, 3rd Edition
    Product Evangelist for Red Gate Software

  • Thanks, Grant. I'll do more research. Hopefully Google will come up with more than the marketing stuff this time around.

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

  • 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

    The Scary DBA
    Author of: SQL Server 2017 Query Performance Tuning, 5th Edition and SQL Server Execution Plans, 3rd Edition
    Product Evangelist for Red Gate Software

  • 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.

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

  • Awesome! Thank you for that link.

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

  • 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

  • Sue_H - Wednesday, November 29, 2017 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

    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.

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

  • 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 10 (of 10 total)

You must be logged in to reply to this topic. Login to reply