Wrong data in DNS manager

[Eagle]

Hello,
I have created 32 sites with some co-domains. In left panel (Sites section) are displayed all sites (every site has one domain) correctly.
But in DNS manager I see only 22 domains. 10 domains missing. When I look into /var/named.conf, all 32 domains have record.
Where is the problem? Thanks for answer.

[till]

Have you checkt all folders in DNS manager and all resellers? Can you find the missing 10 domains by using the search function in DNS-Manager?

[Eagle]

Missing records are not in folders.
When I try search missing records with search function in DNS manager, i found it.
DNS Entry window show up:
Server: MyServer
Domain (SOA): missingdomain.sk
IP Address: 217.12.49.10
(values was changed for security reason)
All looks good, but if I can click to options or records tab, i get error:
Feld: IP Adresse
IP-Adress invalid.

[falko]

Did you change anything manually in the ISPConfig database?

[Eagle]

Yes, I did. I was trying to remove one corrupted user, but I thing it is not a error cause.
But...
I had one reseller with a few clients and sites. I renamed this reseller. Next I created new reseller with the same name, as first reseller before renaming. After moving sites and clients to the new reseller, I deleted old reseller.
Domains, created under new reseller looks good and they are visible in DNS manager. Moved domains aren't visible.
(uf, sorry for my english)

[till]

Yes, I did. I was trying to remove one corrupted user, but I thing it is not a error cause.
But...
I had one reseller with a few clients and sites. I renamed this reseller. Next I created new reseller with the same name, as first reseller before renaming. After moving sites and clients to the new reseller, I deleted old reseller.
Domains, created under new reseller looks good and they are visible in DNS manager. Moved domains aren't visible.
(uf, sorry for my english)

Which version had you installed as you moved the sites? There was a bugfix in the 2.2.0 release.

[Eagle]

I have the latest version 2.2.0.
Have I any chance to repair my problem?

[falko]

I don't think so because you made changes to the database! :eek:

[Eagle]

It was a deleting one user, nothing more. When you created bugfix, you must know where is a problem and what to do to correct it. Please.

[falko]

The problem is that the database is very complex. Even I couldn't do changes manually. So if you do manual changes, it is most likely that you break something.

[Zoon]

Try checking in the recycle bin on the DNS Manager.

I found before that mysteriously my DNS zones ended up in there and I still haven't figured out why... just restore all the entries!

[onastvar]

I've got a similar problem - I had to restart server after power outage. (This is the first time server was rebooted since ISPConfig has been setup)
I do not have option

I have not changed anything on the server. When I'm in ISPConfig DNS Manager I cannot open OPTIONS tab on any of sites.

Error message:

Field: IP Adresse
IP-Adress invalid.

I have CentOS 5.1 with ISPConfig Version: 2.2.23

Is there a way to fix this - Please advise?

[falko]

Can you check if MySQL is running? Maybe you need to repair the ISPConfig database (you can do this from within phpMyAdmin).

[onastvar]

Falko,

MySQL is running! I did a repair on all the tables within phpMyAdmin & still the same issue? I restarted MySQL server - still no luck. Any other suggestions?

Thanks

[falko]

Are there any errors in your logs?

[onastvar]

Could you please specify which logs I should check for errors? I checked /var/log/httpd folder for error_log & ispconfig_access_log, I'm really not sure if that's the right place to check logs for my issue.

Thanks!

[falko]

I'd check all logs in /var/log plus the error log in /root/ispconfig/httpd/logs.

[onastvar]

This what I have in my: /root/ispconfig/httpd/logs/error_log

du: `/var/www/web9/user/web9_domain9.com/Maildir': Permission denied
du: `/var/www/web9/user/web9_domain9.com/.spamassassin': Permission denied
du: `/var/www/web2/user/web2_domain9/Maildir': Permission denied
du: `/var/www/web2/user/web2_domain9/.spamassassin': Permission denied
du: `/var/www/web2/user/web2_domain9/Maildir': Permission denied


I didn't see anything in other logs within /var/log folder.
Any ideas?

[falko]

Please set $go_info["server"]["sudo_du_enabled"] to 1 in /home/admispconfig/ispconfig/lib/config.inc.php.

[onastvar]

Thanks!
I made a change from 0 to 1 in /home/admispconfig/ispconfig/lib/config.inc.php
What would be next step?

[falko]

Do you still get the same errors in /root/ispconfig/httpd/logs/error_log?

[onastvar]

Thanks! No, I don't have errors in /root/ispconfig/httpd/logs/error_log

However, I'm still trying to resolve my ISPConfig problem:

"When I'm in ISPConfig DNS Manager I cannot open OPTIONS tab on any of sites."

Error message:

Field: IP Adresse
IP-Adress invalid

[falko]

Can you check the table dns_isp_dns if there are valid IP addresses in it for each record?

[onastvar]

Thanks Falko!

I've checked table dns_isp_dns in ispconfigbd and there are valid IP addresses for each record? I'm attaching some screenshots from phpMyAdmin.
Anything else I should check?

[falko]

Then I have no idea... :(

[onastvar]

I was able to resolve issue

Error message:
Field: IP Adresse
IP-Adress invalid

by reinstalling ISPConfig 2.2.23

Thanks to ALL who responded to this thread!