Help to build a graph template for Huawei MA5800 OLT

[Sophanith]

Hi All,

I'm starting to deploy one Huawei MA5800 OLT and looking for scripts and graph template to fetch all graph on interfaces uplink port, PONs UP/DOWN Link port and ONT/ONU connect to end customer port.

If you could share or build such this graph/script template using its OIDs. Or please let me know for other requirements needed or questions.
I am happy to pay if you can build a workable template/scripts to fits my requirements.


Thanks,

[ramyramy]

Hi All,

I'm starting to deploy one Huawei MA5800 OLT and looking for scripts and graph template to fetch all graph on interfaces uplink port, PONs UP/DOWN Link port and ONT/ONU connect to end customer port.

If you could share or build such this graph/script template using its OIDs. Or please let me know for other requirements needed or questions.
I am happy to pay if you can build a workable template/scripts to fits my requirements.


Thanks,

Hello dear friend
did you find a solution for your work, I fell into the same problem

[adriansima]

Hello there!

I already did MA5600 template for my company, but I'm happy to sharing with others.

This template runs on cacti 1.2 and will draw graphics for:
1. CPU loading for each OLT card;
2. Interface statistics for each ONU, including: traffic, unicast, errors; Non-unicast statistics may be added sometime;
3. Statistics for Optical Power Level for ONU's and OLT, including; ONU RX and TX power, CATV RX (if ONT support) and OLT RX power

SNMP queering against Optical Power Level may stress the OLT. Based on this reason, the OLT queries was distributed over a longer period of time, which required a secondary poller script distinct from cacti poller. This script will use cacti database to store data and must be addled to crontab to be run at every 5 minutes! OPL poller needs one hour to populate all data.

By default, total queering interval was sets to one hour, but you may adjust by your needs by editing poller script ($periodReadingTime on ontopl_poller.php). $periodReadingTime it gives us the graph granulation as well. One hour period are suitable up to 1000 ONU.

Installing instruction:
- unzip the ma5600_template.zip
- copy contents of ma5600_template folder to your cacti root folder
- import to cacti cacti_host_template_olt_huawei_ma5600.xml
- create a new rule on your system crontab to run ontopl_poller.php script at every 5 minutes. Eg: */5 * * * * cd <cacti path> ; /usr/bin/php <cacti path>/ontopl_poller.php >/dev/null 2>&1
- create device by selecting 'Device Template' MA5600 and wait one hour to let template to get all data from device
- on 'Associated Data Queries' reload query on each 'Data Query Name'
- continue to 'Create Graph'


I can offer you support to comply template with your requirements.

Enjoy!

[cdamsa]

works well however can you help with this

- SYSTEM STATS: Time:27.0038 Method:cmd.php Processes:1 Threads:0 Hosts:8 HostsPerProcess:8 DataSources:3426 RRDsProcessed:1604
- CMDPHP SQL Backtrace: (/var/lib/cacti/scripts/ontopl_poller.php[69]:db_fetch_assoc(), /lib/database.php[452]:db_fetch_assoc_prepared(), /lib/database.php[466]:db_execute_prepared())
- CMDPHP ERROR: A DB Row Failed!, Error: Table 'cacti.ont_opl_devices' doesn't exist
- CMDPHP SQL Backtrace: (/var/lib/cacti/scripts/ontopl_poller.php[65]:db_execute(), /lib/database.php[191]:db_execute_prepared())

thanks

-cdma

[adriansima]

Hello,

Check your database. Cacti DB user must be able to create tables.
Also you may create tables manually. Load the attached sql file to your database.

[cdamsa]

hi ,

cacti db user is able to create table and the table already existed

Code: Select all

 mysql -u root -p cacti < ont.sql
Enter password:
ERROR 1050 (42S01) at line 1: Table 'ont_opl_devices' already exists

and the errors are still there

[adriansima]

Create a directory under the cacti folder. Eg: ontopl_poller and move ontopl_poller.php onto this directory.

Create a new rule on your system crontab to run this script at every 5 minutes. Eg:
*/5 * * * * cd /var/lib/cacti/ontopl_poller ; /usr/bin/php /var/lib/cacti/ontopl_poller/ontopl_poller.php >/dev/null 2>&1

If you want to run this script from the cacti root folder, edit ontopl_poller.php file and change this: '/../include/cli_check.php' to '/include/cli_check.php', and adjust system crontab rule for this path.

Cacti cmd.php is executing this script but is not designed for this. "scripts" folder are not a functional path for ontopl_poller.php

[joca]

Sorry, we could not process your last action.
XML: Hash version does not exist.
XML parse error.


tested on cacti 1.2.2 and 0.8.8h

[adriansima]

Try on Version 1.2.7,
only *.xml must be imported.

[joca]

ON ma5800
Total: 0.000000, Delta: 0.000000, Found data query XML file at '/usr/share/cacti/site/resource/script_queries/ont_opl.xml'
Total: 0.000000, Delta: 0.000000, Running Data Query [21].
Total: 0.000000, Delta: 0.000000, Found Type = '4' [Script Query].
Total: 0.000000, Delta: 0.000000, XML file parsed ok.
Total: 0.140000, Delta: 0.140000, Executing script for num of indexes '/usr/bin/php -q /usr/share/cacti/site/scripts/ont_opl.php '10.40.50.1' 'public123' 'num_indexes''
Total: 0.140000, Delta: 0.000000, Found number of indexes: 0
Total: 0.250000, Delta: 0.110000, ERROR: Data Query returned no indexes.

[adriansima]

Did you create a new rule on your system crontab to run ontopl_poller.php script at every 5 minutes?
After that, create device by selecting 'Device Template' MA5600 and wait one hour to let template to get all data from device

[joca]

Did you create a new rule on your system crontab to run ontopl_poller.php script at every 5 minutes?
After that, create device by selecting 'Device Template' MA5600 and wait one hour to let template to get all data from device

yes ,I will wait a few hours

[adriansima]

contact me via email dan.adrian@gmail.com

[joca]

hi, edit OLT - CPU Usage , common Options title to
|host_description| - CPU Usage - |query_cardtype| - |query_cpuIndex|
to show slot id

Seleção_010.jpg (113.64 KiB) Viewed 10722 times

[ataullahsaleem]

04-09-2020 16:53:45 - CMDPHP ERROR: A DB Row Failed!, Error: Table 'cacti.ont_opl_devices' doesn't exist