Logo 
Search:

Unix / Linux / Ubuntu Forum

Ask Question   UnAnswered
Home » Forum » Unix / Linux / Ubuntu       RSS Feeds

teapop-mysql on 7.10-server

  Date: Dec 28    Category: Unix / Linux / Ubuntu    Views: 330
  

I'm trying to setup a teapop-mysql pop3 server along with virtual
domains stored in MySQL for my office users and I would like to use
whole email address as a login. Postfix and Teapop are configured to use
the same db . My problem is that teapop somehow cut the "@domain.com"
part from login.

Let me show you:

Here is db schema:

create table uzytkownicy
(
id int auto_increment not null primary key,
login varchar(255) not null,
haslo varchar(255) not null,
mailbox varchar(128) not null,
maildir varchar(255) not null default '/usr/local/vmail/',
uid varchar(4) not null default '1003',
gid varchar(4) not null default '1004',
active bool not null default '1'

);

create table valias
(
id int auto_increment not null primary key,
alias varchar(255) not null,
adres varchar(255) not null
);

sample user: user@...
sample pass: password

pop3 session:

Escape character is '^]'.
+OK Teapop [0.3.7] - Teaspoon stirs around again
<1205364477.60CF7179@Llywellyn>
user user@...
+OK Welcome, do you have any type of ID?
pass password
-ERR Incorrect password...or maybe you don't even have an account here?

syslog entry for this session is:

lynx teapop[21704]: Query result is incomplete
lynx teapop[21704]: Failed login for user@... [127.0.0.1] from
localhost [127.0.0.1]

... which is correct because ... :
080313 0:19:31 571 Query select * from uzytkownicy
080313 0:28:06 572 Connect adminpoczta@localhost on
572 Init DB poczta
572 Query SELECT login, haslo, mailbox FROM
uzytkownicy WHERE login = 'user' AND active=1
572 Quit

in sql query login is ='user' and not user@...'

teapop config goes like this:

domain.com:*:mysql:/usr/local/vmail/::vmail:vmail:localhost::poczta:adminpoczta:\
dbadminpass:uzytkownicy:login:haslo:mailbox:

I'm quite confused and I don't know, what I'm doing wrong here so if
there is anyone who is familiar with teapop.

Share: 

 

No Answers Found. Be the First, To Post Answer.

 
Didn't find what you were looking for? Find more on teapop-mysql on 7.10-server Or get search suggestion and latest updates.




Tagged: