How would I know to use sudo port load/unload mysql55-server?

2013-09-20 Thread Troy S
After installing macports, mysql55, mysql55-server, and all the dependances, I could not figure out how to start/stop the mysql server via the documentation at macports.org. Is the documentation there at macports.org and I had just missed it OR misunderstanding it? If so, please point me

Re: How would I know to use sudo port load/unload mysql55-server?

2013-09-20 Thread Brandon Allbery
installing mysql55-server. I see no message about a startup item. It seems like such a message should appear when installing the port and during port notes. Mrrr. Is the startupitem generated when building the archive, so the message would not show up when installing from an archive? -- brandon s

Re: How would I know to use sudo port load/unload mysql55-server?

2013-09-20 Thread Lawrence Velázquez
On Sep 20, 2013, at 12:18 PM, Jeremy Lavergne jer...@lavergne.gotdns.org wrote: Eh, there's more to it than just the notes: $ port notes mysql55-server mysql55-server has the following notes: If this is a new install you might want to run: $ sudo -u _mysql /opt/local/lib/mysql55/bin

Re: How would I know to use sudo port load/unload mysql55-server?

2013-09-20 Thread Lawrence Velázquez
On Sep 20, 2013, at 11:57 AM, Troy S tdsimp...@gmail.com wrote: After installing macports, mysql55, mysql55-server, and all the dependances, I could not figure out how to start/stop the mysql server via the documentation at macports.org. MacPorts should have printed a message about it when

Re: How would I know to use sudo port load/unload mysql55-server?

2013-09-20 Thread Jeremy Lavergne
Ah, that's why I never saw it then: it's not accessible through notes. On Sep 20, 2013, at 1:05 PM, Lawrence Velázquez wrote: Yes, and MacPorts prints a message to that effect whenever a StartupItem is created, independent of the port's notes. ___

Re: How would I know to use sudo port load/unload mysql55-server?

2013-09-20 Thread Lawrence Velázquez
On Sep 20, 2013, at 1:36 PM, Brandon Allbery allber...@gmail.com wrote: On Fri, Sep 20, 2013 at 1:26 PM, Frank Schima macsforever2...@macports.orgwrote: I'm clearly missing something. Here's my output when installing mysql55-server. I see no message about a startup item. It seems like

Re: How would I know to use sudo port load/unload mysql55-server?

2013-09-20 Thread Jeremy Lavergne
Eh, there's more to it than just the notes: $ port notes mysql55-server mysql55-server has the following notes: If this is a new install you might want to run: $ sudo -u _mysql /opt/local/lib/mysql55/bin/mysql_install_db You need to run `port load...` or `port unload...` to actually start

Re: How would I know to use sudo port load/unload mysql55-server?

2013-09-20 Thread Ryan Schmidt
On Sep 20, 2013, at 14:26, Lawrence Velázquez wrote: On Sep 20, 2013, at 1:36 PM, Brandon Allbery wrote: On Fri, Sep 20, 2013 at 1:26 PM, Frank Schima wrote: I'm clearly missing something. Here's my output when installing mysql55-server. I see no message about a startup item. It seems

Re: How would I know to use sudo port load/unload mysql55-server?

2013-09-20 Thread Frank Schima
is created, independent of the port's notes. I'm clearly missing something. Here's my output when installing mysql55-server. I see no message about a startup item. It seems like such a message should appear when installing the port and during port notes. $ sudo port install mysql55-server

mysql5 should be replaced_by mysql55, mysql56 or mariadb

2013-08-03 Thread Bradley Giesbrecht
It appears many major distributions are switching from mysql to mariadb: Redhat Fedora: http://linux.slashdot.org/story/13/06/14/1225257/red-hat-ditches-mysql-switches-to-mariadb http://fedoraproject.org/wiki/Features/ReplaceMySQLwithMariaDB Slackware and Arch Linux:

Re: mysql5 should be replaced_by mysql55, mysql56 or mariadb

2013-08-03 Thread Jeremy Lavergne
Maria is a drop-in open source replacement for mysql. It also has many features that mysql has avoided adding (for future profit model?). Mysql has already had some gaffs where they're hinting at closing up the source. It's pretty clear mysql is on the way out, but it may not be there yet.

Re: mysql5 should be replaced_by mysql55, mysql56 or mariadb

2013-08-03 Thread Bradley Giesbrecht
The mysql51, mysql55, mysql56, mariadb and percona ports do not conflict so there are no common files, if thats what you meant. I would like MacPorts to have an [un]official default mysql port that ports can depend on or the ports can provide variants or subports for the other mysql's when

Re: mysql5 should be replaced_by mysql55, mysql56 or mariadb

2013-08-03 Thread Jeremy Lavergne
The mysql51, mysql55, mysql56, mariadb and percona ports do not conflict so there are no common files, if thats what you meant. Yup, that's basically what I meant. I would like MacPorts to have an [un]official default mysql port that ports can depend on or the ports can provide variants

Re: mysql5 should be replaced_by mysql55, mysql56 or mariadb

2013-08-03 Thread Craig Treleaven
how that ought to work. Craig At 9:21 AM -0700 8/3/13, Bradley Giesbrecht wrote: The mysql51, mysql55, mysql56, mariadb and percona ports do not conflict so there are no common files, if thats what you meant. I would like MacPorts to have an [un]official default mysql port that ports can

Warning: Error parsing file /opt/local/lib/mysql55/bin/my_print_defaults: Error opening or reading file

2013-06-04 Thread Brad Allison
I get this error now whenever I install anything with macports.. tried uninstalling mysql55... and everything... still get this error... --- Attempting to fetch p7zip-9.20.1_1.darwin_12.x86_64.tbz2 from http://packages.macports.org/p7zip --- Attempting to fetch p7zip-9.20.1_1.darwin_12.x86_64

Re: Warning: Error parsing file /opt/local/lib/mysql55/bin/my_print_defaults: Error opening or reading file

2013-06-04 Thread Ryan Schmidt
On Jun 4, 2013, at 16:51, Brad Allison wrote: I get this error now whenever I install anything with macports.. tried uninstalling mysql55... and everything... still get this error... --- Attempting to fetch p7zip-9.20.1_1.darwin_12.x86_64.tbz2 from http://packages.macports.org/p7zip

mysql55 no longer ships with startup script for MacPorts

2012-05-30 Thread Brad Allison
I used these instructions for installing mysql -- http://matthewcarriere.com/2008/04/02/installing-mysql-on-mac-os-x-leopard-using-macports/ The only thing I changed was mysql5 to mysql55 . sudo port selfupdate sudo port install mysql55 +server When I got to the step to install the startup

Re: mysql55 no longer ships with startup script for MacPorts

2012-05-30 Thread Bjarne D Mathiesen
Brad Allison wrote: What's the difference between mysql55 +server and mysql55-server? mysql55 +server is a variant that means, that you install both the client and the server in one command with /port install mysql55 +server/ mysql55-server is a subport of mysql55 that means that you in fact

Re: mysql55 no longer ships with startup script for MacPorts

2012-05-30 Thread Jeremy Lavergne
mysql55 +server is a variant that means, that you install both the client and the server in one command with /port install mysql55 +server/ mysql55-server is a subport of mysql55 that means that you in fact install 2 ports: mysql55 mysql55-server You can just install /port

Re: mysql55 no longer ships with startup script for MacPorts

2012-05-30 Thread Brad Allison
port install mysql55 +server installs just the server (but without the startup scripts). port install mysql55-server installs just the server. So I don't see why there are both? Neither one installed the client for me and there's no mysql55-client package. :( -b On Wed, May 30, 2012 at 11:48

Re: mysql55 no longer ships with startup script for MacPorts

2012-05-30 Thread Jeremy Lavergne
port install mysql55 +server installs just the server (but without the startup scripts). mysql55 +server does not exist. $ port variants mysql55 mysql55-server mysql55 has the variants: debug: Enable debug binaries openssl: Enable OpenSSL support system_readline: Use system readline

Re: mysql55 no longer ships with startup script for MacPorts

2012-05-30 Thread Brad Allison
So when I installed mysql55 +server I was just getting mysql55 then? In either case there's still no startup scripts... that's the core problem I'm having (other than I have no clue which of these two packages to install). -brad On Wed, May 30, 2012 at 11:56 AM, Jeremy Lavergne jer

Re: mysql55 no longer ships with startup script for MacPorts

2012-05-30 Thread Brad Allison
I ran sudo port install mysql55 and it did not install a client... :( And there's no mysql55-client. So how do you get the mysql client? On Wed, May 30, 2012 at 11:57 AM, Brad Allison brad.alli...@gmail.comwrote: So when I installed mysql55 +server I was just getting mysql55

Re: mysql55 no longer ships with startup script for MacPorts

2012-05-30 Thread Brad Allison
and back to the original point. Still no startup script. : # sudo port load mysql55-server Error: org.macports.load for port mysql55-server returned: Launchd plist /Library/LaunchDaemons/org.macports.mysql55-server.plist was not found Please see the log file for port mysql55-server

Re: mysql55 no longer ships with startup script for MacPorts

2012-05-30 Thread Jeremy Lavergne
and back to the original point. Still no startup script. : There's a script for me. What does your `port contents mysql55-server` show? $ port contents mysql55-server Port mysql55-server contains: /Library/LaunchDaemons/org.macports.mysql55-server.plist /opt/local/etc/LaunchDaemons

Re: mysql55 no longer ships with startup script for MacPorts

2012-05-30 Thread Jeremy Lavergne
I ran sudo port install mysql55 and it did not install a client... :( $ port contents mysql55 | grep bin/ ... /opt/local/lib/mysql55/bin/mysql There's the client. And there's no mysql55-client. So how do you get the mysql client? mysql55 installs the client smime.p7s Description: S

Re: mysql55 no longer ships with startup script for MacPorts

2012-05-30 Thread Brad Allison
But I'm still confused. Which should I be using mysql55-server or mysql? I want both the client and server so I thought mysql55... but does that not come with the startup scripts? -brad On Wed, May 30, 2012 at 12:02 PM, Jeremy Lavergne jer...@lavergne.gotdns.org wrote: and back

Re: mysql55 no longer ships with startup script for MacPorts

2012-05-30 Thread Jeremy Lavergne
But I'm still confused. Which should I be using mysql55-server or mysql? I want both the client and server so I thought mysql55... but does that not come with the startup scripts? Only mysql55-server has the startup scripts, and installs no binaries. Only mysql55 installs binaries, both

Re: mysql55 no longer ships with startup script for MacPorts

2012-05-30 Thread Bjarne D Mathiesen
Brad Allison wrote: port install mysql55 +server installs just the server (but without the startup scripts). port install mysql55-server installs just the server. So I don't see why there are both? Neither one installed the client for me and there's no mysql55-client package. :( /port

Re: mysql55 no longer ships with startup script for MacPorts

2012-05-30 Thread Ryan Schmidt
On May 30, 2012, at 11:08, Bjarne D Mathiesen wrote: after installing mysql55 you'll have to select a version to symlink into ${prefix}/bin as below : You don't *have* to. You *can*, if you want to be able to type mysql and have it do something. (Otherwise, you have to type the full path

Re: mysql55 no longer ships with startup script for MacPorts

2012-05-30 Thread Brad Allison
Works like a champ now! Thanks! # sudo launchctl load -w /Library/LaunchDaemons/org.macports.mysql55-server.plist On Wed, May 30, 2012 at 12:08 PM, Jeremy Lavergne jer...@lavergne.gotdns.org wrote: Ah - now I get it. I need BOTH! :) There we go! Semantics: If you install mysql55

Re: mysql55 no longer ships with startup script for MacPorts

2012-05-30 Thread Bjarne D Mathiesen
Ryan Schmidt wrote: On May 30, 2012, at 11:08, Bjarne D Mathiesen wrote: after installing mysql55 you'll have to select a version to symlink into ${prefix}/bin as below : You don't *have* to. You *can*, if you want to be able to type mysql and have it do something. (Otherwise, you have

Re: mysql55 no longer ships with startup script for MacPorts

2012-05-30 Thread Brandon Allbery
On Wed, May 30, 2012 at 12:21 PM, Bjarne D Mathiesen macint...@mathiesen.info wrote: Ryan Schmidt wrote: On May 30, 2012, at 11:08, Bjarne D Mathiesen wrote: after installing mysql55 you'll have to select a version to symlink into ${prefix}/bin as below : You don't *have* to. You *can

Re: mysql55 no longer ships with startup script for MacPorts

2012-05-30 Thread Bjarne D Mathiesen
to be installed (for their libraries; it could be argued that libraries should be a separate port, but I suspect anyone who does so argue wins the right to redesign the ports to do so...). I've had mysql51 mysql55 installed the servers for both running concurrently when I upgraded from mysql5 - mysql51

Re: mysql55 up and running on production

2012-05-26 Thread Bjarne D Mathiesen
Bjarne D Mathiesen wrote: Some recent changes that pixilla made to the port file breaks a normal install : https://trac.macports.org/ticket/34552 https://trac.macports.org/changeset/93312 To make it work, you have two options : 1) If this is a new install : port install mysql55

Re: mysql55 up and running on production

2012-05-23 Thread Bjarne D Mathiesen
Some recent changes that pixilla made to the port file breaks a normal install : https://trac.macports.org/ticket/34552 https://trac.macports.org/changeset/93312 To make it work, you have two options : 1) If this is a new install : port install mysql55 +system_readline 2) If you've already

Re: mysql55 up and running on production

2012-05-23 Thread Watch Dog
On Wed, May 23, 2012 at 7:35 AM, Bjarne D Mathiesen macint...@mathiesen.info wrote: Some recent changes that pixilla made to the port file breaks a normal install : https://trac.macports.org/ticket/34552 https://trac.macports.org/changeset/93312 Ah, yes, pixilla. Commit w/o testing, again.

Re: mysql55 up and running on production

2012-05-23 Thread Ryan Schmidt
On May 23, 2012, at 10:06, Watch Dog wrote: On Wed, May 23, 2012 at 7:35 AM, Bjarne D Mathiesen wrote: Some recent changes that pixilla made to the port file breaks a normal install : https://trac.macports.org/ticket/34552 https://trac.macports.org/changeset/93312 Ah, yes, pixilla.

Re: mysql55 up and running on production

2012-05-23 Thread Watch Dog
On Wed, May 23, 2012 at 2:58 PM, Ryan Schmidt ryandes...@macports.org wrote: On May 23, 2012, at 10:06, Watch Dog wrote: On Wed, May 23, 2012 at 7:35 AM, Bjarne D Mathiesen wrote: Some recent changes that pixilla made to the port file breaks a normal install :

Re: mysql55 up and running on production

2012-05-23 Thread Jeremy Lavergne
Being a volunteer should not be equated with being unaccountable. MacPorts is actually provided as-is, and its contributors cannot be held liable for anything. smime.p7s Description: S/MIME cryptographic signature ___ macports-users mailing list

Re: mysql55 up and running on production

2012-05-23 Thread Bjarne D Mathiesen
Watch Dog wrote: On Wed, May 23, 2012 at 2:58 PM, Ryan Schmidt ryandes...@macports.org wrote: On May 23, 2012, at 10:06, Watch Dog wrote: On Wed, May 23, 2012 at 7:35 AM, Bjarne D Mathiesen wrote: Some recent changes that pixilla made to the port file breaks a normal install :

Re: mysql55 up and running on production

2012-05-23 Thread Lawrence Velázquez
On May 23, 2012, at 7:39 p.m., Watch Dog wrote: Mistakes are one thing. But this was a change to a working port and the change broke a normal install of the port. So it seems a safe bet that the change was not tested adequately (maybe not at all). According to his comment[1] on the ticket,

Re: mysql55 up and running on production

2012-05-23 Thread Ryan Schmidt
a safe bet that the change was not tested adequately (maybe not at all). Being a volunteer should not be equated with being unaccountable. How to fix: revert until a proper fix is available. Putting such an important port in a broken state is not nice. It should be noted that mysql55 is a new

Re: mysql55 up and running on production

2012-05-23 Thread Watch Dog
in a broken state is not nice. It should be noted that mysql55 is a new port. It did not exist until two months ago. So I do not consider breakage in this port to be a catastrophe at this point. If the build fails for you, then you can simply continue using the previous version that you

Re: mysql55 up and running on production

2012-05-23 Thread Watch Dog
On Wed, May 23, 2012 at 6:13 PM, Bjarne D Mathiesen macint...@mathiesen.info wrote: I do know that many people consider anonymity on the net important - and I do see the value in certain cases - but I can't take a person in this case critizising pixilla and being anonymous seriously. WD ::

Re: mysql55 up and running on production

2012-05-23 Thread Jeremy Lavergne
Whether I use something that looks like a real name is irrelevant. When sending a series of pretentious emails, using an obviously false name just makes reading the messages upsetting. smime.p7s Description: S/MIME cryptographic signature ___

Re: mysql55 up and running on production

2012-05-23 Thread Bjarne D Mathiesen
Watch Dog wrote: On Wed, May 23, 2012 at 6:13 PM, Bjarne D Mathiesen macint...@mathiesen.info wrote: I do know that many people consider anonymity on the net important - and I do see the value in certain cases - but I can't take a person in this case critizising pixilla and being anonymous

Re: mysql55 up and running on production

2012-05-23 Thread Ian Wadham
Watch Dog wrote: But since you insist: T. Chad Gow (google that and cf. above comment) is my name, and I don't recall a time when I liked it. What kid likes having only a 'T' for a first name? It is not an abbreviation for anything, it is just 'T'. As a kid, a friend noted that it is an

mysql55 up and running on production

2012-05-10 Thread Bjarne D Mathiesen
after all my troubles with wrong settings in the mysql55 port, I've finally got it up and running on my production server : http://lists.macosforge.org/pipermail/macports-dev/2012-May/019111.html http://lists.macosforge.org/pipermail/macports-dev/2012-May/019169.html https://trac.macports.org

port select and load/unload was Re: mysql55

2012-04-03 Thread Chris Janton
potentially problematic scenario to consider, if we were to do that, is this: user selects mysql51, user uses your hypothetical port load mysql-server to start mysql51, user selects mysql55. Now mysql51 is still running, and the launchd id corresponding to it is mysql-server, but the launchd

Re: mysql55

2012-04-03 Thread Chris Janton
On 2012-04-02 , at 09:41 , Bradley Giesbrecht wrote: This appears to work. /opt/local/etc/mysql55/my.cnf ... [mysqld] plugin-load = federated=ha_federated.so federated Yes, that works. This works as well from a properly privileged database user mysql -e INSTALL PLUGIN federated

Re: port select and load/unload was Re: mysql55

2012-04-03 Thread Bradley Giesbrecht
or not, but if you think it is, maybe others do too. One potentially problematic scenario to consider, if we were to do that, is this: user selects mysql51, user uses your hypothetical port load mysql-server to start mysql51, user selects mysql55. Now mysql51 is still running, and the launchd id

Re: mysql55

2012-04-02 Thread Bradley Giesbrecht
On Apr 1, 2012, at 10:22 AM, Chris Janton wrote: How do I enable the FEDERATED engine in this case? Something missing in the build that allows it? I do not have any experience with federated tables. Perhaps installing the federated plugin will help. $ port contents mysql55 | grep

Re: mysql55

2012-04-02 Thread Ryan Schmidt
On Apr 1, 2012, at 12:22, Chris Janton wrote: Decided to give mysql55 a go. Switching from mysql5 Everything appeared to work just fine with the build. deactivated mysql5 and mysql5-server (forced due to some dependencies) installed mysql55 and mysql55-server port select mysql

mysql55

2012-04-01 Thread Chris Janton
Decided to give mysql55 a go. Switching from mysql5 Everything appeared to work just fine with the build. deactivated mysql5 and mysql5-server (forced due to some dependencies) installed mysql55 and mysql55-server port select mysql mysql55 mysql won't start due to the following problems, both