Author Archives: Vyacheslav

How to change the drive letter in Windows

For different versions of Windows, the procedure for changing the drive letter is almost the same.

To change the drive letter in Windows 8, click “Start“, type “Control Panel” on the screen, select “Control Panel” – “Administration” – “Computer Management” – “Disk Management“.
On the right disk, right-click the bears and select “Change Drive Letter and Path …“, click “Change…” in the window that opens, select “Assign the folowing drive latter” if it is not selected and select the desired letter, click “OK” to finish. Click “Yes” to confirm.

You can also open the Computer Management window by typing “compmgmt.msc” on the command line or in the search bar.

Configuring an FTP server on MikroTik Router OS

Usually an FTP server on MikroTik Router OS is enabled and uses ports 20 and 21 for communication.
Connection type without encryption, login and password are same as for access to mikrotik.

You can connect by typing the ip address of the router in the browser’s address bar:
ftp://192.168.88.1

Via the graphical interface, the FTP service is turned off and turned on in the “IP” – “Service”

Through the command line:

ip service disable service_number
ip service enable service_number

View a list of services:

ip service print

To view the information about the files, you can run the following command:

file print detail
disk print detail

SQL queries for Zabbix

I will write some useful examples of sql queries for the Zabbix database:

Search for a host by name:

SELECT * FROM hosts WHERE host like '%name%';
SELECT * FROM hosts WHERE name like '%name%';

Find the data items of the specified host:

SELECT * FROM items WHERE hostid = '10105';

Find the history of the values for the specified data item:

SELECT * FROM history WHERE itemid = '24526';

Delete the whole history of the data element until 01.11.2014 (the time is specified in Unix format, converters can be found through the search engine):

DELETE FROM history WHERE itemid = '24526' AND clock < '1414800000';

Delete all data history until 01.11.2014:

DELETE FROM history WHERE clock < '1414800000';

Massively changed the interval and dynamics of changes to the data elements of templates and hosts, I have the following queries (the first identifies the template ID or host, the second changes the intervals):

SELECT * FROM `hosts` WHERE host="Template ICMP Ping";
UPDATE items SET delay=3600 WHERE hostid=10105 AND delay=600;
UPDATE items SET trends=180 WHERE hostid=10047 AND trends=365;

Adding ONT PICOTEL PU-G510 on Huawei SmartAX MA5683T

Suppose that we set up Huawei SmartAX MA5683T and added lineprofile/srvprofile using this instruction: Configuring Huawei SmartAX MA5683T through the console

Next, add ONT similarly as I wrote in the article Alcatel-Lucent I-010G

On the test after adding ONT PICOTEL PU-G510 to OLT Huawei SmartAX MA5683T, when connecting the computer to ONT – the Internet worked, when connecting the router – no.
Therefore, I still had to open the ONT web interface, pointing in the address line http://192.168.1.1 (login and password – admin), before registering the computer with a static IP 192.168.1.2.
In the web interface, select the menu “Admin” – “GPON Settings”, where “OMCI OLT Mode:”, if using Huawei OLT – select “Huawei OLT Mode” and click “Apply Changes”.

See how I did it on video:

Etnernet ports are disabled on ONT Huawei EchoLife

I recently noticed a problem that, when ONT, the Huawei EchoLife HG8110, HG8120 and HG8120R watched the Ethernet ports shutdown about 30 seconds after the ONT was turned on.
At the same time, ONT continued to work, the optical connection did not disappear.
On the Huawei EchoLife HG8110 the link did not disappear, but the interface ONT 192.168.100.1 stopped pinging.

The cause was defective power supplies.

Adding ONT Huawei EchoLife HG8120 and HG8120R

On the test I will use ONT Huawei EchoLife HG8120 (works only in Bridge mode as a media converter) and Huawei EchoLife HG8120R (can work as Router & Bridge, with reset settings has no configuration, so it works the same as HG8120 in Bridge mode).
The standard IP for both models is 192.168.100.1, the login is telecomadmin, the password is admintelecom.
I will use VLAN 228 for the Internet.

Continue reading “Adding ONT Huawei EchoLife HG8120 and HG8120R”

Firmware Update TP-Link TL-WR841N

It was necessary to flash TP-Link TL-WR841N router, because it periodically hung up, disconnected from the Internet, the router itself was pinging at that moment, but it was impossible to enter its web interface.

First, check the hardware version of the device, usually it is indicated on the label under the router, in our case it’s V8. I note that updating the firmware not from that version of the device can spoil it! Also, you can not update the firmware on Wi-Fi and turn off the power of the router during the firmware!

And so, to update the firmware you need:
1) Download the archive with the new firmware from the official site and unpack it
https://www.tp-link.com/us/download/TL-WR841N.html

2) Open the router settings by typing in the browser address http://192.168.0.1 and enter your login – admin, password – admin.

3) In the menu choose System Tools -> Firmware Upgrade, click the “Browse” button, select the previously downloaded firmware. Click “Upgrade”. Wait for the firmware to be installed and the device will reboot automatically.

After updating the firmware, the settings in the router are reset to standard.

Done.

This router model also has unofficial firmware DD-WRT
http://www.dd-wrt.com/site/support/router-database