DIYMacServer » Tag: connect

DIYMacServer » Tag: connect - Recent Posts http://diymacserver.com/forum/ DIYMacServer » Tag: connect - Recent Posts en Wed, 08 Feb 2012 06:03:15 +0000 Richard 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-484 Sat, 31 May 2008 09:58:11 +0000 Richard 484@http://diymacserver.com/forum/ Thanks will do that. 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-480 Fri, 30 May 2008 20:30:04 +0000 Rimas 480@http://diymacserver.com/forum/ Hi... OK, adding e-mail capability to the domain that I am hosting on my Mac Mini server is obviously not a high priority, so don't worry about the delay in responding. Just to close out this dangling thread, using sockets as suggested did in fact solve this problem when I finally got back to it the other day... If I may, I would like to suggest that you update your wonderful documentation to say that if you add "skip-networking" to your /etc/my.cnf as suggested in the instructions for "Securing your MySQL install", that you will need to use sockets in the mysql_virtual_xxxxxxx_maps.cf files when "Configuring Postfix for virtual domains using MySQL". Cheers, Rimas Richard 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-447 Sun, 16 Mar 2008 11:06:19 +0000 Richard 447@http://diymacserver.com/forum/ Ok, sorry for the late reply but I was out of the country for work... Do you have a firewall enabled ? Can you tell me which version of OS X you are running ? Can you try using sockets ? <pre><code> user = mailsrvr password = ******** hosts = unix:/tmp/mysql.sock dbname = postfix </code></pre> Make sure that your socket file is in the same place, you can use the command "mysql_config" to see where our socket file is. 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 Keeya on "/usr/local/virtual empty & mysql connect" http://diymacserver.com/forum/topic/usrlocalvirtual-empty-038-mysql-connect#post-387 Fri, 01 Jun 2007 15:59:12 +0000 Keeya 387@http://diymacserver.com/forum/ Also should add the owners and perms on /usr/local/virtual for reference in case that helps: drwxrwx--x 2 vmail postfix 68 May 23 10:39 virtual Keeya on "/usr/local/virtual empty & mysql connect" http://diymacserver.com/forum/topic/usrlocalvirtual-empty-038-mysql-connect#post-386 Fri, 01 Jun 2007 14:37:11 +0000 Keeya 386@http://diymacserver.com/forum/ Yeah, everything seems to work via the command line with the reset users and passwords: <pre><code> mysql -u postfix -p postfix <entered password> mysql> mysql -u postfixadmin -p postfix <entered password> mysql> postconf -m </code></pre> btree cidr environ hash mysql pcre proxy regexp static unix Of note, mysql_config looks slightly different than what you had posted, though. An extra "mysql" directory, though the socket and port look fine: <pre><code> mysql_config Usage: /usr/local/mysql/bin/mysql_config [OPTIONS] Options: --cflags [-I/usr/local/mysql/include/mysql -arch ppc -isysroot /Developer/SDKs/MacOSX10.4u.sdk] --include [-I/usr/local/mysql/include/mysql] --libs [-L/usr/local/mysql/lib/mysql -lmysqlclient -lz -lm] --libs_r [-L/usr/local/mysql/lib/mysql -lmysqlclient_r -lz -lm] --socket [/tmp/mysql.sock] --port [3306] --version [5.0.41] --libmysqld-libs [-L/usr/local/mysql/lib/mysql -lmysqld -lz -lm] </code></pre> Richard on "/usr/local/virtual empty & mysql connect" http://diymacserver.com/forum/topic/usrlocalvirtual-empty-038-mysql-connect#post-385 Fri, 01 Jun 2007 08:17:12 +0000 Richard 385@http://diymacserver.com/forum/ Can you connect to the database from the command line using: <code>mysql -u username -p database</code> And if that works did you compile postfix correctly with mysql support. Check by using the command <code>postconf -m</code> in the response there should be an item mysql. 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