summaryrefslogtreecommitdiffstats
diff options
context:
space:
mode:
authortt412011-08-19 19:08:01 +0200
committertt412011-08-19 19:08:01 +0200
commit7cbd30ee6b5b2866a168c575ab327a50de397554 (patch)
tree6d568d06558fb0fb8470012dc41e5c75988dc9c9
parentAdded a comment how to make an RSA key and how to use it for logging without ... (diff)
downloadgsm-selftest-7cbd30ee6b5b2866a168c575ab327a50de397554.tar.gz
gsm-selftest-7cbd30ee6b5b2866a168c575ab327a50de397554.tar.xz
gsm-selftest-7cbd30ee6b5b2866a168c575ab327a50de397554.zip
add database dumping file.
-rw-r--r--Database/gsmselftesting.sql164
-rw-r--r--For Weekly Test/19-08-2011/GSM EPlus handler.log8
-rw-r--r--For Weekly Test/19-08-2011/GSM O2 handler.log8
-rw-r--r--For Weekly Test/19-08-2011/GSM Vodaphone handler.log8
-rw-r--r--For Weekly Test/19-08-2011/SIP handler.log43
-rw-r--r--For Weekly Test/19-08-2011/TestProcessLog.log44
6 files changed, 275 insertions, 0 deletions
diff --git a/Database/gsmselftesting.sql b/Database/gsmselftesting.sql
new file mode 100644
index 0000000..ad50687
--- /dev/null
+++ b/Database/gsmselftesting.sql
@@ -0,0 +1,164 @@
+-- phpMyAdmin SQL Dump
+-- version 3.3.10deb1
+-- http://www.phpmyadmin.net
+--
+-- Host: localhost
+-- Generation Time: Aug 19, 2011 at 07:07 PM
+-- Server version: 5.1.54
+-- PHP Version: 5.3.5-1ubuntu7.2
+
+SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
+
+
+/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
+/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
+/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
+/*!40101 SET NAMES utf8 */;
+
+--
+-- Database: `gsmselftesting`
+--
+DROP DATABASE `gsmselftesting`;
+CREATE DATABASE `gsmselftesting` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;
+USE `gsmselftesting`;
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table `DeviceAddressTable`
+--
+
+DROP TABLE IF EXISTS `DeviceAddressTable`;
+CREATE TABLE IF NOT EXISTS `DeviceAddressTable` (
+ `deviceName` varchar(15) NOT NULL,
+ `deviceIP` varchar(60) NOT NULL,
+ `number` varchar(20) NOT NULL,
+ `lastChange` datetime NOT NULL,
+ `username` varchar(20) NOT NULL,
+ `password` varchar(20) NOT NULL,
+ `server` varchar(20) NOT NULL,
+ PRIMARY KEY (`deviceName`)
+) ENGINE=MyISAM DEFAULT CHARSET=latin1;
+
+--
+-- Dumping data for table `DeviceAddressTable`
+--
+
+INSERT INTO `DeviceAddressTable` (`deviceName`, `deviceIP`, `number`, `lastChange`, `username`, `password`, `server`) VALUES
+('sip', 'localhost', '07612034661928', '2011-07-26 00:00:00', 'mpselftest1', '1mpselftest', '132.230.4.8'),
+('unisip', 'localhost', '076120397897', '2011-07-27 00:00:00', '4976120397897', 'hB8M3WyFt61C', '132.230.252.228'),
+('landline', 'localhost', '076145875681', '2011-07-26 00:00:00', '1289459', 'MMW9AX', 'sipgate.de'),
+('GSMRZ1', 'localhost', '07612034661xxx', '2011-07-27 15:47:08', '', '', ''),
+('GSMRZ2', '132.230.4.64', '07612034661455', '2011-07-27 15:48:04', '', '', ''),
+('GSMExt.Eplus', 'localhost', '015782677224', '2011-07-28 14:33:43', '', '', ''),
+('GSMExt.Voda', 'localhost', '015252423662', '2011-07-28 14:35:33', '', '', ''),
+('GSMExt.O2', 'localhost', '017678038038', '2011-07-28 14:36:13', '', '', '');
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table `ErrorCodeTable`
+--
+
+DROP TABLE IF EXISTS `ErrorCodeTable`;
+CREATE TABLE IF NOT EXISTS `ErrorCodeTable` (
+ `errorcode` int(4) NOT NULL,
+ `description` varchar(100) NOT NULL,
+ PRIMARY KEY (`errorcode`)
+) ENGINE=MyISAM DEFAULT CHARSET=latin1;
+
+--
+-- Dumping data for table `ErrorCodeTable`
+--
+
+INSERT INTO `ErrorCodeTable` (`errorcode`, `description`) VALUES
+(200, 'Call was OK'),
+(604, 'General Handler Error: Destination handler no respond timeout'),
+(998, 'General Handler Error: Could not connect Destination handler'),
+(605, 'General Handler Error: caller handler no respond timeout'),
+(999, 'General Handler Error: Could not connect to Caller handler'),
+(486, 'Call Failed'),
+(500, 'Server Internal Error');
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table `PingResultTable`
+--
+
+DROP TABLE IF EXISTS `PingResultTable`;
+CREATE TABLE IF NOT EXISTS `PingResultTable` (
+ `taskNo` int(11) NOT NULL,
+ `sipServer` int(3) NOT NULL,
+ `sipGate` int(3) NOT NULL,
+ `sipLoc` int(3) NOT NULL,
+ `gsmBox1` int(3) NOT NULL,
+ `gsmBox2` int(3) NOT NULL,
+ PRIMARY KEY (`taskNo`)
+) ENGINE=MyISAM DEFAULT CHARSET=latin1;
+
+--
+-- Dumping data for table `PingResultTable`
+--
+
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table `ResultTable`
+--
+
+DROP TABLE IF EXISTS `ResultTable`;
+CREATE TABLE IF NOT EXISTS `ResultTable` (
+ `taskID` int(11) NOT NULL,
+ `result` int(3) NOT NULL,
+ PRIMARY KEY (`taskID`)
+) ENGINE=MyISAM DEFAULT CHARSET=latin1;
+
+--
+-- Dumping data for table `ResultTable`
+--
+
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table `TaskTable`
+--
+
+DROP TABLE IF EXISTS `TaskTable`;
+CREATE TABLE IF NOT EXISTS `TaskTable` (
+ `taskID` int(11) NOT NULL AUTO_INCREMENT,
+ `taskNo` int(11) NOT NULL,
+ `from` varchar(10) NOT NULL,
+ `to` varchar(10) NOT NULL,
+ `status` int(2) NOT NULL,
+ `timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
+ PRIMARY KEY (`taskID`)
+) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=25 ;
+
+--
+-- Dumping data for table `TaskTable`
+--
+
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table `TempTaskTable`
+--
+
+DROP TABLE IF EXISTS `TempTaskTable`;
+CREATE TABLE IF NOT EXISTS `TempTaskTable` (
+ `taskID` int(11) NOT NULL,
+ `taskNo` int(11) NOT NULL,
+ `from` varchar(10) NOT NULL,
+ `to` varchar(10) NOT NULL,
+ `status` int(1) NOT NULL,
+ PRIMARY KEY (`taskID`)
+) ENGINE=MyISAM DEFAULT CHARSET=latin1;
+
+--
+-- Dumping data for table `TempTaskTable`
+--
+
diff --git a/For Weekly Test/19-08-2011/GSM EPlus handler.log b/For Weekly Test/19-08-2011/GSM EPlus handler.log
index e14f407..6c5702c 100644
--- a/For Weekly Test/19-08-2011/GSM EPlus handler.log
+++ b/For Weekly Test/19-08-2011/GSM EPlus handler.log
@@ -144,3 +144,11 @@ On: 2011-08-03 20:19:13.737044 Event: TALK INITIALIZATION SENT
On: 2011-08-03 20:19:13.737198 Event: CALLER READY SENT
On: 2011-08-03 20:19:20.637407 Event: CALLER STATUS SENT
On: 2011-08-03 20:19:30.637747 Event: other appeared
+
+
+------------------STARTED THE LOGGING 2011-08-10 14:18:22.404733 ------------------
+On: 2011-08-10 14:18:22.404855 Event: LISTEN ON PORT: 50013
+On: 2011-08-10 14:18:24.266139 Event: CONNECTION ESTABLISHED AND DEVICE WORKING: ('127.0.0.1', 35727)
+On: 2011-08-10 14:18:24.266324 Event: TALK INITIALIZATION SENT
+On: 2011-08-10 14:18:24.266508 Event: RECEIVER READY SENT
+On: 2011-08-10 14:18:59.333435 Event: RECEIVE STATUS REPORTED
diff --git a/For Weekly Test/19-08-2011/GSM O2 handler.log b/For Weekly Test/19-08-2011/GSM O2 handler.log
index d092e80..1e38268 100644
--- a/For Weekly Test/19-08-2011/GSM O2 handler.log
+++ b/For Weekly Test/19-08-2011/GSM O2 handler.log
@@ -210,3 +210,11 @@ On: 2011-08-03 20:17:35.806258 Event: CONNECTION ESTABLISHED AND DEVICE WORKING:
On: 2011-08-03 20:17:35.806372 Event: TALK INITIALIZATION SENT
On: 2011-08-03 20:17:35.806609 Event: RECEIVER READY SENT
On: 2011-08-03 20:17:46.645399 Event: RECEIVE STATUS REPORTED
+
+
+------------------STARTED THE LOGGING 2011-08-10 14:17:20.367588 ------------------
+On: 2011-08-10 14:17:20.367757 Event: LISTEN ON PORT: 50010
+On: 2011-08-10 14:17:22.136026 Event: CONNECTION ESTABLISHED AND DEVICE WORKING: ('127.0.0.1', 53292)
+On: 2011-08-10 14:17:22.136184 Event: TALK INITIALIZATION SENT
+On: 2011-08-10 14:17:22.136318 Event: RECEIVER READY SENT
+On: 2011-08-10 14:17:57.177444 Event: RECEIVE STATUS REPORTED
diff --git a/For Weekly Test/19-08-2011/GSM Vodaphone handler.log b/For Weekly Test/19-08-2011/GSM Vodaphone handler.log
index 994be27..ecd787c 100644
--- a/For Weekly Test/19-08-2011/GSM Vodaphone handler.log
+++ b/For Weekly Test/19-08-2011/GSM Vodaphone handler.log
@@ -134,3 +134,11 @@ On: 2011-08-03 20:18:02.322071 Event: CONNECTION ESTABLISHED AND DEVICE WORKING:
On: 2011-08-03 20:18:02.322244 Event: TALK INITIALIZATION SENT
On: 2011-08-03 20:18:02.322395 Event: RECEIVER READY SENT
On: 2011-08-03 20:18:12.977393 Event: RECEIVE STATUS REPORTED
+
+
+------------------STARTED THE LOGGING 2011-08-10 14:18:00.326436 ------------------
+On: 2011-08-10 14:18:00.326556 Event: LISTEN ON PORT: 50011
+On: 2011-08-10 14:18:02.202150 Event: CONNECTION ESTABLISHED AND DEVICE WORKING: ('127.0.0.1', 34153)
+On: 2011-08-10 14:18:02.202318 Event: TALK INITIALIZATION SENT
+On: 2011-08-10 14:18:02.202603 Event: RECEIVER READY SENT
+On: 2011-08-10 14:18:13.509452 Event: RECEIVE STATUS REPORTED
diff --git a/For Weekly Test/19-08-2011/SIP handler.log b/For Weekly Test/19-08-2011/SIP handler.log
index c149e76..a77f8a1 100644
--- a/For Weekly Test/19-08-2011/SIP handler.log
+++ b/For Weekly Test/19-08-2011/SIP handler.log
@@ -1020,3 +1020,46 @@ On: 2011-08-03 20:19:15.742360 Event: Receiver Handler Ready
On: 2011-08-03 20:19:15.742488 Event: RECEIVE START
On: 2011-08-03 20:19:45.637748 Event: Terminate
On: 2011-08-03 20:19:45.637799 Event: Goodbye
+
+
+------------------STARTED THE LOGGING 2011-08-10 14:17:18.344119 ------------------
+On: 2011-08-10 14:17:18.354507 Event: try to Connect to Controller
+On: 2011-08-10 14:17:20.130856 Event: init state
+On: 2011-08-10 14:17:20.131016 Event: Register Account to SIP server
+On: 2011-08-10 14:17:20.131385 Event: 100
+On: 2011-08-10 14:17:20.131437 Event: Caller Handler Ready
+On: 2011-08-10 14:17:25.137399 Event: CALL START
+On: 2011-08-10 14:17:25.137434 Event: Make a call to: 017678038038
+On: 2011-08-10 14:17:28.185298 Event: Call Connecting
+On: 2011-08-10 14:17:28.185324 Event: 200
+On: 2011-08-10 14:17:53.185615 Event: Terminate
+On: 2011-08-10 14:17:53.185638 Event: Goodbye
+
+
+------------------STARTED THE LOGGING 2011-08-10 14:17:58.341153 ------------------
+On: 2011-08-10 14:17:58.349528 Event: try to Connect to Controller
+On: 2011-08-10 14:18:00.197019 Event: init state
+On: 2011-08-10 14:18:00.197142 Event: Register Account to SIP server
+On: 2011-08-10 14:18:00.197459 Event: 100
+On: 2011-08-10 14:18:00.197501 Event: Caller Handler Ready
+On: 2011-08-10 14:18:05.205396 Event: CALL START
+On: 2011-08-10 14:18:05.205431 Event: Make a call to: 015252423662
+On: 2011-08-10 14:18:15.249857 Event: Call Connecting
+On: 2011-08-10 14:18:15.249897 Event: 200
+On: 2011-08-10 14:18:15.250631 Event: Terminate
+On: 2011-08-10 14:18:15.250673 Event: Goodbye
+
+
+------------------STARTED THE LOGGING 2011-08-10 14:18:20.394724 ------------------
+On: 2011-08-10 14:18:20.403544 Event: try to Connect to Controller
+On: 2011-08-10 14:18:22.260942 Event: init state
+On: 2011-08-10 14:18:22.261090 Event: Register Account to SIP server
+On: 2011-08-10 14:18:22.261490 Event: 100
+On: 2011-08-10 14:18:22.261545 Event: Caller Handler Ready
+On: 2011-08-10 14:18:27.269396 Event: CALL START
+On: 2011-08-10 14:18:27.269430 Event: Make a call to: 015782677224
+On: 2011-08-10 14:18:33.243381 Event: Call Connecting
+On: 2011-08-10 14:18:33.243412 Event: 200
+On: 2011-08-10 14:18:42.396197 Event: Call Disconnected
+On: 2011-08-10 14:18:58.244034 Event: Terminate
+On: 2011-08-10 14:18:58.244056 Event: Goodbye
diff --git a/For Weekly Test/19-08-2011/TestProcessLog.log b/For Weekly Test/19-08-2011/TestProcessLog.log
index 0e46fc5..e07a1a1 100644
--- a/For Weekly Test/19-08-2011/TestProcessLog.log
+++ b/For Weekly Test/19-08-2011/TestProcessLog.log
@@ -1142,3 +1142,47 @@ On: 2011-08-03 20:19:15.742381 Event: Receiver handler : Ready
On: 2011-08-03 20:19:15.742425 Event: Start Call
On: 2011-08-03 20:19:15.742492 Event: Waiting Feedback
On: 2011-08-03 20:19:45.637551 Event: Test Failed
+
+
+------------------STARTED THE LOGGING 2011-08-10 14:17:18.126200 ------------------
+On: 2011-08-10 14:17:18.126245 Event: init Caller
+On: 2011-08-10 14:17:18.126261 Event: sip
+On: 2011-08-10 14:17:20.130679 Event: Connected to Caller Handler
+On: 2011-08-10 14:17:20.130872 Event: Caller Handler respond
+On: 2011-08-10 14:17:20.131488 Event: Caller handler : Ready
+On: 2011-08-10 14:17:20.131524 Event: init Receiver
+On: 2011-08-10 14:17:20.131547 Event: GSMExt.O2
+On: 2011-08-10 14:17:22.135970 Event: Connected to Receiver Handler
+On: 2011-08-10 14:17:22.136209 Event: Receiver Handler respond
+On: 2011-08-10 14:17:22.136335 Event: Receiver handler : Ready
+On: 2011-08-10 14:17:22.136363 Event: Start Call
+On: 2011-08-10 14:17:22.136429 Event: Waiting Feedback
+On: 2011-08-10 14:17:53.185459 Event: Test Failed
+On: 2011-08-10 14:17:58.192429 Event:
+On: 2011-08-10 14:17:58.192464 Event: init Caller
+On: 2011-08-10 14:17:58.192479 Event: sip
+On: 2011-08-10 14:18:00.196880 Event: Connected to Caller Handler
+On: 2011-08-10 14:18:00.197036 Event: Caller Handler respond
+On: 2011-08-10 14:18:00.197577 Event: Caller handler : Ready
+On: 2011-08-10 14:18:00.197609 Event: init Receiver
+On: 2011-08-10 14:18:00.197635 Event: GSMExt.Voda
+On: 2011-08-10 14:18:02.202034 Event: Connected to Receiver Handler
+On: 2011-08-10 14:18:02.202409 Event: Receiver Handler respond
+On: 2011-08-10 14:18:02.202677 Event: Receiver handler : Ready
+On: 2011-08-10 14:18:02.202715 Event: Start Call
+On: 2011-08-10 14:18:02.202795 Event: Waiting Feedback
+On: 2011-08-10 14:18:15.250049 Event: Test Succeed
+On: 2011-08-10 14:18:20.256065 Event:
+On: 2011-08-10 14:18:20.256112 Event: init Caller
+On: 2011-08-10 14:18:20.256139 Event: sip
+On: 2011-08-10 14:18:22.260770 Event: Connected to Caller Handler
+On: 2011-08-10 14:18:22.260959 Event: Caller Handler respond
+On: 2011-08-10 14:18:22.261568 Event: Caller handler : Ready
+On: 2011-08-10 14:18:22.261604 Event: init Receiver
+On: 2011-08-10 14:18:22.261635 Event: GSMExt.Eplus
+On: 2011-08-10 14:18:24.266080 Event: Connected to Receiver Handler
+On: 2011-08-10 14:18:24.266354 Event: Receiver Handler respond
+On: 2011-08-10 14:18:24.266530 Event: Receiver handler : Ready
+On: 2011-08-10 14:18:24.266564 Event: Start Call
+On: 2011-08-10 14:18:24.266644 Event: Waiting Feedback
+On: 2011-08-10 14:18:58.243876 Event: Test Failed