
# cd / usr / ports / databases / mysql51-server / && make install # cd / usr / ports / textproc / expat2 && make install # cd / usr / ports / devel / libtool && make all && make install # cd / usr / ports / security / sudo && make install
# cd / usr / ports / net / isc-dhcp31-server / && make install
# cd / usr / ports / lang / php5 && make install
# cd / usr / ports / lang / php5-extensions / && make config && make install
# fetch http://stg.dp.ua/download/server/2.407-p1/stg-2.407-p1.tar.gz && tar zxvf stg-2.407-p1.tar.gz && cd stg-2.407-p1 / projects / stargazer / && ./build && gmake install # cd ../sgconf && ./build && gmake && gmake install && cd ../sgconf_xml/ && ./build && gmake && gmake install
# cd / usr / local / www / data / # mkdir billing # cd billing # fetch http://ubilling.net.ua/ub.tgz # tar zxvf ub.tgz # chmod -R 777 content / config / multinet / exports / remote_nas.conf vservices.php
# mkdir / etc / stargazer / dn # chmod -R 777 / etc / stargazer / dn # ln -fs / usr / local / www / data / billing / multinet / usr / local / etc / multinet # ln -fs /usr/local/www/data/billing/remote_nas.conf /etc/stargazer/remote_nas.conf # ln -fs / etc / stargazer / dn / usr / local / www / data / billing / content / dn
# /usr/local/etc/rc.d/mysql-server start # /usr/local/etc/rc.d/apache onestart
 LogFile = /var/log/stargazer.log 
 PIDFile = /var/run/stargazer.pid 
 Rules = / etc / stargazer / rules 
 DetailStatWritePeriod = 1/4 
 StatWritePeriod = 10 
 DayFee = 1 
 DayFeeIsLastDay = no 
 DayResetTraff = 1 
 SpreadFee = no 
 FreeMbAllowInet = no 
 WriteFreeMbTraffCost = yes 
 FullFee = yes 
 <DirNames> 
   DirName0 = Internet 
   DirName1 =
   DirName2 = 
   DirName3 = 
   DirName4 = 
   DirName5 = 
   DirName6 = 
   DirName7 = 
   DirName8 = 
   DirName9 = 
 </ DirNames> 
 ExecutersNum = 1 
 ModulesPath = / usr / lib / stg 
 <StoreModule store_mysql> 
   dbhost = localhost 
   dbname = stg 
   dbuser = root 
   rootdbpass = newpassword 
 </ StoreModule> 
 <Modules> 
 <Module auth_ao> 
 </ Module> 
 <Module auth_ia> 
   Port = 5555 
   UserDelay = 60 
   UserTimeout = 65 
   FreeMb = cash 
 </ Module> 
 <Module conf_sg> 
   Port = 5555 
 </ Module> 
 <Module cap_nf>
         TCPPort = 42111
         UDP port = 42111
 </ Module>
 <Module remote_script> 
 SendPeriod = 10
 SubnetFile = / etc / stargazer / remote_nas.conf
 Password = password_for_rscriptd
 UserParams = Cash Tariff
 Port = 9999 
 </ Module>
 </ Modules> 
# echo "ALL 0.0.0.0/0 DIR0"> / etc / stargazer / rules
# echo "172.16.0.0/18 172.16.0.2"> /etc/stargazer/remote_nas.conf
# stargazer # killall stargazer
# mysql -u root -p stg -e "S Enter password: + --------------- + | Tables_in_stg | + --------------- + | admins | | messages | | stat | | tariffs | | users | + --------------- +
User_Alias ​​BILLING = www BILLING ALL = NOPASSWD: ALL
# cd / usr / local / www / data / billing / # cat docs / test_dump.sql | mysql -u root -p stg
#mysql -u root -p stg -e "SHOW TABLES" Enter password: + ----------------- + | Tables_in_stg | + ----------------- + | address | | admins | | ahenassign | | apt | | build | | cardbank | | cardbrute | | cashtype | | cfitems | | cftypes | | city ​​| | contracts | | contrahens | | cpe | | cpetypes | | dhcp | | directions | | dshape_time | | emails | | employee | | jobs | | jobtypes | | messages | | modem_templates | | modems | | nas | | nethosts | | networks | | notes | | payments | | phones | | realname | | services | | servtariff | | speeds | | stat | | street | | switches | | switchmodels | | tags | | tagtypes | | tariffs | | taskman | | userreg | | users | | userspeeds | | vcash | | vcashlog | | vservices | | weblogs | + ----------------- +
baseconf = sgconfxml SGCONF = / usr / sbin / sgconf SGCONFXML = / usr / sbin / sgconf_xml STG_HOST = localhost STG_PORT = 5555 XMLRPC_PORT = 8081 STG_LOGIN = admin STG_PASSWD = new_password_starmin_azer Sudo = / usr / local / bin / sudo TOP = / usr / bin / top -b CAT = / bin / cat Grep = / usr / bin / grep RC_DHCPD = / usr / local / etc / rc.d / isc-dhcpd UPTIME = / usr / bin / uptime Ping = / sbin / ping KILL = / bin / kill STGPID = / var / run / stargazer.pid STGNASHUP = 1 PHPSYSINFO = phpsysinfo / LANG = ua TASKBAR_ICON_SIZE = 128 REGRANDOM_MAC = 1 REGALWONLINE = 1 REGDISABLEDSTAT = 1
# cp -f docs / presets / FreeBSD / etc / stargazer / config / etc / stargazer / # cp -f docs / presets / FreeBSD / etc / stargazer / GetMac / etc / stargazer / # chmod a + x / etc / stargazer / *
#! / bin / sh LOGIN = $ 1 IP = $ 2 CASH = $ 3 ID = $ 4 MAC = `php / etc / stargazer / GetMac $ LOGIN` / usr / sbin / arp -S $ IP $ MAC
host = localhost username = root password = newpassword database = stg
; database host server = "localhost" ; database port port = "3306" ; user login username = "root" ; user password password = "newpassword" ; database name to use db = "stg" character = "UTF8" prefix = "billing"
# stargazer # sgconf_xml -s localhost -p 5555 -a admin -w 123456 -r "<ChgAdmin Login = \" admin \ "Password = \" new_password_admin_stargazer \ "/>"
gateway_enable = "YES" hostname = "billing.isp" ifconfig_em0 = "inet 172.16.0.1 netmask 255.255.192.0" inetd_enable = "YES" keymap = "ru.koi8-r" sshd_enable = "YES" named_enable = "YES" sendmail_enable = "NO" mysql_enable = "YES" apache_enable = "YES" dhcpd_enable = "YES" dhcpd_flags = "- q" dhcpd_conf = "/ usr / local / etc / multinet / dhcpd.conf" dhcpd_ifaces = "em0"
 acl internals {172.16.0.0/18;  };
 acl local {127.0.0.1;  };
 zone "isp" {
     type master;
     file "/ etc / namedb / master / isp";
     allow-query {internals;  local;  };
 };
 $ TTL 86400
 @ IN SOA isp.  admin.isp.  (
                         2011101001;  Serial
                                 8H;  Refresh
                                 1D;  Retry
                                 2W;  Expire
                                 1D);  Negative Cache TTL
         IN NS dns.isp.
 @ IN A 172.16.0.1
 billing IN A 172.16.0.1
 stat IN A 172.16.0.1
 nas1 IN A 172.16.0.2
#! / bin / sh / usr / sbin / stargazer
# chmod a + x /etc/rc.d/billing
NameVirtualHost *: 80 <VirtualHost *: 80> ServerName billing.isp DocumentRoot "/ usr / local / www / data / billing /" AddDefaultCharset utf-8 </ Virtualhost> <VirtualHost *: 80> ServerName stat.isp DocumentRoot "/ usr / local / www / data / billing / userstats /" AddDefaultCharset utf-8 </ Virtualhost>
 option domain-name "isp";
 option domain-name-servers 172.16.0.1;
 default-lease-time 3600;
 max-lease-time 43200;
 authoritative;
 ddns-update-style none;
 log facility local7;
 one-lease-per-client true;
 deny duplicates;
 shared-network ourisp {
 {SUBNETS}
 }




 subnet {NETWORK} netmask {MASK} {
 default-lease-time 3600;
 option domain-name "ourisp";
 option subnet-mask {MASK};
 option routers 172.16.0.2;
 include "/ usr / local / etc / multinet / {HOSTS}";
 }









# cd / usr / src / sys / i386 / conf / # cp GENERIC NAS1
options IPFIREWALL options IPFIREWALL_DEFAULT_TO_ACCEPT options IPFIREWALL_FORWARD options IPFIREWALL_VERBOSE options IPFIREWALL_VERBOSE_LIMIT = 50 options IPFIREWALL_NAT options LIBALIAS options ROUTETABLES = 2 options DUMMYNET
# config NAS1 && cd ../compile/NAS1 && make cleandepend && make depend && make && make install
defaultrouter = "1.2.3.3" gateway_enable = "YES" hostname = "nas1" ifconfig_em1 = "inet 1.2.3.4 netmask 255.255.255.0 -rxcsum -txcsum -tso" ifconfig_em0 = "inet 172.16.0.2 netmask 255.255.192.0 -rxcsum -txcsum -tso" inetd_enable = "YES" sshd_enable = "YES" firewall_enable = "YES" firewall_nat_enable = "YES" dummynet_enable = "YES" firewall_script = "/ etc / firewall.conf" thttpd_enable = "YES" thttpd_enable = "YES"
# cd / usr / ports / www / thttpd / && make install
# cd / usr / ports / net-mgmt / softflowd / && make install
#cd / usr / ports / textproc / expat2 && make install
# cd / usr / ports / net-mgmt / bandwidthd / && make install
# cd / usr / ports / lang / php5 && make install
# cd / usr / ports / lang / php5-extensions / && make config && make install
 #! / bin / sh
 # send netflow to billing server
 / usr / local / sbin / softflowd -i em0 -n 172.16.0.1:42111
 FwCMD = "/ sbin / ipfw -q"
 $ {FwCMD} -f flush
 # user network
 $ {FwCMD} table 2 add 172.16.0.0/18
 # networks which will not be NAT-it
 $ {FwCMD} table 9 add 1.2.3.4/24
 #NAT
 $ {FwCMD} nat 1 config log if em1 reset same_ports
 $ {FwCMD} add 600 nat 1 ip from table \ (2 \) to not table \ (9 \) via em1
 $ {FwCMD} add 601 nat 1 ip from any to 1.2.3.4 via em1
 # default blocking policy
 $ {FwCMD} add 65533 deny all from table \ (2 \) to any via em0
 $ {FwCMD} add 65534 deny all from any to any table \ (2 \) via em0
 $ {FwCMD} add 65535 allow
# chmod a + x /etc/firewall.conf
# fetch http://stg.dp.ua/download/server/2.407-p1/stg-2.407-p1.tar.gz && tar zxvf stg-2.407-p1.tar.gz && cd stg-2.407-p1 / projects / rscriptd / && ./build && gmake install
#! / bin / sh / usr / sbin / rscriptd
#chmod a + x /etc/rc.d/rscriptd
# mkdir ubilling && fetch http://ubilling.net.ua/ub.tgz && tar zxvf ub.tgz && cd ubilling # mkdir / etc / stargazer / dn && chmod a + w / etc / stargazer / dn # cp -f docs / presets / FreeBSD / etc / stargazer / * / etc / rscripd / # chmod a + x / etc / rscriptd / *
IFACE = "em0"
subnet 172.16.0.0/18 dev "em0" output_cdf true recover_cdf true
3 3 * * * / bin / kill -HUP `cat / var / run / bandwidthd.pid`
# mv / usr / local / bandwidthd / htdocs / usr / local / www / data / band # ln -fs / usr / local / www / data / band / / usr / local / bandwidthd / htdocs # cp /usr/local/etc/thttpd.conf.sample /usr/local/etc/thttpd.conf
# / usr / local / bandwidthd / bandwidthd # /usr/local/etc/rc.d/thttpd start
net.inet.ip.fw.one_pass = 1 net.inet.ip.fastforwarding = 1 net.inet.tcp.nolocaltimewait = 1
Source: https://habr.com/ru/post/130937/
All Articles