Author Topic: Zentyal and MS SQL  (Read 2738 times)

spst

  • Zen Apprentice
  • *
  • Posts: 21
  • Karma: +3/-0
    • View Profile
Zentyal and MS SQL
« on: June 11, 2020, 02:00:55 pm »
Hi,

I would like to know if it is possible to install MS SQL on Zentyal without any problem.

Microsoft has released the MS SQL database manager for Linux and runs on Ubuntu but I read that it doesn't work properly under Zentyal.

Unfortunately I would need MS SQL but I don't want to create a virtual machine for that.

Thanks for all the information and help.

Regars.

doncamilo

  • Zen Samurai
  • ****
  • Posts: 478
  • Karma: +165/-1
    • View Profile
Re: Zentyal and MS SQL
« Reply #1 on: June 12, 2020, 10:06:40 am »
 :)

I didn't check it, but if Ubuntu supports it, it should run on Zentyal. Check that the SQL server doesn't use some port managed by Zentyal.

Try it and tell us about it!

Cheers!
- Do my pigeons bother you passing over your land?
- They block the sun!

G. Guareschi., Don Camillo.,

spst

  • Zen Apprentice
  • *
  • Posts: 21
  • Karma: +3/-0
    • View Profile
Re: Zentyal and MS SQL
« Reply #2 on: June 12, 2020, 09:10:42 pm »
I don't like to test on my working server but I found this problem:

https://forum.zentyal.org/index.php?topic=32370.0

and i want to know if it has been fixed yet?

Thanks and Regards

doncamilo

  • Zen Samurai
  • ****
  • Posts: 478
  • Karma: +165/-1
    • View Profile
Re: Zentyal and MS SQL
« Reply #3 on: June 14, 2020, 02:20:12 pm »
 :)

Code: [Select]
apt-cache show libsasl2-modules-gssapi-mit
Package: libsasl2-modules-gssapi-mit
Source: cyrus-sasl2
Version: 2.1.27~101-g0780600+dfsg-3+deb9u1
Installed-Size: 185
Maintainer: Debian Cyrus SASL Team <pkg-cyrus-sasl2-debian-devel@lists.alioth.debian.org>
Architecture: amd64
Depends: libsasl2-modules (= 2.1.27~101-g0780600+dfsg-3+deb9u1), libc6 (>= 2.14), libcomerr2 (>= 1.01), libgssapi-krb5-2 (>= 1.14+dfsg), libk5crypto3 (>= 1.6.dfsg.2), libkrb5-3 (>= 1.6.dfsg.2), libssl1.1 (>= 1.1.0)
Conflicts: libsasl2-modules-gssapi-heimdal
Description-en: Cyrus SASL - pluggable authentication modules (GSSAPI)
 This is the Cyrus SASL API implementation, version 2.1. See package
 libsasl2-2 and RFC 2222 for more information.
 .
 This package provides the GSSAPI plugin, compiled with the MIT
 Kerberos 5 library.

The "Conflicts" parameter shows that the heimdal and mit packages can't be both of them installed in a system, but you could run Ms. SQL Server in a dedicated virtual machine managed by Zentyal (virtualization module).

Cheers!
- Do my pigeons bother you passing over your land?
- They block the sun!

G. Guareschi., Don Camillo.,

spst

  • Zen Apprentice
  • *
  • Posts: 21
  • Karma: +3/-0
    • View Profile
Re: Zentyal and MS SQL
« Reply #4 on: June 14, 2020, 08:40:47 pm »
Thanks for your help doncamilo!

This is not good news... It seems that the problem has not been solved in the last two years.

I'm using a virtual machine now but I want to eliminate that. It is therefore a waste of resources to operate a virtual machine. I have no luck...

Thanks and Regards

AlecM

  • Zen Apprentice
  • *
  • Posts: 10
  • Karma: +1/-0
    • View Profile
Re: Zentyal and MS SQL
« Reply #5 on: July 08, 2020, 11:53:09 am »
I haven't seen a note for installing MS-SQL via a Snap or Flatpak, but it does officially support Docker - so that might be an option to resolve that dependency conflict under your config rather than using another VM?
https://docs.microsoft.com/en-us/sql/linux/quickstart-install-connect-docker?view=sql-server-ver15&pivots=cs1-bash