find /var/www/proximity_upload_server_php/web/upload/proximity/*.csv -type f -cmin +60 -delete
Monday, May 21, 2018
Thursday, May 17, 2018
copy mongo collection to another db
db.advertisement1.find().forEach(function(d){ db.getSiblingDB('byrouter_ad_content')['advertisement1'].insert(d); });
Thursday, March 22, 2018
Yii2 mongo db group by count example
$collection = Yii::$app->mongodb->getCollection('collectionname');
$callingstationidCount = $collection->aggregate([
array('$group' => array(
'_id' => '$columnname',
'count' => array('$sum' => 1)
))
]
);
$callingstationidCount = $collection->aggregate([
array('$group' => array(
'_id' => '$columnname',
'count' => array('$sum' => 1)
))
]
);
Thursday, January 11, 2018
What are the supported RADIUS attributes in CoovaChilli Captive Portal
Its been running on my pf platform for months.
Chilli uses RADIUS to provision access and to provide accounting.
Direction of Input and Output
The original ChilliSpot defined input and output as being data uploaded and downloaded by the client respectively. Uses the reverse meaning (per default) making it more compatible with some other commercial access controllers.
In RFC 2866, it says:
Acct-Input-Octets
This attribute indicates how many octets have been received from the port over the course of this service being provided.
Acct-Output-Octets
This attribute indicates how many octets have been sent to the port in the course of delivering this service.
However, this is not very conclusive as it depends on what side of the port you are referring to. In the manual for a popular commercial access controller, is says:
Acct-Input-Octets
Number of octets/bytes received by the customer.
Acct-Output-Octets
Number of octets/bytes sent by the customer.
This is the definition adopted by CoovaChilli - one of the very first changes made to ChilliSpot, for use with back-end systems also supporting commercial access controllers.
Access Provisioning
The following RADIUS attributes are used to place limits on a session authorized by a RADIUS Access-Accept response:
Session-Timeout = seconds
Standard RADIUS attribute (defined in RFC 2865) for setting the maximum session timeout. The user is logged out after this amount of time; session duration.
Idle-Timeout = seconds
Standard RADIUS attribute (defined in RFC 2865) for setting the maximum idle timeout. The user is logged out after this amount of time of inactivity (no traffic).
ChilliSpot-Max-Input-Octets = bytes
ChilliSpot-Max-Output-Octets = bytes
ChilliSpot-Max-Total-Octets = bytes
Chilli vendor specific attributes for setting the max in, out, or total bytes transferred for the session. See above for the meaning of input and output.
WISPr-Bandwidth-Max-Up = bits/second
WISPr-Bandwidth-Max-Down = bits/second
WISPr vendor specific attributes for setting the maximum bandwidth rate in bits per second.
ChilliSpot-Bandwidth-Max-Up = kbits/second
ChilliSpot-Bandwidth-Max-Down = kbits/second
Chilli vendor specific attributes for setting the maximum bandwidth rate in kbits per second. Internally, chilli multiplies this value by 1000 in converting to bits per second.
In all cases, the ChilliSpot vendor specific attributes override WISPr attribute values. However, using the WISPr attributes is perhaps the more standard way to go.
Session Accounting
In RADIUS Accounting, the following attributes are used to report session statistics:
Acct-Session-Time = seconds
Duration of session in seconds.
Acct-Input-Octets = bytes
Acct-Output-Octets = bytes
The lower 32-bit value of the number of bytes of input and output (see above for a discussion of the meaning of input vs. output).
Acct-Input-Gigawords = gigawords
Acct-Output-Gigawords = gigawords
The upper 32-bit value of the number of bytes of input and output; or how many times the above attributes have rolled-over the 32-bit value.
Acct-Input-Packets = num-packets
Acct-Output-Packets = num-packets
The number of packets carrying input or output octets.
Below you can find the RADIUS Attributes used by chilli and a short description:
Chilli uses RADIUS to provision access and to provide accounting.
Direction of Input and Output
The original ChilliSpot defined input and output as being data uploaded and downloaded by the client respectively. Uses the reverse meaning (per default) making it more compatible with some other commercial access controllers.
In RFC 2866, it says:
Acct-Input-Octets
This attribute indicates how many octets have been received from the port over the course of this service being provided.
Acct-Output-Octets
This attribute indicates how many octets have been sent to the port in the course of delivering this service.
However, this is not very conclusive as it depends on what side of the port you are referring to. In the manual for a popular commercial access controller, is says:
Acct-Input-Octets
Number of octets/bytes received by the customer.
Acct-Output-Octets
Number of octets/bytes sent by the customer.
This is the definition adopted by CoovaChilli - one of the very first changes made to ChilliSpot, for use with back-end systems also supporting commercial access controllers.
Access Provisioning
The following RADIUS attributes are used to place limits on a session authorized by a RADIUS Access-Accept response:
Session-Timeout = seconds
Standard RADIUS attribute (defined in RFC 2865) for setting the maximum session timeout. The user is logged out after this amount of time; session duration.
Idle-Timeout = seconds
Standard RADIUS attribute (defined in RFC 2865) for setting the maximum idle timeout. The user is logged out after this amount of time of inactivity (no traffic).
ChilliSpot-Max-Input-Octets = bytes
ChilliSpot-Max-Output-Octets = bytes
ChilliSpot-Max-Total-Octets = bytes
Chilli vendor specific attributes for setting the max in, out, or total bytes transferred for the session. See above for the meaning of input and output.
WISPr-Bandwidth-Max-Up = bits/second
WISPr-Bandwidth-Max-Down = bits/second
WISPr vendor specific attributes for setting the maximum bandwidth rate in bits per second.
ChilliSpot-Bandwidth-Max-Up = kbits/second
ChilliSpot-Bandwidth-Max-Down = kbits/second
Chilli vendor specific attributes for setting the maximum bandwidth rate in kbits per second. Internally, chilli multiplies this value by 1000 in converting to bits per second.
In all cases, the ChilliSpot vendor specific attributes override WISPr attribute values. However, using the WISPr attributes is perhaps the more standard way to go.
Session Accounting
In RADIUS Accounting, the following attributes are used to report session statistics:
Acct-Session-Time = seconds
Duration of session in seconds.
Acct-Input-Octets = bytes
Acct-Output-Octets = bytes
The lower 32-bit value of the number of bytes of input and output (see above for a discussion of the meaning of input vs. output).
Acct-Input-Gigawords = gigawords
Acct-Output-Gigawords = gigawords
The upper 32-bit value of the number of bytes of input and output; or how many times the above attributes have rolled-over the 32-bit value.
Acct-Input-Packets = num-packets
Acct-Output-Packets = num-packets
The number of packets carrying input or output octets.
Below you can find the RADIUS Attributes used by chilli and a short description:
| Attribute(type) | Description |
| User-name (1) | Full username as entered by the user. |
| User-Password (2) | Used for UAM as alternative to CHAP-Password and CHAP-Challenge. |
| CHAP-Password (3) | Used for UAM CHAP Authentication |
| CHAP-Challenge (60) | Used for UAM CHAP Authentication |
| EAP-Message (79) | Used for WPA Authentication |
| NAS-IP-Address (4) | IP address of Chilli (set by the ‘‘nasip’’ or ‘‘radiuslisten’’ option, and otherwise “0.0.0.0”) |
| Service-Type (6) | Set to Login (1) for normal authentication requests. The Access-Accept message from the radius server for configuration management messages must also be set to Administrative-User. |
| Framed-IP-Address (8) | IP address of the user, which is configurable during MAC authentication in the Access-Accept. |
| Framed-IP-Netmask (9) | IP netmask of the user, which is configurable during MAC authentication in the Access-Accept. |
| Filter-ID (11) | Filter ID pass on to scripts possibly. |
| Reply-Message (18) | Reason of reject if present. |
| State (24) | Sent to chilli in Access-Accept or Access-Challenge. Used transparently in subsequent Access-Request. |
| Class (25) | Copied transparently by chilli from Access-Accept to Accounting-Request. |
| Session-Timeout (27) | Logout once session timeout is reached (seconds) |
| Idle-Timeout (28) | Logout once idle timeout is reached (seconds) |
| Called-Station-ID (30) | Set to the ‘‘nasmac’’ option or the MAC address of chilli. |
| Calling-Station-ID (31) | MAC address of client |
| NAS-Identifier (32) | Set to radiusnasid option if present |
| Acct-Status-Type (40) | 1=Start, 2=Stop, 3=Interim-Update |
| Acct-Input-Octets (42) | Number of octets received from client |
| Acct-Output-Octets (43) | Number of octets transmitted to client. |
| Acct-Session-ID (44) | Unique ID to link Access-Request and Accounting-Request messages. |
| Acct-Session-Time (46) | Session duration in seconds. |
| Acct-Input-Packets (47) | Number of packets received from client. |
| Acct-Output-Packets (48) | Number of packets transmitted to client. |
| Acct-Terminate-Cause (49) | 1=User-Request, 2=Lost-Carrier, 4=Idle-Timeout, 5=Session-Timeout, 11=NAS-Reboot |
| Acct-Input-Gigawords (52) | Number of times the Acct-Input-Octets counter has wrapped around. |
| Acct-Output-Gigawords (53) | Number of times the Acct-Output-Octets counter has wrapped around. |
| NAS-Port-Type (61) | 19=Wireless-IEEE-802.11 |
| Message-Authenticator (80) | Is always included in Access-Request. If present in Access-Accept, Access-Challenge or Access-reject chilli will validate that the Message-Authenticator is correct. |
| Acct-Interim-Interval (85) | If present in Access-Accept chilli will generate interim accounting records with the specified interval (seconds). |
| WISPr-Location-ID (14122, 1) | Location
ID is set to the radiuslocationid option if present. Should be in the format:
isocc=, cc=, ac=, network= |
| WISPr-Location-Name (14122, 2) | Location Name is set to the radiuslocationname option if present. Should be in the format: , |
| WISPr-Logoff-URL (14122, 3) | Included in Access-Request to notify the operator of the log off URL. Defaults to “http://uamlisten:uamport/logoff”. |
| WISPr-Redirection-URL (14122, 4) | If present the client will be redirected to this URL once authenticated. This URL should include a link to WISPr-Logoff-URL in order to enable the client to log off. |
| WISPr-Bandwidth-Max-Up (14122, 7) | Maximum transmit rate (b/s). Limits the bandwidth of the connection. Note that this attribute is specified in bits per second. |
| WISPr-Bandwidth-Max-Down (14122, 8) | Maximum receive rate (b/s). Limits the bandwidth of the connection. Note that this attribute is specified in bits per second. |
| WISPr-Session-Terminate-Time (14122, 9) | The time when the user should be disconnected in ISO 8601 format (YYYY-MM-DDThh:mm:ssTZD). If TZD is not specified local time is assumed. For example a disconnect on 18 December 2001 at 7:00 PM UTC would be specified as 2001-12-18T19:00:00+00:00. |
| ChilliSpot-Max-Input-Octets (14559, 1) | Maximum number of octets the user is allowed to transmit. After this limit has been reached the user will be disconnected. |
| ChilliSpot-Max-Output-Octets (14559, 2) | Maximum number of octets the user is allowed to receive. After this limit has been reached the user will be disconnecte |
| ChilliSpot-Max-Total-Octets (14559, 3) | Maximum total octets the user is allowed to send or receive. After this limit has been reached the user will be disconnected. |
| ChilliSpot-Bandwidth-Max-Up (14559, 4) | Maximum bandwidth up |
| ChilliSpot-Bandwidth-Max-Down (14559, 5) | Maximum bandwidth down |
| ChilliSpot-Config (14559, 6) | Configurations passed between chilli and back-end as name value pairs |
| ChilliSpot-Lang (14559, 7) | Language selected in user interface |
| ChilliSpot-Version (14559, 8) | Contains the version of the running CoovaChilli |
| ChilliSpot-DHCP-Netmask (14559, 61) | DHCP IP netmask of the user, which is configurable during MAC authentication in the Access-Accept. |
| ChilliSpot-DHCP-DNS1 (14559, 62) | DHCP DNS1 of the user, which is configurable during MAC authentication in the Access-Accept. |
| ChilliSpot-DHCP-DNS2 (14559, 63) | DHCP DNS2 of the user, which is configurable during MAC authentication in the Access-Accept. |
| ChilliSpot-DHCP-Gateway (14559, 64) | DHCP Gateway of the user, which is configurable during MAC authentication in the Access-Accept |
| ChilliSpot-DHCP-Domain (14559, 65) | DHCP Domain of the user, which is configurable during MAC authentication in the Access-Accept. |
| MS-MPPE-Send-Key (311,16) | Used for WPA |
| MS-MPPE-Recv-Key (311,17) | Used for WPA |
Thursday, December 21, 2017
httpd server option
Usage: httpd [-D name] [-d directory] [-f file]
[-C "directive"] [-c "directive"]
[-k start|restart|graceful|graceful-stop|stop]
[-v] [-V] [-h] [-l] [-L] [-t] [-T] [-S] [-X]
Options:
-D name : define a name for use in directives
-d directory : specify an alternate initial ServerRoot
-f file : specify an alternate ServerConfigFile
-C "directive" : process directive before reading config files
-c "directive" : process directive after reading config files
-e level : show startup errors of level (see LogLevel)
-E file : log startup errors to file
-v : show version number
-V : show compile settings
-h : list available command line options (this page)
-l : list compiled in modules
-L : list available configuration directives
-t -D DUMP_VHOSTS : show parsed vhost settings
-t -D DUMP_RUN_CFG : show parsed run settings
-S : a synonym for -t -D DUMP_VHOSTS -D DUMP_RUN_CFG
-t -D DUMP_MODULES : show all loaded modules
-M : a synonym for -t -D DUMP_MODULES
-t -D DUMP_INCLUDES: show all included configuration files
-t : run syntax check for config files
-T : start without DocumentRoot(s) check
-X : debug mode (only one worker, do not detach)
Example command for checking included configuration file
Example command for checking included configuration file
httpd -t -D DUMP_INCLUDES
Included configuration files:
(*) /usr/local/etc/httpd/httpd.conf
(505) /usr/local/etc/httpd/extra/httpd-vhosts.conf
x
Thursday, November 2, 2017
ENABLE General logs in MYSQL database
If you were login with root user on mysql database . Use below command enable log SET GLOBAL general_log = 'ON'; command for disable mysql log SET GLOBAL general_log = 'OFF'; Thursday, October 12, 2017
SQLSTATE[HY000]: General error MySQL: 1364 Field 'coloum' doesn't have a default value, how to solve
With the root access of the mysql, do the following changes
select @@GLOBAL.sql_mode
In my case, I get the following:
ONLY_FULL_GROUP_BY, STRICT_TRANS_TABLES ,NO_ZERO_IN_DATE,NO_ZERO_DATE,
ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION
Copy this result and remove
STRICT_TRANS_TABLES. Then perform the following:set GLOBAL sql_mode='ONLY_FULL_GROUP_BY, NO_ZERO_IN_DATE,NO_ZERO_DATE,
ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER, NO_ENGINE_SUBSTITUTION'
brew services start mysql
++++++++++++++++++++++++++++++++++++++How to Disable MySQL Strict Mode?
It’s relatively easy to disable MySQL strict mode in Ubuntu 16.04 LTS. This may work on other versions of Linux such as CentOS. But I’m not testing it. You can let other know if it’s working on the comments section. Start by login in to your VPS as root user with SSH.
Create a new .cnf file.
Paste the following code into that file,
Save and close the file. And then restart MySQL server.
Open your application and errors should have disappeared.
How to Enable MySQL Strict Mode back on?
You can turn strict mode back on in the future if your application become compatible with it. Just deleting the file you created earlier and the restarting MySQL will turn strict mode back on. Following command will delete the file,
Restart MySQL,
That’s it. Feel free to use comments section if you’re having trouble disabling or re-enabling MySQL strict mode.
Subscribe to:
Posts (Atom)