Skip to content

Instantly share code, notes, and snippets.

View gvagenas's full-sized avatar

George Vagenas gvagenas

12 followers · 0 following
View GitHub Profile
@gvagenas
gvagenas / Working script
Created June 30, 2016 20:06
USE ${RESTCOMM_DBNAME};
DELIMITER //
CREATE PROCEDURE updateProcedure()
BEGIN
SELECT DISTINCTROW IFNULL(column_name, '') INTO @colName
FROM information_schema.columns
WHERE table_name = 'restcomm_call_detail_records'
AND column_name = 'instanceid';
IF @colName IS NULL THEN
@gvagenas
gvagenas / Script that I used with mysql
Created June 30, 2016 20:04
DELIMITER //
CREATE PROCEDURE updateProcedure()
BEGIN
SELECT DISTINCTROW IFNULL(column_name, '') INTO @colName
FROM information_schema.columns
WHERE table_name = 'restcomm_call_detail_records'
AND column_name = 'conference_sid';
IF @colName IS NULL THEN
CREATE TABLE temp_table LIKE restcomm_call_detail_records;
@gvagenas
gvagenas / Flyway PROBLEMATIC sql script
Created June 30, 2016 20:02
USE ${RESTCOMM_DBNAME};
DELIMITER //
CREATE PROCEDURE updateProcedure()
BEGIN
SELECT DISTINCTROW IFNULL(column_name, '') INTO @colName
FROM information_schema.columns
WHERE table_name = 'restcomm_call_detail_records'
AND column_name = 'conference_sid';
IF @colName IS NULL THEN
@gvagenas
gvagenas / gist:0c1f40b3c2567b3521bb9724af58a49c
Created April 1, 2016 13:33
Olympus fails to call 1234
16:32:46,920 INFO [org.jboss.modules] (main) JBoss Modules version 1.2.0.CR1
16:32:47,067 INFO [org.jboss.msc] (main) JBoss MSC version 1.0.4.GA
16:32:47,173 INFO [org.jboss.as] (MSC service thread 1-7) JBAS015899: JBoss AS 7.2.0.Final "Janus" starting
16:32:48,215 INFO [org.jboss.as.server.deployment.scanner] (DeploymentScanner-threads - 1) JBAS015003: Found restcomm-rvd.war in deployment directory. To trigger deployment create a file called restcomm-rvd.war.dodeploy
16:32:48,216 INFO [org.jboss.as.server.deployment.scanner] (DeploymentScanner-threads - 1) JBAS015003: Found restcomm.war in deployment directory. To trigger deployment create a file called restcomm.war.dodeploy
16:32:48,245 INFO [org.xnio] (MSC service thread 1-14) XNIO Version 3.0.7.GA
16:32:48,249 INFO [org.jboss.as.server] (Controller Boot Thread) JBAS015888: Creating http management service using socket-binding (management-http)
16:32:48,255 INFO [org.xnio.nio] (MSC service thread 1-14) XNIO NIO Implementation Version 3.0.7.GA
16:32
@gvagenas
gvagenas / gist:41e678957ff90277ed21ff61a4c8790c
Created March 31, 2016 08:33
Olympus registration problem
16:58:04,481 INFO [gov.nist.javax.sip.stack.SIPTransactionStack] (SIP-TCP-Core-PipelineThreadpool-16) <message
from="188.4.118.136:58329"
to="172.17.0.2:5063"
time="1459357084480"
isSender="false"
transactionId="z9hg4bk-363039-ca91079f3a805445564afb7c4a659544"
callId="1459357084658"
firstLine="REGISTER sip:staging.restcomm.com SIP/2.0"
>
<![CDATA[REGISTER sip:staging.restcomm.com SIP/2.0
@gvagenas
gvagenas / gist:7903010bbe4912ca2d7f
Created October 10, 2015 18:00
graylog server log file
This file has been truncated, but you can view the full file.
2015-10-06_19:07:40.12339 It looks like you are trying to access MongoDB over HTTP on the native driver port.
2015-10-06_19:07:40.12966 Java HotSpot(TM) 64-Bit Server VM warning: ignoring option PermSize=128m; support was removed in 8.0
2015-10-06_19:07:40.12967 Java HotSpot(TM) 64-Bit Server VM warning: ignoring option MaxPermSize=256m; support was removed in 8.0
2015-10-06_19:07:40.96976 INFO [CmdLineTool] Loaded plugins: [Anonymous Usage Statistics 1.1.1 [org.graylog.plugins.usagestatistics.UsageStatsPlugin], HttpMonitorInput 1.0.2 [org.graylog2.plugin.httpmonitor.HttpMonitorInputPlugin]]
2015-10-06_19:07:41.15273 INFO [CmdLineTool] Running with JVM arguments: -Xms1g -Xmx1500m -XX:NewRatio=1 -XX:PermSize=128m -XX:MaxPermSize=256m -XX:+ResizeTLAB -XX:+UseConcMarkSweepGC -XX:+CMSConcurrentMTEnabled -XX:+CMSClassUnloadingEnabled -XX:+UseParNewGC -XX:-OmitStackTraceInFastThrow -Dlog4j.configuration=file:///opt/graylog/conf/log4j.xml -Djava.library.path=/opt/graylog/server/lib/sigar/
2015-10-06_19:07:44.65709
@gvagenas
gvagenas / gist:6b8707f249fe3bc4b517
Created July 7, 2015 12:47
MMS issue #25
2015-07-07 15:36:07,551 INFO [Main] (main) log4j initialized from a configuration file.
2015-07-07 15:36:07,552 INFO [Main] (main) Home directory: /data/workspace/temp/731/Mobicents-Restcomm-JBoss-AS7-7.3.1.675/mediaserver
2015-07-07 15:36:07,560 INFO [Main] (main) Booting from file:/data/workspace/temp/731/Mobicents-Restcomm-JBoss-AS7-7.3.1.675/mediaserver/conf/bootstrap-beans.xml
2015-07-07 15:36:07,580 DEBUG [KernelFactory] (main) Starting JBoss Kernel construction...
2015-07-07 15:36:07,703 DEBUG [KernelFactory] (main) Completed JBoss Kernel construction. Duration: 123 milliseconds
2015-07-07 15:36:07,727 DEBUG [SaxJBossXBParser] (main) Created parser: com.sun.org.apache.xerces.internal.jaxp.SAXParserImpl@f32b815, isNamespaceAware: true, isValidating: true, isXIncludeAware: true
2015-07-07 15:36:07,728 DEBUG [SaxJBossXBParser] (main) http://xml.org/sax/features/validation set to: true
2015-07-07 15:36:07,728 DEBUG [SaxJBossXBParser] (main) http://xml.org/sax/features/namespaces set to: true
2015-07-07
@gvagenas
gvagenas / gist:93f43ee17a654deed736
Last active August 29, 2015 14:23
SipServlet issue #62 - Debug level logs
Logs at DEBUG level for when calling from Bob - SFLPhone to Alice - Olympus
Sip Servlet Issue #62 - https://github.com/Mobicents/sip-servlets/issues/62
Mobicents Mobicents Restcomm 7.3.1.651
Mobicents Sip Servlets 3.1.605
jain-sip-ri-1.2.233
---
11:35:01,685 INFO [org.jboss.modules] (main) JBoss Modules version 1.2.0.CR1