MAMP Auto Start Servers

LAMP/MAMP/WAMP
#1

I have been having difficulty trying to get MySQL on the MAMP Stack v5.6.30 to auto start. I can get Apache to autostart. Sometimes MySQL will start, then stop, and cycle thru, but it never stays started.

Has anyone else experienced this? Can anyone share a successful method of getting MySQL to auto start? Alternatively, is there a way to simply auto start all MAMP servers at once?

I have been using plist files to accomplish this. I am using Mac OS X 10.11.6. Thanks!

#2

Hi,

You say you used .plist files for autostarting the processes. Could you share your files so we can check what is going wrong? Furthermore, are you able to see which error the service throws when using launchctl?

Best regards,

Javier J. Salmerón

#3

Sure, contents of mysql plist below:

"<?xml version="1.0" encoding="UTF-8"?>

Label com.bitnami.mysql.services ProgramArguments //Applications/mamp/mysql/bin/mysqld_safe --defaults-file=/Applications/mamp/mysql/my.cnf --port=3306 --socket=/Applications/mamp/mysql/tmp/mysql.sock --datadir=/Applications/mamp/mysql/data --log-error=/Applications/mamp/mysql/data/mysqld.log --pid-file=/Applications/mamp/mysql/data/${machine_hostname}.pid UserName asi_adminPreformatted text RunAtLoad 
<key>OnDemand</key>
<false/>
"
#4

Hi @JustAnotherITGuy,

It seems your file differs from the one pointed out on our guide. Did you follow our guide for making components auto-start on OS X? https://docs.bitnami.com/installer/faq/osx-faq/#how-to-start-the-stack-automatically-on-boot

#5

For some reason my plist did not copy thru completely, that is why it looked different. I deleted it and created a new one based on the link you provided but no change. MySql will not start automatically.

#6
<?xml version="1.0" encoding="UTF-8"?> Label ctlscript-mysql ProgramArguments Applications/Mamp/mysql/bin/mysqld_safe --defaults-file=Applications/Mamp/mysql/my.cnf --port=3306 --socket=Applications/Mamp/mysql/tmp/mysql.sock --datadir=Applications/Mamp/mysql/data --log-error=Applications/Mamp/mysql/data/mysqld.log --pid-file=Applications/Mamp/mysql/data/${machine_hostname}.pid RunAtLoad UserName _mysql GroupName _mysql
#7

Hi,

Just wanted to let you know that we reproduced this issue and are looking into it. We’ll get back to you when we have more information.

Best regards,
Marcos

#8

Hi @JustAnotherITGuy,

We have been looking into this issue and have found a plist that works for us. Could you try to apply it?

Before doing anything, please do launchctl unload -w to the plist files you added. After that, create the following .plist files and load them with launchctl load -w:

File: /Library/LaunchDaemons/com.bitnami-mamp.apache.service.plist

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE plist PUBLIC "-//Apple//DTD PLIST 1.0//EN" "http://www.apple.com/DTDs/PropertyList-1.0.dtd">
<plist version="1.0">
    <dict>
        <key>Label</key>
        <string>com.bitnami-mamp.apache</string>
        <key>ProgramArguments</key>
        <array>
            <string>INSTALLDIR/apache2/bin/httpd</string>
            <string>-f</string>
            <string>INSTALLDIR/apache2/conf/httpd.conf</string>
            <string>-DFOREGROUND</string>
        </array>
        <key>RunAtLoad</key>
        <true/>
        <key>UserName</key>
        <string>USERNAME</string>
    </dict>
</plist>

File: /Library/LaunchDaemons/com.bitnami-mamp.mysql.service.plist

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE plist PUBLIC "-//Apple//DTD PLIST 1.0//EN" "http://www.apple.com/DTDs/PropertyList-1.0.dtd">
<plist version="1.0">
    <dict>
        <key>Label</key>
        <string>com.bitnami-mamp.mysql</string>
        <key>ProgramArguments</key>
        <array>
            <string>INSTALLDIR/mysql/bin/mysqld_safe</string>
            <string>--defaults-file=INSTALLDIR/mysql/my.cnf</string>
            <string>--mysqld=mysqld.bin</string>
            <string>--socket=INSTALLDIR/mysql/tmp/mysql.sock</string>
            <string>--datadir=INSTALLDIR/mysql/data</string>
            <string>--log-error=INSTALLDIR/mysql/data/mysqld.log</string>
            <string>--pid-file=INSTALLDIR/mysql/data/mysqld.pid</string>
            <string>--lower-case-table-names=1</string>
        </array>
        <key>RunAtLoad</key>
        <true/>
        <key>UserName</key>
        <string>USERNAME</string>
    </dict>
</plist>

NOTE: Don’t forget to replace all INSTALLDIR and USERNAME placeholders.

I hope it works!

Autostart MAMP Not Working
#9

Hello,

So the new plist you shared for mysql worked! But, the new plist you shared for apache does not. However, I was able to use the previous plist file to start apache and that still works.

#10

Hi,

We are glad that you were able to fix the issue.

If you have any other question and you think we can help, please don’t hesitate to ask.

Best regards,
Silvio Fernández

#11

Hello. So, I am upgrading MAMP 7.1.x installs to later versions, which now uses mariadb, not mysql. I modified the plist to remove mysql and replace with mariadb, but that doesn’t seem enough to auto start mariadb service. Has anyone else ran into this issue? What is the proper syntax in the plist to auto start mariadb with MAMP 7.4.x?

#12

Hello @JustAnotherITGuy,

Could you please open a new case with all the information? Note this case is over 5 years old.

Regards

#13

Does anyone have MAMP 7.4.x or higher with MariaDB starting automatically on MacOS Monterey?

#14

I modified a plist file to try and start MariaDB, it works, but for some reason, the MariaDB service constantly stops and starts itself. If I remove the plist file, I can start MariaDB manually and it stays started. What am I doing incorrectly?

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE plist PUBLIC "-//Apple//DTD PLIST 1.0//EN" "http://www.apple.com/DTDs/PropertyList-1.0.dtd">
<plist version="1.0">
  <dict>
    <key>Label</key> 
  <string>com.bitnami.mariadb.services</string>
    <key>ProgramArguments</key>
    <array>
      <string>/Applications/mamp/ctlscript.sh</string>
      <string>start</string>   
      <string>mariadb</string>
    </array>
    <key>UserName</key>
    <string>root</string>
    <key>RunAtLoad</key>
    <true/>

    <key>OnDemand</key>
    <false/>
  </dict>
</plist>
#15

Hi @JustAnotherITGuy,

Please note that options may have changed since we created the guide. Please take a look at the MariaDB start options in the /Applications/mamp/mariadb/scripts/ctl.sh file and configure the service with those options.

#16

Hello. I did compare to ctl.sh, and it did start the service, BUT, something isn’t right. When I use the plist file to call on ctl.sh to start the service, the mariaDB service constantly stops and restarts itself becoming unusable.

#17

Did you update the plist file with the options we use in the ctl.sh script file? Please note you need to use the same parameters when starting the database when booting the machine. If the ctl.sh script file works, the plist one will also work when using the correct parameters.

#18

I checked the plist file against the ctl.sh file and they are very similar, so I am not sure why this is happening. Again, the service does start, but for whatever reason, it won’t remain started, it gets stuck in a loop of some sort where it starts and stops constantly.

#19

Hi @JustAnotherITGuy,

Can you remove the <false/> flag and check again?

Best regards,
Michiel

#20

Removing the flag prevents the service from auto starting at all. Previously, if I manually stop and start the service, it stays up, if that helps this situation at all. But when it gets start from the plist, it doesn’t want to stay started.