http://diymacserver.com/forum/ DIYMacServer » Forum: Everything else - Recent Posts en Wed, 08 Feb 2012 07:02:34 +0000 http://diymacserver.com/forum/topic/1063-snow-leopard-server-serial#post-1240 Sat, 02 Jul 2011 12:01:47 +0000 Richard 1240@http://diymacserver.com/forum/ <p>b0bby, sorry we don't do that sort of stuff here... </p> http://diymacserver.com/forum/topic/1063-snow-leopard-server-serial#post-1239 Thu, 30 Jun 2011 11:37:30 +0000 b0bby 1239@http://diymacserver.com/forum/ <p>hey guys anybody got a working snow leopard server 10.6.3 Serial ??? </p> http://diymacserver.com/forum/topic/nagios-andor-cacti#post-1137 Mon, 13 Jun 2011 17:01:18 +0000 Richard 1137@http://diymacserver.com/forum/ <p>Sorry, I don't have any experience with either of these products. Perhaps someone else can help... </p> http://diymacserver.com/forum/topic/nagios-andor-cacti#post-1038 Sat, 28 May 2011 21:19:10 +0000 ygor 1038@http://diymacserver.com/forum/ <p>Has anyone set up either or both of these monitoring utilities on a Mac ?<br /> My goal is to be able to monitor the bandwidth useage thru my cable modem/Airport Base Station. </p> http://diymacserver.com/forum/topic/problem-with-sqlgrey-and-mysql#post-945 Thu, 07 Apr 2011 21:32:10 +0000 Lindhardsen 945@http://diymacserver.com/forum/ <p>That's really great service. I hope you will be able to find a clue somewhere, as I have ran my forehead against the wall one to many time now! </p> http://diymacserver.com/forum/topic/problem-with-sqlgrey-and-mysql#post-944 Thu, 07 Apr 2011 09:15:49 +0000 Richard 944@http://diymacserver.com/forum/ <p>I'll see if I can reproduce your problem to be able to determine a solution. </p> http://diymacserver.com/forum/topic/problem-with-sqlgrey-and-mysql#post-943 Tue, 05 Apr 2011 20:25:31 +0000 Lindhardsen 943@http://diymacserver.com/forum/ <p>No, Skip-networking is not enabled.<br /> On the other hand, neither is "port", could that be a problem? I guess not, at least not related to this... </p> http://diymacserver.com/forum/topic/problem-with-sqlgrey-and-mysql#post-942 Tue, 05 Apr 2011 18:51:41 +0000 Richard 942@http://diymacserver.com/forum/ <p>Jan did you enable the skip-networking option in MySQL so it can only use the socket for connectivity? </p> http://diymacserver.com/forum/topic/problem-with-sqlgrey-and-mysql#post-941 Mon, 04 Apr 2011 20:24:17 +0000 Lindhardsen 941@http://diymacserver.com/forum/ <p>Hi Richard, thanks for your responses, your help is highly appreciated!</p> <p>I'm running an DIY server, the only thing that is not according to your guides, is the MySQL, which I downloaded and installed of the MySQL website back in October, just before I found your excellent website.<br /> The version is Server version: 5.1.51 MySQL Community Server<br /> the my.cfn is located in /private/etc/my.cnf and the content is:<br /> <pre><code>[client] socket = /var/mysql/mysql.sock [mysqld] socket = /var/mysql/mysql.sock</code></pre> <p>And if I understand you correct, this is the setting that SQLGrey should pick up, just as the rest of the components does correctly. Right?<br /> If I'm to change the connection setting, where should I do that? In my amateur eyes, this all seems just about right... Maybe I'm looking in the wrong place? </p> http://diymacserver.com/forum/topic/problem-with-sqlgrey-and-mysql#post-940 Mon, 04 Apr 2011 19:36:16 +0000 Richard 940@http://diymacserver.com/forum/ <p>After some googling I found that Perl uses the MYSQL config file to determine the connection or socket settings in the config file.</p> <p>Otherwise we need to change the code to make a database connection look like:<br /> DBI-&gt;connect("DBI:mysql:host=localhost:mysql_socket=/tmp/mysql.sock;database=business"... </p> http://diymacserver.com/forum/topic/problem-with-sqlgrey-and-mysql#post-939 Mon, 04 Apr 2011 19:21:32 +0000 Richard 939@http://diymacserver.com/forum/ <p>Also, I forgot, do you have a MYSQL config file in /etc/ called my.cnf </p> http://diymacserver.com/forum/topic/problem-with-sqlgrey-and-mysql#post-938 Mon, 04 Apr 2011 18:59:50 +0000 Richard 938@http://diymacserver.com/forum/ <p>Jan, which version of MySQl have you got installed and are you running a real OSX server or our DIYMacServer? </p> http://diymacserver.com/forum/topic/problem-with-sqlgrey-and-mysql#post-937 Mon, 04 Apr 2011 10:35:47 +0000 Lindhardsen 937@http://diymacserver.com/forum/ <p>Hi!</p> <p>I have a problem that has been keeping me puzzled since I installed my OSX "Server" in October:</p> <p>When I restart my server, postfix cannot connect to Dovecot. This it turns out, is related to that postgrey cannot ponnect to the database.<br /> For some reason, sqlgrey is trying to connect to the socket (I assume) /tmp/mysql.sock!</p> <p>The workaround for this is simple, just create a link from the socket file /private/var/mysql/mysql.sock to /tmp/mysql.sock using:<br /> "ln /private/var/mysql/mysql.sock /tmp/mysql.sock".<br /> The disadvantage of this, is that /tmp is emptied on every restart of the server, so I have to manually run this command after each restart.</p> <p>But WHY is this happening? Looking in my sqlgrey.conf, I have the following connection settings:<br /> db_type = mysql<br /> db_name = sqlgrey<br /> # Note: the following are not used with SQLite<br /> db_host = localhost<br /> db_port = default</p> <p>Which is the same as any other component that uses MySQL on the system, and all other works fine!<br /> I have tried to change the location of the mysql.sock file, but that basically causes all other components to fail :-(</p> <p>Is there a hidden setting in perl (which sqlgrey is built upon), which points to an alternative mysql location?</p> <p>Alternatively how can I prevent OSX from deleting the /tmp/mysql.sock link on shutdown?</p> <p>What I see in my system.log file is this:<br /> Apr 4 10:38:52 Minin com.diymacserver.sqlgrey[357]: dbaccess: can't connect to DB: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)<br /> Apr 4 10:38:52 Minin com.diymacserver.sqlgrey[357]: dbaccess: error: couldn't get now() from DB: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)</p> <p>Best regards,<br /> Jan </p> http://diymacserver.com/forum/topic/spamassassin-error#post-898 Thu, 11 Nov 2010 00:07:11 +0000 dw 898@http://diymacserver.com/forum/ <p>Hmm, I don't know why there would be two perl installations.... although I've tinkered a lot through the years. </p> <p>Thanks, any help would be appreciated. </p> http://diymacserver.com/forum/topic/32-bits-vs-64-bits#post-897 Wed, 10 Nov 2010 19:55:32 +0000 Richard 897@http://diymacserver.com/forum/ <p>If your kernel is not 64 bits you can’t run any 64 bits programs. Sorry…</p> <p>If you have a 64 bit kernel you can run 32 bits programs, but the advantages of running 64 bits are many. Simply said your software will run much faster. We’ve done tests with mysql that show a 20% increase of performance on the same machine.</p> <p>You can switch between both kernels. How? Read: <a href="http://support.apple.com/kb/HT3773" rel="nofollow">http://support.apple.com/kb/HT3773</a> </p> http://diymacserver.com/forum/topic/32-bits-vs-64-bits#post-896 Mon, 08 Nov 2010 21:15:00 +0000 aleks 896@http://diymacserver.com/forum/ <p>Hi, I am considering setting up a server on a C2D Mac mini running SL as described on this site soon. Can anyone explain the pros and cons of compiling everything in 64 bits vs 32 bits, considering the kernel will be 32 bits? I am curious as to the impact on memory usage, disk usage, etc. My initial thoughts are that 32 bits will use less memory, processing, etc. I hope to use this mini as a desktop simultaneously as a server(is this a good idea?). Am I wrong? </p> http://diymacserver.com/forum/topic/spamassassin-error#post-895 Mon, 08 Nov 2010 12:42:11 +0000 Drew 895@http://diymacserver.com/forum/ <p>You have 2 versions or perl installed?<br /> Do you have something like fink installed?</p> <p>It appears that amavisd is finding perl 5.8.8 and trying to use that but SpamAssassin installed in the 5.8.9 version.</p> <p>I am looking for a solution as best I can. </p> http://diymacserver.com/forum/topic/spamassassin-error#post-894 Sat, 06 Nov 2010 18:37:31 +0000 dw 894@http://diymacserver.com/forum/ <p>Thanks, binaries do show up, but here:</p> <p>find / -name SpamAssassin.pm<br /> /opt/local/lib/perl5/site_perl/5.8.9/Mail/SpamAssassin.pm </p> http://diymacserver.com/forum/topic/spamassassin-error#post-893 Sat, 06 Nov 2010 12:45:37 +0000 Drew 893@http://diymacserver.com/forum/ <p>The fist thing I would do is check that it did install the binaries.</p> <p>try finding SpamAssassin.pm with<br /> &gt;find / -name SpamAssassin.pm</p> <p>or you could try typing in "spama" followed by a tab. It should autocomplete to "spamassassin" if it installed in the path. </p> <p>if it doesn't show up i would try using perl to install it from CPAN. perl will claim it is already installed if it is installed correctly. Otherwise it will try to install it again for you.</p> <p>sudo perl -MCPAN -e shell<br /> install Mail::SpamAssassin</p> <p>let me know what happens </p> http://diymacserver.com/forum/topic/spamassassin-error#post-886 Fri, 05 Nov 2010 05:34:28 +0000 dw 886@http://diymacserver.com/forum/ <p>Right, it is not in that folder.</p> <p>I installed SA per your instructions here. I did note that the config files were in</p> <p>/etc/opt/mail/spamassassin/ rather than /etc/mail/spamassassin/</p> <p>... should I just try to reinstall? </p> http://diymacserver.com/forum/topic/spamassassin-error#post-885 Wed, 03 Nov 2010 07:09:02 +0000 Drew 885@http://diymacserver.com/forum/ <p>I take it that SpamAssassin.pm is not in that folder.</p> <p>How did you install SpamAssassin? </p> http://diymacserver.com/forum/topic/spamassassin-error#post-884 Mon, 01 Nov 2010 23:30:39 +0000 dw 884@http://diymacserver.com/forum/ <p>Thanks for the reply Drew,</p> <p>huh, I don't even have a Mail folder in /Library/Perl/5.8.8/ ....<br /> though there is one here:</p> <p>/System/Library/Perl/Extras/5.8.8/Mail </p> http://diymacserver.com/forum/topic/spamassassin-error#post-883 Mon, 01 Nov 2010 06:04:03 +0000 Drew 883@http://diymacserver.com/forum/ <p>Hi dw,<br /> The first thing to do is to check that SpamAssassin.pm exists on your system.</p> <p>In your case it should be located under /Library/Perl/5.8.8/Mail/</p> <p>Can you see if it is there?</p> <p>Drew </p> http://diymacserver.com/forum/topic/spamassassin-error#post-882 Sun, 31 Oct 2010 16:32:23 +0000 dw 882@http://diymacserver.com/forum/ <p>Hi folks, I'm seeing this error in my console:</p> <p>10/31/10 9:30:09 AM org.diymacserver.amavisd[5580] Problem in antispam SA code: Can't locate Mail/SpamAssassin.pm in @INC (@INC contains: /Library/Perl/Updates/5.8.8/darwin-thread-multi-2level /Library/Perl/Updates/5.8.8 /System/Library/Perl/5.8.8/darwin-thread-multi-2level /System/Library/Perl/5.8.8 /Library/Perl/5.8.8/darwin-thread-multi-2level /Library/Perl/5.8.8 /Library/Perl /Network/Library/Perl/5.8.8/darwin-thread-multi-2level /Network/Library/Perl/5.8.8 /Network/Library/Perl /System/Library/Perl/Extras/5.8.8/darwin-thread-multi-2level /System/Library/Perl/Extras/5.8.8 /Library/Perl/5.8.6 /Library/Perl/5.8.1) at (eval 48) line 64.<br /> 10/31/10 9:30:09 AM org.diymacserver.amavisd[5580] BEGIN failed--compilation aborted at (eval 48) line 64.<br /> 10/31/10 9:30:09 AM com.apple.launchd[1] (org.diymacserver.amavisd[5580]) Exited with exit code: 2<br /> 10/31/10 9:30:09 AM com.apple.launchd[1] (org.diymacserver.amavisd) Throttling respawn: Will start in 10 seconds</p> <p>Any clues? ---I'm running this on Leopard.<br /> Thanks,<br /> David </p> http://diymacserver.com/forum/topic/diy-compile-compared-to-macportsfink#post-880 Tue, 05 Oct 2010 08:10:24 +0000 aurora72 880@http://diymacserver.com/forum/ <p>When I first started out to use my 1,83Ghz (64bit) Mac mini as a Unix/Linux machine, I tried MacPorts &amp; Fink. Both of them offered the beginners a suitable way of trying Open Source software on a Mac but they've got some weak points though I appreciate the effort. </p> <p>When I started using MAcports &amp; Fink problems mostly related to ".dylib" started to occur. I remember trying to install CLISP (a Lisp implementation) using Fink and running into referencing problems, i.e. Fink expects to find say, libJPEG.dylib under "/sw", the default place of Fink, while the original script referenced somewhere else. I remember giving up Fink and trying MacPorts to set up a web server (Apache, MySQL, PHP). Because my Mac mini was a 64bit machine, I have instructed the MacPorts to install them as 64bit binaries but I remember stopping at PHP. MacPorts was complaining about a .dylib (it might be libinconv.dylib, or libJpeg.dylib) which was running as 32bits on my machine and that it had to be 64bits, too. Surely enough, MacPorts could not convert to or find the 64bit version of that .dylib by itself. It was forcing me to install only the 32bit version of PHP and I didn't want that. You don't want to depend on MacPorts or Fink when you don't have to. </p>