Ubuntu Servers :: Update DHCP Leased File To PowerDNS MySQL DB?
Mar 2, 2010I setup PowerDNS for my local system following
[URL]
How can I update client info from DHCPd leased file to PDNS MySQL for lookup/reverse my network?
ADVERTISEMENT
Networking :: Installed Mysql As The Backend To PowerDNS?
Mar 17, 2011I am marking this solved because I believe it is posted in the wrong forum. I will repost in Software. Sorry for the mistake. I have a small website that I want to host from home. I'm able to access it through the public IP but have not been successful in setting up the zones in PowerDns using PowerAdmin to resolve the domain name. I have read several sites regarding the issue but I still have no success. I'm hoping someone may be able to help with editing my master zone in order to resolve the domain name. I am using CentOS 5.5 to host the site and I've installed mysql as the backend to PowerDNS.
View 3 Replies View RelatedUbuntu Servers :: Slave DHCP And DynamicDNS Can't Update Record
Nov 29, 2010I setup 2 servers for DHCP and DDNS failover. But I see only Master DNS can update to db. file. When I disconnect Master, the Slave can release new IP to client but can't update record to db. file.
Error:
Code:
bdc named[878]: client 192.168.100.2#36203: signer "rndc-key" denied
Nov 28 22:42:22 bdc named[878]: client 192.168.100.2#36203: update forwarding 'systeminteg.com/IN' denied
[Code]....
Ubuntu Servers :: Update Process (and I) Can't Stop Mysql?
Mar 10, 2010I'm running an update, and get this:
Code:
The following packages will be upgraded:
apache2 apache2-doc apache2-mpm-prefork apache2-utils apache2.2-common libcupsys2 libmysqlclient15-dev linux-libc-dev mysql-server
mysql-server-5.0 php5-imap sudo
12 upgraded, 0 newly installed, 0 to remove and 0 not upgraded.
5 not fully installed or removed.
[Code]...
Ubuntu Servers :: DHCP Server And DHCP Client Simultaneously?
Aug 4, 2010I have an embedded device for which I've created an html configuration page. This page allows you to set static IPs, dhcp, and can scan for wireless devices.My problem is that in order to access the device it requires that it runs as a dhcp server otherwise people are not assigned an IP and so can not access the embedded devices static IP. (This config page is for the laymen and so they are not the type who are able to set up their own static IPs). One of the potential options is to have the device connect to the network on eth0 acting as a dhcp client. However this prevents me from running a dhcp server.One solution I can think of is running a dhcp server only if it doesn't detect another dhcp server running on the network.
View 4 Replies View RelatedUbuntu Servers :: DHCP And DHCP Client Simultaneously?
Oct 31, 2010I have an embedded device for which I've created an html configuration page. This page allows you to set static IPs, dhcp, and can scan for wireless devices. My problem is that in order to access the device it requires that it runs as a dhcp server otherwise people are not assigned an IP and so can not access the embedded devices static IP. (This config page is for the laymen and so they are not the type who are able to set up their own static IPs). One of the potential options is to have the device connect to the network on eth0 acting as a dhcp client. However this prevents me from running a dhcp server. One solution I can think of is running a dhcp server only if it doesn't detect another dhcp server running on the network. However I have no idea how this could be setup.
View 2 Replies View RelatedSoftware :: Update Csv File Into Mysql Db Via Bash Script?
Jan 12, 2010I have a csv file that has a upc code and a qty (inventory). I need to insert it into my mysql table, but the table has several columns including upc, qty, price, etc. point me in the right direction to getting this done? Hopefully I can have a handy script when I'm done and all I do is run that script. I just want to make sure we don't delete the description, price, etc stuff and only update qty, using the upc code as the identifier so that the right qty get's input into the table.
View 4 Replies View RelatedUbuntu Servers :: Trying To Insert JPG File Into MySQL Table
Mar 12, 2011I would like to store JPG files in a mysql database table. I figured that using BLOB fields on the one hand and the 'load_file' command on the other would do the trick. Here is how I set up the table:
mysql> create table blobtable (id int(10) not null auto_increment,
fileName varchar(15) not null,
file longblob not null, primary key(id) );
Query OK, 0 rows affected (0.51 sec)
Then I tried to enter the data:
mysql> insert into blobtable(filename,file)values('pic',load_file('/var/www/temp/IMGP4764.JPG'));
Which got me the following error signal:
ERROR 1048 (23000): Column 'file' cannot be null
It seems to me that the file path to the JPG file (although correct) is the source of the problem, and is causing the load_file command not to work. My first attempt was with the JPG file in my PC's home directory. When that returned the same error message, I figured that maybe the file had to be in the PC's (server's) web area so I put it under the 'www' directory.
Ubuntu Servers :: Backup MySQL To A Date Named File?
Sep 23, 2010I am manually backing up my server now with mysqldump and that works but I was wondering about mechanizing the process.
Nirvana would be to dump to a file named with the date
This way I have backups going back over time
Ubuntu Servers :: MySQL Incremental Backup - Binary Log File Names
Mar 15, 2011I am currently using a script to backup my Ubuntu 10.04.1 system. The mySQL databases are backed up separately from the the system / data.
My problem is with the mySQL incremental / binary log backups.
The problem is that the binary log file(s) are always named xxxx-bin.1.
Up to about a month ago the binary logs were named xxxx-bin.000001, xxxx-bin.000002, etc.
I did make some changes at about the time that this change in file naming ocurred, but I can not identify what, if any, setting I may have changed that has caused all of the binary log files to always have the same name.
My back up script uses both mysqldump and mysqladmin flush-logs to create the binary logs.
All of the setting for mysqldump and mysqladmin are contained in the my.cnf file.
The my.cnf file contents that are relavent are as follows:
Code:
The statements in the backup script that do the backup are:
mysqladmin flush-logs
or
mysqldump | gzip > $DB_BACKUP_DIR/$ARCHIVE_FILE #Note: delete-master-logs in my.cnf
Ubuntu Servers :: Separate Virtual Machines For Apache, Mysql, File Server?
Jul 11, 2011I'm working on a side project where I would like to install three ubuntu server systems,each with only one task.So server0 would be the apache server, server1 would be the database and server2 would be the file server.which key terms I should be researching?
View 9 Replies View RelatedUbuntu Servers :: Mysql Error Stopping MySQL Database Server Mysqld?
Jun 17, 2010I have installed Mysql in Ubuntu 9, for the use of roundcube database.After installing iam getting the error like this
* Stopping MySQL database server mysqld [ OK ]
* Starting MySQL database server mysqld [ OK ]
* Checking for corrupt, not cleanly closed and upgrade needing tables.
So because of this in the roundcube configuration its giving the error message that MYSQL is not installed. So Kindly give me a idea how to solve this.
Ubuntu Servers :: Mysql ERROR 1045 \ Trying To Allow Remote Access To Mysql?
Jan 14, 2011i was trying to allow remote access to mysql by following mysql was running perfectly until i got here :
Code:
/sbin/iptables -A INPUT -i eth0 -s 192.168.1.0/24 -p tcp --destination-port 3306 -j ACCEPT
i changed my.cnf bind-address line to : "bind-address = 127.0.0.1" and nothing
[code]....
Networking :: ADSL & Connects To Internet Via Leased Line
Jan 20, 2011i have a leased line ( speed 2 MB ) which we use to connect to our mail server , oracle ERP etc.. we have a dhcp scope defined as 192.168.100.1-192.168.101.254. with a default gateway as 192.168.100.90 ( which is a cisco router ) we have a pix firewall ( 192.168.100.10 ).. now the gateway passed all the request to firewall..
we have an ADSL of 4 MB speed.. ip is 83.*.*.230 from ISP. i have a proxy server ( squid ) eth0 is connected to ISP (83.*.*.230).. eth1 to LAN ( 192.168.100.79 ) now the problem is when i put default gateway to eth1 ie 192.168.100.90 the squid connects to internet via leased line.. if i leave the default gateway field empty on eth1 , the squid connects to internet via ADSL ( which i want ) but the problem is no one on the lan cant ping the squid server ( no connectivity to internet for the whole LAN ) how can i solve this problem? i want squid to connect to internet with ADSL, but if i put gateway on eth1 ie LAN squid goes through leased line which i dont want to happen.
Debian :: Get Mysql To Update From Lenny (mysql-5.0) To Squeeze (5.1)?
Aug 20, 2010I can't get mysql to update from lenny (mysql-5.0) to squeeze (5.1). apt tries to start the server but comes up with some kind of configuration script error.
View 1 Replies View RelatedUbuntu Servers :: Windows DHCP Server - Multiple Boot Servers ?
Apr 1, 2011I'm curious if anybody can shed some light for me in this department. We're in a large environment with a Windows DHCP Server. We have been tinkering with LTSP on Edubuntu as thin and fat clients. It works great, but right now we just have 1 server handling the lab, which works fine unless we want to expand, which may be very possible.
These are the instructions I received:
Login to your windows server and load the DHCP configuration screen
Create a DHCP reservation for the MAC address you obtained
Add the configuration options below to enable the machine to boot from the LTSP server
017 Root Path: /opt/ltsp/i386
066 Boot Server Host Name: <ip address>
067 Bootfile Name: ltsp/arch/pxelinux.0 # Specify CPU architecture in place of 'arch', for instance 'i386'
From: [url]
I'm curious, what if I want to have multiple Ubuntu servers on the network that I want to have bootable? For example, let's say I have 3 labs, and 3 servers. Server A to Lab A, Server B to Lab B, and Server C to Lab C. I want all C's computers to boot to C, and B to B, A to A, etc.
1 - How would I add multiple entries on the Windows DHCP Server to allow all 3 (A B C) servers to boot?
2 - How would I be able to isolate the clients so ONLY Lab A clients boot to Server A, etc?
Fedora Servers :: Build A F12 Cluster To Run DHCP On Top Of Two Servers Using Pacemaker And Drbd?
Apr 28, 2010I'm trying to build a Fedora 12 cluster to run DHCP on top of two servers using pacemaker and drbd. The pacemaker runs great but i'm having the hardest time getting DRBD installed.
My kernel version is 2.6.32.11-99.fc12.i686.PAE First i tried to [root@dhcp-primary drbd]#yum install drbd this doesn't give me everything because apparently the kernel module for DRBD must be built from source. so i unpacked drbd-8.3.6.tar.gz and tried :
[Code]...
I'm not very experienced in compiling from source i'd love to make an rpm for this but after scouring the web and trying different install methods, I am still at a loss.
Software :: Install PowerDNS And Poweradmin On CentOS 5.5?
Dec 31, 2010I am trying to install PowerDNS (With MySQL Backend) And Poweradmin on CentOS 5.5.I have set up a LAMP stack using the default CentOS RPMs briefly as
Code:
yum groupinstall "Web Server" "MySQL Database"
yum install php* mysql* httpd*
These are the packages involved:
Quote:
MySQL5.0.77-4
PHP5.1.6-27
PowerDNS Authoritative Server 2.9.22
[Code]...
OpenSUSE :: MySql Won't Start / No File Mysql.sock?
Feb 5, 2009I thought that the problem is in the phpMyAdmin not in the mysql. But now i think different. It seems that the problem is right in the mysql. I think that there was no root user, when mysql was freshly installed. Unfortunately i did everything i can find on internet (some tutorials) but they don`t helped me at all, maybe i fu**ed up the mysql service. So i reinstalled it, and when i want to start it there is no file mysql.sock and i get the following:
linux-nepg:~ # service mysql restart
Restarting service MySQL
Shutting down service MySQL done
Starting service MySQL warning: /var/lib/mysql/mysql.sock didn't appear within 30 seconds
Software :: Unable To Properly Configure PowerDNS / Won't Resolve Domain Name
Mar 17, 2011I am using CentOS 5.5 and have installed PowerDNS with MySQL backend. I have Apache and PHP installed and I'm using PowerAdmin to create the master zone.I have tried to configure the zone to resolve my domain name and I have had no success.I've googled and read tutorials and have tried suggested methods, but it's still not working.This is a new adventure for me and I would like to be able to host a site from my home for experimental purposes. I am a mature (read OLD) student enrolled in Networking and have done some units in Web Design (though I'm not very good at it).
View 7 Replies View RelatedNetworking :: How To Update DHCP
Jun 1, 2010I have DHCP server running on CentOS-5.4.The dhcp version is 3.0.5 In the dhcpd.conf file I want to use "update-conflict-detection". But, when I add the line as
Code:
update-conflict-detection false;
and after saving the file when I restart dhcpd, it fails. I read somewhere that dhcp version 3.1.x supports my requirement. Is it required to update dhcp? If yes, how can I update?
Fedora Servers :: Mysql At Boot Time In 10 / Get Mysql To Start At Boot?
Jul 28, 2009I am trying to get mysql to start at boot without any success.
The mysqld scripts works fine when run from the command line, but it does not work when i use the links created by chkconfig. I checked the boot.log and found that mysql starts but then it stops or gets shutdown. This is the log message:
Starting mysqld daemon with databases from /data/mysql [ OK ]
Starting cups: [ OK ]
STOPPING server from pid file /var/run/mysqld/mysqld.pid
starting DenyHosts: /usr/bin/denyhosts.py --daemon --config=/usr/share/denyho
sts/denyhosts.cfg
090727 04:35:47 mysqld ended
The same init script works fine in Ubuntu.
Ubuntu Networking :: DHCP Update Killed Internet Connection?
Jan 30, 2010I've been connecting to the Internet via Ubuntu 8.10 on my Toshiba laptop fine for ages now, but today it has stopped working. Yesterday an update came through relating to DHCP and, like all other updates, I installed it. And now my laptop can see the wireless router but it cannot connect to the Internet. (As I always install the recommended Ubuntu updates I didn't look closely at exactly what the update said, but I did see DHCP in the title, so this is why I suspect my connection is now broken.) Or can anyone tell me how to undo yesterday's update? I really wish now that Ubuntu had a utility similar to Windows System Restore.
View 2 Replies View RelatedUbuntu Servers :: Logwatch On 10.04 Dhcp?
Jun 16, 2010i was wondering if there is anybody out there who has logwatch running and configured to just grab dhcp leases only
View 3 Replies View RelatedUbuntu Servers :: Unable To Get IP From The Dhcp?
May 1, 2011I am setting up dhcp server for my public library and need to divide clients into a number of pools on the same network. The different ranges will be for different filtering requirements via squid/dansguard proxy. I have inhouse clients: staff, adult patron, and child patron, that have different filtering requirements and wireless guests that I want to shorter lease times to handle the rapid turnover rate. Trying to understand the terse manual, you assign pools via allow/deny members of classes, but classes are assigned by matching on mac address or vendor ids. Unfortunately as a poor rural library we have a hodge-podge of hardware with no matchable pattern. So I can solve the inhouse clients by using fixed-address, and remove them from the dynamic pool. Now the dhcp server would be serving only the short term wireless guests from the pool.
A common problem at libraries, you always get a few that are compelled to misbehave and break the libraries TOS. In the past the librarians would kick the offenders out of the library only to have them link in from the step or parking lot. Since I have their mac address in their initial lease I would like to prevent them from reestablishing a connection when they are banned.
My thinking is this; the library's computers are static and not part of the pool, the wireless clients would be unknown-clients, so set the pool to allow only unknown-clients, and for the "bad-boys" add their hosts in a group directive would make them "known" and therefore unable to get a IP from the dhcp server.
group {
host banned1 { hardware ethernet 00:00:00:00:00:01; }
host banned2 { hardware ethernet 00:00:00:95:a6:c1; }
host banned3 { hardware ethernet 0c:f1:b6:fe:00:01; }
}
[Code]....
Ubuntu Servers :: Setting Up DHCP After Install
Feb 15, 2010Due to me not remembering how my father set up the DHCP in my FreeBSD server (Files etc) i could not input the corrent info while i was installed Ubuntu 8.04 (LTS) server edition (32 bit). Could anyone be nice enough to tell me what i need to do, or what files to edit so i can access the internet from it?
View 9 Replies View RelatedUbuntu Servers :: Dnsmasq DHCP Nor DNS Working?
Jun 11, 2010I have been rtying for a couple of days now to set up a local dns/dhcp server with dnsmasq on a ubunut server 10.04 I followed the basic instructions from several websites, starting with the ubuntu community one, didnt work, then tried some other, and nothing.
In the server the dns works, i test with dig example.com and i can see the time difference, so dns is working. so the problem is not making the dns work but to make the server listen for dns and dhcp resquests and respond to them.
I have desactivated the dhcp from the router so thats not the problem. making a windows box ping the server works, so the network is configured correctly.
dnsmaq is listed as "LISTEN" on netstat, i read in some blog that it should be using ports 67 and 68 but those are no listed, neither i configured them in any moments, none of the instructions i followed mentioned sth about that. i even tried configuring the window box with the ips and dns accordingly and that wouldnt work either.
so in conclusin i have dnsmasq that does have dns set up but wont answer to any requests of either DNS nor DHCP.
Ubuntu Servers :: DHCP And Static IP's Dual NIC's?
Aug 28, 2010I'm have a number of ubuntu servers that all have dual nics.One interface is used to assign a static public ip and the other is used to assign a static internal IP that can be used on the internal network.The interfaces pull IP's from completely separate gateways on different networks.The problem I face now it that our internal network is moving everything to DHCP on the internal side.I can configure my /etc/network/interfaces so that I can get a public static Ip and a private DCHP, but the problem is that the public IP no longer functions for any services.here is an example of my interfaces
Code:
# The primary network interface
auto eth0
[code]....
Ubuntu Servers :: Install On A Non-DHCP Network?
Feb 8, 2011I'm trying to install Ubuntu server on an older 05-06 Desktop (IBM) and when I get to the Configuration part it stops right around 95% and the prompt reads that configuration failed do to the fact that my unit is running a non DHCP Network or my machine is two slow. Now it does only have 1 gig in it right now so I'm thinking that might be the problem also. But if it is a DHCP issue how can I install UBUNTU or is it even possible?
View 9 Replies View RelatedUbuntu Servers :: How To Setup A Dhcp Server
May 30, 2011Ive tried on multiple occasions to setup a dhcp server, but all the google searches return legitimate results it seems, and ill set everything up, except the last few instructions i have to configure /etc/dhcp3/dhcpd.conf and /etc/default/dhcp3-server, but ubuntu says its not there.Im running Ubuntu Server 11.04 and using nano to edit files
View 4 Replies View Related