lunes, 3 de diciembre de 2007
Video & Audio Streaming Concepts
Part involved : Streaming Server facilities.
Summary : Clears the way how this technology works.
Scenario : It is part of a free training program taught by COS-PERU.
Company : Open Source Center of Peru (COS-PERU).
Reference date : December 2007.
There are several services such as : radio and tv looking the way to change the broadcast of its signal information and opens the way to access them from internet selecting web browser since your computer. That is integration of Radio&Tv using ip technology.
Radio & TV have use the same requirements to build it and these ones are :
1.- Spread Server
2.- Broadcast Client (Life)
3.- Bandwidth assigned
The techniques used to transmit audio and data (video) is named "streaming". Then the Spread Server (1) managements and emits the streaming signal to www. About the quantity of simultaneous connections supported is called "concurrence" and can be calculated by how do you spend the concurrence resource of Spread Server. Then, next, we find a few samples of needs required for every type of broadcast.
Audio 24Kbps for every user connected
Video 100Kbps for every user connected
Buffer of the Spread Server.- Initially this parameter is considered to program and save space to concurrence concept, check next example :
- If my computer (1.-) has 1G RAM conifigured with 8K Buffer RAM, how many users can be attended ?
Remember that 1G= 1024K, then 1024/8= 128 users or concurrence top value.
The widthband (3.-) used by these concurrence connections then is calculated such as follow for :
Audio = 24 x 128 users = 3,072Kbps
Video = 100x 128 users = 12,800 Kbps
At this point, It's clear how many bandwidth will be used or How can I adjust this resource according to the available of bandwidth of my provider (ISP).
Related to the software used by Spread Server (1.-), we find next software free application to fullfill with this purpose : ShoutCast, IceCast, StreamCast, while these applications assigned carpets into server to every audio and video files to share and save information.
The Broadcast Client (2.-) converts the analog signal into digital signal through video capturer card (video broadcast case) while the client computer (user placed in office or home connected through www) needs to support multimedia basically since the applications WinAmp, Real Player, Windows Media to connect to (2.-).
There is a video example attached to show (2.-) under main title "YouTube Videos hosted by German Medina" at the right bottom of this page and select title "Video Streaming Concepts" for more information.
viernes, 2 de noviembre de 2007
Handing Fiber Optical Connectors
Part Involved : SC connector
Summary: Procedure to prepare, weld with epoxy fiber optical connectors.
Scenario : Upgrading of Networking infrastructure.
Company : Minister of Health of Peru (MINSA).
Reference Date : November 2007.
I have uploaded an interesting video with the step by step to reach with this goal.
Check at the right-bottom side of this page under section "YouTube Videos hosted by German Medina" under title "Handing Fiber Optics Connectors" to watched my video uploaded.
sábado, 27 de octubre de 2007
Gutsy Gibbon Peru
Part involved : Gutsy Gibbon.
Summary : Peruvian launch of Gutsy Gibbon.
Scenario : A set of conference given by Linux experts in this event into "Open Source Center of Lima Peru" .
Company : Open Source Center of Peru.
Reference date : October 2007.
Open Source Center of Lima Peru http://www.cosperu.com/
Ubuntu Peru Team http://www.ubuntu-pe.org/
You will find an insteresting video captured about this event at the right-down side of my blog under title "You Tube Videos hosted by German Medina".
jueves, 25 de octubre de 2007
Panasonic D500
Part Involved : Panasonic D500
Summary: I gave a presentation about the basic concepts used in telephone systems
Scenario : The enviroment belongs to celebrate the anniversary of "Telecommunication Office of Maria Auxiliadora Hospital".
Company : Maria Auxiliadora Hospital of Peru (HMA).
Reference Date : October 2007.
jueves, 27 de septiembre de 2007
IEDS
Part Involved : Catalogs introduced: "Places Building of Health" and "Producing units of Health Services" .
Summary : Looking to join data health information between all producing units of health of the country.
Scenario : Presentation of the catalogs is focusing to share and join all the health information and trace a method to search a "key health data" from the overall health institutions of the country.
Company : Minister of Health of Peru (MINSA).
Reference date : September 2007.
The Catalog “Producing Units of Health Services” proposes a new structure of producing units linked to their respective cost center and set up a new identification coding to every specialist of medicine associated to every cost center, such as clear way to interconect data fields between institutions.
In Reference of “Places Building of Health” catalog, it has been programmed “The National Record of Places Building of Health (RENAES)”, through a web interface every Health Institution in the country should be filled information related to its own institution and later the update information process should be responsible to every institution (administration) while the system generates an own code identification appended a new record to IEDS database then query information can be accessed by internal and external users. The manager assigned in charge is “The General Direction of Health of people (DGSP) of MINSA.
About this topic, I can add that MINSA has advanced into the first step of e-goverment services because focused on next objectives : (1) Main Health Database available, (2) Global Access to Health information, (3) The value added of health services can be programmed from this point (move patients, stock of medicine, global of trace of clinical history of patients in the entire country and so on).
I have added Videos related to this issue at the right side of the screen
miércoles, 26 de septiembre de 2007
Installing Ubuntu Linux over VmWare
Part Involved : Ubuntu
Summary: Procedure to install Ubuntu over VmWare
Scenario : I am using my Pc to work with xp and Ubuntu at the same time.
Company : Owner.
Reference Date : September 2007.
Follow next tips :
1.- Click on http://www.ubuntu.com/getubuntu/download and download your preference installation according to your requirements, at this topic I want to advanced to you that Server edition is not complete and later you will need to download additionally files to complete your installation. And about the type of computer that you have to select, check on "Standard personal computers" in 32 bits case.
2.- At the end of the download process you will find an iso file (image of installation).
3.- To test the iso file go to https://help.ubuntu.com/community/HowToMD5SUM and download MD5SUM exe file, after that install it, and execute on the same carpet location of your iso file:
4.- Set up the bootable device through http://germanmedinavirtual.blogspot.com/2007/10/virtual-machines.html and check point 5 to specify source bootable path to locate iso file.
Check an example of installation through "YouTube Videos hosted by German Medina" at the right side of the screen with the titles : "Installing Ubuntu over VmWare - part1 and part2".
miércoles, 19 de septiembre de 2007
Virtual Machines
Part involved : Server Console.
Summary : Software to create "Virtual Machine" in your Pc.
Scenario : An easy way to test operating systems and several applications over different plattforms using the only and the same hardware available.
Company : Owner.
Reference date : September 2007.
You can install several operating systems and working with all of them at the same time (Windows Xp, Vista, Linux, and so on) using the same computer to achieve with this goal. Follow next tips :
1.- Go to http://www.vmware.com/download/server/
3.- Click on "Download Now" button, then download and install.
4.- Click on Edit/Preferences/Input and check the options "Grab keyboard and mouse input on mouse click", "Grab keyboard and mouse input on key press"
5.- To set up bootable device check "Edit virtual machine settings" and select CD-ROM and the source device of the boot process like as picture below :
The complete process of installation is available at the right side of the screen under title "Installing VmWare" on "YouTube Videos hosted by German Medina "
miércoles, 12 de septiembre de 2007
Auditing report of Minister of Transport and Communications of Peru (MTC)
Part involved : Minister of Transport and Communications of Peru (MTC).
Summary : Through this report MTC tryes to explain to peruavian citizens what happened when mobile phone communications and land phone communications crashed on August 15, 2007.
Scenario : That date our country was shaken by 2 consecutive earthquakes of 7.5º on Richter scale and after that the communication was lost upto 6 hours in main city (Lima) and several days near to the epicenter (Chincha and Ica -200 Kms south of Lima-).
Company : Owner.
Reference date : September 2007.
Today MTC has published the auditing report in http://www.mtc.gob.pe/portal/Informe%20Nº%20009-2007-MTC-29.pdf to achieve with next goals :
- To decide on capacity of Public Commute Branch Exchange.
- To decide if the capacity of traffic management system and the size of telecommunication networking are enough to attend the requirements of telephone communications of the suscribers.
- In the case of mobile phone service, look at the level of working of cells.
- An additional actions to be necessary.
While OSIPTEL has published two documents in : (1) http://200.89.2.171/Index.ASP?T=T&P=GCC%2FNOTICIAS%5FPUBLICACIONES%2FNOTAS%5FPRENSA%2FFILES%2FNP+Resultados+de+Comision+de+Alto+Nivel%2Epdf (2) http://200.8.92.171/Index.ASP?T=T&P=GCC%2FEL%5FSECTOR%2FNORMAS%5FOSIPTEL%2FFILES%2Fres%5FPD%2F2007%2Fres1232007PDOSIPTEL%5Finforme%2Epdf about the same subject.
The auditing report of MTC shows a delimited sections of every mobile phone operator. Next parameters are defined as : IC-TINE (attempt not connected), TTLI (callings fallen) and summary of them :
Nextel (Mobile phone carrier operator)
Cpu (qty) = 1
Cpu % = 67
IC-TINE = 3
TLLI = > 2
Subscribers= 390,000
Traffic Channels= 4,604
Users/Channel= 84.70
MoviStar (Mobile phone carrier operator)
Cpu (qty) = 6 MGW
Cpu % = 70
IC-TINE = 4.03 (April), 6.41 (May), 3.48 (June), 4.54 (July)
TLLI = (No information)
Subscribers= 7,637,504
Traffic Channels= 141,492
Users/Channel= 53.98
Claro (Mobile phone carrier operator)
Cpu (qty) = (No information)
Cpu % = 72 and 98
IC-TINE = (No information)
TLLI = (No information)
Subscribers= 4,521,412
Traffic Channels= 138,203
Users/Channel= 32.72
Telefónica (Land Line carrier operator)
Cpu (qty) = 5
Cpu % = 60
IC-TINE = (No information)
TLLI = (No information)
Subscribers= 2,340,000
Traffic Channels= (no information)
Users/Channel= (no information)
Telmex (Land Line carrier operator)
Cpu (qty) = (no information)
Cpu % = 43
IC-TINE = (No information)
TLLI = (No information)
Subscribers= 28,530
Traffic Channels= (no information)
Users/Channel= (no information)
In Claro's case the auditing report suggests an acceptable value of "Users/Channel" (32.72), while at the same time does not confirm the rest values indicated under the reference (no information) and clears the responsabilities between MTC and OSIPTEL (Telecommunication Supervisor Body) such as next table :
Duties of MTC
Supervision of implementation networking (first 12 months)
Fill goals of the spectrum.
Fill goals of secret of communications.
Duties of OSIPTEL
Check quality and efficiency in public telcommunications services.
Check the goals and obligation to expand services.
Check to fulfilling the contract as carrier operator.
In the auditing report of OSIPTEL, we can find :
-IC-TINE and TLLI superpassed 3% in MoviStar, Claro and Nextel since previous months ago to earthquake.
- It founded 807,900 callings lost at peak hour (it is an abuse!)
- Most of calling cases are GoS are 1%.
I am going to suppose that :
(a) The quantity of traffic channels busy in Lima reachs up to 70,476 (assumed only 55% from the overall) multiply by 300 minutes, and every one minute had a cost average of S/.050, then the big business for MoviStar was for that event (after earthquake) the profit of S/. 10'571,400 ( US$ American Dolar 3,410,129.00).
(b) But I am going to give to MoviStar the benefit of the doubt according to the previous paragraph : only the half of the overall traffic channels made (dial) the call becuase the other half received the call, then the profit is US$ 1,705,064.00).
(c) There is no any rule and local law to establish the maximum ratio and relation to the parameter "Users/Channel", that is, if the carrier operator exceeds that parameter then this one should be forbidden to sell additional mobile phones. -You want to sell more mobile phones then first build the networking wireless to use-.
(d) The end user at the time of buying a new mobile phone should be noticed about the available traffic channels and another networking resources offered by carrier operator.
(e) The advertisment on news paper, tv and others medias to sell mobile phones should be included additionals indicators of quality of services and availability of networking services, that can be access too, by links of www.
(f) The auditing reports does not confirm an absence of call service and that means, that was a super plus of calling service?, and what happened with suscribers did not connect never at that time?. Both auditing reports confirm deficiency of planning networking telecommunications and degraded of call service but at this point the main reason of typing the auditing report was to confirm what suscribers were feeling at that day ?, is not explained what was the main reason calling services crashed on August 15.
jueves, 6 de septiembre de 2007
Lost Internet
Part involved : Squid.
Summary : Users can not access to internet.
Scenario : Troubleshooting internet service of end users .
Company : National Institute of Cancer Sickness of Peru (INEN).
Reference date : May 2005.
The main functionality of internet connection is based on "rcinetd" service running on Linux, then is possible to get up it swaping the states of that service, such as :
/etc/inetd.conf
rcinetd restart
cd /var/spool/mail
vdir
du -h
tail -f /var/log/mail
tail -f /var/log/httpd/access_log
tail -f /var/squid/logs/access.log
last more
vi /etc/passwd
bi /etc/shadow
And, after that, it persists a lost of internet service then try with ping command from your gateway to outside if there exists any other response, in negative answers check your connection with your ISP.
viernes, 31 de agosto de 2007
Checking Links of BTS
Part involved : 9600.
Summary : To proceed to discard problems with link carrier then check spams.
Scenario : BTS is appearently oos.
Company : Motorola of Peru.
Reference date : June 1998.
Connect to BTS using ALMF :
Almf
c-Kermit
Login ILGIP :
You are already logged
disp param span
diap param edlc
/** Check values, these ones should be LVO=7 and Line Code=2 **/
Logout
Swap mmi cable to next GLI and repeat the procedure in all GLIs, after that check if the links are working with :
display emx link_status
lunes, 27 de agosto de 2007
WaveCom Q2426B
Part involved : Q2426B.
Summary : Set up and configuration of wavecom card.
Scenario : Enable traffic channels of mobile phone call termination using wavecom card connect to PBX Alcatel.
Company : Minister of Health of Peru (MINSA).
Reference date : January 2007.
1.- Check cable DB9 to DB9 (pin to pin).
2.- Set up hyperterminal with next fields : 34800, N, 8, 1, N
3.-
Check as reference : http://germanmedinavirtual.blogspot.com/2007/08/calculate-traffic-channels-3.html
lunes, 20 de agosto de 2007
SU VG
Part involved : Card SU VG.
Summary : Handing flash card.
Scenario : Updating welcome message of PBX.
Company : Minister of Health of Peru (MINSA).
Reference date : August 2007.
Through mgr menu connected by mtcl user to PBX and to adjust configuration of message of welcome then select : Automated Attendant / Application; the flash card memory can be inserted into SU VG card in hot ( is not need to turn off PBX or pull off SU VG card), I have attached a You Tube video to confirm this procedure (check "DISA Message"at the right side under title "You Tube videos hosted by German Medina")
miércoles, 15 de agosto de 2007
Calculate Traffic Channels (3)
Part involved : Implementation of practical use to calculate the quantity of traffic channels needed.
Summary : How much need to grow our infrastructure in land lines, mobile phone calls and another types of service callings ?
Scenario : Developing IT plans will be based on the growth of the future company needs and that includes how to calculate the quantity of traffic channels.
Company : Minister of Health of Peru (MINSA).
Reference date : October 2006.
In the case of mobile phone termination calling party, the trunking ports needed will be replaced by the same quantity of mobile phones cards attached to PBX, as I show at next picture :
viernes, 10 de agosto de 2007
Calculate Traffic Channels (2)
Part involved : Implementation of practical use to calculate the quantity of traffic channels needed.
Summary : How much need to grow our infrastructure in land lines, mobile phone calls and another types of callings ?
Scenario : Developing IT plans will be based on the growth of the future company needs and that includes how to calculate the quantity of traffic channels .
Company : Minister of Health of Peru (MINSA).
Reference date : October 2006.
This stage is focused to discuss what action should be take after our detailed record call party information has been storage, remember that the call party log belongs to the input data -with the fields: Date, Time, from Extension, Number called, Call party time (secs) - of our "magic box" and after finished the append process the size of the log can be grow up to decide to save that log information into some Access table following the same order and priority of the fields described.
According to the filter -what type of calling wants to study, selecting the capacity of traffic or planning to implement some type of service call can be grouped by the series number of the number called, ensure one type of service call as input- activated is possible to reduced the response of time.
Dim rs As DAO.Recordset
Set db = CurrentDb()
Set rs = db.OpenRecordset("2006_Dic_Fijo") : Set rs2 = db.OpenRecordset("2006_Dic_Fijo_Tch")
Dim Tabla1(31, 24, 60, 60) As Integer
Dim ss As Integer: Dim mm As Integer: Dim hh As Integer: Dim dia As Integer
rs.MoveFirst
While Not rs.EOF
With rs
ss = Second(.Fields!Hora)
mm = Minute(.Fields!Hora)
hh = Hour(.Fields!Hora)
dia = Day(.Fields!Fecha)
Party = .Fields!Segundos
End With
For a = 1 To Party
Tabla1(dia, hh, mm, ss) = Tabla1(dia, hh, mm, ss) + 1
ss = ss + 1
If ss = 60 Then
ss = 0: mm = mm + 1
End If
If mm = 60 Then
mm = 0: hh = hh + 1
End If
If hh = 24 Then
hh = 0: dia = dia + 1
End If
If dia = 32 Then
dia = 1:
End If
Next a
rs.MoveNext
Wend
For Zap = 1 To 31
For Zep = 0 To 24
For Zip = 0 To 60
For Zop = 0 To 60
If Tabla1(Zap, Zep, Zip, Zop) > 0 Then
rs2.AddNew
With rs2
.Fields!dia = Zap
.Fields!Hora = Zep
.Fields!Minutos = Zip
.Fields!Segundos = Zop
.Fields!Canales = Tabla1(Zap, Zep, Zip, Zop)
End With
rs2.Update
End If
Next Zop
Next Zip
Next Zep
Next Zap
rs.Close: rs2.Close
MsgBox ("Fin de Ejecucion de Script")
viernes, 3 de agosto de 2007
Calculate Traffic Channels (1)
Part involved : Implementation of practical use to calculate the quantity of traffic channels needed.
Summary : How much need to grow our infrastructure in land lines, mobile phone calls and another types of callings ?
Scenario : Developing IT plans will be based on the growth of the future company needs and that includes how to calculate the quantity of traffic channels .
Company : Minister of Health of Peru (MINSA).
Reference date : October 2006.
The most type of PBX display reports with some profiles about detailed calling party processed into PBX, this information is the input that we need to generate into our own model of trunking size. Next lines is an example of this type of information :
2832 Ana M.León M OGP1 0609010125000:00:05 0.74 S 0' 4481949 N 0001001001001 40 0BA
When information is not formatted like than the upper lines then is necessary to start with preliminar delimited field information of every record in order to establish a standard input information with the purpose of create a main input call party file log, such as next lines :
"01/11/2006","00:01:00","2782","5519617",0 “ is the same to say
Date, Time, from Extension, Number called, Call party time (secs)
When the information is appended according to the last format is possible to filter the information with every field or the combination of these ones. Next script works under excel enviroment and can be executed to achieved this goal. Check that the differents levels of code nesting are separated with differents colors.
Ruta10:
FilaIn = 1: FilaOut = 1: condicion = True
While condicion = True
If ActiveSheet.Cells(FilaIn, 1).Value = "" Then
End If
If Taz >= 1 Then condicion = False
Level1 = 0: Level2 = 0: Level3 = 0: Level4 = 0
ActiveSheet.Cells(FilaIn, 1).Select
CCadena = ActiveSheet.Cells(FilaIn, 1).Value
Ccadena1 = Left(CCadena, 2)
Ccadena2 = Left(ActiveSheet.Cells(FilaIn + 1, 1).Value, 2)
If Ccadena1 = " " Then
ActiveSheet.Cells(FilaIn, 9).Value = ""
Else
ActiveSheet.Cells(FilaIn, 9).Value = "NO"
End If
If Ccadena1 <> " " And Ccadena2 <> " " Then
Selection.EntireRow.Delete
Else
FilaIn = FilaIn + 1
End If
'
Wend
FilaIn = 1: condicion = True: Par = 0: Taz = 0
While condicion = True
If ActiveSheet.Cells(FilaIn, 1).Value = "" Then
Taz = Taz + 1
End If
If Taz >= 1 Then condicion = False
ActiveSheet.Cells(FilaIn, 1).Select
CCadena = ActiveSheet.Cells(FilaIn, 9).Value
If CCadena = "NO" And Par = 0 Then ActiveSheet.Cells(FilaIn, 10).Value = ""
If CCadena <> "NO" And Par = 0 Then ActiveSheet.Cells(FilaIn, 10).Value = "Error"
If CCadena = "" And Par = 1 Then ActiveSheet.Cells(FilaIn, 10).Value = ""
If CCadena <> "" And Par = 1 Then ActiveSheet.Cells(FilaIn, 10).Value = "Error"
If ActiveSheet.Cells(FilaIn, 10).Value = "Error" Then
Selection.EntireRow.Delete
Else
Par = Par + 1: FilaIn = FilaIn + 1
If Par = 2 Then Par = 0
End If
Wend
' Crear archivo de texto con las columnas Fecha, Hora, Anexo, NumeroLlamado, Segs
' en modo append
Ruta1:
FilaIn = 1: Techito = True: Taz = 0
Dim Fecha As Date: Dim Hora As Date
Dim cadena1 As String: Dim cadena2 As String
Dim numero As String: Dim Cadena As String: Dim anexo As String: Dim tmp As String
Dim saro As String: Dim smes As String: Dim sdia As String: Dim shh As String: Dim smm As String: Dim sss As String
Dim ss1 As String: Dim ss2 As String: Dim ss3 As String
Dim iaro As Integer: Dim imes As Integer: Dim idia As Integer: Dim ihh As Integer: Dim imm As Integer: Dim iss As Integer
Dim iss1 As Integer: Dim iss2 As Integer: Dim iss3 As Integer
While Techito = True
ActiveSheet.Cells(FilaIn, 1).Select
Estacion = Len(ActiveSheet.Cells(FilaIn, 1).Value)
If Estacion = 0 Then
Taz = Taz + 1
End If
If Taz >= 1 Then Techito = False
Level1 = 0: Level2 = 0: Level3 = 0: Level4 = 0
Cadena = ActiveSheet.Cells(FilaIn, 1).Value
Largo = Len(Cadena)
For a = 1 To Largo
If Mid(Cadena, a, 1) = "" Then Level1 = Level1 + 1: Level2 = 0
If Mid(Cadena, a, 1) = " " Then Level2 = Level2 + 1
If Level1 = 1 And Level2 = 0 Then anexo = anexo + Mid(Cadena, a + 1, 1)
If Level1 = 4 And Level2 = 0 Then
If Level3 >= 1 And Level3 <= 2 Then saro = saro + Mid(Cadena, a, 1)
Next a
tmp = "": If Left(numero, 1) = "1" Then numero = Mid(numero, 2, Len(numero))
For b = 1 To Len(numero)
If Mid(numero, b, 1) = " " Then
Else
tmp = tmp + Mid(numero, b, 1)
End If
Next b: numero = tmp: tmp = ""
For b = 1 To Len(anexo)
If Mid(anexo, b, 1) = " " Then
Else
tmp = tmp + Mid(anexo, b, 1)
End If
Next b: anexo = tmp: tmp = ""
segs = 0
iaro = Val(saro): imes = Val(smes): idia = Val(sdia)
ihh = Val(shh): imm = Val(smm): iss = Val(sss)
iss1 = Val(ss1): iss2 = Val(ss2): iss3 = Val(ss3)
Fecha = DateSerial(iaro, imes, idia): cadena1 = Fecha
Hora = TimeSerial(ihh, imm, iss): cadena2 = Hora
If iss1 = 0 Then
Else
segs = segs + (3600 * iss1)
End If
If iss2 = 0 Then
Else
segs = segs + (60 * iss2)
End If
If iss3 = 0 Then
Else
segs = segs + iss3
End If
Open "C:\Temo\1.txt" For Append As #1
Write #1, cadena1, cadena2, anexo, numero, segs: Close 1
FilaIn = FilaIn + 1: Level1 = 0: Level2 = 0: Level3 = 0: Level4 = 0
saro = "": smes = "": sdia = "": ss1 = "": ss2 = "": ss3 = "": shh = "": smm = "": sss = ""
iaro = 0: imes = 0: idia = 0: ihh = 0: imm = 0: iss = 0: anexo = "": numero = "": tmp = ""
Wend
MsgBox ("Fin de Ejecución del Programa")
lunes, 23 de julio de 2007
Designing VLAN
What do you seem the method ?
viernes, 20 de julio de 2007
Automation sending email
Part Involved : Excel
Summary: Monitoring process involved to send notifications in the same moment that the event has been detected..
Scenario : After the event has been triggered using VBA programming code enviroment is used to send a warn message by email to chief supervisor.
Company : Ministry of Health of Peru (MINSA).
Reference Date : March 2007.
Develop programming code VBA brings a intesting integration tool because the entire Office Suite (Access, Excel, Word, Power Point, OutLook itself) can be connected to the programmed VBA code developed and use as instance every resource available into Office as input data for our programming code to fire the event desired (in this case -send an email-). The exception is : only works up to office 2000, after that Microsoft inserted into office suite a security issue where it forbids a third party vendor use this plattaform as base to launch emails. The same restriction is applied when the interchange information between every office suite is used. But there is another type of executable file that handle client email functions that I will take in additionally topic. Next example works nice but up to Office 2000
Dim Uno As Object
Set Uno = CreateObject("Outlook.application")
Set Dos = Uno.GetNameSpace("MAPI")
Set Tres = Uno.CreateItem(0)
Tres.To = "germanmedinavirtual@gmail.com"
Tres.Subject = "Summary " + Str(hoy)
Tres.Body = Message
Tres.Send
Set Uno = Nothing: Set Dos = Nothing: Set Tres = Nothing:
lunes, 16 de julio de 2007
GSM 850 MHZ with noise ?
Part Involved : GSM 850 MHz
Summary: The quality of mobile call party has been degraded.
Scenario : Mobile call party has a lot of noise inside of main building of MINSA (HQ).
Company : Ministry of Health of Peru (MINSA).
Reference Date : April 2007.
sábado, 14 de julio de 2007
Opening a new GSM mobile phone shop center
Part involved : Assistance to the entire sets of mobile phone of Telefonica of Peru (GSM 850Mhz).
Summary : A new point of Technical support opening for GSM mobile phones.
Scenario : The user of the mobile phone services need to discard problems from the same equipment and following the best quality of the call service.
Company : Chaquinet Telecomunicaciones SRL.
Reference date : Julio 2007.
My friend Freddy Fabian has opened a new point of sales and technical support for GSM mobile phone while at the same time is an authorized agent of the mobile carrier operator Telefonica of Peru on north of Lima city. I was invited by him during the opening party and from here I want to congratulate him for this important step into the business world.
martes, 10 de julio de 2007
Wireless DWL-900AP+ Configuration
viernes, 6 de julio de 2007
Connection to database Oracle 10G
Part Involved : Log in
Summary : Can not log in to database.
Scenario : Your connection to database is refused, the problem become from LAN issues ?
Company : National Institute of Cancer sickness of Peru (INEN).
Reference Date : June 2006.
This subject involved to know additional knowledge from Oracle plattform in order to discard suppose Oracle problems and focused on LAN issues.
1.- The client computer has a file called tnsnames.ora saving the profile of the strings of connections of every database available into networking infrastructure configured.
2.- Next lines belongs to a sample of tnsnames.ora file
#tnsnames.ora Network Configuration File:
D:\oracle\product\10.2.0\db_1\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.
ORCL=
(DESCRIPTION=
(ADDRESS=(PROTOCOL=TCP)(HOST=707-03)(PORT=1521)
(CONNECT_DATA=
(SERVER=DEDICATED)
(SERVICE_NAME= sw1)
)
)
BD=
(DESCRIPTION=
(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.16.100)(PORT=1521)
(CONNECT_DATA=
(SERVER=DEDICATED)
(SERVICE_NAME= sw1)
)
)
EXTPROC_CONNECTION_DATA=
(DESCRIPTION=
(ADDRESS_LIST=
(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1))
)
(CONNECT_DATA=
(SID=PLSExtProc)
(PRESENTATION= RO)
)
)
3.- SERVICE_NAME is the name of the Oracle instance while ORCL and BD are the strings of connections to database, then from DOS windows execute next command directed to the strings of connection :
C:\> tnsping bd
TNS Ping Utility for 32-bit Windows: Version 10.2.0.1.0 - Production on 06-JUL-2007 17:51:29
Copyright (c) 1997,2005, Oracle. All rights reserved.
Archivos de parametros utilizados:
D:\Oracle\product\10.2.0\db_1\network\admin\sqlnet.ora
Adaptador TNSNAMES utilizado para resolver el alias
Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.16.100)(PORT = 1521)(CONNECT_DATA = (SERVER=DEDICATED) (SERVICE_NAME = sw1)))
Realizado correctamente (10 mseg)
C:\>
This is a example that connection from your computer and database is working.
4.- Now try with next command :
C:\> ping 192.168.16.100
5.- If you have answer from ping command and not from tnsping command then the Oracle listener is down. Later I will take this issue.
lunes, 2 de julio de 2007
POP3 connectivity
Part Involved : Port 110
Summary : Checking if POP3 functions is working with configuration of email service.
Scenario : Sometimes email does not arrive to our inbox while client insist you to say : I have sent you.
Company : National Institute of Cancer sickness of Peru (INEN).
Reference Date : April 2003.
Sometimes is not enough to set up configuration of user mailbox, POP3 and SMTP into outlook user profile account such as http://germanmedinavirtual.blogspot.com/2007/04/migrating-pst-2003-2007-to-previous.html when trying to recover email is not working because there is some type of lost connection -seemingly- , after that additionally it needs to test if mailbox account is working and you can achive when log in to email server account and execute POP3 commands and rule out bad connections of LAN issues from probably email server services problems. Next lines are a true example (with real email server and user account) that you can follow to troubleshoot your connection with email server using POP3 commands.
C:\> telnet inen6.inen.sld.pe 110
+OK POP3 inen6.inen.sld.pe 2004.89 server ready
user prueba1
+OK User name accepted, password please
pass prueba1
+OK Mailbox open, 20 messages
list
+OK Mailbox scan listing follows
1 15955
2 36492
3 31637
4 14385
5 1340
6 1441
7 1444
8 1444
9 1444
10 1444
11 1443
12 1443
13 1443
14 1443
15 1443
16 1443
17 1443
18 1444
19 11596
20 1443
stat
+OK 20 131610
Reach to here means connectivity from your pc to email server account is ok, list command shows the quantity of email saved temporaly into email server -identify by ID- waiting to download in the next connection and stat command shows the summary of the previous command. To close connection proceed :
quit
+OK Sayonara
Se ha perdido la conexión con el host
C:\>
miércoles, 27 de junio de 2007
Timer 102 and Timer 160 into Alcatel 4400
Part Involved : Timer 260 and Timer 102.
Summary : Troubleshooting and adjust the values of timers.
Scenario : Add information related to how to set up these sets of timers
Company : National Institute of Cancer sickness of Peru (INEN).
Reference Date : April 2003.
Connect to PBX through telnet command by user mtcl, then proceed to follow next sequence : mgr / Translator / External Numbering Scheme / Numbering Descriptor / go down hierarchy / Consult Modify overview object
Timer 260 set up the maximum time of calling party and its relation scale vs value are 600 = 1 minute. This value will affect to overall outgoing call party restricted by "Telephone Facility category Id" from PBX.
Timer 102 set up a threshold time between when the calling party starts and the message of welcome starts. In this case 100 = 10 seconds. Taking as reference that values then the welcome message will be listen 10 seconds after started the calling party.
lunes, 25 de junio de 2007
UpLink Rf's samples
Part Involved : 9600 Frame.
Summary : Set up a procedure to collecting measures of RF on UpLink.
Scenario : Define the lobule of coverage of the Cell Site upLink
Company : Motorola of Peru
Reference Date : January 1998.
At the Cell site connect to 9600 frame through LMF by LAN port with the next steps :
Login ALMF
ALMF> disp tch 2 config /** Verify frecuency and sector -sets of antennas-
ALMF>keyup tch 2
Outside of the Cell site, proceed with engineer mode with the mobile phone configuring the traffic channel :
*11----* /** Frecuency in four digits
This step force to the mobile phone to track only in that traffic channel, then after this confirm to team in Cell site to proceed to open log file of RSSI values into cell site.
ALMF>start emd log file=/usr/emd/logs/test1.dat
ALMF>monitor tch 2 rssi on
ALMF>monitor tch 2 rssi off
ALMF>Force tch 2 oos
ALMF>LmfCtrl xcvr 2
ALMF>keyup xcvr 2
viernes, 22 de junio de 2007
Slow/fail connections dLink DI-624
Part Involved : DI-624 or DI-624+.
Summary : Recomendation to set up configuration of Access Point.
Scenario : Sometimes the device does not respond or is very slowly
Company : National Institute of Cancer sickness of Peru (INEN).
Reference Date : June 2006.
.16:14:23.506164 00:a0:f8:ae:9b:44 (oui Unknown) > 01:a0:f8:f0:f0:02 (oui Unknown), ethertype Unknown (0x8781), length 237:
0x0000: 002d 0000 00d7 0000 0007 0007 0000 0001 .-..............
0x0010: c0a8 47d4 0000 0000 0000 0001 0000 0e02 ..G.............
0x0020: 0300 0000 0000 0000 4e45 4f50 4c41 5349 ........NEOPLASI
0x0030: 4341 5300 0000 0000 0000 0000 0000 0000 CAS.............
0x0040: 0000 0000 0000 0000 0000 0000 000c 3033 ..............03
0x0050: 2e37 .7
16:14:23.883708 IP COMPUTO003.137 > 192.168.71.255.137: UDP, length 50
16:14:24.226375 arp who-has COMPUTO003 tell NETWORKING01
16:14:24.226530 arp reply COMPUTO003 is-at 00:05:5d:6b:11:5b (oui Unknown)
16:14:24.226536 IP NETWORKING01.137 > COMPUTO003.137: UDP, length 50
16:14:24.226752 IP COMPUTO003.137 > NETWORKING01.137: UDP, length 229
16:14:24.307070 arp who-has 192.168.71.136 tell FILESERVER
16:14:24.633673 IP COMPUTO003.137 > 192.168.71.255.137: UDP, length 50
16:14:25.239559 arp who-has 192.168.71.136 tell NETWORKING01
16:14:25.533321 IP 192.168.0.12.1900 > 239.255.255.250.1900: UDP, length 253
16:14:25.533488 IP 192.168.0.12.1900 > 239.255.255.250.1900: UDP, length 253
16:14:25.533597 IP 192.168.0.12.1900 > 239.255.255.250.1900: UDP, length 271
16:14:25.533773 IP 192.168.0.12.1900 > 239.255.255.250.1900: UDP, length 271
......
.....
.....
16:14:31.015531 IP 192.168.0.11.1900 > 239.255.255.250.1900: UDP, length 317
16:14:31.020414 IP 192.168.0.11.1900 > 239.255.255.250.1900: UDP, length 245
16:14:31.024321 IP 192.168.0.11.1900 > 239.255.255.250.1900: UDP, length 319
16:14:31.036038 IP 192.168.0.11.1900 > 239.255.255.250.1900: UDP, length 289
16:14:31.043850 IP 192.168.0.11.1900 > 239.255.255.250.1900: UDP, length 313
16:14:31.547790 IP LOGIS04.138 > 192.168.71.255.138: UDP, length 201
16:14:34.447520 IP PISO701X.137 > 192.168.71.255.137: UDP, length 50
16:14:34.458966 arp who-has 192.168.71.137 tell FILESERVER
16:14:38.743974 IP NETWORKING01.137 > FILESERVER.137: UDP, length 50
16:14:38.750300 IP NETWORKING01.137 > 239.255.255.250.137: UDP, length 50
miércoles, 13 de junio de 2007
Microphone does not work in WebCam DLV-B33
Part Involved : DLV-B33.
Summary : Troubleshooting configuration of new device into my computer.
Scenario : I have detected microphone -incorporated in web Cam- is not working.
Company : Private computer.
Reference Date : June 2007.
In a few words I will describe only the steps necessary to fulfill with the installation of this device :
1.- Install the mini DVD video software WebCam and select the choice "302" after finish this process it will appear a message to reset computer.
2.- During reset process plug the usb webcam. (only plug from now)
3.- Then proceed to update this driver, after that restart computer system again.
4.- Start/Programs/Vmicro USB Pc Camera (ZC0302)/AMPCAP
5.- Click menu Capture and review if the item "Capture Audio" can not be selected then you should proceed to uninstall the software web cam, restart computer again and start from the step 1 again.
6.- Enable audio option clicking on "Capture Audio".
7.- Testing capture images with audio click on menu "file/set capture file" to specify location of file and to begin with capture click on menu "Capture/Start Capture; later review if the file contains audio with video.
martes, 5 de junio de 2007
Set up ip in 3Com
Part Involved : 4500.
Summary : Procedure to set up ip -first time- on switching equipment .
Scenario : Remote management of switching equipment.
Company : National Institute of Cancer illness of Peru (INEN).
Reference Date : June 2006.
Follow the next tips :
1.- Connect cable between 3Com switching equipment (RJ45 port) and computer (com1 port). -the cable becomes with switching equipment-.
2.- On computer enable hyperterminal with the next features : 19200, 8, N, 1, hardware.
3.- With hyperterminal window type (ENTER) and type user "admin".
4.- <4500> type: system-view (ENTER)
5.- [4500] type: interface vlan 1 (ENTER)
6.- [4500-Vlan-interface1] type: ip address 192.68.x.y 255.255.255.0
7.- Press (CTRL+Z) and prompt swap to:
8.- <4500> type: save (ENTER)
9.- The configuration will be written to the device.
Are you sure?[Y/N]; type Y(ENTER)
10.- Please input the file name(*.cfg)[flash:/3comoscfg.cfg]:; type (ENTER)
11.- Check the next messages
Now saving current configuration to the device.
Saving configuration. Please wait
.......
Configuration is saved to flash memory successfully.
Unit1 save configuration flash:/3comoscfg.cfg successfully
12.- Turn off switch and verify through ping command or internet browser that the ip has been saved successfully.
Next, I have attached a log of 3Com switching equipment when the equipment is restarted.
Username:admin
Password:
<4500>%Apr 1 23:57:04:651 2000 4500 SHELL/5/LOGIN:- 1 - admin(aux0) in unit1 login
System View: return to User View with Ctrl+Z.
[4500]interface vlan 1
[4500-Vlan-interface1]ip address 192.168.88.156 252.255.255.0 Error: Invalid IP address or subnet mask!
[4500-Vlan-interface1]save ^ % Unrecognized command found at '^' position.
[4500-Vlan-interface1]
The configuration will be written to the device. Are you sure?[Y/N] Y
Please input the file name(*.cfg)[flash:/3comoscfg.cfg]:
Now saving current configuration to the device.
Saving configuration. Please wait...
....
Configuration is saved to flash memory successfully.
Unit1 save configuration flash:/3comoscfg.cfg successfully
<4500>%Apr 1 23:59:34:201 2000 4500 CFM/3/CFM_LOG:- 1 -Unit1 save configuration successfully.
<4500>#Apr 2 00:01:18:849 2000 4500 L2INF/2/PORT LINK STATUS CHANGE:- 1 - Trap 1.3.6.1.6.3.1.1.5.4: portIndex is 4227690, ifAdminStatus is 1, ifOperStatus is 1
#Apr 2 00:01:19:49 2000 4500 IFNET/5/TRAP:- 1 -1.3.6.1.6.3.1.1.5.4Interface 31 is Up %Apr 2 00:01:19:149 2000 4500 L2INF/5/PORT LINK STATUS CHANGE:- 1 - Ethernet1/0/9: is UP
%Apr 2 00:01:19:265 2000 4500 L2INF/5/VLANIF LINK STATUS CHANGE:- 1 - Vlan-interface1: is UP
%Apr 2 00:01:19:382 2000 4500 IFNET/5/UPDOWN:- 1 -Line protocol on the interface Vlan-interface1 is UP
%Apr 2 00:01:19:499 2000 4500 STP/2/SPEED:- 1 -Ethernet1/0/9's speed changed!%Apr 2 00:01:19:599 2000 4500 STP/2/PFWD:- 1 -Ethernet1/0/9 is forwarding!
Starting......
******************************************************************
* *
* SuperStack 3 Switch 4500 26-Port BOOTROM, Version 1.00 *
* *
******************************************************************
Copyright 2003-2005 3Com Corporation. All Rights Reserved.
Creation date : Sep 13 2005, 11:36:29
CPU type : BCM4704
CPU Clock Speed : 200MHz
BUS Clock Speed : 33MHz
Memory Size : 64MB
Mac Address : 0016e00ff700
Press Ctrl-B to enter Boot Menu... 1
Auto-booting...
Decompress image....................................................OK!
Starting at 0x80100000...
User interface aux0 is available.
Press ENTER to get started.
Login authentication
Username:%
viernes, 1 de junio de 2007
Engineer mode in mobile phone
Part Involved : Engineer mode or testing mode.
Summary : Enable engineer mode or testing mode into mobile phone.
Scenario : Troubleshooting traffic channels of Cell sites .
Company : Motorola of Perú.
Reference Date : Nov 1997.
1 32511
2 10101100
3 511 96628500
4 10
5 02
6 10
7 000000
8 123
9 004
10 11000100
11 00000000
12 0333
13 0333
14 0334
15 021
16 10100011
Parameter 1 is SID and is the local identification of the carrier operator in that city and 15 indicates the quantity of SIG (signal channel) to scan during idle mode, while 3 is the world number of the mobile phone. The rest of the parameters will be taken with frecuency plan issue.
viernes, 25 de mayo de 2007
RadioOperators Guideline
Part Involved : Handing equipments
Summary : Training of use radio equipment.
Scenario : Meeting of institutions cares prevention of disasters.
Company : National Institute of Emergency Squad (INDECI).
Reference Date : May 2007
miércoles, 23 de mayo de 2007
Public Bidding Nº 11-2006-MINSA
Part Involved : Nomination of the winner of public bidding
Summary : Today was scheduled at 3:00pm with notary, candidates suppliers and members of the commitee
Scenario : Project of implementation of new equipment communications to LAN MINSA main building office.
Company : Minister of Health of Perú (MINSA).
Reference Date : May 2007
lunes, 21 de mayo de 2007
Error to downloads e-mails
Part involved : OutLook.
Summary : e-mails does not download successfully.
Scenario : POP3 server is outside of LAN
Company : Ministry of Health of Perú (MINSA).
Reference date : May 2007
miércoles, 16 de mayo de 2007
LAN wireless
Part involved : Network wireless by dLink.
Summary : Reinforce through wireless knowledge.
Scenario : Anniversary.
Company : Engineers Association of Perú (CIP).
Reference date : May 2007.
Take as reference, this type of meeting needs labs to testing technology and simulate situations -propose a implementation of solution and a set of installations as an example-, without this we are going to fall into the retoric speech of the politicians.
Saving the meeting I have attached at the end of the web page the procedure to crack wep of wireless network teached into this conference.lunes, 14 de mayo de 2007
XCVRs of 9600 Frame
Part involved : 9600 Frame.
Summary : Distribution of XCVR cards into 9600 Motorola cabinet.
Scenario : The analog cell site coverage area (AMPS , NAMPS) used this hardware to manage the outgoing and incoming calls.
Company : Motorola of Perú.
Reference date : December 1997.
SIG 10 : Carry out REVERSE of sector 3.
SIG 11 : Carry out REVERSE of sector 2.
SIG 12 : Carry out REVERSE of sector 1 and FORDWARD of all the Cell Site.
SIG 22 : Redundant of SIG 10.
SIG 23 : Redundant of SIG 11.
SIG 24 : Redundant of SIG 12.
The SCAN measures the power received from the mobile phone –as part of the process involved into REVERSE- then it is taking measure and samples of Handoff process (request HOMR – Handoff Measurement Request), then the current cell site asks to the SCANS of the neighborhood cell sites to compare how do they received the signal of that calling party –tiny, strong signal- and looking if the readings of the signal is inside of the values permited if this condition is fullfilled then the neighborhood cell site takes the control of the calling party and accepted the rest of rotuing connections established in the current call party.