DIYMacServer » Tag: MySQL

DIYMacServer » Tag: MySQL - Recent Topics http://diymacserver.com/forum/ DIYMacServer » Tag: MySQL - Recent Topics en Wed, 08 Feb 2012 06:32:30 +0000 Lindhardsen on "Problem with SQLGrey and MySQL" 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/ Hi! I have a problem that has been keeping me puzzled since I installed my OSX "Server" in October: When I restart my server, postfix cannot connect to Dovecot. This it turns out, is related to that postgrey cannot ponnect to the database. For some reason, sqlgrey is trying to connect to the socket (I assume) /tmp/mysql.sock! The workaround for this is simple, just create a link from the socket file /private/var/mysql/mysql.sock to /tmp/mysql.sock using: "ln /private/var/mysql/mysql.sock /tmp/mysql.sock". 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. But WHY is this happening? Looking in my sqlgrey.conf, I have the following connection settings: db_type = mysql db_name = sqlgrey # Note: the following are not used with SQLite db_host = localhost db_port = default Which is the same as any other component that uses MySQL on the system, and all other works fine! I have tried to change the location of the mysql.sock file, but that basically causes all other components to fail :-( Is there a hidden setting in perl (which sqlgrey is built upon), which points to an alternative mysql location? Alternatively how can I prevent OSX from deleting the /tmp/mysql.sock link on shutdown? What I see in my system.log file is this: 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) 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) Best regards, Jan robcd on "10.6.5 -> 10.6.7 breaks postfix setup (with fix)" http://diymacserver.com/forum/topic/1065-1067-breaks-postfix-setup-with-fix#post-935 Tue, 22 Mar 2011 17:07:32 +0000 robcd 935@http://diymacserver.com/forum/ Dear Postfix forum, After upgrading my Mac OS X client, I got the following error message: ... postfix/smtpd[526]: fatal: unsupported dictionary type: mysql I noticed that the /usr/libexec/postfix/smtpd executable had been changed, together with who knows what else in that directory. So I restored the old one, only to get a similar error message from the trivial-rewrite executable (in the same directory). So I restored that as well, followed by the cleanup one, and then all is well again. So a couple of questions: * What should I do to fix things properly? * How can I avoid having to do this next time I upgrade the OS? Thanks and best regards, Rob PS Setup has otherwise worked great - many thanks! Fred Turner on "Postfix "Can't connect to MySQL server"" http://diymacserver.com/forum/topic/postfix-cant-connect-to-mysql-server#post-816 Tue, 11 May 2010 17:40:55 +0000 Fred Turner 816@http://diymacserver.com/forum/ Had everything pretty close to running, aside from the "createmaildir" script not working, but after a reboot of the server, I get this over and over in the logs: postfix/trivial-rewrite[809]: warning: connect to mysql server 127.0.0.1: Can't connect to MySQL server on '127.0.0.1' (61) postfix/trivial-rewrite[809]: fatal: mysql:/etc/postfix/mysql_virtual_alias_maps.cf(0,lock|fold_fix): table lookup problem postfix/smtpd[479]: warning: problem talking to service rewrite: Unknown error: 0 postfix/master[31]: warning: process /usr/libexec/postfix/trivial-rewrite pid 809 exit status 1 postfix/master[31]: warning: /usr/libexec/postfix/trivial-rewrite: bad command startup -- throttling Any idea why it can't connect? I'm assuming that the "table lookup problem" is simply the first mysql lookup that postfix does, and since it is unable to connect, that fails w/ the "lookup problem"...right? I manually ran mysql and connected as user "postfix" w/o issue. Thx, Fred zerustech on "Compile Apache+MySQL+php on Snow Leopard" http://diymacserver.com/forum/topic/compile-apachemysqlphp-on-snow-leopard#post-716 Sun, 27 Sep 2009 06:40:01 +0000 zerustech 716@http://diymacserver.com/forum/ Hi Guys, I was trying to compile Apache+MySQL+PHP on Snow Leopard according to the instructions on this website, but unfortunately none of them worked. I tried different solutions and finally succeeded. So I'm just posting the instructions here and hopefully it will be helpful to you. 1. First of all, you should download apache 2.2.13 (the apxs in its previous releases does not work) 2. Install xcode from Snow Leopard installation DVD (I guess you have already installed) 3. Install MacPorts and the following port libs: - zlib - curl - xsl - gd - openjpeg - libpng - freetype - xpm - exif - libiconv 4. Compile MySQL (5.1.39) as follows: #!/bin/sh MYSQLVERSION="5.1.39" MYSQLDIR="/opt/mysql/$MYSQLVERSION" make distclean ./configure \ --prefix=$MYSQLDIR \ --with-server-suffix=--standard \ --enable-thread-safe-client \ --enable-local-infile \ --enable-shared \ --with-zlib-dir=bundled \ --with-big-tables \ --with-readline \ --with-plugins=all \ --with-mysqld-user=mysql \ --with-extra-charsets=all \ --with-unix-socket-path=$MYSQLDIR/var/mysql.sock \ --without-docs make make install 5. Compile Apache (2.2.13) as follows: #!/bin/sh APACHEVERSION="2.2.13" APACHEDIR="/opt/apache/$APACHEVERSION" make distclean ./configure -prefix=$APACHEDIR \ -enable-mods-shared=all \ -with-ssl \ -with-mpm=prefork \ -disable-unique-id \ -enable-ssl \ -enable-dav \ -enable-cache \ -enable-proxy \ -enable-logio \ -enable-deflate \ -with-included-apr \ -enable-cgi \ -enable-cgid \ -enable-suexec 6. Compile PHP (4.4.9 or 5.3.0) as follows: #!/bin/sh PHPVERSION=4.4.9 MYSQLVERSION=5.1.39 APACHEVERSION=2.2.13 BUILDTAG=$PHPVERSION.mysql.$MYSQLVERSION PHPDIR=/opt/php/$BUILDTAG MYSQLDIR=/opt/mysql/$MYSQLVERSION make distclean ./configure \ --prefix=$PHPDIR \ --with-apxs2=/opt/apache/$APACHEVERSION/bin/apxs \ --with-config-file-path=$PHPDIR/etc \ --with-mysql=$MYSQLDIR \ --with-mysqli=$MYSQLDIR/bin/mysql_config \ --with-pdo-mysql=$MYSQLDIR \ --with-zlib=/opt/local \ --with-curl=/opt/local \ --with-mcrypt=/opt/local \ --with-xsl=/opt/local \ --with-gd=/opt/local \ --with-jpeg-dir=/opt/local \ --with-png-dir=/opt/local \ --with-zlib-dir=/opt/local \ --with-xpm-dir=/opt/local \ --with-freetype-dir=/opt/local \ --with-iconv=/opt/local \ --enable-mbstring \ --enable-exif \ --enable-cli \ --enable-pcntl \ --enable-sockets \ --enable-ftp \ --enable-soap export EXTRA_CFLAGS="-lresolv" make make install papa lozarou on "Optimising a server" http://diymacserver.com/forum/topic/optimising-a-server#post-560 Mon, 22 Sep 2008 14:18:08 +0000 papa lozarou 560@http://diymacserver.com/forum/ Hi I'm running a mac mini, which Richard kindly helped me get a mail server on. The only think other than that I run is a web forum for football supporters. I'm having real problems with the mysql/apache load. Basically the server slows to a crawl on lunchtimes. I've got about 1.5k users, which can balloon up to 2.5k if something big hits the news. Average hits per day is somewhere between 50k and 90k (again if there's some big story). Does anyone have any ideas? When I look at top I'm seeing MySQL sometimes at 150% plus of CPU processes, and the CPU itself maxed out between User and System with no idle. Also the average CPU load seems to be 2.5 plus. All these things aren't supposed to be I'm pretty sure, but I am unsure if it's a software issue or a hardware one. The forum software I run is phpbb3. Any ideas? jstubbs on "Still need to recompile MySQL" http://diymacserver.com/forum/topic/still-need-to-recompile-mysql#post-554 Mon, 08 Sep 2008 18:25:23 +0000 jstubbs 554@http://diymacserver.com/forum/ Richard, My old G3 finally gave the ghost. Got my hands on a G4, installed 10.5, downloaded the 5.0.67 ppc package (32 bit) of mysql. I unpacked it and was poking around. I noticed that there are shared libraries inside of lib. Still need to recompile the source code? Jeff eulipion2 on "MySQL recompile problems" http://diymacserver.com/forum/topic/mysql-recompile-problems#post-319 Tue, 20 Feb 2007 23:37:32 +0000 eulipion2 319@http://diymacserver.com/forum/ Hello all, Bit of a newbie here. I've installed MySQL via the .dmg for my Powerbook G4 (OS 10.4.8, most recent system updates, Developer Tools 2.4, not 2.4.1), but when I try to recompile with shared libraries I keep getting a lot of make errors. 1.) is there a log of the make procedure so I can find and post the errors? 2.) are the directions on the "Compiling MySQL" page accurate? I'm following the ppc directions exactly. 3.) does it matter that the .dmg file is version 5.0.27 while the source is 5.0.33? Is there anything I need to do differently because of this? taylor1111 on "Database Error : Connection Failed" http://diymacserver.com/forum/topic/database-error-connection-failed#post-486 Wed, 04 Jun 2008 04:12:16 +0000 taylor1111 486@http://diymacserver.com/forum/ I followed your documentation word for word, but did not want to upgrade MySQL from 4.1.22 I have even tried hosting the MySQL database on a different server using version 5.0 and it still prompted me with the same error. Are there any suggestions, I would love to see RoundCube in action, but I am on my last nerves trying to get the install running properly. Thanks or all the help. Rimas on "Can't connect to MySQL server on '127.0.0.1' (61)" http://diymacserver.com/forum/topic/cant-connect-to-mysql-server-on-127001-61#post-446 Wed, 12 Mar 2008 21:51:41 +0000 Rimas 446@http://diymacserver.com/forum/ Hi! What an excellent source of information this web site is...!!! I got MySQL, Apache and PHP all successfully working. However, I am struggling to get even a basic mail server up and running. After building, installing, configuring and starting all of the required pieces, I find that I am unable to send or receive e-mail. Looking in /var/log/mail.log I see the same pattern of messages repreated every 60 seconds or so: <code> Mar 12 16:00:10 MacMiniServer postfix/trivial-rewrite[584]: warning: connect to mysql server 127.0.0.1: Can't connect to MySQL server on '127.0.0.1' (61) Mar 12 16:00:10 MacMiniServer postfix/trivial-rewrite[584]: fatal: mysql:/etc/postfix/mysql_virtual_alias_maps.cf(0,lock|fold_fix): table lookup problem Mar 12 16:00:11 MacMiniServer postfix/smtpd[488]: warning: problem talking to service rewrite: Unknown error: 0 Mar 12 16:00:11 MacMiniServer postfix/smtpd[347]: warning: problem talking to service rewrite: Unknown error: 0 Mar 12 16:00:11 MacMiniServer postfix/master[286]: warning: process /usr/libexec/postfix/trivial-rewrite pid 584 exit status 1 Mar 12 16:00:11 MacMiniServer postfix/master[286]: warning: /usr/libexec/postfix/trivial-rewrite: bad command startup -- throttling </code> I am able to connect to MySQL from a cmd line: <code> MacMiniServer:~ Rimas$ mysql --user=Rimas --password=******** Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 67 Server version: 5.0.51a-standard-log Source distribution Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql> use mysql Database changed mysql> select host, user, password, select_priv from user; +---------------------+-----------+-------------------------------------------+-------------+ | host | user | password | select_priv | +---------------------+-----------+-------------------------------------------+-------------+ | localhost | Rimas | *972D8E7C521419D7E52E96B357E80789D622948D | Y | | MacMiniServer.local | Rimas | *972D8E7C521419D7E52E96B357E80789D622948D | Y | | 127.0.0.1 | Rimas | *972D8E7C521419D7E52E96B357E80789D622948D | Y | | localhost | mailsrvr | *972D8E7C521419D7E52E96B357E80789D622948D | N | | localhost | mailadmin | *972D8E7C521419D7E52E96B357E80789D622948D | N | +---------------------+-----------+-------------------------------------------+-------------+ 5 rows in set (0.00 sec) mysql> select host, db, user, select_priv from db; +-----------+---------+-----------+-------------+ | host | db | user | select_priv | +-----------+---------+-----------+-------------+ | localhost | postfix | mailsrvr | Y | | localhost | postfix | mailadmin | Y | +-----------+---------+-----------+-------------+ 2 rows in set (0.00 sec) mysql> exit </code> Just to make sure it was a problem connecting to MySQL, I edited /etc/postfix/main.cf and changed <code> virtual_alias_maps = mysql:/etc/postfix/mysql_virtual_alias_maps.cf </code> to <code> virtual_alias_maps = ********.org </code> and after restarting Postfix the can't connect to MySQL error moved to the next item (i.e. mysql_virtual_domains_maps.cf). If it helps, my mysql_virtual_domains_maps.cf looks like this: <code> MacMiniServer:~ Rimas$ cat /etc/postfix/mysql_virtual_alias_maps.cf user = mailsrvr password = ******** hosts = 127.0.0.1 dbname = postfix query = SELECT goto FROM alias WHERE address='%s' AND active = 1 MacMiniServer:~ Rimas$ </code> I have tried changing user = mailsrvr to user = Rimas, and also hosts = 127.0.0.1 to hosts = localhost but to no avail. At this point I feel like I am kinda stuck and am hoping that I am just missing something really obvious. Thanks, Rimas nerdcoder on "courier-authlib-0.60.2: error in mail.log: Symbol not found: _auth_mysql" http://diymacserver.com/forum/topic/courier-authlib-0602-error-in-maillog-symbol-not-found-_auth_mysql#post-424 Thu, 29 Nov 2007 02:45:57 +0000 nerdcoder 424@http://diymacserver.com/forum/ After compiling everything succesfully on Mac OS X Leopard (10.5) I get this error in the mail.log when starting authdaemond: <pre><code>Nov 29 03:23:05 XXX authdaemond[88436]: dlopen(/XXX/lib/courier- authlib/libauthmysql.0.so, 9): Symbol not found: _auth_mysql</code></pre> Everything seems to compile nicely. It even knows where to find the compiled mysql - I tried to move it and I got another error. I have now tried with mysql's own precompiled Mac tarball. Besides that I have tried a variety of configurations and compile methods. This is one of them (I have tried compiling with servers to and without any special CFLAGS or other stuff: <pre><code>CC=gcc CFLAGS=\"-O3 -fno-omit-frame-pointer\" CXX=gcc CXXFLAGS=\"-O3 -fno- omit-frame-pointer -felide-constructors -fno-exceptions -fno-rtti\" ./ configure --prefix=/XXX --with-extra-charsets=complex --enable-thread- safe-client --enable-shared --without-server make sudo make install</code></pre> This seems to work for courier-authlib: <pre><code>CC=\"\" CXX=\"\" CXXFLAGS=\"\" CFLAGS=\"-arch i386\" ./configure --with-authmysql --without-authpam -- with-mysql-libs=/XXX/lib/mysql --with-mysql-includes=/XXX/include/ mysql --with-mailuser=_postfix --with-mailgroup=_postfix --prefix=/XXX make sudo make install</code></pre> I have set up the authdaemonrc and authmysqlrc just as they are on a working server I have + the new setup connects to the already running and working mysql db. Any idea what is going on? Thanks! Dan Larsen P.S: I even tested 0.60.1 and 0.60.0 Keeya on "/usr/local/virtual empty & mysql connect" http://diymacserver.com/forum/topic/usrlocalvirtual-empty-038-mysql-connect#post-384 Fri, 01 Jun 2007 05:34:28 +0000 Keeya 384@http://diymacserver.com/forum/ Following up on earlier emails... Tried going through and resetting everything-- deleted the user rows from mysql and redid the config files/usernames/passwords. Still not working-- not seeing anything added to /usr/local/virtual/, though domains and mailboxes appear as records in mysql. mail.log errors look like: ... postfix/trivial-rewrite[17976]: warning: connect to mysql server 127.0.0.1: Can't connect to MySQL server on '127.0.0.1' (61) postfix/trivial-rewrite[17976]: fatal: mysql:/etc/postfix/mysql_virtual_alias_maps.cf(0,lock|fold_fix): table lookup problem postfix/smtpd[17955]: warning: problem talking to service rewrite: Unknown error: 0 postfix/master[17934]: warning: process /usr/libexec/postfix/trivial-rewrite pid 17976 exit status 1 postfix/cleanup[17964]: warning: connect to mysql server 127.0.0.1: Can't connect to MySQL server on '127.0.0.1' (61) postfix/cleanup[17964]: warning: D24877562A: virtual_alias_maps map lookup problem for <a href="mailto:test@email.com">test@email.com</a> postfix/trivial-rewrite[17977]: warning: connect to mysql server 127.0.0.1: Can't connect to MySQL server on '127.0.0.1' (61) postfix/trivial-rewrite[17977]: fatal: mysql:/etc/postfix/mysql_virtual_alias_maps.cf(0,lock|fold_fix): table lookup problem postfix/pickup[17942]: 1EFF875630: uid=501 from=<my_username> postfix/smtpd[17955]: warning: problem talking to service rewrite: Unknown error: 0 ... I tried sending an email to the box I created as suggested (see the pickup line in the). Anything else you'd advise? Thanks again, --Keeya PeterZwarich on "configure:error mysql-5.0.37" http://diymacserver.com/forum/topic/configureerror-mysql-5037#post-345 Mon, 02 Apr 2007 19:33:31 +0000 PeterZwarich 345@http://diymacserver.com/forum/ Hi - I am working on the compilation instructions for MySQL. after entering: without-bench I get this message: configure: error: invalid variable name: with-server-suffix I downloaded mysql-5.0.37. peter Priz on "mysql plugin couldnt connect to any host" http://diymacserver.com/forum/topic/mysql-plugin-couldnt-connect-to-any-host#post-328 Mon, 26 Feb 2007 00:19:24 +0000 Priz 328@http://diymacserver.com/forum/ Hello, <code>Feb 25 20:01:15 MiniMac postfix/smtpd[433]: mysql plugin couldnt connect to any host\n</code> I had this message in system.log when smtpd process received an email and... I don't understand why : the email is nevertheless send. Richard on "How do I know if this is working?" http://diymacserver.com/forum/topic/how-do-i-know-if-this-is-working#post-205 Tue, 14 Nov 2006 06:33:56 +0000 Richard 205@http://diymacserver.com/forum/ Keep us posted on the results... Ryan on "Issues compiling 5.0.24a" http://diymacserver.com/forum/topic/issues-compiling-5024a#post-120 Tue, 03 Oct 2006 20:26:56 +0000 Ryan 120@http://diymacserver.com/forum/ Thanks Richard, got the dev tools installed and had no problems with mysql.