Skip to content
  • Categories
  • Recent
  • Tags
  • Popular
  • Users
  • Groups
Skins
  • Light
  • Brite
  • Cerulean
  • Cosmo
  • Flatly
  • Journal
  • Litera
  • Lumen
  • Lux
  • Materia
  • Minty
  • Morph
  • Pulse
  • Sandstone
  • Simplex
  • Sketchy
  • Spacelab
  • United
  • Yeti
  • Zephyr
  • Dark
  • Cyborg
  • Darkly
  • Quartz
  • Slate
  • Solar
  • Superhero
  • Vapor

  • Default (Flatly)
  • No Skin
Collapse
Brand Logo

NetXMS Forum

  1. Home
  2. Support
  3. Database create. Fail to create table

Database create. Fail to create table

Scheduled Pinned Locked Moved Support
6 Posts 3 Posters 33.0k Views
  • Oldest to Newest
  • Newest to Oldest
  • Most Votes
Reply
  • Reply as topic
Log in to reply
This topic has been deleted. Only users with topic management privileges can see it.
  • D
    D
    Dan6
    wrote on last edited by
    #1

    Hi,

    Have MySql installed and trying to hook up NetXMS.

    Ive tried the create new database option but it cant even grant itself permission to the DB

    Now trying use existing,
    Ive created a user for netxms in MySQL.

    It seems to be able to create a load of tables but always fails on the attached.

    Between every try i am dropping the schema.


    Netxms install.png

    1 Reply Last reply
    0
    • A
      A
      Alex Kirhenshtein
      wrote on last edited by
      #2

      Hello.

      What version of the NetXMS you are installing? This issue was fixed in 2.2.9.

      1 Reply Last reply
      0
      • D
        D
        Dan6
        wrote on last edited by
        #3

        2.2.9

        Now tried sql express 2017 and it cant even login. Haveenable mixed login mode so its not just windows authentification.

        Would be useful to have a guide for this stuff so we know what settings to choose.  Seems to be many posts with same issues.
        Enabled named pipes and tcp in sql express.
        With sql express 2017 you get the message when installing Netxms that a newer version of the SQl client is installed so it doesnt use the one in the netxms installer

        1 Reply Last reply
        0
        • D
          D
          Dan6
          wrote on last edited by
          #4

          Nope, Definatly not fixed in MySQL

          just did a complete reinstall, Created the DB in workbench and assigned the user.

          Still get the error in the pic above.

          1 Reply Last reply
          0
          • Z
            Z
            Tatjana Dubrovica
            wrote on last edited by
            #5

            What version of MySQL are you using? We do not support MySQL 8.

            1 Reply Last reply
            0
            • D
              D
              Dan6
              wrote on last edited by
              #6

              Downloaded the last release of sql and everything went through OK thx.

              1 Reply Last reply
              0

              Hello! It looks like you're interested in this conversation, but you don't have an account yet.

              Getting fed up of having to scroll through the same posts each visit? When you register for an account, you'll always come back to exactly where you were before, and choose to be notified of new replies (either via email, or push notification). You'll also be able to save bookmarks and upvote posts to show your appreciation to other community members.

              With your input, this post could be even better 💗

              Register Login
              Reply
              • Reply as topic
              Log in to reply
              • Oldest to Newest
              • Newest to Oldest
              • Most Votes


              • Login

              • Don't have an account? Register

              • Login or register to search.
              Powered by NodeBB Contributors
              • First post
                Last post
              0
              • Categories
              • Recent
              • Tags
              • Popular
              • Users
              • Groups