Go Back   HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials > ISPConfig 2 > Installation/Configuration

Do you like HowtoForge? Please consider supporting us by becoming a subscriber.
Reply
 
Thread Tools Display Modes
  #1  
Old 17th July 2006, 20:01
mxc mxc is offline
Member
 
Join Date: May 2006
Location: South Africa
Posts: 91
Thanks: 1
Thanked 2 Times in 2 Posts
Send a message via Skype™ to mxc
Default Problems with creating/deleting email accounts

Hi all,

It seems that we have somehow corrupted an entry in the database for dns. We have deleted a MX record and emptied the recycle bin. When we try and recreate the entry we kept on getting error messages that it already exists.

I have looked at the pri. zone file and there is no entry in there. In addition it appears not to add the domain to the /etc/postfix/local-host-names file or the user to /etc/postfix/virtusertable file.

We had a look at the database tables prefixed with dns_ but they are quite cryptic and doc_id appears to refer to different entity records in each table.

Help please.
Reply With Quote
Sponsored Links
  #2  
Old 17th July 2006, 20:15
mxc mxc is offline
Member
 
Join Date: May 2006
Location: South Africa
Posts: 91
Thanks: 1
Thanked 2 Times in 2 Posts
Send a message via Skype™ to mxc
Default

oh yes --- it also wont create users for these domains. The database has the users in its tables and the web app show these users but mail just bounces from these accounts say "relay denied" and as said above there is no entry from them in the postfix config file.


I also get "Duplicate Email Address" when trying to create a user who has been deleted from the domain. The recycle bin is also empty
and the user is not in /home/adminispconfig/users

Last edited by mxc; 17th July 2006 at 20:42.
Reply With Quote
  #3  
Old 17th July 2006, 20:41
till till is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 35,340
Thanks: 810
Thanked 5,165 Times in 4,049 Posts
Default

Quote:
Originally Posted by mxc
oh yes --- it also wont create users for these domains. The database has the users in its tables and the web app show these users but mail just bounces from these accounts say "relay denied" and as said above there is no entry from them in the postfix config file.
PLease enable " server requires authentication" in the SMTP settings of your mail client.
__________________
Till Brehm
--
Get ISPConfig support and the ISPConfig 3 manual from ispconfig.org.
Reply With Quote
  #4  
Old 17th July 2006, 20:42
till till is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 35,340
Thanks: 810
Thanked 5,165 Times in 4,049 Posts
Default

Quote:
Originally Posted by mxc
Hi all,

It seems that we have somehow corrupted an entry in the database for dns. We have deleted a MX record and emptied the recycle bin. When we try and recreate the entry we kept on getting error messages that it already exists.

I have looked at the pri. zone file and there is no entry in there. In addition it appears not to add the domain to the /etc/postfix/local-host-names file or the user to /etc/postfix/virtusertable file.

We had a look at the database tables prefixed with dns_ but they are quite cryptic and doc_id appears to refer to different entity records in each table.

Help please.
Have you checked that the MX is not in one of the recycle bins in the DNS-Manager part of ISPConfig?

The MX records are not used for the postfix configuration.
__________________
Till Brehm
--
Get ISPConfig support and the ISPConfig 3 manual from ispconfig.org.
Reply With Quote
  #5  
Old 17th July 2006, 21:03
mxc mxc is offline
Member
 
Join Date: May 2006
Location: South Africa
Posts: 91
Thanks: 1
Thanked 2 Times in 2 Posts
Send a message via Skype™ to mxc
Default

Hi Till,

Thanks for the reply. I have checked the dns manager recycle bin is empty. The relay denied error message is printed in the maillog for mail sent to user@domain --- really wierd.


I managed to overcome the duplicate email error by deleting the record from the isp_isp_user table. Somehow the user was not showing in the application but they where still in the table?

Will continue to investigate. What tables are used to create the /etc/postifix/local-host-names and /etc/postfix/virtusertable files?
Reply With Quote
  #6  
Old 17th July 2006, 22:06
mxc mxc is offline
Member
 
Join Date: May 2006
Location: South Africa
Posts: 91
Thanks: 1
Thanked 2 Times in 2 Posts
Send a message via Skype™ to mxc
 
Default

Ok some more results of my investigation.

1) It appears that this mess happens when a user accidently creates a web site with the domain name www.<domain> then deletes this site and recreates it, without empting the recycle bin, as just <domain>. It may be that they just edit the current record and remove www. This seems to confuse the isp_isp_domain table.

2) I had to update the table isp_isp_domain and set the domain_host to null. This seems to fix postfix problems.

3) I still have problems trying to delete and recreate the mx records. I keep being told the MX record is already registered. Its almost impossible to tell which record needs to be deleted from dns_mx as I am not sure what the doc_id links to. This doc_id appears refer to different entities in each table.

" This or a similar MX Record does already exist in this zone."

4) I found some orphaned cname records in dns_cname which I deleted. I really cant see how these tables are linked? The doc_id seems completely random and doesnt seem to link to primary keys in another table.
Will report back later.

Last edited by mxc; 17th July 2006 at 22:34.
Reply With Quote
Reply

Bookmarks

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Email problems lead to apache problems natewlew Installation/Configuration 7 10th July 2006 08:53
New Setup Email Configuration problems jerutley Installation/Configuration 2 12th June 2006 22:06
email -> forwarding to 2 accounts when only 1 is in the database md@waw.co.uk Installation/Configuration 2 18th May 2006 11:53
Sending email problems: Relay access denied jaffaizal HOWTO-Related Questions 35 24th April 2006 10:04
Problems on setting new site always www on email!!! lyndros Installation/Configuration 3 14th March 2006 05:45


All times are GMT +2. The time now is 11:48.


Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2014, vBulletin Solutions, Inc.