Designing Linux Server for CMs Provisioning

Hi perse0,

I also stumbled up on this but have not had a look at it.

At this time I played around with the docsis-server: http://users.accesscomm.ca/docsis_server/
the tftp and time-server works fine. I had only a lab-Installation, so I don't know how it works
in the live network.

Yesterday I found a third project, anounced in "Software,Testing,Provsioning":
http://jhthorsen.github.com/quelea/

regards
Benedikt

You don't need to. Most of what you want to do is easiest to do through the provisioning server. The full action of reprovisioning a customer (which I take to mean changing the config file) involves updating the host declaration in the DHCP server to reflect the new config file then rebooting the modem. Here is the modem class I wrote to handle it. Some of it won't make much sense because it is unique to my database schema, but it should give you an idea of how I handle it. [code] class modem{ private $id; public $customer; public $property; public $mac; public $qos; public $provisioned; public $ip; public $status; private $omconn; function __construct($id=NULL){ if(is_numeric($id)){ $this->setID($id); $this->populate(); } } function assign_customer($id){ $this->customer = $id; } function setID($id){ $this->id = $id; } function setMAC($mac){ $this->mac = $mac; } function populate(){ $query = "Select * from modems, qos where modems.qos = qos.`qosID` AND modems.`id` = '{$this->id}'"; $result = mysql_query($query); $row = mysql_fetch_assoc($result); $this->mac = $row['mac']; $this->customer = $row['custID']; $this->qos = $row['qosID']; $this->qosName = $row['name']; $this->provisioned = $row['provisioned']; $this->qosGroup = $row['dhcpdGroup']; $this->up = $row[up]; $this->down = $row[down]; } function status(){ $query = "Select * from Walkdata where mac = '{$this->mac}'"; $result = mysql_query($query) or die(mysql_error()); if(mysql_num_rows($result)) $row = mysql_fetch_assoc($result); $this->ip = $row['ip']; $this->status = $row['status']; $this->prov_status(); } ################################### function set_qos($qos){ $this->qos = $qos; $query = "update modems set qos = '$qos' where id = '{$this->id}'"; mysql_query($query); $this->populate(); $this->log('QOS profile changed to {$this->qosName}'); } function mute(){ $success = $this->deregister(); if($success){ $query = "update modems set provisioned = '0' where id = '{$this->id}'"; mysql_query($query); $this->log('Modem muted'); return 1; } return 0; } function unmute(){ $success = $this->register(); if($success){ $query = "update modems set provisioned = '1' where id = '{$this->id}'"; mysql_query($query); $this->log('Modem unmuted'); return 1; } return 0; } function toggle(){ if($this->provisioned == 1) return $this->mute(); else return $this->unmute(); } function add(){ if(!$this->qos) $this->qos = 1; $this->populate_qos(); $this->register(); $query = "Insert into `modems` (`custID`,`mac`,`qos`,`provisioned`) VALUES ('{$this->customer}','{$this->mac}','{$this->qos}','{$this->provisioned}')"; mysql_query($query) or die(mysql_error()); $this->id = mysql_insert_id(); $this->log('Modem Registered'); return 1; } function delete(){ $this->deregister(); $query = "Delete from `modems` where id = '{$this->id}'"; mysql_query($query) or die(mysql_error()); $this->log('Modem Removed'); return 1; } ################################## function populate_qos(){ $query = "Select * from qos where qosID = '{$this->qos}'"; $result = mysql_query($query); $this->qosGroup = mysql_result($result,0,'dhcpdGroup'); $this->qosName = mysql_result($result,0,'name'); } function log($action){ $query = "Insert into `modem-Transactions` (`modem`,`mac`,`customerID`,`comments`) VALUES ('{$this->id}','{$this->mac}','{$this->customer}','$action')"; mysql_query($query); } function omapi_connect(){ $this->omconn = new omapi_Connection($this->dhcp_Server); } function register(){ if(!$this->omconn) $this->omapi_connect(); $this->omconn->add($this->mac,$this->qosGroup); return $this->prov_status(); } function deregister(){ if(!$this->omconn) $this->omapi_connect(); $this->omconn->delete($this->mac); $this->prov_status(); $this->reboot(); if(!$this->provisioned) return 1; return 0; } function prov_status(){ if(!$this->omconn) $this->omapi_connect(); $status = $this->omconn->query($this->mac); $this->provisioned = isset($status) ? 0 : 1; return $this->provisioned; } function apply_qos($qos = NULL){ if($qos) $this->set_qos($qos); $sucess = $this->deregister(); if(!$success && $this->provisioned) die('Could not unregister modem'); $sucess = $this->register(); if(!$success && !$this->provisioned) die('Could not reregister modem'); $this->reboot(); return 1; } function log_dump(){ if($this->omconn) return $this->omconn->logs; } function reboot(){ if(!$this->ip) $this->status(); exec("/usr/local/bin/modemClient reset {$this->ip} {$this->dhcp_Server}"); $this->log('reboot'); } function query(){ if(!$this->ip) $this->status(); exec("/usr/local/bin/modemClient info {$this->ip} {$this->dhcp_Server}", $live_info); print_r($live_info); } } [/code] If you look at the bottom functions, you can see how I deal with provisioning, unprovisioning and updating modems. muting and unmuting is how I handle nonpay. I change the registration status in the dhcp server, but don't delete it from my master database. To change the modem's provisioning, you use this function: [code] function apply_qos($qos = NULL){ if($qos) $this->set_qos($qos); //if a new qos is defined, update database $success = $this->deregister(); //delete modem declaration from dhcp server if(!$success && $this->provisioned) die('Could not unregister modem'); // if errors were returned and the host declaration is still active, die $success = $this->register(); // register the modem using the new qos. if(!$success && !$this->provisioned) die('Could not reregister modem'); // if errors and the new host declaration does not exist, die $this->reboot(); //reboot the modem so that it can take the new config. return 1; // return success } [/code] To reboot the modem, I call: exec("/usr/local/bin/modemClient reset {$this->ip} {$this->dhcp_Server}"); modemClient is a perl script I wrote that connects to a perl dameon running on the provisioning server. The modemClient script sends the reset command and the modem's ip to the ip specified in $this->dhcp_Server. When the server receives this command, it resets the modem by setting the reset SNMP MIB. I did it this way because most of my sites were behind a WAN interface, so I connect to the system through a public IP. I didn't want to give every modem a public IP, so I just give the provisioning server a public and connect via this daemon.