DIYMacServer » Tag: MySQL

DIYMacServer » Tag: MySQL - Recent Posts http://diymacserver.com/forum/ DIYMacServer » Tag: MySQL - Recent Posts en Tue, 07 Feb 2012 07:20:03 +0000 Lindhardsen on "Problem with SQLGrey and MySQL" 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/ 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! Richard on "Problem with SQLGrey and MySQL" 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/ I'll see if I can reproduce your problem to be able to determine a solution. Lindhardsen on "Problem with SQLGrey and MySQL" 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/ No, Skip-networking is not enabled. On the other hand, neither is "port", could that be a problem? I guess not, at least not related to this... Richard on "Problem with SQLGrey and MySQL" 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/ Jan did you enable the skip-networking option in MySQL so it can only use the socket for connectivity? Lindhardsen on "Problem with SQLGrey and MySQL" 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/ Hi Richard, thanks for your responses, your help is highly appreciated! 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. The version is Server version: 5.1.51 MySQL Community Server the my.cfn is located in /private/etc/my.cnf and the content is: <pre><code>[client] socket = /var/mysql/mysql.sock [mysqld] socket = /var/mysql/mysql.sock</code></pre> 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? 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? Richard on "Problem with SQLGrey and MySQL" 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/ After some googling I found that Perl uses the MYSQL config file to determine the connection or socket settings in the config file. Otherwise we need to change the code to make a database connection look like: DBI->connect("DBI:mysql:host=localhost:mysql_socket=/tmp/mysql.sock;database=business"... Richard on "Problem with SQLGrey and MySQL" 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/ Also, I forgot, do you have a MYSQL config file in /etc/ called my.cnf Richard on "Problem with SQLGrey and MySQL" 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/ Jan, which version of MySQl have you got installed and are you running a real OSX server or our DIYMacServer? 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 Richard 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-936 Wed, 23 Mar 2011 20:48:06 +0000 Richard 936@http://diymacserver.com/forum/ Hi Rob, This is a known problem and if you look at the blog and look at the articles that talk about the security updates you see that this sometimes happens and how to fix it. Here is an example that will help you solve your problem: <a href="http://diymacserver.com/2010/11/12/mac-os-x-update-10-6-5-and-security-update-2010-007/" rel="nofollow">http://diymacserver.com/2010/11/12/mac-os-x-update-10-6-5-and-security-update-2010-007/</a> 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-832 Mon, 07 Jun 2010 23:41:17 +0000 Fred Turner 832@http://diymacserver.com/forum/ Okay, seem to be making progress, although I can't say w/ 100% certainty that I know what the fix was. I went into the 3 mysql_virtual files and changed the "hosts" line from: <code>hosts = 127.0.0.1</code> as the instructions say, to: <code>hosts = localhost</code> No idea why that would make a difference-- they should be one and the same. However, things seem to work now w/o the error, and mail gets delivered properly. Would still be interested to hear your thoughts. Now on to the next problem! :-D Thx, Fred Fred Turner on "Postfix "Can't connect to MySQL server"" http://diymacserver.com/forum/topic/postfix-cant-connect-to-mysql-server#post-831 Mon, 07 Jun 2010 21:01:00 +0000 Fred Turner 831@http://diymacserver.com/forum/ Can you think of *any* reason why lookups from postfix to mysql would be failing? It seems to me that the critical log entries are: <pre><code>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</code></pre> Is it something to do w/ the virtual alias maps file? Fred Turner on "Postfix "Can't connect to MySQL server"" http://diymacserver.com/forum/topic/postfix-cant-connect-to-mysql-server#post-830 Mon, 07 Jun 2010 15:54:14 +0000 Fred Turner 830@http://diymacserver.com/forum/ Thanks, Richard, but I don't have the foggiest idea how to use that. I tried running it on "ib_logfile0" and "ib_logfile1", but only got the following output: <pre><code>Warning: is opened with same process and filenumber Maybe you should use the -P option ?</code></pre> I guess it's a sign you should throw in the towel and do something else when you're not even able to see the logs to tell you what might be going wrong... Richard on "Postfix "Can't connect to MySQL server"" http://diymacserver.com/forum/topic/postfix-cant-connect-to-mysql-server#post-829 Fri, 04 Jun 2010 19:47:38 +0000 Richard 829@http://diymacserver.com/forum/ Think you need to use something like this: <a href="http://dev.mysql.com/doc/refman/5.1/en/myisamlog.html" rel="nofollow">http://dev.mysql.com/doc/refman/5.1/en/myisamlog.html</a> Fred Turner on "Postfix "Can't connect to MySQL server"" http://diymacserver.com/forum/topic/postfix-cant-connect-to-mysql-server#post-828 Fri, 04 Jun 2010 14:31:37 +0000 Fred Turner 828@http://diymacserver.com/forum/ Okay, I must be dense...what do I need to use to view these logs? Tried 'tail' and I got mostly gibberish over the screen! Thx, Fred Richard on "Postfix "Can't connect to MySQL server"" http://diymacserver.com/forum/topic/postfix-cant-connect-to-mysql-server#post-819 Thu, 13 May 2010 20:24:06 +0000 Richard 819@http://diymacserver.com/forum/ They are in /usr/local/mysql/data/ you'll need root access to read them. Are the files readable for postfix. notifications are not yet possible, I need to upgrade the software of the forum to do that. But don't despair Im working on it... Fred Turner on "Postfix "Can't connect to MySQL server"" http://diymacserver.com/forum/topic/postfix-cant-connect-to-mysql-server#post-818 Thu, 13 May 2010 15:48:43 +0000 Fred Turner 818@http://diymacserver.com/forum/ Uh oh...if you've never seen this, then I'm probably screwed! If you think of anything I can test or check out, I'm all ears. Seems to me like somehow postfix is unable to access info in the auxiliary virtual files. Dumb question: where are the MySQL-specific logs in our DIY installation? Thx, FT P.S. Is there any way to subscribe to threads here for instant email notification? Richard on "Postfix "Can't connect to MySQL server"" http://diymacserver.com/forum/topic/postfix-cant-connect-to-mysql-server#post-817 Wed, 12 May 2010 09:27:59 +0000 Richard 817@http://diymacserver.com/forum/ I've never seen this error before. I would have to try some stuff to really pinpoint the cause of this. But I'm currently don't have access to a Mac, perhaps later... 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 Richard on "Compile Apache+MySQL+php on Snow Leopard" http://diymacserver.com/forum/topic/compile-apachemysqlphp-on-snow-leopard#post-719 Mon, 28 Sep 2009 05:51:46 +0000 Richard 719@http://diymacserver.com/forum/ No problem, why are you using apache 2.2.4? It's not even the default installed version on Snow Leopard (2.2.11). The instructions are meant as a complete set and I'm assuming everyone is using the latest version. Checking all components with all possible older versions is not something I'm even considering ;-) Consider this a closed ticket.... zerustech on "Compile Apache+MySQL+php on Snow Leopard" http://diymacserver.com/forum/topic/compile-apachemysqlphp-on-snow-leopard#post-718 Sun, 27 Sep 2009 14:02:46 +0000 zerustech 718@http://diymacserver.com/forum/ Hi Richard, I think the problem is: looks like it's only possible to compile php with apache 2.2.13 on snow leopard. I tried to compile php with apache 2.2.4 and 2.0.55, but the "apxs" didn't work. So can you please update your instruction and close this ticket? Kind regards Richard on "Compile Apache+MySQL+php on Snow Leopard" http://diymacserver.com/forum/topic/compile-apachemysqlphp-on-snow-leopard#post-717 Sun, 27 Sep 2009 06:49:59 +0000 Richard 717@http://diymacserver.com/forum/ Hi, I don't know why you think the instructions here don't work. They do, there is a whole separate section that describes compiling on Snow Leopard: <a href="http://diymacserver.com/installing-everything-on-snow-leopard/" rel="nofollow">http://diymacserver.com/installing-everything-on-snow-leopard/</a> Maybe you didn't look at the correct place? 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 Richard on "Optimising a server" http://diymacserver.com/forum/topic/optimising-a-server#post-561 Mon, 22 Sep 2008 18:31:22 +0000 Richard 561@http://diymacserver.com/forum/ For wordpress you can use a caching plugin which will help in caching pages which means that MySQL isn't accessed that much. I don't use phpbb so I'm not that experienced with their options.