Categories
Video

How to Install Cacti Server on WINDOWS | All SOLVED Error while Cacti Installation Wizard #cacti



**How to Install Cacti Server on WINDOWS Step by Step with all SOLVED Error during Cacti Installation Wizard**

Short Video how to install cacti under windows PC/Server
PART1: Fast video tutorial to install cacti: https://youtu.be/uP7ipMkgzaQ

Fixed all Cacti Pre-installation Errors Step by Step
PART2: Cacti Pre-installation Errors SOLVED: https://youtu.be/qHX0ctTUfC4

Cacti Tutorial PlayList:
https://www.youtube.com/playlist?list=PL2iPlJTsTrSRcLWPSRi–dF7rN4RyUzWb

Alternative Free Networking Monitoring Tool LibreNMS
LibreNMS Tutorials: https://www.youtube.com/playlist?list=PL2iPlJTsTrSRdSVlok674Bkou0zkrPbgb

CCNP Enterprise Training Course:https://www.youtube.com/playlist?list=PL2iPlJTsTrSQfHphYfo5HR0bmmQ08N1Hw

Follow our step by step Guide Lines :

Download Cacti link:
https://www.cacti.net/download_cacti.php

The latest stable version is 1.2.17, released 05/03/21
Cacti require MySQL, PHP, RRDTool, net-SNMP, and a web server that supports PHP such as Apache or IIS.

Before Installing CACTI on Windows Computer /Windows Server there are some Prerequisite:

Software Prerequisite:
Step1: Install XAMPP
Step2: Install Cacti Server
Step3: Configuring Database and Settings
Step4: Install RRD-Tool and net-SNMP
Step5: cacti post-installation settings

⌚ Timestamps
0:00 Cacti Introduction
0:52 Download & Install Xampp
1:47 Download & Extract Cacti Server
2:23 Download & Install Net-SNMP
2:31 Download & Install RRDtool
4:10 Setting PHP Timezone
9:21 Change Apache http/https Ports Number
11:02 Configure cacti DB
13:34 Cacti WEB Access
17:02 Fix Cacti Pre-Installation Checks Errors
23:39 Create Poller Script for cacti poller

Step1: Install XAMPP and settings
WARN:
1.It is highly recommended to set your system Date, Time, and ZONE
according to your country time, and zone.
2.XAMPP installation will be successful only if you have set the correct date, time, and zone
Under WINDOWs and PHP.
https://www.php.net/manual/en/timezones.asia.php

Once you have finished XAMPP installation you must change
Time & date under XAMPP Registry
I have already set my systems time and date I am going to change only the XAMPP time and date for PHP

3.Open Drive C: edit php.ini configuration file located in
C:xamppphp (file name (php) configuration setting)
Once you have changed the time& date must be restarted XAMPP

Probably your 3306 or whatever you use is being used by other applications. Maybe you don’t know that XAMPP usually has problems with apps like Skype. If you are running Skype try to close it and open XAMPP. You can also change default ports for HTTP and MySQL.
To Edit Apache ports open apache. conf and restart the server.
To Edit MySql ports open my.cnf and restart the service.

Step2: Import cacti folder under XAMPP register
File path: C:xampphtdoc

Step3: Create database and set DB name cacti
Import the cacti.sql file into MySQL database
NOTE:
Apache server did not open webpage if you have faced this error
You must change apache port

Step4:
Edit the cacti database settings located in
C:xampphtdocscactiinclude

Step5:
Open any web browser enter the IP address of your PC
http://127.0.0.1:8090/cacti
default username: admin
default password: admin

SQL command to set SQL time zone
MySQL -u root -p MySQL
GRANT SELECT ON mysql.time_zone_name TO cacti@localhost;
flush privileges;
exit

Note: if you did not fix SQL time and date errors you are still stuck then
download from here timezone list and copy-paste
C:xamppmysqldatamysql
https://dev.mysql.com/downloads/timezones.html
_________________________________________________
Error during Cacti Installation Wizard under MySQL my.ini file
add and some change parameters

[mysqld]
collation-server = utf8mb4_unicode_ci
max_allowed_packet = 16777216
max_heap_table_size = 256M
join_buffer_size = 512M
innodb_buffer_pool_size = 4096M
nnodb_flush_log_at_timeout = 3
innodb_read_io_threads = 32
innodb_write_io_threads = 16
innodb_io_capacity = 5000
innodb_io_capacity_max = 10000
innodb_buffer_pool_instances=35

Download net-SNMP for windows and install it
https://www.tuc.gr/fileadmin/Download_Files/Install_Net-SNMP_in_Windows.pdf

Last step:
Create a pooler script for cacti poller
Open notepad and copy-paste the below script ,save file format.bat and associate with a task scheduler that runs every 5 minutes
C:xamppphpphp.exe C:xampphtdocscactipoller.php
___________________________
PHP Modules required
How to install/enable PHP Modules

gd
gmp
sockets
com_dotnet
ldap

go to php.ini file
search this ;extension=gd
remove ; on all gp,gmp sockets,
and add
extension=com_dotnet
extension=ldap

cacti installation on windows 10 | free monitoring tools for windows
https://ipcorenetworks.blogspot.com/2021/05/cacti-pre-installation-checks-solved.html

Installing Cacti on a Windows system | install Cacti On Windows 10
#cacti #snmp #window10 #CACTI

source

Categories
Video

Database Clustering Tutorial 1 – Intro to Database Clustering



💯 FREE Courses (100+ hours) – https://calcur.tech/all-in-ones
🐍 Python Course – https://calcur.tech/python-courses

✅ Data Structures & Algorithms – https://calcur.tech/dsa-youtube

~~~~~~~~~~~~~~~ CONNECT ~~~~~~~~~~~~~~~

✉️ Newsletter – https://calcur.tech/newsletter
📸 Instagram – https://www.instagram.com/CalebCurry
🐦 Twitter – https://twitter.com/calebCurry
🔗 LinkedIn – https://www.linkedin.com/in/calebcurry
▶️ Subscribe – http://calcur.tech/subscribe
👨🏻‍🎓 Courses – https://www.codebreakthrough.com

~~~~~~~~~~~~~~ SUPPORT ME ~~~~~~~~~~~~~~

↪ My Amazon Store – https://www.amazon.com/shop/calebcurry
🅿 Patreon – http://calcur.tech/patreon-calebcurry
🅖 GitHub Sponsors – https://github.com/sponsors/CalebCurry
Ⓟ Paypal – http://paypal.me/calcur

🅑 Bitcoin – 3HnF1SWTzo1dCU7RwFLhgk7SYiVfV37Pbq
🅔 Eth – 0x350139af84b60d075a3a0379716040b63f6D3853
📈 Buy Bitcoin – https://calcur.tech/crypto
Reserve the Ruby Steel crypto rewards card and get a $25 bonus (use affiliate code “Caleb”) – https://calcur.tech/crypto

source

Categories
Video

Top 65 SQL Interview Questions and Answers | SQL Interview Preparation | SQL Training | Edureka



🔥 MYSQL DBA Certification Training: https://www.edureka.co/mysql-dba
🔥 Edureka Computer Science Bootcamp Program: https://www.edureka.co/masters-program/computer-science-bootcamp-program
This Edureka video on Top 65 SQL Interview Question and Answers (SQL Interview Questions blog: http://bit.ly/2G2XapU) will help you to prepare yourself for Database Administrators Interviews. It covers questions for beginners, intermediate and experienced professionals.

Subscribe to our channel to get video updates. Hit the subscribe button above: https://goo.gl/6ohpTV

Join Edureka’s Meetup community and never miss any event – YouTube Live, Webinars, Workshops etc. https://bit.ly/2EfTXS1

#edureka #edurekasql #sqlinterviewquestions #sql

——————–

📌𝐓𝐞𝐥𝐞𝐠𝐫𝐚𝐦: https://t.me/edurekaupdates
📌𝐓𝐰𝐢𝐭𝐭𝐞𝐫: https://twitter.com/edurekain
📌𝐋𝐢𝐧𝐤𝐞𝐝𝐈𝐧: https://www.linkedin.com/company/edureka
📌𝐈𝐧𝐬𝐭𝐚𝐠𝐫𝐚𝐦: https://www.instagram.com/edureka_learning/
📌𝐅𝐚𝐜𝐞𝐛𝐨𝐨𝐤: https://www.facebook.com/edurekaIN/
📌𝐒𝐥𝐢𝐝𝐞𝐒𝐡𝐚𝐫𝐞: https://www.slideshare.net/EdurekaIN
📌𝐂𝐚𝐬𝐭𝐛𝐨𝐱: https://castbox.fm/networks/505?country=IN
📌𝐌𝐞𝐞𝐭𝐮𝐩: https://www.meetup.com/edureka/
📌𝐂𝐨𝐦𝐦𝐮𝐧𝐢𝐭𝐲: https://www.edureka.co/community/

——————-
How does it work?

1. This is a 4 Week Instructor-led Online Course.
2. The course consists of 24 hours of online classes, 25 hours of assignment, 20 hours of project
3. We have a 24×7 One-on-One LIVE Technical Support to help you with any problems you might face or any clarifications you may require during the course.
4. You will get Lifetime Access to the recordings in the LMS.
5. At the end of the training, you will have to complete the project based on which we will provide you with a Verifiable Certificate!

– – – – – – – – – – – – – –

About the Course

MySQL DBA Certification Training trains you on the core concepts & advanced tools and techniques to manage data and administer the MySQL Database. It includes hands-on learning on concepts like MySQL Workbench, MySQL Server, Data Modeling, MySQL Connector, Database Design, MySQL Command line, MySQL Functions etc. End of the training you will be able to create and administer your own MySQL Database and manage data.

– – – – – – – – – – – – – –

Who should go for this course?

This course can be beneficial for people having the below professional background:
Database Developers
Application Developers
Database Designers
Database Administrators
– – – – – – – – – – – – – –

Project

In the project you will be creating a Database using MySQL on SALARY MANAGEMENT SYSTEM :-

• Employee list to be maintained having id, name, designation, experience
• Salary details having employee id, current salary
• Salary in hand details having employee id, CTC salary, pf deduction or any other deduction and net salary to be given and also maintain details of total savings of employee
• Salary increment to be given by next year if any depending upon constraints
• Deduction in monthly salary if any depending upon any discrepancy in work and amount to be deducted.

– – – – – – – – – – – – – –

Got a question on the topic? Please share it in the comment section below and our experts will answer it for you.

For more information, Please write back to us at sales@edureka.co or call us at IND: 9606058406 / US: 18338555775 (toll free).

source

Categories
Video

Refresh your data in Power BI WITHOUT a user???



Can a Power BI Dataset be setup to refresh without an actual user? It would be great from an automation perspective and to avoid being tied to someone specific. Adam digs in.

Service Principal Video:
https://www.youtube.com/watch?v=1SO19uik1rw

Add-DataGatewayClusterUser (DataGateway CMDLET – Add to Admin List)
https://docs.microsoft.com/powershell/module/datagateway/add-datagatewayclusteruser?view=datagateway-ps

Add-DataGatewayClusterDatasourceUser (DataGateway CMDLET – Add to Datasource User list)
https://docs.microsoft.com/powershell/module/datagateway/add-datagatewayclusterdatasourceuser?view=datagateway-ps

Invoke-PowerBIRestMethod (Power BI CMDLET)
https://docs.microsoft.com/powershell/module/microsoftpowerbimgmt.profile/invoke-powerbirestmethod?view=powerbi-ps

Datasets – Take Over In Group (Power BI CMDLET / REST API)
https://docs.microsoft.com/rest/api/power-bi/datasets/take-over-in-group

Datasets – Bind To Gateway In Group (Power BI CMDLET / REST API)
https://docs.microsoft.com/rest/api/power-bi/datasets/bind-to-gateway-in-group

📢 Become a member: https://guyinacu.be/membership

*******************

Want to take your Power BI skills to the next level? We have training courses available to help you with your journey.

🎓 Guy in a Cube courses: https://guyinacu.be/courses

*******************
LET’S CONNECT!
*******************

http://twitter.com/guyinacube
http://twitter.com/awsaxton
http://twitter.com/patrickdba
http://www.facebook.com/guyinacube
https://www.instagram.com/guyinacube/
https://guyinacube.com

***Gear***
🛠 Check out my Tools page – https://guyinacube.com/tools/

#PowerBI #Refresh #GuyInACube

source

Categories
Video

Scaling Interactive and Insightful Dashboards with Data Studio and BigQuery (Cloud Next '18)



Large datasets in BigQuery might make it cost prohibitive to scale dashboard solutions. Unless carefully designed, solutions can lead to queries piling up with repeated viewing and result in significant costs in BigQuery. Google Data Studio lets users build interactive shareable data visualizations using their BigQuery data. In this session, we will show the common failure points and how you can build scalable, interactive, insightful dashboards in Data Studio from BigQuery data.

With Felipe Hoffa and Minhaz Kazi, Developer Advocates.

Build with Google Cloud → https://bit.ly/2KdoExqq

Watch more Data Analytics sessions here → http://bit.ly/2KXMtcJ
Next ‘18 All Sessions playlist → http://bit.ly/Allsessions

Subscribe to the Google Cloud channel! → http://bit.ly/NextSub
Session: DA300

re_ty: Publish; product: Cloud – Data Analytics – BigQuery, Cloud – Data Analytics – Google Data Studio; fullname: Minhaz Kazi, Felipe Hoffa; event: Google Cloud Next 2018;

source

Categories
Video

Sql vs tsql vs plsql



sql vs pl/sql vs mysql | sql vs tsql | pl sql vs tsql | sql vs pl/sql | ansi sql vs tsql | sql vs mysql vs sql server

Text version of the video and SQL scripts
https://csharp-video-tutorials.blogspot.com/2021/03/sql-vs-tsql-vs-plsql.html

SQL Server Tutorial for beginners
https://www.youtube.com/playlist?list=PL08903FB7ACA1C2FB

SQL Server Interview Questions and Answers
https://www.youtube.com/playlist?list=PL6n9fhu94yhXcztdLO7i6mdyaegC8CJwR

SQL Server Performance Tuning and Query Optimization
https://www.youtube.com/playlist?list=PL6n9fhu94yhXg5A0Fl3CQAo1PbOcRPjd0

source

Categories
Video

PostgreSQL WAL and Commit Synchronization, Optimization Opportunities – Jobin Augustine



#PostgreSQL uses different types of #WAL records for recording activities happening on the database. A deeper understanding of what they are, how they are synchronized, what the optimization opportunities are, etc., can lead to a better-tuned system.

Comment 💬, Share 🔗, Like 👍, and Subscribe ✅ to our channel + Turn on the 🔔
📺 Subscribe To Our Channel + Turn on the 🔔 and Get More videos about #OpenSource #Databases, and many other things.
https://percona.tv/subscribe

This talk also discusses the different sets of PostgreSQL parameters and their impact on WAL and optimization considerations for a high-performance database.

This talk covers:
What the WAL records are
Synchronization considerations
What is important from the host IO subsystem
Parameters for tuning
Different levels of tuning, Instance, Database, User, Session, and Transaction,
and how it impacts performance.
WAL Propagation to standby
Synchronous standby, important points to be considered
Remote write, flush, and replay stages.
This talk also includes small code snippets, demonstrations, and efficiency comparisons.
You can find more information about #PostgreSQL #Databases and Percona Database Events in these links 👇👇👇

Postgresql Support ⏩ https://per.co.na/postgresql-support
Postgresql info ⏩ https://per.co.na/postgresql-info
Postgresql events ⏩ https://per.co.na/lGkGc9
Percona Private Cloud ⏩ https://per.co.na/pl2020
Percona Distribution for PostgreSQL ⏩ https://per.co.na/postgresql
Monitor your PostgreSQL For Free ⏩ https://percona.tv/pmm-yt

Connect With us on our Social Networks 👇👇👇
Follow Percona on Twitter: https://per.co.na/twitter
Follow Percona on Facebook: https://per.co.na/facebook
Follow Percona on Instagram: https://per.co.na/instagram
Follow Percona on LinkedIn: https://per.co.na/linkedin

source

Categories
Video

Building Resilient, Mission-Critical Applications with Azure Database for PostgreSQL | 日本マイクロソフト



Are you looking to deploy your mission-critical application to a managed Postgres database service that is secure, reliable, available—as well as performant and scalable? If yes, this session is for you. You will learn about the new Flexible Server option in Azure Database for PostgreSQL that gives you zone-redundant HA (my favorite topic) as well as more control of your database configuration, networking options, and maintenance window. You will also learn how Citus—an open source extension to Postgres that transforms Postgres into a distributed database—is changing what’s possible for data-intensive applications. We’ll walk through some interesting applications that are already scaling out with Hyperscale (Citus), a built-in deployment option in Azure Database for PostgreSQL. And we’ll explore how Kubernetes has opened the door to running Postgres on Azure in hybrid scenarios, too.

■日本マイクロソフト 公式 YouTube チャンネル
https://www.youtube.com/channel/UCASliASL93lb8fdnpFiE3eQ?sub_confirmation=1

■日本マイクロソフト 公式 Facebook
https://www.facebook.com/microsoftjp

■日本マイクロソフト 公式 twitter
https://twitter.com/mskkpr

■日本マイクロソフト Webサイト
https://www.microsoft.com/ja-jp

source

Categories
Video

How Master Data Management can help MDM Managers like you



Meet Peter, a master data manager. Despite Peter’s best efforts, his team is not getting all the value out of their master data because they don’t have an overview of all the information that resides in various systems. Watch the video to see how managers such as Peter can get the results they need with Stibo Systems’ master data management solution.

source

Categories
Video

Web Crawling vs. Web Scraping | Oxylabs



Web Crawling vs. Web Scraping – What’s the Difference?

A crawler, also called a spider, crawls through different websites and looks for two things:

1. For data (the user is searching for)
2. For more targets to crawl

For example, the process would look something like this:

The crawler goes to your predefined target e.g. www.example.com, and it crawls through and discovers various product pages. Once the crawler finds the products, this is where scraping comes in.

Web scraping happens when a scraper downloads product data (price, title, description, etc.)

So, if web crawling means going through and clicking on different targets, web scraping is the part where you take the found data and download it.

More on Web Crawling vs. Web Scraping: https://oxylabs.io/blog/crawling-vs-scraping

Check out Oxylabs’ Real-Time Crawler: https://oxylabs.io/products/real-time-crawler
Visit Oxylabs: https://oxylabs.io

© 2021 Oxylabs. All rights reserved.

source