Health Status: Transport Accident Mortality (M) 2017 and 2015 . Compare countries including Canada and Canadian Provinces #nothing

The author is: the_authornHealth Status: Transport Accident Mortality (M) 2017 and 2015 . [Compare countries including Canada and Canadian Provinces]
Dataset: from CIHI, Canada. The same information plotted with different charts. Data files are also attached. If you see any mistakes, or if you need more information, feel free to inform us
[‘Measurement units used: Age-standardized rate per 100,000 males. Heatmap might show relative comparisons; not absolute values. The primary goal of these visualizations are to compare. If units are not provided, interpret them as relative values’]
These are outputs from a small Python based tool developed on 2019. The tool can generate many more of such plots easily, and will work with data for other purposeSayed Ahmed
Linkedin: https://ca.linkedin.com/in/sayedjustetc
Blog: http://sitestree.com, http://bangla.salearningschool.com
bubble_Transport_Accident_Mortality_(M)_06_37_PM_on_July_30,_201961893 bubble_Transport_Accident_Mortality_(M)_06_37_PM_on_July_30,_201997501 bubble_Transport_Accident_Mortality_(M)_06_37_PM_on_July_30,_201996970 bubble_Transport_Accident_Mortality_(M)_06_37_PM_on_July_30,_201958139 bubble_Transport_Accident_Mortality_(M)_06_37_PM_on_July_30,_201918447 geo_plot_for_a_year_Trans_06_37_PM_on_July_30,_201991890 horizontal_bar_Transport_Accident_Mortality_(M)_06_37_PM_on_July_30,_201997777 line_Transport_Accident_Mortality_(M)_06_37_PM_on_July_30,_201960854 line_Transport_Accident_Mortality_(M)_06_37_PM_on_July_30,_20195793 pie_Transport_Accident_Mortality_(M)_06_37_PM_on_July_30,_201940441 bar_Transport_Accident_Mortality_(M)_06_37_PM_on_July_30,_201969933 heatmap_health-statusTransport_Accident_Mortality_(M)_06_37_PM_on_July_30,_201926220 bubble_Transport_Accident_Mortality_(M)_06_37_PM_on_July_30,_201967535 bubble_Transport_Accident_Mortality_(M)_06_37_PM_on_July_30,_201961262 bubble_Transport_Accident_Mortality_(M)_06_37_PM_on_July_30,_201964953 bubble_Transport_Accident_Mortality_(M)_06_37_PM_on_July_30,_201929397 bubble_Transport_Accident_Mortality_(M)_06_37_PM_on_July_30,_201955579 bubble_Transport_Accident_Mortality_(M)_06_37_PM_on_July_30,_201982708 line_Transport_Accident_Mortality_(M)_06_37_PM_on_July_30,_201932263 line_Transport_Accident_Mortality_(M)_06_37_PM_on_July_30,_201954335 geo_plot_for_a_year_Trans_06_37_PM_on_July_30,_201986746 pie_Transport_Accident_Mortality_(M)_06_37_PM_on_July_30,_201975071 horizontal_bar_Transport_Accident_Mortality_(M)_06_37_PM_on_July_30,_201931465 bubble_Transport_Accident_Mortality_(M)_06_37_PM_on_July_30,_201920790 bar_Transport_Accident_Mortality_(M)_06_37_PM_on_July_30,_201933330 heatmap_health-statusTransport_Accident_Mortality_(M)_06_37_PM_on_July_30,_201954669

csv_data_file_for_2017_for indicator_Transport_Accident_Mortality_(M)for_plot_heatmap_across_indicators csv_data_file_for_2017_for indicator_Transport_Accident_Mortality(M)for_plot_measure_by_years csv_data_file_for_2017_for indicator_Transport_Accident_Mortality(M)forplot_map_measure_by_regions csv_data_file_for_2017_for indicator_Transport_Accident_Mortality(M)_forplot_measure_by_regions

csv_data_file_for_2015_for indicator_Transport_Accident_Mortality_(M)for_plot_heatmap_across_indicators csv_data_file_for_2015_for indicator_Transport_Accident_Mortality(M)for_plot_measure_by_years csv_data_file_for_2015_for indicator_Transport_Accident_Mortality(M)forplot_map_measure_by_regions csv_data_file_for_2015_for indicator_Transport_Accident_Mortality(M)_forplot_measure_by_regions
Share this: From: http://sitestree.com/health-status-transport-accident-mortality-m-2017-and-2015-compare-countries-including-canada-and-canadian-provinces-2/
Categories:
Tags:
Post Data:2021-01-24 21:19:39

    Shop Online: <a href='https://www.ShopForSoul.com/' target='new' rel="noopener">https://www.ShopForSoul.com/</a>
    (Big Data, Cloud, Security, Machine Learning): Courses: <a href='http://Training.SitesTree.com' target='new' rel="noopener"> http://Training.SitesTree.com</a> 
    In Bengali: <a href='http://Bangla.SaLearningSchool.com' target='new' rel="noopener">http://Bangla.SaLearningSchool.com</a>
    <a href='http://SitesTree.com' target='new' rel="noopener">http://SitesTree.com</a>
    8112223 Canada Inc./JustEtc: <a href='http://JustEtc.net' target='new' rel="noopener">http://JustEtc.net (Software/Web/Mobile/Big-Data/Machine Learning) </a>
    Shop Online: <a href='https://www.ShopForSoul.com'> https://www.ShopForSoul.com/</a>
    Medium: <a href='https://medium.com/@SayedAhmedCanada' target='new' rel="noopener"> https://medium.com/@SayedAhmedCanada </a>

Learn some Centos/Redhat Linux: RHCE: MariaDB Administration on Redhat/Fedora/CentOS #nothing

The author is: the_authornRHCE: MariaDB Administration on Redhat/Fedora/CentOS
Check if mariaDB is installed or not
130 yum list installed | grep ^mariadb
mariaDB originated from MySQL – after MySQL Got Bought by Oracle
133 yum list installed | grep ^mariadb
I see – installed though not completely
Output:
mariadb-libs.x86_64 1:5.5.52-1.el7 @anaconda
There are two other components: mariaDB – client component. MariaDB-server: Server Component
The MariaDB packages:
138 mariadb-bench.x86_64 mariadb-devel.x86_64 mariadb-server.x86_64 mariadb-test.x86_64 mariadb.x86_64
Install all packages at once
139 yum install mariadb*
140 yum list installed | grep ^mariadb
Now, I see the following, after I have installed – all MariaDB packages available in my system
mariadb.x86_64 1:5.5.52-1.el7 @local
mariadb-bench.x86_64 1:5.5.52-1.el7 @local
mariadb-devel.x86_64 1:5.5.52-1.el7 @local
mariadb-libs.x86_64 1:5.5.52-1.el7 @anaconda
mariadb-server.x86_64 1:5.5.52-1.el7 @local
mariadb-test.x86_64 1:5.5.52-1.el7 @local
MariaDB Configuration Files
149 ls /etc/my.cnf
150 ls /etc/my.cnf.d/*
The files
/etc/my.cnf.d/client.cnf /etc/my.cnf.d/mysql-clients.cnf /etc/my.cnf.d/server.cnf
153 vim /etc/my.cnf
154 vim /etc/my.cnf.d/client.cnf
155 vim /etc/my.cnf.d/server.cnf
156 vim /etc/my.cnf.d/mysql-clients.cnf
157 main config file /etc/my.cnf
158 grep -v ^# /etc/my.cnf : will show lines that are not comments
159 grep -v ^# /etc/my.cnf
The content of my.cnf : some lines are self explanatory
[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
symbolic-links=0
[mysqld_safe]
log-error=/var/log/mariadb/mariadb.log
pid-file=/var/run/mariadb/mariadb.pid
MariaDB messages are logged at: /var/log/mariadb/mariadb.log
MySQL Specific Selinux Contexts
171 ps -eZ | grep mysqld
I do not see anything as mysqld/maridb is not running
178 systemctl start mariadb.service
179 systemctl enable mariadb.service
180 ps -eZ | grep mysqld
now the output:
system_u:system_r:mysqld_safe_t:s0 4428 ? 00:00:00 mysqld_safe
system_u:system_r:mysqld_t:s0 4585 ? 00:00:00 mysqld
184 mysqld runs on it’s own domain mysqld_t
Related Selinux file type: mysql_exec_t
etc_t is for /etc/my.cnf.d
mysql_db_t is for /var/lib/mysql/
mysql_log_t is for /var/log/mariadb/
189 ll -dZ /usr/libexec/mysqld /etc/my.cnf.d /var/lib/mysql /var/log/mariadb
The output – please note the Selinux Contexts in the output
drwxr-xr-x. root root system_u:object_r:mysqld_etc_t:s0 /etc/my.cnf.d
-rwxr-xr-x. root root system_u:object_r:mysqld_exec_t:s0 /usr/libexec/mysqld
drwxr-xr-x. mysql mysql system_u:object_r:mysqld_db_t:s0 /var/lib/mysql
drwxr-x—. mysql mysql system_u:object_r:mysqld_log_t:s0 /var/log/mariadb
Corresponding Selinux Port Type: mysql_port_t
196 semanage port -l | grep mysqld
output:
mysqld_port_t tcp 1186, 3306, 63132-63164
Related Selinux Booleans: mysql_connect_any, selinuxuser_mysql_connect_enabled
200 getsebool -a | grep mysql
I see the output
mysql_connect_any –> off
selinuxuser_mysql_connect_enabled –> off
To install MariaDB-Server:
205 yum -y install mariadb-server
already installed. we installed with yum -y install mariadb* [installed everything together]
207 systemctl enable mariadb
We can run mysql_secure_installation – to secure our MariaDB installation

209 mysql_secure_installation

The Output: from mysql_secure_installation command
NOTE: RUNNING ALL PARTS OF THIS SCRIPT IS RECOMMENDED FOR ALL MariaDB
SERVERS IN PRODUCTION USE! PLEASE READ EACH STEP CAREFULLY!
In order to log into MariaDB to secure it, we’ll need the current
password for the root user. If you’ve just installed MariaDB, and
you haven’t set the root password yet, the password will be blank,
so you should just press enter here.
Enter current password for root (enter for none):
OK, successfully used password, moving on…
Setting the root password ensures that nobody can log into the MariaDB
root user without the proper authorisation.
Set root password? [Y/n] y
New password:
Re-enter new password:
Password updated successfully!
Reloading privilege tables..
… Success!
By default, a MariaDB installation has an anonymous user, allowing anyone
to log into MariaDB without having to have a user account created for
them. This is intended only for testing, and to make the installation
go a bit smoother. You should remove them before moving into a
production environment.
Remove anonymous users? [Y/n] y
… Success!
Normally, root should only be allowed to connect from ‘localhost’. This
ensures that someone cannot guess at the root password from the network.
Disallow root login remotely? [Y/n] y
… Success!
By default, MariaDB comes with a database named ‘test’ that anyone can
access. This is also intended only for testing, and should be removed
before moving into a production environment.
Remove test database and access to it? [Y/n] y
– Dropping test database…
… Success!
– Removing privileges on test database…
… Success!
Reloading the privilege tables will ensure that all changes made so far
will take effect immediately.
Reload privilege tables now? [Y/n] y
… Success!
Cleaning up…
All done! If you’ve completed all of the above steps, your MariaDB

installation should now be secure.
Thanks for using MariaDB!
Enable MariaDB through Firewall and Allow traffic on Port 3306 – default mysql port
218 firewall-cmd –add-service=mysql –perm
220 firewall-cmd –reload
221 systemctl start mariadb
222 systemctl status mariadb
223 start mysql/mariadb
Run MySQL
224 mysql -u root -p
mysqldump is used to backup a database
mysql command can be used to restore a database
you can even use IDEs such as MySQL Workbench to backup and restore MySQL Databases
228 mysql -u root -p
229 mysqldump -u root -p testsayed > testsayeddb.sql
to restore – you need to use < testsayeddb.sql
231 mysql -u root -p testsayed < testsayeddb.sql
Backup and Restore MySQL Database
You can backup multiple databases at once, you can even backup some tables or other database objects using mysqldump
similarly, you can restore multiple databases at the same time using mysql command
just use multiple datbase or database object names with NO comma – one after another
235 mysqldump -u root -p DB1 DB2 DB3 > alldb.sql
when you use restore and give the sql file – if you use db name or table name before < then only that part will be restored irrespective hiow much data is there on the file
example
238 mysql -u root -p DB1 tbl1 < alldb.sql ;
you can use –all-databases or –databases with mysqldump command
Share this: From: http://sitestree.com/learn-some-centos-redhat-linux-rhce-mariadb-administration-on-redhat-fedora-centos-5/
Categories:
Tags:
Post Data:2021-01-24 21:19:23

    Shop Online: <a href='https://www.ShopForSoul.com/' target='new' rel="noopener">https://www.ShopForSoul.com/</a>
    (Big Data, Cloud, Security, Machine Learning): Courses: <a href='http://Training.SitesTree.com' target='new' rel="noopener"> http://Training.SitesTree.com</a> 
    In Bengali: <a href='http://Bangla.SaLearningSchool.com' target='new' rel="noopener">http://Bangla.SaLearningSchool.com</a>
    <a href='http://SitesTree.com' target='new' rel="noopener">http://SitesTree.com</a>
    8112223 Canada Inc./JustEtc: <a href='http://JustEtc.net' target='new' rel="noopener">http://JustEtc.net (Software/Web/Mobile/Big-Data/Machine Learning) </a>
    Shop Online: <a href='https://www.ShopForSoul.com'> https://www.ShopForSoul.com/</a>
    Medium: <a href='https://medium.com/@SayedAhmedCanada' target='new' rel="noopener"> https://medium.com/@SayedAhmedCanada </a>

Learn some Centos/Redhat Linux: RHCE: MariaDB Administration on Redhat/Fedora/CentOS #nothing

The author is: the_authornRHCE: MariaDB Administration on Redhat/Fedora/CentOS
Check if mariaDB is installed or not
130 yum list installed | grep ^mariadb
mariaDB originated from MySQL – after MySQL Got Bought by Oracle
133 yum list installed | grep ^mariadb
I see – installed though not completely
Output:
mariadb-libs.x86_64 1:5.5.52-1.el7 @anaconda
There are two other components: mariaDB – client component. MariaDB-server: Server Component
The MariaDB packages:
138 mariadb-bench.x86_64 mariadb-devel.x86_64 mariadb-server.x86_64 mariadb-test.x86_64 mariadb.x86_64
Install all packages at once
139 yum install mariadb*
140 yum list installed | grep ^mariadb
Now, I see the following, after I have installed – all MariaDB packages available in my system
mariadb.x86_64 1:5.5.52-1.el7 @local
mariadb-bench.x86_64 1:5.5.52-1.el7 @local
mariadb-devel.x86_64 1:5.5.52-1.el7 @local
mariadb-libs.x86_64 1:5.5.52-1.el7 @anaconda
mariadb-server.x86_64 1:5.5.52-1.el7 @local
mariadb-test.x86_64 1:5.5.52-1.el7 @local
MariaDB Configuration Files
149 ls /etc/my.cnf
150 ls /etc/my.cnf.d/*
The files
/etc/my.cnf.d/client.cnf /etc/my.cnf.d/mysql-clients.cnf /etc/my.cnf.d/server.cnf
153 vim /etc/my.cnf
154 vim /etc/my.cnf.d/client.cnf
155 vim /etc/my.cnf.d/server.cnf
156 vim /etc/my.cnf.d/mysql-clients.cnf
157 main config file /etc/my.cnf
158 grep -v ^# /etc/my.cnf : will show lines that are not comments
159 grep -v ^# /etc/my.cnf
The content of my.cnf : some lines are self explanatory
[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
symbolic-links=0
[mysqld_safe]
log-error=/var/log/mariadb/mariadb.log
pid-file=/var/run/mariadb/mariadb.pid
MariaDB messages are logged at: /var/log/mariadb/mariadb.log
MySQL Specific Selinux Contexts
171 ps -eZ | grep mysqld
I do not see anything as mysqld/maridb is not running
178 systemctl start mariadb.service
179 systemctl enable mariadb.service
180 ps -eZ | grep mysqld
now the output:
system_u:system_r:mysqld_safe_t:s0 4428 ? 00:00:00 mysqld_safe
system_u:system_r:mysqld_t:s0 4585 ? 00:00:00 mysqld
184 mysqld runs on it’s own domain mysqld_t
Related Selinux file type: mysql_exec_t
etc_t is for /etc/my.cnf.d
mysql_db_t is for /var/lib/mysql/
mysql_log_t is for /var/log/mariadb/
189 ll -dZ /usr/libexec/mysqld /etc/my.cnf.d /var/lib/mysql /var/log/mariadb
The output – please note the Selinux Contexts in the output
drwxr-xr-x. root root system_u:object_r:mysqld_etc_t:s0 /etc/my.cnf.d
-rwxr-xr-x. root root system_u:object_r:mysqld_exec_t:s0 /usr/libexec/mysqld
drwxr-xr-x. mysql mysql system_u:object_r:mysqld_db_t:s0 /var/lib/mysql
drwxr-x—. mysql mysql system_u:object_r:mysqld_log_t:s0 /var/log/mariadb
Corresponding Selinux Port Type: mysql_port_t
196 semanage port -l | grep mysqld
output:
mysqld_port_t tcp 1186, 3306, 63132-63164
Related Selinux Booleans: mysql_connect_any, selinuxuser_mysql_connect_enabled
200 getsebool -a | grep mysql
I see the output
mysql_connect_any –> off
selinuxuser_mysql_connect_enabled –> off
To install MariaDB-Server:
205 yum -y install mariadb-server
already installed. we installed with yum -y install mariadb* [installed everything together]
207 systemctl enable mariadb
We can run mysql_secure_installation – to secure our MariaDB installation

209 mysql_secure_installation

The Output: from mysql_secure_installation command
NOTE: RUNNING ALL PARTS OF THIS SCRIPT IS RECOMMENDED FOR ALL MariaDB
SERVERS IN PRODUCTION USE! PLEASE READ EACH STEP CAREFULLY!
In order to log into MariaDB to secure it, we’ll need the current
password for the root user. If you’ve just installed MariaDB, and
you haven’t set the root password yet, the password will be blank,
so you should just press enter here.
Enter current password for root (enter for none):
OK, successfully used password, moving on…
Setting the root password ensures that nobody can log into the MariaDB
root user without the proper authorisation.
Set root password? [Y/n] y
New password:
Re-enter new password:
Password updated successfully!
Reloading privilege tables..
… Success!
By default, a MariaDB installation has an anonymous user, allowing anyone
to log into MariaDB without having to have a user account created for
them. This is intended only for testing, and to make the installation
go a bit smoother. You should remove them before moving into a
production environment.
Remove anonymous users? [Y/n] y
… Success!
Normally, root should only be allowed to connect from ‘localhost’. This
ensures that someone cannot guess at the root password from the network.
Disallow root login remotely? [Y/n] y
… Success!
By default, MariaDB comes with a database named ‘test’ that anyone can
access. This is also intended only for testing, and should be removed
before moving into a production environment.
Remove test database and access to it? [Y/n] y
– Dropping test database…
… Success!
– Removing privileges on test database…
… Success!
Reloading the privilege tables will ensure that all changes made so far
will take effect immediately.
Reload privilege tables now? [Y/n] y
… Success!
Cleaning up…
All done! If you’ve completed all of the above steps, your MariaDB

installation should now be secure.
Thanks for using MariaDB!
Enable MariaDB through Firewall and Allow traffic on Port 3306 – default mysql port
218 firewall-cmd –add-service=mysql –perm
220 firewall-cmd –reload
221 systemctl start mariadb
222 systemctl status mariadb
223 start mysql/mariadb
Run MySQL
224 mysql -u root -p
mysqldump is used to backup a database
mysql command can be used to restore a database
you can even use IDEs such as MySQL Workbench to backup and restore MySQL Databases
228 mysql -u root -p
229 mysqldump -u root -p testsayed > testsayeddb.sql
to restore – you need to use < testsayeddb.sql
231 mysql -u root -p testsayed < testsayeddb.sql
Backup and Restore MySQL Database
You can backup multiple databases at once, you can even backup some tables or other database objects using mysqldump
similarly, you can restore multiple databases at the same time using mysql command
just use multiple datbase or database object names with NO comma – one after another
235 mysqldump -u root -p DB1 DB2 DB3 > alldb.sql
when you use restore and give the sql file – if you use db name or table name before < then only that part will be restored irrespective hiow much data is there on the file
example
238 mysql -u root -p DB1 tbl1 < alldb.sql ;
you can use –all-databases or –databases with mysqldump command
Share this: From: http://sitestree.com/learn-some-centos-redhat-linux-rhce-mariadb-administration-on-redhat-fedora-centos-4/
Categories:
Tags:
Post Data:2021-01-24 21:13:04

    Shop Online: <a href='https://www.ShopForSoul.com/' target='new' rel="noopener">https://www.ShopForSoul.com/</a>
    (Big Data, Cloud, Security, Machine Learning): Courses: <a href='http://Training.SitesTree.com' target='new' rel="noopener"> http://Training.SitesTree.com</a> 
    In Bengali: <a href='http://Bangla.SaLearningSchool.com' target='new' rel="noopener">http://Bangla.SaLearningSchool.com</a>
    <a href='http://SitesTree.com' target='new' rel="noopener">http://SitesTree.com</a>
    8112223 Canada Inc./JustEtc: <a href='http://JustEtc.net' target='new' rel="noopener">http://JustEtc.net (Software/Web/Mobile/Big-Data/Machine Learning) </a>
    Shop Online: <a href='https://www.ShopForSoul.com'> https://www.ShopForSoul.com/</a>
    Medium: <a href='https://medium.com/@SayedAhmedCanada' target='new' rel="noopener"> https://medium.com/@SayedAhmedCanada </a>

#Canada: #IT Jobs:#Consultants, #Contractors, #Analysts, #Engineers, #Developers, #Technology Consultants, #IT-Consultants Opportunities2021-09-02

Apply yourself, or submit others as a candidate, Build a recruitment team to submit others as a candidate, submit RFP to be considered for projects in future, Try to become a vendor so that you are asked to submit consultants/resources in future

  1. communications-detection-and-fibre-optics-10031
  2. Electrical Consulting Services
  3. construction-products-10032
  4. Electrical Consulting Services
  5. edp-and-office-equipment-maintenance-10035
  6. Drupal Based Cloud Hosted Web Content Management System
  7. electrical-and-electronics-10006
  8. Electrical Consulting Services
  9. energy-10007
  10. Advocate Cost Consulting Services for 45 Sacré-Coeur Blvd. Project
  11. textiles-and-apparel-10028
  12. Electrical Consulting Services
  13. RFP #21.0054 Integrated Project Delivery Team – Turf Consultant and Turf Contractor for the Indoor Fieldhouse
  14. architect-and-engineering-services-10048
  15. Consulting Engineering Services for the Mobility Master Plan (MMP) for City of London
  16. Storm Pond Rehabilitation – Environmental Consulting
  17. communications-photographic-mapping-printing-and-publication-services-10042
  18. Electrical Consulting Services
  19. custodial-operations-and-related-services-10037
  20. Electrical Consulting Services
  21. educational-and-training-services-10043
  22. Human Resources and Organizational Development Consulting Services
  23. Space standards consultant for the university sector
  24. Medical Consulting Services for the Assured Income for the Severely Handicapped (AISH) Program for the of Alberta
  25. environmental-services-10050
  26. Electrical Consulting Services
  27. financial-and-related-services-10038
  28. Prime Consultant for Design Services – Roofing Specialization
  29. P01AD21429 – CONSULTING SERVICES FOR RETAIL STRATEGY DEVELOPMENT
  30. health-and-social-services-10052
  31. HCP Psychology Consultant Services
  32. information-processing-and-related-telecommunications-services-10049
  33. Electrical Consulting Services
  34. operation-of-government-owned-facilities-10039
  35. Professional Food Consulting Services (RE-POSTED)
  36. professional-administrative-and-management-support-services-10040
  37. Consulting Services for the City of Vaughan 2022-2026 Term of Council Strategic Plan
  38. Consulting Services – Preparation of a Conceptual Redesign for the First Floor of the Library/Arts Building, 710 Rosser Avenue, Brandon, Manitoba
  39. Consulting Services for Development Cost Charges
  40. Consulting & Inspection Services Manitoba Personal Care Home (PCH) HVAC Systems
  41. quality-control-testing-inspection-and-technical-representative-services-10053
  42. Consulting & Inspection Services Manitoba Personal Care Home (PCH) HVAC Systems
  43. Consulting Services for Drone Inspection Studies of Halton Region Open and Closed Landfill Sites
  44. REQUEST FOR PROPOSAL (RFP) for THIRD PARTY MATERIAL TESTING CONSULTANT SERVICES for NEW EDMONTON HOSPITAL PROJECT – CAMPUS SITE WORKS
  45. research-and-development-r-d-10036
  46. Professional Consulting Service for Compensation & Job Description Review Projec
  47. Storm Pond Rehabilitation – Environmental Consulting
  48. Engineering Consulting Services for Detailed Dam Break Flood Inundation Mapping
  49. special-studies-and-analysis-not-r-d-10047
  50. P72AD21459 – TRANSIT STOP PLACEMENT CONSULTING SERVICES
  51. INDEPENDENT CONSULTANT – SCHEDULING, DISPATCH &TRACKING SYSTEM ANALYSIS
  52. Storm Pond Rehabilitation – Environmental Consulting
  53. Space standards consultant for the university sector
  54. Consulting Services for Feasibility Study and Public Benefit Review for a Vacant Home Tax in Halton Region
  55. Consulting Services for Landfill Infrastructure Condition Assessments at Halton Region Open and Closed Landfill Sites
  56. utilities-10041
  57. Consulting & Inspection Services Manitoba Personal Care Home (PCH) HVAC Systems
  58. Electrical Consulting Services
  59. test #nothing

    Test Test From: http://sitestree.com/test-3/
    Categories:
    Tags:
    Post Data:2021-01-24 21:10:48

        Shop Online: <a href='https://www.ShopForSoul.com/' target='new' rel="noopener">https://www.ShopForSoul.com/</a>
        (Big Data, Cloud, Security, Machine Learning): Courses: <a href='http://Training.SitesTree.com' target='new' rel="noopener"> http://Training.SitesTree.com</a> 
        In Bengali: <a href='http://Bangla.SaLearningSchool.com' target='new' rel="noopener">http://Bangla.SaLearningSchool.com</a>
        <a href='http://SitesTree.com' target='new' rel="noopener">http://SitesTree.com</a>
        8112223 Canada Inc./JustEtc: <a href='http://JustEtc.net' target='new' rel="noopener">http://JustEtc.net (Software/Web/Mobile/Big-Data/Machine Learning) </a>
        Shop Online: <a href='https://www.ShopForSoul.com'> https://www.ShopForSoul.com/</a>
        Medium: <a href='https://medium.com/@SayedAhmedCanada' target='new' rel="noopener"> https://medium.com/@SayedAhmedCanada </a>
    

    Learn some Centos/Redhat Linux: RHCE: MariaDB Administration on Redhat/Fedora/CentOS #nothing

    The author is: the_authornRHCE: MariaDB Administration on Redhat/Fedora/CentOS
    Check if mariaDB is installed or not
    130 yum list installed | grep ^mariadb
    mariaDB originated from MySQL – after MySQL Got Bought by Oracle
    133 yum list installed | grep ^mariadb
    I see – installed though not completely
    Output:
    mariadb-libs.x86_64 1:5.5.52-1.el7 @anaconda
    There are two other components: mariaDB – client component. MariaDB-server: Server Component
    The MariaDB packages:
    138 mariadb-bench.x86_64 mariadb-devel.x86_64 mariadb-server.x86_64 mariadb-test.x86_64 mariadb.x86_64
    Install all packages at once
    139 yum install mariadb*
    140 yum list installed | grep ^mariadb
    Now, I see the following, after I have installed – all MariaDB packages available in my system
    mariadb.x86_64 1:5.5.52-1.el7 @local
    mariadb-bench.x86_64 1:5.5.52-1.el7 @local
    mariadb-devel.x86_64 1:5.5.52-1.el7 @local
    mariadb-libs.x86_64 1:5.5.52-1.el7 @anaconda
    mariadb-server.x86_64 1:5.5.52-1.el7 @local
    mariadb-test.x86_64 1:5.5.52-1.el7 @local
    MariaDB Configuration Files
    149 ls /etc/my.cnf
    150 ls /etc/my.cnf.d/*
    The files
    /etc/my.cnf.d/client.cnf /etc/my.cnf.d/mysql-clients.cnf /etc/my.cnf.d/server.cnf
    153 vim /etc/my.cnf
    154 vim /etc/my.cnf.d/client.cnf
    155 vim /etc/my.cnf.d/server.cnf
    156 vim /etc/my.cnf.d/mysql-clients.cnf
    157 main config file /etc/my.cnf
    158 grep -v ^# /etc/my.cnf : will show lines that are not comments
    159 grep -v ^# /etc/my.cnf
    The content of my.cnf : some lines are self explanatory
    [mysqld]
    datadir=/var/lib/mysql
    socket=/var/lib/mysql/mysql.sock
    symbolic-links=0
    [mysqld_safe]
    log-error=/var/log/mariadb/mariadb.log
    pid-file=/var/run/mariadb/mariadb.pid
    MariaDB messages are logged at: /var/log/mariadb/mariadb.log
    MySQL Specific Selinux Contexts
    171 ps -eZ | grep mysqld
    I do not see anything as mysqld/maridb is not running
    178 systemctl start mariadb.service
    179 systemctl enable mariadb.service
    180 ps -eZ | grep mysqld
    now the output:
    system_u:system_r:mysqld_safe_t:s0 4428 ? 00:00:00 mysqld_safe
    system_u:system_r:mysqld_t:s0 4585 ? 00:00:00 mysqld
    184 mysqld runs on it’s own domain mysqld_t
    Related Selinux file type: mysql_exec_t
    etc_t is for /etc/my.cnf.d
    mysql_db_t is for /var/lib/mysql/
    mysql_log_t is for /var/log/mariadb/
    189 ll -dZ /usr/libexec/mysqld /etc/my.cnf.d /var/lib/mysql /var/log/mariadb
    The output – please note the Selinux Contexts in the output
    drwxr-xr-x. root root system_u:object_r:mysqld_etc_t:s0 /etc/my.cnf.d
    -rwxr-xr-x. root root system_u:object_r:mysqld_exec_t:s0 /usr/libexec/mysqld
    drwxr-xr-x. mysql mysql system_u:object_r:mysqld_db_t:s0 /var/lib/mysql
    drwxr-x—. mysql mysql system_u:object_r:mysqld_log_t:s0 /var/log/mariadb
    Corresponding Selinux Port Type: mysql_port_t
    196 semanage port -l | grep mysqld
    output:
    mysqld_port_t tcp 1186, 3306, 63132-63164
    Related Selinux Booleans: mysql_connect_any, selinuxuser_mysql_connect_enabled
    200 getsebool -a | grep mysql
    I see the output
    mysql_connect_any –> off
    selinuxuser_mysql_connect_enabled –> off
    To install MariaDB-Server:
    205 yum -y install mariadb-server
    already installed. we installed with yum -y install mariadb* [installed everything together]
    207 systemctl enable mariadb
    We can run mysql_secure_installation – to secure our MariaDB installation

    209 mysql_secure_installation

    The Output: from mysql_secure_installation command
    NOTE: RUNNING ALL PARTS OF THIS SCRIPT IS RECOMMENDED FOR ALL MariaDB
    SERVERS IN PRODUCTION USE! PLEASE READ EACH STEP CAREFULLY!
    In order to log into MariaDB to secure it, we’ll need the current
    password for the root user. If you’ve just installed MariaDB, and
    you haven’t set the root password yet, the password will be blank,
    so you should just press enter here.
    Enter current password for root (enter for none):
    OK, successfully used password, moving on…
    Setting the root password ensures that nobody can log into the MariaDB
    root user without the proper authorisation.
    Set root password? [Y/n] y
    New password:
    Re-enter new password:
    Password updated successfully!
    Reloading privilege tables..
    … Success!
    By default, a MariaDB installation has an anonymous user, allowing anyone
    to log into MariaDB without having to have a user account created for
    them. This is intended only for testing, and to make the installation
    go a bit smoother. You should remove them before moving into a
    production environment.
    Remove anonymous users? [Y/n] y
    … Success!
    Normally, root should only be allowed to connect from ‘localhost’. This
    ensures that someone cannot guess at the root password from the network.
    Disallow root login remotely? [Y/n] y
    … Success!
    By default, MariaDB comes with a database named ‘test’ that anyone can
    access. This is also intended only for testing, and should be removed
    before moving into a production environment.
    Remove test database and access to it? [Y/n] y
    – Dropping test database…
    … Success!
    – Removing privileges on test database…
    … Success!
    Reloading the privilege tables will ensure that all changes made so far
    will take effect immediately.
    Reload privilege tables now? [Y/n] y
    … Success!
    Cleaning up…
    All done! If you’ve completed all of the above steps, your MariaDB

    installation should now be secure.
    Thanks for using MariaDB!
    Enable MariaDB through Firewall and Allow traffic on Port 3306 – default mysql port
    218 firewall-cmd –add-service=mysql –perm
    220 firewall-cmd –reload
    221 systemctl start mariadb
    222 systemctl status mariadb
    223 start mysql/mariadb
    Run MySQL
    224 mysql -u root -p
    mysqldump is used to backup a database
    mysql command can be used to restore a database
    you can even use IDEs such as MySQL Workbench to backup and restore MySQL Databases
    228 mysql -u root -p
    229 mysqldump -u root -p testsayed > testsayeddb.sql
    to restore – you need to use < testsayeddb.sql
    231 mysql -u root -p testsayed < testsayeddb.sql
    Backup and Restore MySQL Database
    You can backup multiple databases at once, you can even backup some tables or other database objects using mysqldump
    similarly, you can restore multiple databases at the same time using mysql command
    just use multiple datbase or database object names with NO comma – one after another
    235 mysqldump -u root -p DB1 DB2 DB3 > alldb.sql
    when you use restore and give the sql file – if you use db name or table name before < then only that part will be restored irrespective hiow much data is there on the file
    example
    238 mysql -u root -p DB1 tbl1 < alldb.sql ;
    you can use –all-databases or –databases with mysqldump command
    Share this: From: http://sitestree.com/learn-some-centos-redhat-linux-rhce-mariadb-administration-on-redhat-fedora-centos-3/
    Categories:
    Tags:
    Post Data:2021-01-24 20:38:50

        Shop Online: <a href='https://www.ShopForSoul.com/' target='new' rel="noopener">https://www.ShopForSoul.com/</a>
        (Big Data, Cloud, Security, Machine Learning): Courses: <a href='http://Training.SitesTree.com' target='new' rel="noopener"> http://Training.SitesTree.com</a> 
        In Bengali: <a href='http://Bangla.SaLearningSchool.com' target='new' rel="noopener">http://Bangla.SaLearningSchool.com</a>
        <a href='http://SitesTree.com' target='new' rel="noopener">http://SitesTree.com</a>
        8112223 Canada Inc./JustEtc: <a href='http://JustEtc.net' target='new' rel="noopener">http://JustEtc.net (Software/Web/Mobile/Big-Data/Machine Learning) </a>
        Shop Online: <a href='https://www.ShopForSoul.com'> https://www.ShopForSoul.com/</a>
        Medium: <a href='https://medium.com/@SayedAhmedCanada' target='new' rel="noopener"> https://medium.com/@SayedAhmedCanada </a>
    

    Learn some Centos/Redhat Linux: RHCE: MariaDB Administration on Redhat/Fedora/CentOS #nothing

    The author is: the_authornRHCE: MariaDB Administration on Redhat/Fedora/CentOS
    Check if mariaDB is installed or not
    130 yum list installed | grep ^mariadb
    mariaDB originated from MySQL – after MySQL Got Bought by Oracle
    133 yum list installed | grep ^mariadb
    I see – installed though not completely
    Output:
    mariadb-libs.x86_64 1:5.5.52-1.el7 @anaconda
    There are two other components: mariaDB – client component. MariaDB-server: Server Component
    The MariaDB packages:
    138 mariadb-bench.x86_64 mariadb-devel.x86_64 mariadb-server.x86_64 mariadb-test.x86_64 mariadb.x86_64
    Install all packages at once
    139 yum install mariadb*
    140 yum list installed | grep ^mariadb
    Now, I see the following, after I have installed – all MariaDB packages available in my system
    mariadb.x86_64 1:5.5.52-1.el7 @local
    mariadb-bench.x86_64 1:5.5.52-1.el7 @local
    mariadb-devel.x86_64 1:5.5.52-1.el7 @local
    mariadb-libs.x86_64 1:5.5.52-1.el7 @anaconda
    mariadb-server.x86_64 1:5.5.52-1.el7 @local
    mariadb-test.x86_64 1:5.5.52-1.el7 @local
    MariaDB Configuration Files
    149 ls /etc/my.cnf
    150 ls /etc/my.cnf.d/*
    The files
    /etc/my.cnf.d/client.cnf /etc/my.cnf.d/mysql-clients.cnf /etc/my.cnf.d/server.cnf
    153 vim /etc/my.cnf
    154 vim /etc/my.cnf.d/client.cnf
    155 vim /etc/my.cnf.d/server.cnf
    156 vim /etc/my.cnf.d/mysql-clients.cnf
    157 main config file /etc/my.cnf
    158 grep -v ^# /etc/my.cnf : will show lines that are not comments
    159 grep -v ^# /etc/my.cnf
    The content of my.cnf : some lines are self explanatory
    [mysqld]
    datadir=/var/lib/mysql
    socket=/var/lib/mysql/mysql.sock
    symbolic-links=0
    [mysqld_safe]
    log-error=/var/log/mariadb/mariadb.log
    pid-file=/var/run/mariadb/mariadb.pid
    MariaDB messages are logged at: /var/log/mariadb/mariadb.log
    MySQL Specific Selinux Contexts
    171 ps -eZ | grep mysqld
    I do not see anything as mysqld/maridb is not running
    178 systemctl start mariadb.service
    179 systemctl enable mariadb.service
    180 ps -eZ | grep mysqld
    now the output:
    system_u:system_r:mysqld_safe_t:s0 4428 ? 00:00:00 mysqld_safe
    system_u:system_r:mysqld_t:s0 4585 ? 00:00:00 mysqld
    184 mysqld runs on it’s own domain mysqld_t
    Related Selinux file type: mysql_exec_t
    etc_t is for /etc/my.cnf.d
    mysql_db_t is for /var/lib/mysql/
    mysql_log_t is for /var/log/mariadb/
    189 ll -dZ /usr/libexec/mysqld /etc/my.cnf.d /var/lib/mysql /var/log/mariadb
    The output – please note the Selinux Contexts in the output
    drwxr-xr-x. root root system_u:object_r:mysqld_etc_t:s0 /etc/my.cnf.d
    -rwxr-xr-x. root root system_u:object_r:mysqld_exec_t:s0 /usr/libexec/mysqld
    drwxr-xr-x. mysql mysql system_u:object_r:mysqld_db_t:s0 /var/lib/mysql
    drwxr-x—. mysql mysql system_u:object_r:mysqld_log_t:s0 /var/log/mariadb
    Corresponding Selinux Port Type: mysql_port_t
    196 semanage port -l | grep mysqld
    output:
    mysqld_port_t tcp 1186, 3306, 63132-63164
    Related Selinux Booleans: mysql_connect_any, selinuxuser_mysql_connect_enabled
    200 getsebool -a | grep mysql
    I see the output
    mysql_connect_any –> off
    selinuxuser_mysql_connect_enabled –> off
    To install MariaDB-Server:
    205 yum -y install mariadb-server
    already installed. we installed with yum -y install mariadb* [installed everything together]
    207 systemctl enable mariadb
    We can run mysql_secure_installation – to secure our MariaDB installation

    209 mysql_secure_installation

    The Output: from mysql_secure_installation command
    NOTE: RUNNING ALL PARTS OF THIS SCRIPT IS RECOMMENDED FOR ALL MariaDB
    SERVERS IN PRODUCTION USE! PLEASE READ EACH STEP CAREFULLY!
    In order to log into MariaDB to secure it, we’ll need the current
    password for the root user. If you’ve just installed MariaDB, and
    you haven’t set the root password yet, the password will be blank,
    so you should just press enter here.
    Enter current password for root (enter for none):
    OK, successfully used password, moving on…
    Setting the root password ensures that nobody can log into the MariaDB
    root user without the proper authorisation.
    Set root password? [Y/n] y
    New password:
    Re-enter new password:
    Password updated successfully!
    Reloading privilege tables..
    … Success!
    By default, a MariaDB installation has an anonymous user, allowing anyone
    to log into MariaDB without having to have a user account created for
    them. This is intended only for testing, and to make the installation
    go a bit smoother. You should remove them before moving into a
    production environment.
    Remove anonymous users? [Y/n] y
    … Success!
    Normally, root should only be allowed to connect from ‘localhost’. This
    ensures that someone cannot guess at the root password from the network.
    Disallow root login remotely? [Y/n] y
    … Success!
    By default, MariaDB comes with a database named ‘test’ that anyone can
    access. This is also intended only for testing, and should be removed
    before moving into a production environment.
    Remove test database and access to it? [Y/n] y
    – Dropping test database…
    … Success!
    – Removing privileges on test database…
    … Success!
    Reloading the privilege tables will ensure that all changes made so far
    will take effect immediately.
    Reload privilege tables now? [Y/n] y
    … Success!
    Cleaning up…
    All done! If you’ve completed all of the above steps, your MariaDB

    installation should now be secure.
    Thanks for using MariaDB!
    Enable MariaDB through Firewall and Allow traffic on Port 3306 – default mysql port
    218 firewall-cmd –add-service=mysql –perm
    220 firewall-cmd –reload
    221 systemctl start mariadb
    222 systemctl status mariadb
    223 start mysql/mariadb
    Run MySQL
    224 mysql -u root -p
    mysqldump is used to backup a database
    mysql command can be used to restore a database
    you can even use IDEs such as MySQL Workbench to backup and restore MySQL Databases
    228 mysql -u root -p
    229 mysqldump -u root -p testsayed > testsayeddb.sql
    to restore – you need to use < testsayeddb.sql
    231 mysql -u root -p testsayed < testsayeddb.sql
    Backup and Restore MySQL Database
    You can backup multiple databases at once, you can even backup some tables or other database objects using mysqldump
    similarly, you can restore multiple databases at the same time using mysql command
    just use multiple datbase or database object names with NO comma – one after another
    235 mysqldump -u root -p DB1 DB2 DB3 > alldb.sql
    when you use restore and give the sql file – if you use db name or table name before < then only that part will be restored irrespective hiow much data is there on the file
    example
    238 mysql -u root -p DB1 tbl1 < alldb.sql ;
    you can use –all-databases or –databases with mysqldump command
    Share this: From: http://sitestree.com/learn-some-centos-redhat-linux-rhce-mariadb-administration-on-redhat-fedora-centos-2/
    Categories:
    Tags:
    Post Data:2021-01-24 20:31:57

        Shop Online: <a href='https://www.ShopForSoul.com/' target='new' rel="noopener">https://www.ShopForSoul.com/</a>
        (Big Data, Cloud, Security, Machine Learning): Courses: <a href='http://Training.SitesTree.com' target='new' rel="noopener"> http://Training.SitesTree.com</a> 
        In Bengali: <a href='http://Bangla.SaLearningSchool.com' target='new' rel="noopener">http://Bangla.SaLearningSchool.com</a>
        <a href='http://SitesTree.com' target='new' rel="noopener">http://SitesTree.com</a>
        8112223 Canada Inc./JustEtc: <a href='http://JustEtc.net' target='new' rel="noopener">http://JustEtc.net (Software/Web/Mobile/Big-Data/Machine Learning) </a>
        Shop Online: <a href='https://www.ShopForSoul.com'> https://www.ShopForSoul.com/</a>
        Medium: <a href='https://medium.com/@SayedAhmedCanada' target='new' rel="noopener"> https://medium.com/@SayedAhmedCanada </a>
    

    Learn some Centos/Redhat Linux: RHCE: MariaDB Administration on Redhat/Fedora/CentOS #nothing

    RHCE: MariaDB Administration on Redhat/Fedora/CentOS
    Check if mariaDB is installed or not
    130 yum list installed | grep ^mariadb
    mariaDB originated from MySQL – after MySQL Got Bought by Oracle
    133 yum list installed | grep ^mariadb
    I see – installed though not completely
    Output:
    mariadb-libs.x86_64 1:5.5.52-1.el7 @anaconda
    There are two other components: mariaDB – client component. MariaDB-server: Server Component
    The MariaDB packages:
    138 mariadb-bench.x86_64 mariadb-devel.x86_64 mariadb-server.x86_64 mariadb-test.x86_64 mariadb.x86_64
    Install all packages at once
    139 yum install mariadb*
    140 yum list installed | grep ^mariadb
    Now, I see the following, after I have installed – all MariaDB packages available in my system
    mariadb.x86_64 1:5.5.52-1.el7 @local
    mariadb-bench.x86_64 1:5.5.52-1.el7 @local
    mariadb-devel.x86_64 1:5.5.52-1.el7 @local
    mariadb-libs.x86_64 1:5.5.52-1.el7 @anaconda
    mariadb-server.x86_64 1:5.5.52-1.el7 @local
    mariadb-test.x86_64 1:5.5.52-1.el7 @local
    MariaDB Configuration Files
    149 ls /etc/my.cnf
    150 ls /etc/my.cnf.d/*
    The files
    /etc/my.cnf.d/client.cnf /etc/my.cnf.d/mysql-clients.cnf /etc/my.cnf.d/server.cnf
    153 vim /etc/my.cnf
    154 vim /etc/my.cnf.d/client.cnf
    155 vim /etc/my.cnf.d/server.cnf
    156 vim /etc/my.cnf.d/mysql-clients.cnf
    157 main config file /etc/my.cnf
    158 grep -v ^# /etc/my.cnf : will show lines that are not comments
    159 grep -v ^# /etc/my.cnf
    The content of my.cnf : some lines are self explanatory
    [mysqld]
    datadir=/var/lib/mysql
    socket=/var/lib/mysql/mysql.sock
    symbolic-links=0
    [mysqld_safe]
    log-error=/var/log/mariadb/mariadb.log
    pid-file=/var/run/mariadb/mariadb.pid
    MariaDB messages are logged at: /var/log/mariadb/mariadb.log
    MySQL Specific Selinux Contexts
    171 ps -eZ | grep mysqld
    I do not see anything as mysqld/maridb is not running
    178 systemctl start mariadb.service
    179 systemctl enable mariadb.service
    180 ps -eZ | grep mysqld
    now the output:
    system_u:system_r:mysqld_safe_t:s0 4428 ? 00:00:00 mysqld_safe
    system_u:system_r:mysqld_t:s0 4585 ? 00:00:00 mysqld
    184 mysqld runs on it’s own domain mysqld_t
    Related Selinux file type: mysql_exec_t
    etc_t is for /etc/my.cnf.d
    mysql_db_t is for /var/lib/mysql/
    mysql_log_t is for /var/log/mariadb/
    189 ll -dZ /usr/libexec/mysqld /etc/my.cnf.d /var/lib/mysql /var/log/mariadb
    The output – please note the Selinux Contexts in the output
    drwxr-xr-x. root root system_u:object_r:mysqld_etc_t:s0 /etc/my.cnf.d
    -rwxr-xr-x. root root system_u:object_r:mysqld_exec_t:s0 /usr/libexec/mysqld
    drwxr-xr-x. mysql mysql system_u:object_r:mysqld_db_t:s0 /var/lib/mysql
    drwxr-x—. mysql mysql system_u:object_r:mysqld_log_t:s0 /var/log/mariadb
    Corresponding Selinux Port Type: mysql_port_t
    196 semanage port -l | grep mysqld
    output:
    mysqld_port_t tcp 1186, 3306, 63132-63164
    Related Selinux Booleans: mysql_connect_any, selinuxuser_mysql_connect_enabled
    200 getsebool -a | grep mysql
    I see the output
    mysql_connect_any –> off
    selinuxuser_mysql_connect_enabled –> off
    To install MariaDB-Server:
    205 yum -y install mariadb-server
    already installed. we installed with yum -y install mariadb* [installed everything together]
    207 systemctl enable mariadb
    We can run mysql_secure_installation – to secure our MariaDB installation

    209 mysql_secure_installation

    The Output: from mysql_secure_installation command
    NOTE: RUNNING ALL PARTS OF THIS SCRIPT IS RECOMMENDED FOR ALL MariaDB
    SERVERS IN PRODUCTION USE! PLEASE READ EACH STEP CAREFULLY!
    In order to log into MariaDB to secure it, we’ll need the current
    password for the root user. If you’ve just installed MariaDB, and
    you haven’t set the root password yet, the password will be blank,
    so you should just press enter here.
    Enter current password for root (enter for none):
    OK, successfully used password, moving on…
    Setting the root password ensures that nobody can log into the MariaDB
    root user without the proper authorisation.
    Set root password? [Y/n] y
    New password:
    Re-enter new password:
    Password updated successfully!
    Reloading privilege tables..
    … Success!
    By default, a MariaDB installation has an anonymous user, allowing anyone
    to log into MariaDB without having to have a user account created for
    them. This is intended only for testing, and to make the installation
    go a bit smoother. You should remove them before moving into a
    production environment.
    Remove anonymous users? [Y/n] y
    … Success!
    Normally, root should only be allowed to connect from ‘localhost’. This
    ensures that someone cannot guess at the root password from the network.
    Disallow root login remotely? [Y/n] y
    … Success!
    By default, MariaDB comes with a database named ‘test’ that anyone can
    access. This is also intended only for testing, and should be removed
    before moving into a production environment.
    Remove test database and access to it? [Y/n] y
    – Dropping test database…
    … Success!
    – Removing privileges on test database…
    … Success!
    Reloading the privilege tables will ensure that all changes made so far
    will take effect immediately.
    Reload privilege tables now? [Y/n] y
    … Success!
    Cleaning up…
    All done! If you’ve completed all of the above steps, your MariaDB

    installation should now be secure.
    Thanks for using MariaDB!
    Enable MariaDB through Firewall and Allow traffic on Port 3306 – default mysql port
    218 firewall-cmd –add-service=mysql –perm
    220 firewall-cmd –reload
    221 systemctl start mariadb
    222 systemctl status mariadb
    223 start mysql/mariadb
    Run MySQL
    224 mysql -u root -p
    mysqldump is used to backup a database
    mysql command can be used to restore a database
    you can even use IDEs such as MySQL Workbench to backup and restore MySQL Databases
    228 mysql -u root -p
    229 mysqldump -u root -p testsayed > testsayeddb.sql
    to restore – you need to use < testsayeddb.sql
    231 mysql -u root -p testsayed < testsayeddb.sql
    Backup and Restore MySQL Database
    You can backup multiple databases at once, you can even backup some tables or other database objects using mysqldump
    similarly, you can restore multiple databases at the same time using mysql command
    just use multiple datbase or database object names with NO comma – one after another
    235 mysqldump -u root -p DB1 DB2 DB3 > alldb.sql
    when you use restore and give the sql file – if you use db name or table name before < then only that part will be restored irrespective hiow much data is there on the file
    example
    238 mysql -u root -p DB1 tbl1 < alldb.sql ;
    you can use –all-databases or –databases with mysqldump command
    Share this: From: http://sitestree.com/learn-some-centos-redhat-linux-rhce-mariadb-administration-on-redhat-fedora-centos/
    Categories:
    Tags:
    Post Data:2021-01-24 20:25:57

        Shop Online: <a href='https://www.ShopForSoul.com/' target='new' rel="noopener">https://www.ShopForSoul.com/</a>
        (Big Data, Cloud, Security, Machine Learning): Courses: <a href='http://Training.SitesTree.com' target='new' rel="noopener"> http://Training.SitesTree.com</a> 
        In Bengali: <a href='http://Bangla.SaLearningSchool.com' target='new' rel="noopener">http://Bangla.SaLearningSchool.com</a>
        <a href='http://SitesTree.com' target='new' rel="noopener">http://SitesTree.com</a>
        8112223 Canada Inc./JustEtc: <a href='http://JustEtc.net' target='new' rel="noopener">http://JustEtc.net (Software/Web/Mobile/Big-Data/Machine Learning) </a>
        Shop Online: <a href='https://www.ShopForSoul.com'> https://www.ShopForSoul.com/</a>
        Medium: <a href='https://medium.com/@SayedAhmedCanada' target='new' rel="noopener"> https://medium.com/@SayedAhmedCanada </a>
    

    Basic Information on Exception Handling in .Net #.Net Web Applications

    Brought from our old site: http://salearningschool.com/displayArticle.php?table=Articles&articleID=1356&title=Basics%20of%20Exception%20Handling%20in%20.Net

    Basic Information on Exception Handling in .Net

    Why exception handling? In your applications, unexpected error situations may occur that are out of your application scope and your application logic. These are actually external to your application. For example, while you are reading a file from hard drive, the file may not be there; or the remote server may be too busy or unavailable to get back to you with the result of your query. Exception handling addresses such situations.

    How can you handle such situations:

    • Use try, catch, finally structure to address such situations
    • Put the code where, you are anticipating an exception inside a try{} block. Put the code to handle the error situation in catch (Exception ex) {} blocks. You can have multiple catch blocks where each one will address a specific type of exception situation.
    • One more note, the code block where exception may occur may need to execute some logic/code whether an exception occurs or or not such as closing a file, closing the database connection. To accomplish this, you can use a finally block. A finally block is always executed, regardless of whether an exception is thrown or not.
    • When an exception occurs, the events are thrown by the environment. You need to address that if you want to. Else, your users will see the errors and will cause a bad user experience.
    • You can even throw exceptions on your own in your code. But why? say if you anticipate that there will be some error situations that are not external but related to your application logic and you actually do not want to handle those situations (serve some services in those situations for example) in your application. You can just throw exceptions and think that these are the conditions; you do not want to support in your application. Throw exception and provide some generalized response to your visitors.
    • You can also handle exceptions throw the web objects’ built in error events such as Page_Error, Global_Error, Application_Error.
    • In certain situations, You can take advantage of the error pages of the webserver to provide useful information to your visitors. You can replace the default error pages of your web-server and provide customized error pages to your visitor
    • Finally, you can use tracing to log the error events. Monitor the tracing to understand which types of situations occur more frequently than others. And find out a solution and apply the solution
    • It is possible to turn on and off this tracing without modifying the application code. You can make use of the web.config file configurations

    Regarding error pages, you can provide your custom error pages for the standard HTTP error codes. Some codes are given below:204:No Content, 301:Moved, Moved Permanently, 302: Found, Redirect, 400:bad request, 401:unauthorized, 403: forbidden, 404:not found, 408:request time out, 500:internal server error, 503:service unavailable, 505:Http version not supported.

    You can also make use of the errorPage attribute of the Page object to define an error page for the exceptions of that particular page. Page level settings override the application level settings (as provided by web.config file)

    • How to enable application level tracing: use something similar as below in your web.config file
      { and } are used instead of < and > respectively.
          {configuration}
              {system.web}
                  {trace enabled="true" requestLimit="40" localOnly="false"/}
              {/system.web}
          {/configuration}
      
    • to enable tracing for a particular page, use the trace property of the Document object
    • how to write tracing information to the trace log: Trace.Warn()

    From: http://sitestree.com/?p=3744
    Categories:.Net Web Applications
    Tags:
    Post Data:2016-07-16 12:23:19

        Shop Online: <a href='https://www.ShopForSoul.com/' target='new' rel="noopener">https://www.ShopForSoul.com/</a>
        (Big Data, Cloud, Security, Machine Learning): Courses: <a href='http://Training.SitesTree.com' target='new' rel="noopener"> http://Training.SitesTree.com</a> 
        In Bengali: <a href='http://Bangla.SaLearningSchool.com' target='new' rel="noopener">http://Bangla.SaLearningSchool.com</a>
        <a href='http://SitesTree.com' target='new' rel="noopener">http://SitesTree.com</a>
        8112223 Canada Inc./JustEtc: <a href='http://JustEtc.net' target='new' rel="noopener">http://JustEtc.net (Software/Web/Mobile/Big-Data/Machine Learning) </a>
        Shop Online: <a href='https://www.ShopForSoul.com'> https://www.ShopForSoul.com/</a>
        Medium: <a href='https://medium.com/@SayedAhmedCanada' target='new' rel="noopener"> https://medium.com/@SayedAhmedCanada </a>
    

    Encryption and .Net #.Net Web Applications

    Brought from our old site: http://salearningschool.com/displayArticle.php?table=Articles&articleID=1355&title=Encryption%20and%20.Net

    Encryption and .Net

    Dot net provides rich support for data encryption. the namespace System.Security.Cryptography includes the encryption features.

    There are three primary concepts related to encryption such as Hashing, Symmetric Encryption, and Asymmetric encryption. A hash is a data fingerprint, a small data that represents the uniqueness of a large block of data. In Symmetric Encryption, a single key is used for both encryption and decryption. In Asymmetric encryption, two different keys are used, one for encryption and another one for decryption. In real world applications, a combination of all three methods are used to provide better security.

    A digital transmission of a check can be as follows: create the hash of the check, encrypt the hash with the public key using asymmetric encryption, apply the encrypted hash on the document, encrypt the symmetric encryption key with asymmetric encryption method, encrypt the check with symmetric encryption, transmit the encrypted key and encrypted document to the receiver

    Hash Example

       hash = New Encryption.Hash(Encryption.Hash.Provider.CRC32)
       data = New  Encryption.Data("Hash Browns")
       hash.Calculate(data)
    

    Symmetric example:

        sym = New Encryption.Symmetric(Encryption.Symmetric.Provider.Rijndael)
        key = New Encryption.Data("Pass")
        Encryption.Data encryptedData;
        encryptedData = sym.Encrypt(New Encryption.Data("Secret"), key)
        string base64EncryptedString = encryptedData.ToBase64
    

    Asymmetric Example

      
            asym = New Encryption.Asymmetric
        pubkey = New Encryption.Asymmetric.PublicKey
        privkey = New Encryption.Asymmetric.PrivateKey
        asym.GenerateNewKeyset(pubkey, privkey)
    
        secret = "ancient chinese"
        Encryption.Data encryptedData
        encryptedData = asym.Encrypt(New Encryption.Data(secret), pubkey)
        Encryption.Data decryptedData 
        asym2 = New Encryption.Asymmetric
        decryptedData = asym2.Decrypt(encryptedData, privkey)
    

    From: http://sitestree.com/?p=3742
    Categories:.Net Web Applications
    Tags:
    Post Data:2016-07-16 12:15:58

        Shop Online: <a href='https://www.ShopForSoul.com/' target='new' rel="noopener">https://www.ShopForSoul.com/</a>
        (Big Data, Cloud, Security, Machine Learning): Courses: <a href='http://Training.SitesTree.com' target='new' rel="noopener"> http://Training.SitesTree.com</a> 
        In Bengali: <a href='http://Bangla.SaLearningSchool.com' target='new' rel="noopener">http://Bangla.SaLearningSchool.com</a>
        <a href='http://SitesTree.com' target='new' rel="noopener">http://SitesTree.com</a>
        8112223 Canada Inc./JustEtc: <a href='http://JustEtc.net' target='new' rel="noopener">http://JustEtc.net (Software/Web/Mobile/Big-Data/Machine Learning) </a>
        Shop Online: <a href='https://www.ShopForSoul.com'> https://www.ShopForSoul.com/</a>
        Medium: <a href='https://medium.com/@SayedAhmedCanada' target='new' rel="noopener"> https://medium.com/@SayedAhmedCanada </a>