Results 1 to 5 of 5

Thread: SQL Server on Ubuntu error setup

  1. #1
    Join Date
    Jan 2017
    Beans
    1

    SQL Server on Ubuntu error setup

    I want to install ms-sql to my Ubuntu 16.04: https://docs.microsoft.com/en-us/sql...x-setup-ubuntu

    But when I try to set a password for the SA with the command sudo /opt/mssql/bin/sqlservr-setup I got error: "sqlservr: Debugger.cpp:531: static void Debugger:rint(const void *, unsigned int): Assertion `m_IsAttached' failed."
    How to solve a problem?

    Thanks

    Microsoft(R) SQL Server(R) Setup


    You can abort setup at anytime by pressing Ctrl-C. Start this program
    with the --help option for information about running it in unattended
    mode.


    The license terms for this product can be downloaded from
    http://go.microsoft.com/fwlink/?LinkId=746388 and found
    in /usr/share/doc/mssql-server/LICENSE.TXT.


    Do you accept the license terms? If so, please type "YES": YES


    Please enter a password for the system administrator (SA) account:
    Please confirm the password for the system administrator (SA) account:


    Setting system administrator (SA) account password...
    sqlservr: Debugger.cpp:531: static void Debugger:rint(const void *, unsigned int): Assertion `m_IsAttached' failed.
    Hint: You are currently not seeing messages from other users and the system.
    Users in the 'systemd-journal' group can see all messages. Pass -q to
    turn off this notice.
    No journal files were opened due to insufficient permissions.
    Hint: You are currently not seeing messages from other users and the system.
    Users in the 'systemd-journal' group can see all messages. Pass -q to
    turn off this notice.
    No journal files were opened due to insufficient permissions.
    tail: cannot open '/var/log/syslog' for reading: Permission denied
    ls: cannot access '/var/opt/mssql/log/errorlog*': No such file or directory
    ls: cannot access '/var/opt/mssql/log/exception.log': No such file or directory
    ls: cannot access '/var/opt/mssql/log/SQLDu*.txt': No such file or directory
    ls: cannot access '/var/opt/mssql/log/SQLDu*.mdmp': No such file or directory
    ls: cannot access '/var/opt/mssql/log/system_health*': No such file or directory
    nohup: redirecting stderr to stdout

  2. #2
    Join Date
    Apr 2011
    Location
    Mystletainn Kick!
    Beans
    13,614
    Distro
    Ubuntu

    Re: SQL Server on Ubuntu error setup

    Thread moved to Server Platforms.
    Splat Double Splat Triple Splat
    Earn Your Keep
    Don't mind me, I'm only passing through.
    Once in a blue moon, I'm actually helpful
    .

  3. #3
    Join Date
    Nov 2009
    Location
    Catalunya, Spain
    Beans
    14,560
    Distro
    Ubuntu 18.04 Bionic Beaver

    Re: SQL Server on Ubuntu error setup

    It reports more errors, not just that one. Are you sure it installed correctly without errors?

    You should probably post a question to MS because it's their product. Just because you are trying to install it on Ubuntu it doesn't mean we will have the answers, especially since this is new software. Plus I bet almost no one uses MS SQL on linux servers, for me it beats the point. That's why long time proven and stable solutions like mysql exist. Don't forget, this seems to be first steps for MS SQL on ubuntu, be prepared for many bugs and unexplained errors.
    Darko.
    -----------------------------------------------------------------------
    Ubuntu 18.04 LTS 64bit

  4. #4
    Join Date
    Nov 2008
    Location
    Boston MetroWest
    Beans
    16,326

    Re: SQL Server on Ubuntu error setup

    I've used PostgreSQL for decades now. From Windows I connect to it via its ODBC driver. I don't use MySQL unless something requires it like WordPress. I can't see much reason to run MS-SQL on Linux either. If you're a Windows shop, then run it on Windows. If you prefer Linux servers, use one of the SQL servers with a long history on the platform.
    If you ask for help, do not abandon your request. Please have the courtesy to check for responses and thank the people who helped you.

    Blog · Linode System Administration Guides · Android Apps for Ubuntu Users

  5. #5

    Re: SQL Server on Ubuntu error setup

    Quote Originally Posted by ekangal View Post
    No journal files were opened due to insufficient permissions.
    ...
    No journal files were opened due to insufficient permissions.
    tail: cannot open '/var/log/syslog' for reading: Permission denied
    stands out,
    Windows assumes the user is an idiot.
    Linux demands proof.

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •