* [Comm] postfix+mysql
@ 2003-11-30 15:13 Valery V. Inozemtsev
2003-11-30 15:32 ` [Comm] postfix+mysql Konstantin Lepikhov
2003-11-30 18:27 ` [Comm] postfix+mysql Aleksandr Blokhin
0 siblings, 2 replies; 10+ messages in thread
From: Valery V. Inozemtsev @ 2003-11-30 15:13 UTC (permalink / raw)
To: community
Здравствуйте.
Пытаюсь подружить postfix и mysql. пока безрезультатно.
postfix/trivial-rewrite[26514]: warning: connect to mysql server
localhost: Can't connect to local MySQL server through socket
'/var/lib/mysql/mysql.sock' (2)
postfix/cleanup[26513]: warning: connect to mysql server localhost:
Can't connect to local MySQL server through socket
'/var/lib/mysql/mysql.sock' (2)
postfix/cleanup[26513]: warning: 7AE6E36D9B12: virtual_alias_maps map
lookup problem for root@myhost.mydomain.ru
postfix/cleanup[26513]: warning: 7AE6E36D9B12: skipping further client input
postfix/pickup[26196]: warning: maildrop/74B7050D7802: Error writing
message file
postfix/pickup[26196]: 7FC0F36D9B12: uid=0 from=<root>
postfix/cleanup[26513]: warning: 7FC0F36D9B12: virtual_alias_maps map
lookup problem for root@myhost.mydomain.ru
postfix/cleanup[26513]: warning: 7FC0F36D9B12: skipping further client input
и т. д...
Как заставить постфикс видеть mysql.sock?
С уважением, Валерий.
^ permalink raw reply [flat|nested] 10+ messages in thread
* [Comm] Re: postfix+mysql
2003-11-30 15:13 [Comm] postfix+mysql Valery V. Inozemtsev
@ 2003-11-30 15:32 ` Konstantin Lepikhov
2003-11-30 15:58 ` Valery V. Inozemtsev
2003-11-30 18:24 ` Konstantin Lepikhov
2003-11-30 18:27 ` [Comm] postfix+mysql Aleksandr Blokhin
1 sibling, 2 replies; 10+ messages in thread
From: Konstantin Lepikhov @ 2003-11-30 15:32 UTC (permalink / raw)
To: community
Hi Valery!
Sunday 30, at 06:13:30 PM you wrote:
> Здравствуйте.
>
> Пытаюсь подружить postfix и mysql. пока безрезультатно.
>
> postfix/trivial-rewrite[26514]: warning: connect to mysql server
> localhost: Can't connect to local MySQL server through socket
> '/var/lib/mysql/mysql.sock' (2)
> postfix/cleanup[26513]: warning: connect to mysql server localhost:
> Can't connect to local MySQL server through socket
> '/var/lib/mysql/mysql.sock' (2)
> postfix/cleanup[26513]: warning: 7AE6E36D9B12: virtual_alias_maps map
> lookup problem for root@myhost.mydomain.ru
> postfix/cleanup[26513]: warning: 7AE6E36D9B12: skipping further client input
> postfix/pickup[26196]: warning: maildrop/74B7050D7802: Error writing
> message file
> postfix/pickup[26196]: 7FC0F36D9B12: uid=0 from=<root>
> postfix/cleanup[26513]: warning: 7FC0F36D9B12: virtual_alias_maps map
> lookup problem for root@myhost.mydomain.ru
> postfix/cleanup[26513]: warning: 7FC0F36D9B12: skipping further client input
>
> и т. д...
> Как заставить постфикс видеть mysql.sock?
service mysqld start?
--
WBR, Konstantin chat with ==>ICQ: 109916175
Lepikhov, speak to ==>JID: lakostis@jabber.org
aka L.A. Kostis write to ==>mailto:lakostis@pisem.net.nospam
...The information is like the bank... (c) EC8OR
^ permalink raw reply [flat|nested] 10+ messages in thread
* Re: [Comm] Re: postfix+mysql
2003-11-30 15:32 ` [Comm] postfix+mysql Konstantin Lepikhov
@ 2003-11-30 15:58 ` Valery V. Inozemtsev
2003-11-30 17:37 ` Alexei Takaseev
2003-11-30 18:24 ` Konstantin Lepikhov
1 sibling, 1 reply; 10+ messages in thread
From: Valery V. Inozemtsev @ 2003-11-30 15:58 UTC (permalink / raw)
To: community
<skip>
>>lookup problem for root@myhost.mydomain.ru
>>postfix/cleanup[26513]: warning: 7FC0F36D9B12: skipping further client input
>>
>>и т. д...
>>Как заставить постфикс видеть mysql.sock?
>>
>>
>service mysqld start?
>
>
>
типа прикололся? шутник блин...
^ permalink raw reply [flat|nested] 10+ messages in thread
* Re: [Comm] Re: postfix+mysql
2003-11-30 15:58 ` Valery V. Inozemtsev
@ 2003-11-30 17:37 ` Alexei Takaseev
2003-11-30 17:56 ` Valery V. Inozemtsev
0 siblings, 1 reply; 10+ messages in thread
From: Alexei Takaseev @ 2003-11-30 17:37 UTC (permalink / raw)
To: ALT Linux Community
On Sun, 30 Nov 2003 18:58:31 +0300
"Valery V. Inozemtsev" <shrek@progroup.ru> wrote:
> <skip>
>
> >>lookup problem for root@myhost.mydomain.ru
> >>postfix/cleanup[26513]: warning: 7FC0F36D9B12: skipping further
> >client input>
> >>и т. д...
> >>Как заставить постфикс видеть mysql.sock?
> >>
> >>
> >service mysqld start?
> >
> >
> >
> типа прикололся? шутник блин...
А если подключаться к MySQL через IP? Ведь postfix работает в chroot'е.
^ permalink raw reply [flat|nested] 10+ messages in thread
* Re: [Comm] Re: postfix+mysql
2003-11-30 17:37 ` Alexei Takaseev
@ 2003-11-30 17:56 ` Valery V. Inozemtsev
2003-11-30 18:32 ` Konstantin Lepikhov
2003-12-01 14:13 ` Alexei Takaseev
0 siblings, 2 replies; 10+ messages in thread
From: Valery V. Inozemtsev @ 2003-11-30 17:56 UTC (permalink / raw)
To: community
>>
>>
>>>>lookup problem for root@myhost.mydomain.ru
>>>>postfix/cleanup[26513]: warning: 7FC0F36D9B12: skipping further
>>>>
>>>>
>>>client input>
>>>
>>>
>>>>и т. д...
>>>>Как заставить постфикс видеть mysql.sock?
>>>>
>>>>
>>>>
>>>>
>>>service mysqld start?
>>>
>>>
>>>
>>>
>>>
>>типа прикололся? шутник блин...
>>
>>
>
>А если подключаться к MySQL через IP?
>
как объяснить это постфиксу не пойму, если подскажите буду очень признателен
>Ведь postfix работает в chroot'е.
>
>
угу, в этом вся и проблема
^ permalink raw reply [flat|nested] 10+ messages in thread
* [Comm] Re: postfix+mysql
2003-11-30 15:32 ` [Comm] postfix+mysql Konstantin Lepikhov
2003-11-30 15:58 ` Valery V. Inozemtsev
@ 2003-11-30 18:24 ` Konstantin Lepikhov
1 sibling, 0 replies; 10+ messages in thread
From: Konstantin Lepikhov @ 2003-11-30 18:24 UTC (permalink / raw)
To: community
Hi community!
Sunday 30, at 06:32:50 PM you wrote:
> Hi Valery!
>
> Sunday 30, at 06:13:30 PM you wrote:
>
> > Здравствуйте.
> >
> > Пытаюсь подружить postfix и mysql. пока безрезультатно.
> >
> > postfix/trivial-rewrite[26514]: warning: connect to mysql server
> > localhost: Can't connect to local MySQL server through socket
> > '/var/lib/mysql/mysql.sock' (2)
> > postfix/cleanup[26513]: warning: connect to mysql server localhost:
> > Can't connect to local MySQL server through socket
> > '/var/lib/mysql/mysql.sock' (2)
> > postfix/cleanup[26513]: warning: 7AE6E36D9B12: virtual_alias_maps map
> > lookup problem for root@myhost.mydomain.ru
> > postfix/cleanup[26513]: warning: 7AE6E36D9B12: skipping further client input
> > postfix/pickup[26196]: warning: maildrop/74B7050D7802: Error writing
> > message file
> > postfix/pickup[26196]: 7FC0F36D9B12: uid=0 from=<root>
> > postfix/cleanup[26513]: warning: 7FC0F36D9B12: virtual_alias_maps map
> > lookup problem for root@myhost.mydomain.ru
> > postfix/cleanup[26513]: warning: 7FC0F36D9B12: skipping further client input
> >
> > и т. д...
> > Как заставить постфикс видеть mysql.sock?
> service mysqld start?
>
Аа у вас же postfix в chroot'е, так что socket он не увидит
--
WBR, Konstantin chat with ==>ICQ: 109916175
Lepikhov, speak to ==>JID: lakostis@jabber.org
aka L.A. Kostis write to ==>mailto:lakostis@pisem.net.nospam
...The information is like the bank... (c) EC8OR
^ permalink raw reply [flat|nested] 10+ messages in thread
* Re: [Comm] postfix+mysql
2003-11-30 15:13 [Comm] postfix+mysql Valery V. Inozemtsev
2003-11-30 15:32 ` [Comm] postfix+mysql Konstantin Lepikhov
@ 2003-11-30 18:27 ` Aleksandr Blokhin
2003-11-30 18:59 ` Valery V. Inozemtsev
1 sibling, 1 reply; 10+ messages in thread
From: Aleksandr Blokhin @ 2003-11-30 18:27 UTC (permalink / raw)
To: community
[-- Attachment #1: Type: text/plain, Size: 1454 bytes --]
On Sun, Nov 30, 2003 at 06:13:30PM +0300, Valery V. Inozemtsev wrote:
> Здравствуйте.
>
> Пытаюсь подружить postfix и mysql. пока безрезультатно.
>
> postfix/trivial-rewrite[26514]: warning: connect to mysql server
> localhost: Can't connect to local MySQL server through socket
> '/var/lib/mysql/mysql.sock' (2)
> postfix/cleanup[26513]: warning: connect to mysql server localhost:
> Can't connect to local MySQL server through socket
> '/var/lib/mysql/mysql.sock' (2)
> postfix/cleanup[26513]: warning: 7AE6E36D9B12: virtual_alias_maps map
> lookup problem for root@myhost.mydomain.ru
> postfix/cleanup[26513]: warning: 7AE6E36D9B12: skipping further client input
> postfix/pickup[26196]: warning: maildrop/74B7050D7802: Error writing
> message file
> postfix/pickup[26196]: 7FC0F36D9B12: uid=0 from=<root>
> postfix/cleanup[26513]: warning: 7FC0F36D9B12: virtual_alias_maps map
> lookup problem for root@myhost.mydomain.ru
> postfix/cleanup[26513]: warning: 7FC0F36D9B12: skipping further client input
>
> и т. д...
> Как заставить постфикс видеть mysql.sock?
Либо при помощи proxy:mysql:virtual_bla_bla, либо указать mysql
слушать адрес, например 192.168.0.1, и в virtual_alias_maps указать:
host = 192.168.0.1
port = 3306
host = 127.0.0.1 или localhost не подходит, так как postfix найдя такое
определение пытается подключиться через сокет.
--
Best regards
AB
--
... In nomine Altli, et Ctrli, et Spititus Deli, Reset!
[-- Attachment #2: Type: application/pgp-signature, Size: 189 bytes --]
^ permalink raw reply [flat|nested] 10+ messages in thread
* [Comm] Re: postfix+mysql
2003-11-30 17:56 ` Valery V. Inozemtsev
@ 2003-11-30 18:32 ` Konstantin Lepikhov
2003-12-01 14:13 ` Alexei Takaseev
1 sibling, 0 replies; 10+ messages in thread
From: Konstantin Lepikhov @ 2003-11-30 18:32 UTC (permalink / raw)
To: community
Hi Valery!
Sunday 30, at 08:56:51 PM you wrote:
>
> >>
> >>
> >>>>lookup problem for root@myhost.mydomain.ru
> >>>>postfix/cleanup[26513]: warning: 7FC0F36D9B12: skipping further
> >>>>
> >>>>
> >>>client input>
> >>>
> >>>
> >>>>и т. д...
> >>>>Как заставить постфикс видеть mysql.sock?
> >>>>
> >>>>
> >>>>
> >>>>
> >>>service mysqld start?
> >>>
> >>>
> >>>
> >>>
> >>>
> >>типа прикололся? шутник блин...
> >>
> >>
> >
> >А если подключаться к MySQL через IP?
> >
> как объяснить это постфиксу не пойму, если подскажите буду очень признателен
Можно явно указать ip в hosts -
virtual_maps = mysql:/etc/postfix/mysql-virtual.cf
cat /etc/postfix/mysql-virtual.cf
hosts = <x.x.x.x>
user = xxxx
password = xxxx
dbname = xxxx
table = virtual
select_field = dest
where_field = alias
вы так проверяли?
--
WBR, Konstantin chat with ==>ICQ: 109916175
Lepikhov, speak to ==>JID: lakostis@jabber.org
aka L.A. Kostis write to ==>mailto:lakostis@pisem.net.nospam
...The information is like the bank... (c) EC8OR
^ permalink raw reply [flat|nested] 10+ messages in thread
* Re: [Comm] postfix+mysql
2003-11-30 18:27 ` [Comm] postfix+mysql Aleksandr Blokhin
@ 2003-11-30 18:59 ` Valery V. Inozemtsev
0 siblings, 0 replies; 10+ messages in thread
From: Valery V. Inozemtsev @ 2003-11-30 18:59 UTC (permalink / raw)
To: community
<skip>
>>и т. д...
>>Как заставить постфикс видеть mysql.sock?
>>
>>
>
>Либо при помощи proxy:mysql:virtual_bla_bla, либо указать mysql
>слушать адрес, например 192.168.0.1, и в virtual_alias_maps указать:
>host = 192.168.0.1
>port = 3306
>
>
вот так заработало, спасибо.
>host = 127.0.0.1 или localhost не подходит, так как postfix найдя такое
>определение пытается подключиться через сокет.
>
>
>
^ permalink raw reply [flat|nested] 10+ messages in thread
* Re: [Comm] Re: postfix+mysql
2003-11-30 17:56 ` Valery V. Inozemtsev
2003-11-30 18:32 ` Konstantin Lepikhov
@ 2003-12-01 14:13 ` Alexei Takaseev
1 sibling, 0 replies; 10+ messages in thread
From: Alexei Takaseev @ 2003-12-01 14:13 UTC (permalink / raw)
To: ALT Linux Community
On Sun, 30 Nov 2003 20:56:51 +0300
"Valery V. Inozemtsev" <shrek@progroup.ru> wrote:
> >>>>lookup problem for root@myhost.mydomain.ru
> >>>>postfix/cleanup[26513]: warning: 7FC0F36D9B12: skipping further
> >>>>
> >>>>
> >>>client input>
> >>>
> >>>
> >>>>и т. д...
> >>>>Как заставить постфикс видеть mysql.sock?
> >>>>
> >>>>
> >>>>
> >>>>
> >>>service mysqld start?
> >>>
> >>>
> >>>
> >>>
> >>>
> >>типа прикололся? шутник блин...
> >>
> >>
> >
> >А если подключаться к MySQL через IP?
> >
> как объяснить это постфиксу не пойму, если подскажите буду очень
> признателен
У меня используется PistgreSQL, но думаю, что для MySQL это тоже
правомерно:
host = 127.0.0.1
user = mail
password = XXXXX
dbname = mail
table = mailusers
select_field = username
where_field = username
additional_conditions = and active = 1
^ permalink raw reply [flat|nested] 10+ messages in thread
end of thread, other threads:[~2003-12-01 14:13 UTC | newest]
Thread overview: 10+ messages (download: mbox.gz / follow: Atom feed)
-- links below jump to the message on this page --
2003-11-30 15:13 [Comm] postfix+mysql Valery V. Inozemtsev
2003-11-30 15:32 ` [Comm] postfix+mysql Konstantin Lepikhov
2003-11-30 15:58 ` Valery V. Inozemtsev
2003-11-30 17:37 ` Alexei Takaseev
2003-11-30 17:56 ` Valery V. Inozemtsev
2003-11-30 18:32 ` Konstantin Lepikhov
2003-12-01 14:13 ` Alexei Takaseev
2003-11-30 18:24 ` Konstantin Lepikhov
2003-11-30 18:27 ` [Comm] postfix+mysql Aleksandr Blokhin
2003-11-30 18:59 ` Valery V. Inozemtsev
ALT Linux Community general discussions
This inbox may be cloned and mirrored by anyone:
git clone --mirror http://lore.altlinux.org/community/0 community/git/0.git
# If you have public-inbox 1.1+ installed, you may
# initialize and index your mirror using the following commands:
public-inbox-init -V2 community community/ http://lore.altlinux.org/community \
mandrake-russian@linuxteam.iplabs.ru community@lists.altlinux.org community@lists.altlinux.ru community@lists.altlinux.com
public-inbox-index community
Example config snippet for mirrors.
Newsgroup available over NNTP:
nntp://lore.altlinux.org/org.altlinux.lists.community
AGPL code for this site: git clone https://public-inbox.org/public-inbox.git