Go Back   HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials > ISPConfig 3 > General

Do you like HowtoForge? Please consider supporting us by becoming a subscriber.
Reply
 
Thread Tools Display Modes
  #1  
Old 11th November 2010, 19:09
Dextros Dextros is offline
Junior Member
 
Join Date: Jan 2010
Posts: 11
Thanks: 0
Thanked 0 Times in 0 Posts
Default MyDNS

Evening Folks

Im having some bad problems

I cannot get MyDNS to start i keep getting this error:


Starting mydns: mydns[12314]: Error connecting to MySQL server at localhost: Access denied for user 'ispconfig'@'localhost' (using password: YES) (errno=0)

here is SQL log

101111 17:54:22 InnoDB: Starting shutdown...
101111 17:54:23 InnoDB: Shutdown completed; log sequence number 0 43705
101111 17:54:23 [Note] /usr/libexec/mysqld: Shutdown complete

101111 17:54:23 mysqld ended

101111 17:54:23 mysqld started
101111 17:54:23 [Warning] option 'max_join_size': unsigned value 18446744073709551615 adjusted to 4294967295
101111 17:54:23 [Warning] option 'max_join_size': unsigned value 18446744073709551615 adjusted to 4294967295
101111 17:54:23 InnoDB: Started; log sequence number 0 43705
101111 17:54:23 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.0.77' socket: '/var/lib/mysql/mysql.sock' port: 3306 Source distribution


Her is my message log

Nov 11 17:54:39 ks32703 mydns[11774]: Error connecting to MySQL server at localhost: Access denied for user 'ispconfig'@'localhost' (using password: YES) (errno=0)
Nov 11 17:54:39 ks32703 named[3591]: shutting down: flushing changes
Nov 11 17:54:39 ks32703 named[3591]: stopping command channel on 127.0.0.1#953
Nov 11 17:54:39 ks32703 named[3591]: no longer listening on 127.0.0.1#53
Nov 11 17:54:39 ks32703 named[3591]: no longer listening on 213.251.162.200#53
Nov 11 17:54:39 ks32703 named[3591]: exiting
Nov 11 17:54:41 ks32703 named[11819]: starting BIND 9.3.6-P1-RedHat-9.3.6-4.P1.el5_4.1 -u named
Nov 11 17:54:41 ks32703 named[11819]: adjusted limit on open files from 1024 to 1048576
Nov 11 17:54:41 ks32703 named[11819]: found 1 CPU, using 1 worker thread
Nov 11 17:54:41 ks32703 named[11819]: using up to 4096 sockets
Nov 11 17:54:42 ks32703 named[11819]: loading configuration from '/etc/named.conf'
Nov 11 17:54:42 ks32703 named[11819]: using default UDP/IPv4 port range: [1024, 65535]
Nov 11 17:54:42 ks32703 named[11819]: using default UDP/IPv6 port range: [1024, 65535]
Nov 11 17:54:42 ks32703 named[11819]: no IPv6 interfaces found
Nov 11 17:54:42 ks32703 named[11819]: listening on IPv4 interface lo, 127.0.0.1#53
Nov 11 17:54:42 ks32703 named[11819]: listening on IPv4 interface eth0, 213.251.162.200#53
Nov 11 17:54:42 ks32703 named[11819]: command channel listening on 127.0.0.1#953
Nov 11 17:54:42 ks32703 named[11819]: the working directory is not writable
Nov 11 17:54:42 ks32703 named[11819]: running
Nov 11 17:59:32 ks32703 mydns[12314]: Error connecting to MySQL server at localhost: Access denied for user 'ispconfig'@'localhost' (using password: YES) (errno=0)
Nov 11 18:04:37 ks32703 clamd[11673]: No stats for Database check - forcing reload


I have uninstall, installed and updated allowing to reconfigure services on the updates.

before i re did it all, i even went into mydns.conf and changed the database logon password from what was in the phpmyadmins table, which i had changed with "password" instead of MD5. This in theory should have been the same password and i still get this error.

Please help

Lee


Edit;

Ok i got it working buy following http://www.howtoforge.com:8080/insta...-centos-5.1-p2


Now the DNS is messed up,
; <<>> DiG 9.3.6-P1-RedHat-9.3.6-4.P1.el5_4.1 <<>> lahtechnologies.com
;; global options: printcmd
;; Got answer:
;; ->>HEADER<<- opcode: QUERY, status: REFUSED, id: 12434
;; flags: qr rd; QUERY: 1, ANSWER: 0, AUTHORITY: 0, ADDITIONAL: 0

;; QUESTION SECTION:
;lahtechnologies.com. IN A

;; Query time: 2 msec
;; SERVER: 127.0.0.1#53(127.0.0.1)
;; WHEN: Thu Nov 11 22:42:09 2010
;; MSG SIZE rcvd: 37

As you can see it should have a lot more info than that

Last edited by Dextros; 11th November 2010 at 23:46.
Reply With Quote
Sponsored Links
  #2  
Old 12th November 2010, 09:13
Ghostdare Ghostdare is offline
Senior Member
 
Join Date: Aug 2009
Location: Europe - Romania - Bucharest
Posts: 146
Thanks: 10
Thanked 22 Times in 22 Posts
Default

I see that you have installed BIND and MyDNS on your server, and i think that ISPConfig is using BIND, so start configure your zone in ISPConfig pannel.
Reply With Quote
  #3  
Old 12th November 2010, 15:15
falko falko is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 41,701
Thanks: 1,900
Thanked 2,741 Times in 2,575 Posts
Default

ISPConfig 3 supports both MyDNS and BIND.

It seems as if BIND is already running. Can you post the output of
Code:
netstat -tap
?
__________________
Falko
--
Download the ISPConfig 3 Manual! | Check out the ISPConfig 3 Billing Module!

FB: http://www.facebook.com/howtoforge

nginx-Webhosting: Timme Hosting | Follow me on:
Reply With Quote
  #4  
Old 12th November 2010, 18:30
Dextros Dextros is offline
Junior Member
 
Join Date: Jan 2010
Posts: 11
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Please find below;

[root@ks32703 ~]# netstat -tap
Active Internet connections (servers and established)
Proto Recv-Q Send-Q Local Address Foreign Address Stat e PID/Program name
tcp 0 0 *:imaps *:* LIST EN 3469/couriertcpd
tcp 0 0 *op3s *:* LIST EN 3481/couriertcpd
tcp 0 0 localhost.localdomain:10024 *:* LIST EN 5912/amavisd (maste
tcp 0 0 localhost.loc:commplex-main *:* LIST EN 5250/rtorrent
tcp 0 0 localhost.localdomain:10025 *:* LIST EN 27293/master
tcp 0 0 *:mysql *:* LIST EN 3375/mysqld
tcp 0 0 *penvpn *:* LIST EN 3193/openvpn
tcp 0 0 *op3 *:* LIST EN 3475/couriertcpd
tcp 0 0 localhost.local:dyna-access *:* LIST EN 3289/clamd
tcp 0 0 *:imap *:* LIST EN 3462/couriertcpd
tcp 0 0 *:webcache *:* LIST EN 3564/httpd
tcp 0 0 *:http *:* LIST EN 3564/httpd
tcp 0 0 *:tproxy *:* LIST EN 3564/httpd
tcp 0 0 *:51026 *:* LIST EN 5250/rtorrent
tcp 0 0 ks32703.kimsufi.com:domain *:* LIST EN 28745/named
tcp 0 0 localhost.localdomai:domain *:* LIST EN 28745/named
tcp 0 0 *:6933 *:* LIST EN 5231/rtorrent
tcp 0 0 *:ftp *:* LIST EN 3578/pure-ftpd (SER
tcp 0 0 *:ssh *:* LIST EN 3272/sshd
tcp 0 0 localhost.localdomain:rndc *:* LIST EN 28745/named
tcp 0 0 *:smtp *:* LIST EN 27293/master
tcp 0 0 *:https *:* LIST EN 3564/httpd
tcp 0 24226 ks32703.kimsufi.com:56732 119-224-76-251.callpl:57777 ESTA BLISHED 5250/rtorrent
tcp 0 0 localhost.localdomain:mysql localhost.localdomain:52923 ESTA BLISHED 3375/mysqld
tcp 0 163564 ks32703.kimsufi.com:51128 94.123.208.149:60000 ESTA BLISHED 5250/rtorrent
tcp 0 1084 ks32703.kimsufi.com:ssh 5e006322.bb.sky.com:50902 ESTA BLISHED 6141/0
tcp 0 499560 ks32703.kimsufi.com:52099 c-68-61-147-179.hsd1.:17482 ESTA BLISHED 5250/rtorrent
tcp 0 0 localhost.localdomain:58948 localhost.localdomain:mysql ESTA BLISHED 5921/amavisd (ch9-a
tcp 0 0 localhost.localdomain:mysql localhost.localdomain:58948 ESTA BLISHED 3375/mysqld
tcp 0 0 localhost.localdomain:52923 localhost.localdomain:mysql ESTA BLISHED 5920/amavisd (ch10-
tcp 0 65160 ks32703.kimsufi.com:39741 5e049167.bb.sky.com:29180 ESTA
Reply With Quote
  #5  
Old 12th November 2010, 20:48
Dextros Dextros is offline
Junior Member
 
Join Date: Jan 2010
Posts: 11
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Woot, its worki,g...to a fasion.

Bind is not off and gone, mydns has taken over.

Now, when i installed ispconfig (updated) it didnt merge with mydns.

So what i have had to do is use the new database called mydns and import the data from rr and soa in mydns to that it works.

Is there a way to do this automatically?
Reply With Quote
  #6  
Old 13th November 2010, 12:35
falko falko is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 41,701
Thanks: 1,900
Thanked 2,741 Times in 2,575 Posts
Default

Please uninstall BIND. The next time you upgrade ISPConfig, the installer will see that you have MyDNS installed and configure ISPConfig accordingly.
__________________
Falko
--
Download the ISPConfig 3 Manual! | Check out the ISPConfig 3 Billing Module!

FB: http://www.facebook.com/howtoforge

nginx-Webhosting: Timme Hosting | Follow me on:
Reply With Quote
  #7  
Old 13th November 2010, 18:17
Dextros Dextros is offline
Junior Member
 
Join Date: Jan 2010
Posts: 11
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Thank you for you help, unfortunately that did not solve the problem,

When i point mydns to dbispconfig data base it gives the following error,


Starting mydns: mydns[2805]: Required table `soa' in database `dbispconfig' not found or inaccessible
mydns[2805]: Do you need to create the tables in the `dbispconfig' database?
mydns[2805]: You can run `mydns --create-tables' to output appropriate SQL commands


Copy of mydns.conf


## /etc/mydns.conf


# DATABASE INFORMATION

db-host = localhost # SQL server hostname
db-user = root # SQL server userna
db-password = christian1 # SQL server password
database = mydns # MyDNS database name


# GENERAL OPTIONS

user = nobody # Run with the permissions of this user
group = nogroup # Run with the permissions of this group
listen = * # Listen on these addresses ('*' for all)


# CACHE OPTIONS

zone-cache-size = 1024 # Maximum number of elements stored in the zone cache
zone-cache-expire = 60 # Number of seconds after which cached zones expires
reply-cache-size = 1024 # Maximum number of elements stored in the reply cache
reply-cache-expire = 30 # Number of seconds after which cached replies expire

:
# ESOTERICA

log = LOG_DAEMON # Facility to use for program output (LOG_*/stdout/stderr)
pidfile = /var/run/mydns.pid # Path to PID file
timeout = 120 # Number of seconds after which queries time out
multicpu = 1 # Number of CPUs installed on your system
allow-axfr = no # Should AXFR be enabled?
allow-tcp = yes # Should TCP be enabled?
ignore-minimum = no # Ignore minimum TTL for zone?
soa-table = soa # Name of table containing SOA records
rr-table = rr # Name of table containing RR data

Last edited by Dextros; 13th November 2010 at 19:04.
Reply With Quote
  #8  
Old 14th November 2010, 00:40
Dextros Dextros is offline
Junior Member
 
Join Date: Jan 2010
Posts: 11
Thanks: 0
Thanked 0 Times in 0 Posts
Default

I swear im not trying to annoy you guys

I cant seem to load php pages under peoples account.

Any clues?
Reply With Quote
  #9  
Old 14th November 2010, 19:50
falko falko is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 41,701
Thanks: 1,900
Thanked 2,741 Times in 2,575 Posts
Default

Quote:
Originally Posted by Dextros View Post
soa-table = soa # Name of table containing SOA records
rr-table = rr # Name of table containing RR data
The tables are named dns_soa and dns_rr.


Quote:
I cant seem to load php pages under peoples account.
Any errors in Apache's error log?
Which PHP mode do you use?
__________________
Falko
--
Download the ISPConfig 3 Manual! | Check out the ISPConfig 3 Billing Module!

FB: http://www.facebook.com/howtoforge

nginx-Webhosting: Timme Hosting | Follow me on:
Reply With Quote
  #10  
Old 14th November 2010, 19:53
Dextros Dextros is offline
Junior Member
 
Join Date: Jan 2010
Posts: 11
Thanks: 0
Thanked 0 Times in 0 Posts
 
Default

Hi Falko, i know thats what they are called, but the update.php doesnt seem to be updating mydns.

Is there a way i can tall it to look for the tables in dbispconfig rather than it looking for standard soa and rr?

Also no errors in apache, but im still working on figuring that out.
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
mydns failing daily csabo General 5 20th October 2010 19:54
MyDNS fails to start tristanlee85 Installation/Configuration 11 16th March 2010 15:49
ipsconfig3 on Lenny how-to troubles | myDNS tomdavidson Installation/Configuration 3 7th November 2009 19:33
mydns problem uvbnserved Server Operation 3 28th April 2009 16:46
mydns settings/help believo General 1 26th January 2009 12:49


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


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