Hi Alex. Long time no see. :) Welcome to MacPorts. On Apr 1, 2007, at 17:24, Alex Kac wrote:

I am very comfortable with BSD (specifically OS X Server over the last few years) and maintain my current OS X Server primarily via command line, though I like web admin tools as well because I don't always have SSH access and I prefer to not have my impatient typing kill a server. So for the last few years I've been using iTools from Tenon on my Dual G5 server. We are moving to a new XServe Xeon in the next 2 days and I need to migrate the servers/config to that machine. I do not wish to use the Apple supplied servers because they are usually out of date and don't meet my needs. I do not wish to continue using Tenon's iTools for the same reason. I am comfortable building my own servers from source, but its been so long that I'm not completely aware of all the options and I'd rather not recompile apache 50 times because I forgot something. I was told by a friend who maintains Apple's XServes in their IT team that some of those guys are enamored with MacPorts. So great - here I am :)

Here are the open source servers I run: Apache2 with mod_SSL mod_auth_dbm PHP5 MySQL 5 Subversion SFTP

I would like to add Webmin to the new server since we'd not be using iTools. Right now we have Subversion using svn+ssh access (direct SVN server access), but I'd like to change that to mod_SVN. So add that to the list too :)

So my questions and concerns. With Apache2 we have it use the dbm for all authentication instead of htaccess or OS X accounts. I'd like to move our SFTP over to using the same dbm instead of OS X accounts like it is now. And I definitely want MySQL 5 running as an x64 binary. The rest can run as 32-bit binaries. Of course I'd like to have it all start on startup and run in server mode.

With all that said, any tips on variants/options to use with MacPorts to set this up properly?

Apache and Subversion need apr and apr-util, and will install them for you automatically if needed, but will do so with BerkeleyDB support added. This is not necessary for most people, and on Mac OS X I believe it is not recommended, so I like to omit BDB support on my system. Apache always includes SSL support so no special variant is needed. The apache2 port does install a mod_auth_dbm.so but I've never used it. Does it require BerkeleyDB? If so, then you should forget about the above BerkeleyDB-less recommendations. Subversion includes some nice tools you may want which are not installed by default; use the +tools variant to get them. Couldn't hurt even if you don't need the tools right this second. Use the +server variant for mysql5 to get the launchdaemon plist. Apache is always a server and always includes the plist. php5 has many options selectable through many variants. "port info php5" to see what's available. I haven't had a chance to use an Intel Xserve yet but I assume that anything you compile with MacPorts would end up 64-bit if you're on such an Xserve. If you find that's not the case and that we need to modify the portfiles in some way to make it happen, let us know. I don't have any experience managing an SFTP server so I can't suggest a software package to install. It's been years since I ran Webmin. There doesn't appear to be a webmin port for MacPorts. If you install it manually following their instructions, it may work, depending on what you try to do with it. Here's how I would install the ports you mentioned: sudo -s port install apr-util +no_bdb port install subversion +no_bdb +mod_dav_svn +tools port install mysql5 +server port install php5 +apache2 +mysql5 Then you need to install the initial MySQL databases (or move in a data directory from an old MySQL install). Then you activate the launchdaemon plists for apache2 and mysql5.

Alex - please let me know how you find all the macports installation on the xserve goes for you; I don't have the experience you do, but I've installed the same setups (+ruby) on non-server machines with no problem. However, recently trying to get all of this on the xserve has proven itself to be problematic for me recently. I don't know if it's a permissions problem, or something I've done in my own misunderstanding, but I don't have a solid setup right now. The placement of the mysql.sock being a problem at first, the permissions and ability to write to databases being another. As of right now, mysql is a bit farked in that I DO have databases created and users that can write to these dbs, but the minute that I try to run rails to set up an initial database (I'm trying to setup retrospectiva as a bugtracker) -- it all blows up. I've even tried to mySQL gui tools to add to the db, and they crash too. Apache is running (I get the 'It works!' page), but can't quite get the mod svn working as yet. So, if you do get this all up and running smoothly, I'd really appreciate it if you can hand down the steps to get this going on an Xserve.

I've got a MySQL expert who works with the MySQL consulting folks. I had the same issue and here is what he told me to do and now it works great: ustin2-webis-net:/opt/local/var/db/mysql5 root# ls -la total 40976 drwxr-xr-x 10 mysql mysql 340 Apr 5 21:17 . drwxrwxr-x 4 root admin 136 Apr 5 16:47 .. -rw-r--r-- 2 root mysql 0 Apr 5 16:47 .turd_mysql5 -rw-rw---- 1 mysql mysql 3914 Apr 5 21:17 Austin2-webis- net.local.err -rw-rw---- 1 mysql mysql 5242880 Apr 5 21:17 ib_logfile0 -rw-rw---- 1 mysql mysql 5242880 Apr 5 16:49 ib_logfile1 -rw-rw---- 1 mysql mysql 10485760 Apr 5 20:27 ibdata1 -rw-rw---- 1 mysql mysql 2197 Apr 5 20:52 localhost.err drwx------ 53 root mysql 1802 Apr 5 20:49 mysql drwx------ 2 root mysql 68 Apr 5 20:36 test Austin2-webis-net:/opt/local/var/db/mysql5 root# cd .. Austin2-webis-net:/opt/local/var/db root# chmod -R +x mysql5/ Austin2-webis-net:/opt/local/var/db root# chown -R mysql:mysql mysql5/ Of course, don't use the default my.cnf files - they are all horrible. On Apr 1, 2007, at 8:07 PM, grimmwerks wrote:

Alex - please let me know how you find all the macports installation on the xserve goes for you; I don't have the experience you do, but I've installed the same setups (+ruby) on non-server machines with no problem. However, recently trying to get all of this on the xserve has proven itself to be problematic for me recently.

I don't know if it's a permissions problem, or something I've done in my own misunderstanding, but I don't have a solid setup right now. The placement of the mysql.sock being a problem at first, the permissions and ability to write to databases being another. As of right now, mysql is a bit farked in that I DO have databases created and users that can write to these dbs, but the minute that I try to run rails to set up an initial database (I'm trying to setup retrospectiva as a bugtracker) -- it all blows up. I've even tried to mySQL gui tools to add to the db, and they crash too.

Apache is running (I get the 'It works!' page), but can't quite get the mod svn working as yet.

So, if you do get this all up and running smoothly, I'd really appreciate it if you can hand down the steps to get this going on an Xserve.

Alex Kac - President and Founder Web Information Solutions, Inc. - Microsoft Certified Partner "The optimist proclaims that we live in the best of all possible worlds; and the pessimist fears this is true." -- James Clabell

It didn't. No biggie. Its probably not as well tested on OS X anyway. Just spent the last hour compiling and installing perl modules for some our custom junk. Argh. I hate perl. On Apr 5, 2007, at 11:24 PM, Ryan Schmidt wrote:

On Apr 1, 2007, at 19:13, Alex Kac wrote:

...

...

I haven't had a chance to use an Intel Xserve yet but I assume that anything you compile with MacPorts would end up 64-bit if you're on such an Xserve. If you find that's not the case and that we need to modify the portfiles in some way to make it happen, let us know.

Interesting :) Does anyone on this list have experience with this? OS X Tiger on the XServe (Quad core Xeons) supports 64-bit server processes such as MySQL 64-bit, but its not a 64-bit OS per se. I know Leopard comes with 64-bit Apache/MySQL.

Have you been able to test your mysql yet to see if it's 64-bit? I found this document describing how to get mysql to compile 64-bit (on PowerPC):

http://www.afp548.com/article.php?story=20050705130841426

That would imply that it doesn't automatically build 64-bit.

Alex Kac - President and Founder Web Information Solutions, Inc. - Microsoft Certified Partner "You cannot build a reputation on what you intend to do." -- Liz Smith

Well I'm not sure. I can say that I have my server up in production now (http://www.webis.net) and my biggest issue is LDAP authentication in Apache2 - still learning that. But otherwise everything seems to be working dandy. MySQL did not work for me either at first, but I simply had to start it under the right permissions. Then it was swell :) On Apr 7, 2007, at 11:28 PM, grimm@grimmwerks.com wrote:

I could really still use some help with mysql5 on Tiger server; no matter what I do I get:

ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/opt/local/var/run/mysql5/mysqld.sock' (38)

I've tried setting it in the my.cnf, touching the actual file at /opt/local/var/run/mysql5/mysqld.sock

Anybody? This is driving me insane.

Thanks much.

Alex Kac - President and Founder Web Information Solutions, Inc. - Microsoft Certified Partner "The person who is not hungry says that the coconut has a hard shell." -- African Tribal Saying

Thanks Paul, but I've googled my arse off, and have tried what others have recommended: - setting the socket in my.cnf - touching where the mysqld.sock should be, creating the file and making permissions 775 I've rebooted, restarted, etc. I've not had this problem on a non Tiger Server machine, but on this xserve, it's totally flaky. I'll re-install mysql5 according to someone else's setup, but I really need to know the correct steps for OSX Server -- there's something going on there.

-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1

On Apr 7, 2007, at 9:28 PM, grimm@grimmwerks.com wrote:

...

I could really still use some help with mysql5 on Tiger server; no matter what I do I get:

ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/opt/local/var/run/mysql5/mysqld.sock' (38)

I've tried setting it in the my.cnf, touching the actual file at /opt/local/var/run/mysql5/mysqld.sock

Anybody? This is driving me insane.

Thanks much.

This is a pretty common mysql problem, not so much to do with MacPorts: some different approaches here.

http://www.google.com/search?q=ERROR+2002+% 28HY000&ie=utf-8&oe=utf-8&aq=t&rls=org.mozilla:en- US:official&client=firefox-a

- -- Paul Beard contact info: www.paulbeard.org/paulbeard.vcf pictures: http://www.flickr.com/photos/pdb206/ Are you trying to win an argument or solve a problem?

-----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.7 (Darwin)

iD8DBQFGGIXYfHLPwpj1/JQRAoD2AJ9oacN1G+kCgx19R6niciNSsox1jQCeKG2w E5rCkx7+a3Oi2hm8EKvZec4= =tz38 -----END PGP SIGNATURE----- _______________________________________________ macports-users mailing list macports-users@lists.macosforge.org http://lists.macosforge.org/mailman/listinfo/macports-users

On Apr 8, 2007, at 2:23 PM, Altoine Barker wrote:

-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1

Alright let me see if I can help. I will first need to know your setup (i.e. mac os x server version, macports version, mysql version(s), and exact installation steps up and until the point that you received your errors). Here are some points to look at to try to find your problem blindly. I do not know if you installed your Mac OS X Server with MySQL, but you should make sure that you have no MySQL Server instances running before installyin/upgrading MySQL. Run this command:

mysqladmin shutdown

Well, Tiger server comes with mysql4; I've reinstalled the Tiger server disks and also made sure that that is not running (subversion is the name of the machine):

subversion:~ admin$ mysqladmin shutdown mysqladmin: connect to server at 'localhost' failed error: 'Can't connect to local MySQL server through socket '/var/ mysql/mysql.sock' (2)' Check that mysqld is running and that the socket: '/var/mysql/ mysql.sock' exists! subversion:~ admin$ mysqladmin5 shutdown mysqladmin5: connect to server at 'localhost' failed error: 'Can't connect to local MySQL server through socket '/opt/ local/var/run/mysql5/mysqld.sock' (38)' Check that mysqld is running and that the socket: '/opt/local/var/ run/mysql5/mysqld.sock' exists! subversion:~ admin$ subversion:~ admin$ which mysql /usr/bin/mysql subversion:~ admin$ which mysql5 /opt/local/bin/mysql5 subversion:~ admin$

I've done 'top' and see no mysql5 running.

subversion:~ admin$ sudo killall mysql Password: No matching processes were found subversion:~ admin$ sudo killall mysql5 No matching processes were found subversion:~ admin$

Then install/upgrade mysql. I think this is the reason for the mysql.sock error message. HTH

- -Altoine

grimm@grimmwerks.com wrote:

...

Thanks Paul, but I've googled my arse off, and have tried what others have recommended:

- setting the socket in my.cnf - touching where the mysqld.sock should be, creating the file and making permissions 775

I've rebooted, restarted, etc. I've not had this problem on a non Tiger Server machine, but on this xserve, it's totally flaky.

I'll re-install mysql5 according to someone else's setup, but I really need to know the correct steps for OSX Server -- there's something going on there.

On Apr 7, 2007, at 9:28 PM, grimm@grimmwerks.com wrote:

...

...

...

I could really still use some help with mysql5 on Tiger server; no matter what I do I get:

ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/opt/local/var/run/mysql5/mysqld.sock' (38)

I've tried setting it in the my.cnf, touching the actual file at /opt/local/var/run/mysql5/mysqld.sock

Anybody? This is driving me insane.

Thanks much. -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.5 (Darwin) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org

iD8DBQFGGTMWS0foIafBdlkRAmXIAJ49td4d2A4E0SS3d+bbQkv5RKvAngCeI3Xx 8p/s20fG2EipLJP9QRq5TOc= =ODVP -----END PGP SIGNATURE----- _______________________________________________ macports-users mailing list macports-users@lists.macosforge.org http://lists.macosforge.org/mailman/listinfo/macports-users

True, if my server was solely for DB. But I run a small shop so one quad xeon runs everything :) So 32 bit for now isn't too bad. The only major reason I'd want 64-bit is due to the extra registers on EMT64. On Apr 10, 2007, at 1:51 AM, Ryan Schmidt wrote:

On Apr 5, 2007, at 23:54, Alex Kac wrote:

...

On Apr 5, 2007, at 11:24 PM, Ryan Schmidt wrote:

...

Have you been able to test your mysql yet to see if it's 64-bit? I found this document describing how to get mysql to compile 64- bit (on PowerPC):

http://www.afp548.com/article.php?story=20050705130841426

That would imply that it doesn't automatically build 64-bit.

It didn't. No biggie. Its probably not as well tested on OS X anyway.

I had thought that MySQL AB distributed 64-bit binaries, but I see now that it's only for 64-bit PowerPC, not for 64-bit Intel.

It might yet be possible to adapt the instructions in the article above to build MySQL (and ncurses) 64-bit on Intel but you're probably right that not many have tried this yet and you might risk the stability of the server. Still, it would be nice to be able to use all your memory...

Alex Kac - President and Founder Web Information Solutions, Inc. - Microsoft Certified Partner