Go Back   HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials > ISPConfig 2 > Developers' Forum

Do you like HowtoForge? Please consider supporting us by becoming a subscriber.
Reply
 
Thread Tools Display Modes
  #1  
Old 14th March 2006, 03:37
benbalbo benbalbo is offline
Member
 
Join Date: Oct 2005
Posts: 50
Thanks: 0
Thanked 4 Times in 4 Posts
Default Errors in isp_isp_domain hostname

I was just fixing the second server issue Till was halping me with in the config/install forum, and noticed somthing strange in the DB.

When I selected all host names and domain names from isp_isp_domain, I got 11 records with a NULL hostname. These didn't show up in the co-domains section of the site in the admin site, so I couldn't delete them, and were causing main-domain.com to be treated as a local host name (something I was trying to disable).

I'm not sure how the NULLs got in there - all I did was create a number of new web sites with hostanem "clientname" and domain name "main-domain.com" and these appeared.

I deleted all from the table where hostname IS NULL and that seemed to solve my problem.

The issue remains, how can someone delete them from the admin site?

Of interest might be that ispconfig still counted these. I had to set domain count to 3 in order to have the main domain and a co-domain (should be two) and because the NULL's weren't displayed, this confused me no end.

Let me know if you need any other info about this,

Cheers
BB
Reply With Quote
Sponsored Links
  #2  
Old 14th March 2006, 08:33
till till is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lneburg, Germany
Posts: 34,586
Thanks: 792
Thanked 4,983 Times in 3,903 Posts
 
Default

To solve this issue, please edit the (default) properties of the column hostname in the table isp_isp_domain in phpmyadmin and set it to "not null".
__________________
Till Brehm
--
Get ISPConfig support and the ISPConfig 3 manual from ispconfig.org.
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
Virtual Users + Domains With Postfix, Courier + MySQL (+SMTP-AUTH, SpamA, ClamAV) brianwc HOWTO-Related Questions 6 9th May 2007 02:44
PHP Errors in the "WEB-FTP" module crudolphy General 9 27th December 2005 20:17
What should hostname be? Lil'Brudder General 2 19th October 2005 10:08
Server Hostname and IPSConfig Lil'Brudder Installation/Configuration 2 14th October 2005 12:46
FC3 Perfect Installation Make Errors solderboy HOWTO-Related Questions 3 2nd October 2005 16:55


All times are GMT +2. The time now is 05:50.


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