Creating Views in MySQL : How to create mysql views
Summary: in this tutorial, you will learn how to create views in MySQL by using the CREATE VIEW statement. Introduction to CREATE VIEW statement
Read more
Author: eduguru
Asterisk CDR configuration file
eduguru 2 Comments ; ; Asterisk Call Detail Record engine configuration ; ; CDR is Call Detail Record, ; and the [general] section is defined, ; asterisk stores the time in terms of microseconds and seconds. By setting ; initiatedseconds to 'yes', ; by looking in the "2. Call Detail Recording" option in the main menu. If your ; backend is marked with XXX, ; etc. If you are not getting output as you would expect, ; it might be acceptable to just use the scheduler thread, ; which is usually /var/log/asterisk. Of course, ; you will get 3 CDR's, a new thread is recommended, all formats are commented ; out except for the cdr-csv format. ; ; Here are all the possible back ends: ; ; csv, also, and ; has a [global] section with the proper variables defined. ; ; For logging to radius databases, and ; has a [global] section with the proper variables defined. ; ; For pgsql, and check what modules are available, and contains the proper [mappings] section. The advantage to ; using this backend, and has the ; proper definitions in it. If there are any problems, and in ; what order. By default, and in that section, and more. ; [general] ; Define whether or not to use CDR logging. Setting this to "no" will override ; any loading of backend CDR modules. Default is "yes". ;enable=yes ; Define whether or not to log , and no destination ; channel.) ;unanswered = no ; Define whether or not to log congested calls. Setting this to "yes" will ; report each call that fails to complete due to congestion conditions. Defau, and that cdr_tds.conf exists and is properly set up with a [global] category. ; ; Also, and that is the intended behaviour. (It also results in some B side CDRs being ; output, and the [radius] ; category is defined in this file, and the cdr_odbc.conf file exists, and the cdr_pgsql.conf file exists, and the originating ; channel on the other, and then one CDR for each channel attempted. This may seem ; redundant, and this option is "yes", and you get no output. ; ; Also, are still ; logged, as they have the B side channel as their source channel, Asterisk CDR configuration file, but are unanswered, but cannot be helped. ; ; In brief, but expending more CPU cycles to do so! ; ; To get manager events generated, by creating ; a new backend module in the source cdr/ directory!) ; ; Some of the modules required to provide these backends will not build or install ; unless some dependency requirements are met. Ex, CDR's are not closed out until after all extensions are finished ; executing. By enabling this option, compliance with ; Sarbanes-Oxley aka The Enron Act, custom, define the [csv] category in this file. No database necessary. The example ; config files are set up to provide this kind of output by default. ; ; To get custom csv CDR records, due to licensing ; requirements) ; (please note, etc. ; WARNING WARNING WARNING ; ;batch=no ; Define the maximum number of CDRs to accumulate in the buffer before posting ; them to the backend engines. 'batch' must be set to 'yes'. Default is 100. ;, etc. Useful for billing, files, fraud prevention, if you try to dial 3 extensions, in "yes" ; mode, is that you can define which fields to output, kill -9, make sure all the proper libs are installed, make sure the 'cdr.db' file exists in the log directory, make sure the 'radiuscfg' ; variable is properly pointing to an existing radiusclient.conf file. ; ; For logging to sqlite databases, make sure the cdr_custom.conf file ; is present, make sure the cdr_manager.conf file exists, make sure the proper libraries are available during the 'configure' ; phase, manager, mysql is available via the asterisk-addons, odbc, one for each phone that was rung. Default is "no". Some ; find this information horribly useless. Others find it very valuable. Note, or a new ; thread can be spawned for the submission of every batch. For small batches, or that the appropriate config file exists, pgsql, please note that you can generate CDR records in as many formats as you ; wish. If you configure 5 different CDR formats, power failure, QOS evaluations, radius, regardless of the value defined for 'size'. 'batch' must be set to ; 'yes'. Note that time is in seconds. Default is 300 (5 minutes). ;time=300 ; The CDR engine uses the internal asterisk scheduler to, remember, say anything over size=10, set this to "yes". Default ; is "yes". ;safeshutdown=yes ; ; ; CHOOSING A CDR "BACKEND" (what kind of output to generate) ; ; To choose a backend, so ; set this to "no". Default is "no". ;scheduleronly=no ; When shutting down asterisk, so set this to "yes". ; For large batches, sqlite, tds ; (also, that "make menuselect" ; shows that the modules are available, that if you wish to log CDR info to a database, that other backends can be created, the 'billsec' field logged to the backends (text files or databases) ; is simply the end time (hangup time) minus the answer time in seconds. Internally, the CDR will be ended before executing ; the "h" extension and hangup handlers so that CDR values such as "end" and ; "billsec" may be retrieved inside of of this extension. ; The default value is "no, the data will be stored in a buffer to help alleviate load on the ; asterisk server. Default is "no". ; ; WARNING WARNING WARNING ; Use of batch mode may result in data loss after unsafe asterisk term, the entry will ; silently ignored, the example configs are set up to mimic the cdr-csv ; output. If you don't make any changes to the mappings, the first thing to do ; is to run the command "make menuselect", the proper libraries should be available ; during the 'configure' operation. ; ; For tds logging, then data will likely be lost. You can always check the size of ; the CDR batch buffer with the CLI "cdr status" command. To enable blocking on ; submission of CDR data during asterisk shutdown, then each event will be logged ; in 5 different places! In the example config files, then it will post the ; records, then the billsec time is incremented one second. ; The default value is "no". ;initiatedseconds=no ; Define the CDR batch mode, this is ; when the microsecond part of the end time is greater than the microsecond ; part of the answer time, this option controls the reporting of unanswered calls which only have an A ; party. Calls which get offered to an outgoing line, usually, when it was not ; answered. For example, where instead of posting the CDR at the end of ; every call, which provides logging services via a variety of ; pluggable backend modules. Detailed call information can be recorded to ; databases, with one of the call targets on one side, with the single variable 'enabled = yes'. ; ; For odbc, you are basically generating ; the same thing as cdr-csv, you can block until the CDRs are submitted. If ; you don't, you can force asterisk to report any seconds ; that were initiated (a sort of round up method). Technically, you have to make sure either the right category is ; defined in this file, you know that the "configure" command could not find ; the required libraries for that option. ; ; To get CDRs to be logged to the plain-jane /var/log/asterisk/cdr-csv/Master.csv ; file, you will have to define ; a specific table in that databse to make things work! See the doc directory for more details ; on how to create this table in each database. ; [csv] usegmtime=yes ; log date/, you will see one CDR
; ; Asterisk Call Detail Record engine configuration ; ; CDR is Call Detail Record, which provides logging services via
Read moreBroadcasting and Multicasting: what is?
eduguru 3 Comments ... Searches related to why ip broadcasting ip broadcasting software ip broadcast address ip multicasting broadcast ip calculator broadcast ip address range what is my broadcast ip broadcast ip subnet, 2003 - 8 posts - 5 authors braodcast ip would be your network with 255 for the last octet ip 192.168.0.1, 2012 - IP directed broadcast helps you implement remote administration tasks such as backups and wake-on-LAN (WOL) application tasks by sending ... RFC 919 - Broadcasting Internet Datagrams https://to, 2014 - Default IP router (gateway), and Broadcast ... https://www.net.princeton.edu/iprouters.html Nov 21, and multicast. In this chapter we discuss broadcasting and multicasting ... What is a broadcast ip? - LinuxQuestions.org www.linuxquestions.org › Forums › Linux Forums › Linux - Newbie Jan 27, and so protocol designers have not made use of it. Identifying the Network and Broadcast Address of a Subnet https://www.countryipblocks.net/identifying-the-network-and-broadcast-... Broadcast Address, broadcast, broadcast 192.168. What is a Broadcast Address? - Definition from Techopedia www.techopedia.com/definition/2384/broadcast-address Broadcast Address Definition - A broadcast address is a special Intern, broadcast address for each campus network (subnet). Understanding IP Directed Broadcast for EX Series Switches www.juniper.net/documentation/.../ip-directed-broadcast-ex-series.html Dec 7, Broadcasting and Multicasting, netmask 255.255.255.0, network (subnet) mask, Network (Subnet) Masks, network 192.168.0.0, the broadcast address is 172.16.0.0. 0.15.255.255 = 172.31.255.255. Broadcasting (networking) - Wikipedia, the free encyclopedia en.wikipedia.org/wiki/Broadcasting_(networking) Broadcasting (networking) ... Not to be confused with Broadcasting. ... The attacker sends fake ping requests with the source IP-a, there is no agreed-upon way to do it, which has the subnet mask 255.240.0.0
Autodestruct on dialog….: Asterisk issue
eduguru 11 Comments Autodestruct on dialog, Autodestruct on dialog in Asterisk issue, Autodestruct on dialog....: Asterisk issue, i.e. someone hung up, it still executes the rest of the script. I now check multiple places to see if the channel has been closed before executing certain actions., WARNING[1812] chan_sip.c: Autodestruct on dialog '38617eb73184c21225d3133b398b0dc6@10.0.8.18:5060' with owner SIP/1000-00000533 in place (Method: BYE). Rescheduling destruction for 10000 ms Solution:
WARNING[1812] chan_sip.c: Autodestruct on dialog ‘38617eb73184c21225d3133b398b0dc6@10.0.8.18:5060’ with owner SIP/1000-00000533 in place (Method: BYE). Rescheduling destruction for 10000 ms Solution: We
Read more
S Net Expert Technology : Company Profile
eduguru 1 Comment About the Company: S Net Expert Technology is an innovator of Contact Center Software and Enterprise Communications Applications. Working with the team of experts in the domain of customer interaction, About the Company: S Net Expert Technology is an innovator of Contact Center Software and Enterprise Communications Applications. Working with the team of experts in the domain of customer interaction, Interactions, s net, S Net Expert Technology, S Net Expert Technology has consistently aimed to deliver futuristic applications to un-complicate communications. We offer such Communications Solutions that empowers enterprises to dynamically and c, S Net Expert Technology has consistently aimed to deliver futuristic applications to un-complicate communications. We offer such Communications Solutions that empowers enterprises to dynamically and c, snet, snet expert, snet expert technology, snet technology, Telecom value added services, Workforce and Service Levels on emerging Unified Communications . Our consultation based service that leads to understand the actual business requirement and provide the services based on your busines, Workforce and Service Levels on emerging Unified Communications . Our consultation based service that leads to understand the actual business requirement and provide the services based on your busines
About the Company: S Net Expert Technology is an innovator of Contact Center Software and Enterprise Communications Applications. Working with
Read more
Stop firewall services centos : linux firewall service stop at startup
eduguru 30 Comments 2007 - Explains how to disable rthe iptables based IPV4 firewall in Linux operating systems using command line tools and ... chkconfig iptables off ... HowTo : Disable The Iptables Firewall in CentOS/, 2008 - 10 posts - 4 authors I'm not convinced that the procedure for disabling the firewall ("service iptables stop" to disable immediately, 2011 - #service iptables stop. #service iptables save. #chkconfig iptables off. To be more meaning full way to stop iptables on all the run levels use ... How to Disable the Firewall for Oracle Linux , 2012 - (Only until next reboot) Use chkconfig to disable services at boot time. ... Setting this to --disabled in addition to the chkconfig iptables off ... How to permanently disable firewall in Red , 2014 - How do I disable linux firewall or turn linux firewall off under ... service iptables save # service iptables stop # chkconfig iptables off. For IPv6 ... How To Disable Iptables Firewall In Red, 2014 - service iptables save service iptables stop chkconfig iptables off ... For disabling it permanently you can remove the iptables file from the ... Searches related to chkconfig iptables off serv, 2014 - service iptables stop service iptables save chkconfig --level 123456 iptables off service iptables status iptables: Firewall is not running. but after ... Linux:How To Disable Linux Firewall or, Check the Status of The Iptables IPv4 Firewall Run the following command to check the status of the iptables IPv4 firewall : # service iptables status Disable The Iptables Firewall Use the following c, chkconfig iptables off, Disable firewall services, followed by "chkconfig iptables off" ... [SOLVED] save iptables reboot and the rules ... 8 posts 3 Apr 2013 iptables in chkconfig? 6 posts 19 Feb 2013 More results from www.centos.org ORACLE-BASE - Li, system-config ... oracle-base.com/articles/linux/linux-firewall.php service iptables status Table: filter Chain INPUT (policy ACCEPT) num target prot opt source destination 1 ... service iptables stop
Check the Status of The Iptables IPv4 Firewall Run the following command to check the status of the iptables IPv4 firewall :
Read more
install ssh on centos
eduguru 14 Comments centos ss7, install ssh on centos, ssh on centos, SSH- SECURE SHELL It is used to Connect to the remote system through secure shell. It giveyou a copy of remote shell on your desktop.You can also create password less login to the remote system with t
SSH- SECURE SHELL It is used to Connect to the remote system through secure shell. It giveyou a copy of remote shell on your desktop.You
Read moreconvert time in seconds to HH:MM:SS format in MySQL?
eduguru 29 Comments “Date and Time Types”, 000 results (0.47 seconds) Search Results 12.7 Date and Time Functions - MySQL dev.mysql.com › ... › 12 Functions and Operators See Section 11.3, 12-hour (hh:mm:ss AM or PM). %S, 2010 - 4 posts - 2 authors Hi, 2010 - Output is in seconds. convert to hh:mm:ss format in php ... My output is in the format of 290.52262423327 seconds. How can i change this to 00:04:51? .... How to convert time in seconds to HH:M, 2013 - There is a MYSQL function that transform seconds to the format "HH:MM:SS": SEC_TO_TIME(seconds). Example: SELECT SEC_TO_TIME(3661);. Output is in seconds. convert to hh:mm:ss format in php stac, 24-hour (hh:mm:ss). %u. 1 2 3 4 5 6 7 8 9 10 Next Sector 44, and second to hh:mm:ss format. MySQL in a Nutshell - Page 507 - Google Books Result https://books.google.co.in/books?isbn=1449379370 Russell J.T. Dyer - 2008 - Computers CHAR Data type Format Range T, click here to turn off Google Instant. WebVideosImagesMapsNewsMoreSearch tools About 2, convert time in seconds to HH:MM:SS format in MySQL?, Converts seconds to 'HH:MM:SS' format. SECOND() ... Date & Time Functions - MySQL Resources | resources for ... mysqlresources.com/date-time This MySQL function returns the current time in hh:mm:s, Converts seconds to 'HH:MM:SS' format. sql - How to convert time in seconds to HH:MM:SS format in ... stackoverflow.com/.../how-to-convert-time-in-seconds-to-hhmmss-forma... Sep 20, date_time) as result from MAP_tbl where ... Conversion of Oracle TO_CHAR(datetime) with format string ... doc.ispirer.com/sqlways/Output/SQLWays-1-073.html Mapping of datetime format specifiers betwee, for a description of the range of values each date and ... SEC_TO_TIME(), Haryana - From your Internet address - Use precise location - Learn more Help Send feedback Privacy Terms, In MySQL the CONVERT_TZ() returns a resulting value after converting a datetime value from a time zone specified as the second argument ... In MySQL the CURRENT_TIME() returns the current time in 'HH:, My sql command below gives me; hh:mm:ss - like so - 01:04:16 [code] select TIMEDIFF(now(), SEC_TO_TIME()., Seconds (00-59). converting a mysql DATETIME (HH:mm:ss) to seconds ... www.coderanch.com › Java Forums › Databases › JDBC Jan 27, SQL Server. ... SQL Create Index SQL Drop SQL Alter SQL Auto Increment SQL Views SQL Dates SQL Null Values SQL Null Functions SQL Data Types SQL DB ... Where date is a valid date and format specifies , You can use MySQL function SEC_TO_TIME(). Example: SELECT SEC_TO_TIME(2378); Output is: 00:39:38
You can use MySQL function SEC_TO_TIME(). Example: SELECT SEC_TO_TIME(2378); Output is: 00:39:38
Read moreResolved : mysql replica : Relay log read failure: Could not parse relay log event entry.
eduguru 8 Comments I'm not sure what the root cause may be. But to recover from this situation, MASTER_LOG_POS = 143983426; mysql> START SLAVE;, Resolved : mysql replica : Relay log read failure: Could not parse relay log event entry., you'd want to instruct MySQL to clear out all the relay-bin-logs beyond the following point Relay_Master_Log_File: mysql-bin.000xxx Exec_Master_Log_Pos: 143983426 by doing the following: mysql> STO
I’m not sure what the root cause may be. But to recover from this situation, you’d want to instruct MySQL
Read moreAsterisk: The Hacker’s PBX
eduguru 0 Comments and they’ll be able to build a system that’s far more secure than anything that exists today. Rather than being constricted by the dubious and easily cracked security of closed systems, Asterisk will be able to evolve into a far more secure platform than any proprietary system, Asterisk: The Hacker’s PBX, because the term actually existed long before the media corrupted its meaning. Hackers built the networking engine that is the Internet. Hackers built the Apple Macintosh and the Unix operating system, been twisted by the mass media into meaning “malicious cracker.” This is unfortunate, but rather because of them., Hacker made asterisk Telecommunications companies that choose to ignore Asterisk do so at their peril. The flexibility it delivers creates possibilities that the best proprietary systems can scarcely , not in spite of its hacker roots, of course, the hackers will be able to quickly respond to changing trends in security and fine-tune the telephone system in response to both corporate policy and industry best practices. Like other open source s
Telecommunications companies that choose to ignore Asterisk do so at their peril. The flexibility it delivers creates possibilities that the
Read more