Forums

Resolved
0 votes
Ok so trying to get this up and running using a vmware VM, all appears to go well, note the download seems very large at approx 800Mb but no erros or log entries, the eula comes up, click accept and an error appears in the window

/bin/chown: invalid user : "mssql"
also if you navigate away form this page the error clears and is replaced with a link to a MS download page for a windows executable client.

tried various tactical approaches, new VM builds and re-installs at various stages (using samba as directory service, before updates etc, now gathering info, logs and screenies but nothing obvious to a newbie :) and a lot of web references are about centos and refer to different download packs etc
went to cl to try config from there and obtained this pic
Attachments:
Friday, February 16 2018, 03:15 PM
Share this post:

Accepted Answer

Friday, February 23 2018, 12:53 PM - #Permalink
Resolved
0 votes
Our team estimates that it will take a few days to bring this app up to snuff. Microsoft added some new features which greatly eases the deployment of this and they have to retool a bunch of steps to make this more stable in the long term.

You can read about that here:

https://docs.microsoft.com/en-us/sql/linux/sql-server-linux-setup#unattended

Until then, I've asked the Marketplace engineering team to temporarily withdraw the app from being listed.
The reply is currently minimized Show
Responses (13)
  • Accepted Answer

    Wednesday, February 21 2018, 04:15 PM - #Permalink
    Resolved
    0 votes
    cheers chaps, just glad it wasn't something i was doing wrong :D
    The reply is currently minimized Show
  • Accepted Answer

    Wednesday, February 21 2018, 02:31 PM - #Permalink
    Resolved
    0 votes
    Here is your bug filed:

    https://tracker.clearos.com/view.php?id=19211

    The developers are working on it and should have an updated fix soon. I'll watch the build system for their commit and report further when I know more.
    The reply is currently minimized Show
  • Accepted Answer

    Wednesday, February 21 2018, 02:25 AM - #Permalink
    Resolved
    0 votes
    My devs will be up soon and able to work on this in just a couple of hours. Thanks for the feedback and patience.
    The reply is currently minimized Show
  • Accepted Answer

    Tuesday, February 20 2018, 02:57 PM - #Permalink
    Resolved
    0 votes
    ah well, at least the devs now know it doesn't work oob ;)
    The reply is currently minimized Show
  • Accepted Answer

    Saturday, February 17 2018, 08:42 AM - #Permalink
    Resolved
    0 votes
    The dev I contacted has confirmed the installation bombs with the same chown error as you. The package does not appear to be supported by the dev's I have direct contact with so getting feedback won't be so easy.
    The reply is currently minimized Show
  • Accepted Answer

    Saturday, February 17 2018, 12:53 AM - #Permalink
    Resolved
    0 votes
    Cheers mate I think that's progress, it certainly stopped the chown error but server does not stay in running state so from what i have read the next step would normally be a screen where you are asked to choose which edition to trial, this is not coming up.
    The next screen is the admin page for setting the sql sa password and a "system" password (not sure what it means here so just feeding it the root pw) a quick browse round the file system it appears whilst some stuff is put in the clearos/apps directory the actual sql binary is still going in the /opt/mssql/bin path, is this wrong?
    The reply is currently minimized Show
  • Accepted Answer

    Friday, February 16 2018, 10:25 PM - #Permalink
    Resolved
    0 votes
    You could try adding a system user called mysql (I think it is "useradd -r mysql" but I can't check now)
    The reply is currently minimized Show
  • Accepted Answer

    Friday, February 16 2018, 10:17 PM - #Permalink
    Resolved
    0 votes
    yes i noticed that mate, i have the VM set at 6Gb so should be enough, the first issue is the strange chown error when i accept the eula, seen nothing on having to manually set a user or group up to get it running.
    The reply is currently minimized Show
  • Accepted Answer

    Friday, February 16 2018, 09:54 PM - #Permalink
    Resolved
    0 votes
    I noticed the reviews and pinged a dev to see if he knew anything but he has not answered yet. If you are running in a VM, did you notice the huge memory requirements?
    The reply is currently minimized Show
  • Accepted Answer

    Friday, February 16 2018, 09:47 PM - #Permalink
    Resolved
    0 votes
    ok mate, seems like someone managed to get it running 6 months ago so maybe it's an issue with an update either on mssql or on clearos, will try the obvious and re-download the iso, but as this is a test to see how user friendly this is for a server install at my friends place, no point in me spending too much time on it, if he goes ahead with plans there will be no one near any level of technical ability at the site.
    The reply is currently minimized Show
  • Accepted Answer

    Friday, February 16 2018, 08:48 PM - #Permalink
    Resolved
    0 votes
    I really don't know M$SQL so I am not sure what to do.
    The reply is currently minimized Show
  • Accepted Answer

    Friday, February 16 2018, 06:01 PM - #Permalink
    Resolved
    0 votes
    Nick Howitt wrote:

    Are you installing this from the marketplace? It is trying to use file locations like /var/opt and /opt which are not used by ClearOS.

    BTW, better than screenshots are tools like PuTTy (copy by selecting, paste by right-clicking) and WinSCP from a Windoze workstation.


    yes initially i used the market place only dropped down to console to try and figure out what was going on as I couldn't find out how to get any info, (what is the native install path for clearos?) the service remained as stopped, pressing start did nothing, nothing was showing in log viewer and no connection available via the sql server management, clearos firewall was disabled and i opened the port on iptables just in case
    The reply is currently minimized Show
  • Accepted Answer

    Friday, February 16 2018, 05:21 PM - #Permalink
    Resolved
    0 votes
    Are you installing this from the marketplace? It is trying to use file locations like /var/opt and /opt which are not used by ClearOS.

    BTW, better than screenshots are tools like PuTTy (copy by selecting, paste by right-clicking) and WinSCP from a Windoze workstation.
    The reply is currently minimized Show
Your Reply