• Categories
  • Recent
  • Tags
  • Popular
  • Users
  • Search
  • Register
  • Login
Netgate Discussion Forum
  • Categories
  • Recent
  • Tags
  • Popular
  • Users
  • Search
  • Register
  • Login

WARNING: failed to start mysql

Scheduled Pinned Locked Moved General pfSense Questions
7 Posts 2 Posters 1.1k Views
Loading More Posts
  • 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.
  • A
    ahmetakkaya
    last edited by May 22, 2020, 10:09 PM

    [2.4.5-RELEASE][admin@pfSense.localdomain]/root: /usr/local/etc/rc.d/mysql-server.sh start
    Starting mysql.
    Bad -c option
    /usr/local/etc/rc.d/mysql-server.sh: WARNING: failed to start mysql

    I'm getting an error, can you help me?

    1 Reply Last reply Reply Quote 0
    • G
      Gertjan
      last edited by May 23, 2020, 8:18 AM

      Hi,

      Need to tell us more.

      [2.4.5-RELEASE][admin@pfsense.my-domainl.net]/root: /usr/local/etc/rc.d/mysql-server.sh start
      /usr/local/etc/rc.d/mysql-server.sh: Command not found.
      

      As you might know :
      mysql-server isn't a pfSense package,
      pfSense is based of FreeBSD,
      It's true, some native FreeBSD packages can be installed on pfSense, like 'nano'. These are always packages with a small file foot print, and few dependencies. mysql-server has a big (no : huge) file foot print - a lot of files are places all over the file system.
      And guess what : the pfSense file system doesn't follow native FreeBSD file system. There are differences.

      What mysql-server version you installed ? It matches the kernel version number that your pfSense is using ? Like FreeBSD 11.3.

      Again, true, it can be done.
      It's like installing WordPress, Postfix, Apache2, Halo3 or CounterStrike on pfSense : it's not in the manual. So you'll be on your own.
      Because pfSense is a firewall. Not some 'server' device. A firewall is a security device. nOn secure services don't belong on a firewall.

      @ahmetakkaya said in WARNING: failed to start mysql:

      Bad -c option

      I checked some mysql-server startup command line option, and couldn't find anything about a "-c" option. That is : Google doesn't know about it. Great. You just defeated the 230 Yotta bytes of Google data index.

      The error description was :

      @ahmetakkaya said in WARNING: failed to start mysql:

      I'm getting an error

      So I end with the beginning : tell us more.

      Btw : I had mysql-server running on pfSense ones, years ago. Ancient forum thread talk about the subject, installing mysql-server.
      But every update was a hassle. Had to redo the mysql setup nearly every time a pfSense update came out. I finally created a dedicated server device on my network with the needed functionalities. VM's are just great for this.

      No "help me" PM's please. Use the forum, the community will thank you.
      Edit : and where are the logs ??

      1 Reply Last reply Reply Quote 0
      • A
        ahmetakkaya
        last edited by May 23, 2020, 8:38 AM

        clean installation done same for pfsense mysql57 version and mysql80

        I made a new installation, not an update

        my problem is mysql after installation. mysql does not open before sudden eletric interruption.

        I installed it many times and tried this scenario shock power outage

        mysql not working also in sudden shutdown help?

        1 Reply Last reply Reply Quote 0
        • G
          Gertjan
          last edited by May 23, 2020, 8:51 AM

          @ahmetakkaya said in WARNING: failed to start mysql:

          before sudden eletric interruption

          ??
          mysql is the absolute winner in "who has the most files open at any moment" without contest.
          A mysql-server is always run on a device with secured power supply, so a guaranteed clean power down is initiated when needed.
          If the mysql-server data files gets broken - file system errors - you'll be in for a very hard time.
          Ripping out the power on a mysql-server system is like throwing sand into the gas tank of your car.

          @ahmetakkaya said in WARNING: failed to start mysql:

          my problem is mysql after installation. mysql does not open before sudden eletric interruption.

          It will not open after a sudden eletric interruption, neither.

          Use an UPS and power problems are solved.

          No "help me" PM's please. Use the forum, the community will thank you.
          Edit : and where are the logs ??

          1 Reply Last reply Reply Quote 0
          • A
            ahmetakkaya
            last edited by May 23, 2020, 8:57 AM

            frustrated pfsense mysql for all

            Too bad to be so sensitive

            I used a different router, firewall (mikrotik). I did not have a problem even if there was no electricity cut

            I cannot afford additional charges for ups.

            1 Reply Last reply Reply Quote 0
            • G
              Gertjan
              last edited by May 23, 2020, 10:59 AM

              @ahmetakkaya said in WARNING: failed to start mysql:

              frustrated pfsense mysql for all
              Too bad to be so sensitive

              Power issues are hardware issues.
              You afforded yourself a - hardware - device (and settings like enabling writing cache, or not, etc) that's more susceptible to have file system issues.
              Others (could have) solution have less power issues.

              @ahmetakkaya said in WARNING: failed to start mysql:

              I did not have a problem even if there was no electricity cut

              Re read yourself please.

              You said : when you do not have a power cut, you do not have problems.

              That logic : if everything works then .... yes ... all is well.

              Btw : all this has nothing to do with installing and maintaining a mysql-server.

              @ahmetakkaya said in WARNING: failed to start mysql:

              I cannot afford additional charges for ups.

              An UPS is just advisable. You do not have to have one.
              If you can guarantee that no one is ripping out the power, you'll be fine.
              Consider also the ZFS filesystem, which is more resilient to file system problems.

              No "help me" PM's please. Use the forum, the community will thank you.
              Edit : and where are the logs ??

              1 Reply Last reply Reply Quote 1
              • A
                ahmetakkaya
                last edited by ahmetakkaya May 23, 2020, 11:03 AM May 23, 2020, 11:03 AM

                I installed in ZFS pfsense test environment

                I'm still trying, working for now, I continue sudden closings

                I will install on the real system when I get results

                1 Reply Last reply Reply Quote 0
                1 out of 7
                • First post
                  7/7
                  Last post
                Copyright 2025 Rubicon Communications LLC (Netgate). All rights reserved.
                  This community forum collects and processes your personal information.
                  consent.not_received