setup remote ping check
Monitoring response-time via NSClient++
Add a command to NSClient++’s configuration file custom.ini:
command[check_ping]=C:\plugins\check_ping.exe -H $ARG1$ -w $ARG2$ -c $ARG3$
Add a command to NSClient++’s configuration file op5.ini
check_ping = cmd /c scripts\op5\check_ping.exe -H $ARG1$ -w $ARG2$ -c $ARG3$
Client asked to update our cert to their adfs. Couldn’t find a good way to troubleshoot this using google so started to examine all the configuration files in /etc/shibboleth.
Led me to federationmetadata.xml.
Found section keydescriptor that looked like a certificate so I added a new section with the new cert.
<KeyDescriptor use="signing"> <KeyInfo xmlns="http://www.w3.org/2000/09/xmldsig#"> <X509Data> <X509Certificate>MII......hidden......</X509Certificate> </X509Data> </KeyInfo> </KeyDescriptor>
Must have brew
brew install mtr –HEAD
https://httpd.apache.org/docs/trunk/ssl/ssl_howto.html
# "Modern" configuration, defined by the Mozilla Foundation's SSL Configuration # Generator as of August 2016. This tool is available at # https://mozilla.github.io/server-side-tls/ssl-config-generator/ SSLProtocol all -SSLv3 -TLSv1 -TLSv1.1 # Many ciphers defined here require a modern version (1.0.1+) of OpenSSL. Some # require OpenSSL 1.1.0, which as of this writing was in pre-release. SSLCipherSuite ECDHE-ECDSA-AES256-GCM-SHA384:ECDHE-RSA-AES256-GCM-SHA384:ECDHE-ECDSA-CHACHA20-POLY1305:ECDHE-RSA-CHACHA20-POLY1305:ECDHE-ECDSA-AES128-GCM-SHA256:ECDHE-RSA-AES128-GCM-SHA256:ECDHE-ECDSA-AES256-SHA384:ECDHE-RSA-AES256-SHA384:ECDHE-ECDSA-AES128-SHA256:ECDHE-RSA-AES128-SHA256 SSLHonorCipherOrder on SSLCompression off SSLSessionTickets off
[email protected]:~# ntpq -pn remote refid st t when poll reach delay offset jitter ============================================================================== -67.198.200.4 69.89.207.199 3 u 30 64 1 1.182 -0.029 0.000 +216.239.35.0 .GOOG. 1 u 20 64 1 52.571 0.660 0.240 +216.239.35.4 .GOOG. 1 u 20 64 1 36.033 1.016 0.176 -216.239.35.8 .GOOG. 1 u 24 64 1 140.712 1.154 0.286 *216.239.35.12 .GOOG. 1 u 23 64 1 126.636 1.082 0.233
Use Firefox and you’ll be able to download the file.
Need ports TCP 4213, 4214
magento 1.9.3.1
view.phtml around line 100 replace the if statement
<?php if($_item->getColor()): ?>
<?php
$optionId = $_item->getColor();
$optionIdurl = Mage::helper('attributeoptionimage')->getAttributeOptionImage($optionId)
?>
<a href="#" class="color_swatch">
<?php if (strpos( $this->helper('catalog/image')->init($_item, 'small_image')->resize(100, 150), 'placeholder')) {
?>
<img src="<?php echo $optionIdurl; ?>" />
<?php
} else {
?>
<img src="<?php echo $this->helper('catalog/image')->init($_item, 'small_image')->resize(100, 150); ?>" />
<?php } ?>
<?php endif; ?>
reference:
http://www.bubblecode.net/en/2012/02/05/magento-add-images-to-product-attribute-options/
set ssl encrypt 3des sha-1
https://github.com/elkarbackup/elkarbackup
ElkarBackup is a free open-source backup solution based on RSync/RSnapshot
Here’s how to setup an automated backup process using Rsync.
1. Test rysnc using a password. Here we will be copying files from /src-dir to /dest-dir on [email protected]
> rsync -rvz -e 'ssh -p 22' --progress /src-dir [email protected]:/dest-dir2. Now let’s automate Rsync. Create the public and private keys on the source machine.
> ssh-keygen3. Copy the public key to username’s ~/.ssh/authorized_keys file in the destination machine.
> ssh-copy-id "[email protected] -p 22"4. Test SSH using key authentication.
> ssh "[email protected] -p 22"5. Test Rsync using key authentication.
> rsync -rvz -e 'ssh -p 22' --progress /src-dir [email protected]:/dest-dir6. Add Rsync to daily cron.
> cd /etc/cron.daily/> echo 'rsync -rz -e "ssh -p 22" /src-dir [email protected]:/dest-dir' >> rsync.cron> chmod u+x rsync.cron7. In case you want to use a password instead (not recommended), you can use sshpass.
> rsync -rvz -e 'sshpass -p password ssh -l username -p 22' --progress /src-dir [email protected]:/dest-dir
Notice the threads are different
one of the nodes failed then the whole cluster went down.
shutdown mysql on all nodes
cat /var/lib/mysql/grastate.dat
check which node has the highest seq number
boot strap that node
service mysql bootstrap-pxc
then start the next node but before that
mv /var/lib/mysql/grastate.dat ~
service mysql start
this will start a full resync
wait till it finishes then start the same process on the next node.
https://www.percona.com/doc/percona-xtradb-cluster/5.5/manual/bootstrap.html
trying out cloudrouter 3.0.
Doesn’t seem like much of a router when it doesn’t have dhcp.
https://devops.profitbricks.com/tutorials/deploy-outbound-nat-gateway-on-centos-7/
I remember installing this was much easier back in da day….
Trying to find vmware update manager. There is no download link for it on vmware website. After much searching you’ll find it in the vcenter iso.
.net 3.5 sp1 installation in windows 2012 can only be done through server manager. This is a big WTF. If your server isn’t online you need to run some command line that downloads it from a mounted windows 2012 iso. My server was having problems updating because of some firewall policies. Took a long time to figure this out.
installing update manager needs a ODBC connection. I remember in the past it would install sql express but now you gotta do everything manually. Had to download sqlexpress. I downloaded 2014 microsoft sql express 64 and then needed sql server management studio to create a database. Well VUM doesn’t support 64-bit, you need to setup a 32-bit sql. And 32-bit mssql only works with 32-it sql server management studio. Finally after setting up ODBC I was able to complete the install.
yes last problem. after all was said and done, vum service wasn’t talking to the database properly. The error didn’t say it couldn’t talk to database so couldn’t figure out for a while was wrong. I was looking up a bunch of stuff that didn’t help. Finally decided to look at event viewer. I should’ve done this first. Found that the SQL user SYSTEM was trying to access the db no permissions. I went to service manager and changed in properties, login as the administrator.
DONE
kinda old article but mostly worked. http://blog.manbolo.com/2013/02/04/how-to-install-python-3-and-pydev-on-osx
to update java on Mac
used this http://stackoverflow.com/questions/24342886/how-to-install-java-8-on-mac
i installed minimal eclipse install and then added pydev
When you install magmi and you access magmi/web/magmi.php initial login/pass will be “magmi/magmi”. After you setup db connection info it will use magento back office login/password.
create magmi/.htaccess
Order deny,allow
Deny from all
then create magmi/web/.htaccess
Order allow,deny
Allow from all
RewriteEngine On
RewriteCond %{HTTP:Authorization} ^(.+)$
RewriteRule .* – [E=HTTP_AUTHORIZATION:%{HTTP:Authorization}]
You can still add a passphrase to a private key even after a certificate is generated.
openssl rsa -des3 -in your.key -out your.encrypted.key mv your.encrypted.key your.key
the -des3 tells openssl to encrypt the key with DES3.
remove it
openssl rsa -in your.key -out your.open.key
you will be asked for your passphrase one last time by omitting the -des3 you tell openssl to not encrypt the output.
mv your.open.key your.key
http://security.stackexchange.com/questions/59136/can-i-add-a-password-to-an-existing-private-key
extract magmi to your magento folder
go to magmi/web/
create htpasswd using ‘/usr/local/apache/bin/htpasswd -c .htpasswd itheadaches’
set owner to files ‘chown -R fill4style.fill4style itheadaches’
set permission to files
install php-mbstring, in my case I had to recompile apache with mbstring
[email protected]:~$ sudo >>> /etc/sudoers: syntax error near line 33 <<< sudo: parse error in /etc/sudoers near line 33 sudo: no valid sudoers sources found, quitting sudo: unable to initialize policy plugin
[email protected]:~$ pkexec visudo -f /etc/sudoers ==== AUTHENTICATING FOR org.freedesktop.policykit.exec === Authentication is needed to run `/usr/sbin/visudo' as the super user Multiple identities can be used for authentication: 1. Admin User,,, (adminuser) 2. ,,, (krypt) Choose identity to authenticate as (1-2): 2 Password: ==== AUTHENTICATION COMPLETE ===
svchost.exe high cpu on windows 7
used process explorer to figure out what service is taking up all the cpu. process explorer is a free tool from microsoft.
found it was dnscache.
read here to try disabling the dns service. I disabled the service and DNS resolution was working, but after a while it would stop and after reboots it wasn’t working either. Found at the bottom of the forum that processing the hosts file is what’s causing the slow down. Even though my hosts file had some entires from spybot it wasn’t huge. I replaced c:\windows\system32\drivers\etc\hosts with an empty and cpu usage was back to normal.
Add this at the end of .htaccess file
## EXPIRES CACHING ## <IfModule mod_expires.c> ExpiresActive On ExpiresByType image/jpg "access 1 week" ExpiresByType image/jpeg "access 1 week" ExpiresByType image/gif "access 1 week" ExpiresByType image/png "access 1 week" ExpiresByType text/css "access 1 week" ExpiresByType application/pdf "access 1 week" ExpiresByType application/javascript "access 1 week" ExpiresByType application/x-javascript "access 1 week" ExpiresByType application/x-shockwave-flash "access 1 week" ExpiresByType image/x-icon "access 1 week" ExpiresDefault "access 1 week" </IfModule> <IfModule mod_headers.c> <FilesMatch ".(js|css|xml|gz|html)$"> Header append Vary: Accept-Encoding </FilesMatch> Header set Connection keep-alive </IfModule> ## EXPIRES CACHING ##
<?php echo $header; ?>
<?php echo $content_top; ?>
<div class="container">
<div class="row"><?php echo $column_left; ?>
<?php if ($column_left && $column_right) { ?>
<?php $class = 'col-sm-6'; ?>
<?php } elseif ($column_left || $column_right) { ?>
<?php $class = 'col-sm-9'; ?>
<?php } else { ?>
<?php $class = 'col-sm-12'; ?>
<?php } ?>
<div id="content" class="<?php echo $class; ?>"><?php
//echo $my_custom_text;
// var_dump ($download_result);
if ($download_result->num_rows > 0) {
// output data of each row
foreach ($download_result as $row){
if ($row["download_id"]) {
echo "<div class='download'>ID: " . $row["download_id"]. " - <a href='/system/download/" . $row["filename"]. "'>Download: " . $row["mask"] . "</a></div><br>";
}
}
} else {
echo "0 results";
}
?><?php echo $content_bottom; ?></div>
<?php echo $column_right; ?></div>
</div>
<?php echo $footer; ?>
<?php
class ControllerDownloadDownload extends Controller {
public function index() {
// set title of the page
$this->document->setTitle("My Download Page");
// define children templates
$data['column_left'] = $this->load->controller('common/column_left');
$data['column_right'] = $this->load->controller('common/column_right');
$data['content_top'] = $this->load->controller('common/content_top');
$data['content_bottom'] = $this->load->controller('common/content_bottom');
$data['footer'] = $this->load->controller('common/footer');
$data['header'] = $this->load->controller('common/header');
// set data to the variable
$data['my_custom_text'] = "This is my custom page.";
$sql = "SELECT * FROM oc_download";
$download_result = $this->db->query($sql);
// var_dump ($download_result);
$data['download_result'] = $download_result;
// call the "View" to render the output
if (file_exists(DIR_TEMPLATE . $this->config->get('config_template') . '/template/download/download.tpl')) {
$this->response->setOutput($this->load->view($this->config->get('config_template') . '/template/download/download.tpl', $data));
} else {
$this->response->setOutput($this->load->view('default/template/download/download.tpl', $data));
}
}
}
?>
go to http://icetrousa.com/index.php?route=download/download
reference:
http://code.tutsplus.com/articles/from-beginner-to-advanced-opencart-more-about-mvc–cms-21737
Use object-fit:contain in CSS styles to contain image inside width/height.
<div class=”swatch-loader” style=”text-align:center;”><img src=”<?php echo $this->getSkinUrl(‘images/ajaxcartpopup/loading.gif’);?>” width=”17″ height=”17″ style=”object-fit:contain;display:inline;” /></div>
Test should work for any 1.6.x.x, but only tested on 1.6.0.9, 1.6.0.11, and 1.6.1.4
There is a problem with the token. orders.js is the new file and orders.js.bak is the original js file. You will see the token is pulled from the url/href.
[email protected] [/home/bozzolo/www]# diff js/admin/orders.js js/admin/orders.js.bak 595c595 < token: window.location.href.split('token=')[1].split("&")[0], --- > token: token, 685c685 < query = 'ajax=1&token='+window.location.href.split('token=')[1].split("&")[0]+'&action=editProductOnOrder&id_order='+id_order+'&'; --- > query = 'ajax=1&token='+token+'&action=editProductOnOrder&id_order='+id_order+'&'; 762c762 < var query = 'ajax=1&action=deleteProductLine&token='+window.location.href.split('token=')[1].split("&")[0]+'&id_order_detail='+id_order_detail+'&id_order='+id_order; --- > var query = 'ajax=1&action=deleteProductLine&token='+token+'&id_order_detail='+id_order_detail+'&id_order='+id_order;
Fix for this: Can’t edit/add ordered products in an order page
I downloaded tftpserver for mac os x from here.
It uses /private/tftpboot as the path. go to console and type chmod 777 /private/tftpboot
when you try to upload a file you will get access violation. You must first create the file so it can be overwritten.
Headache: [ERROR] WSREP: failed to open gcomm backend connection: 131: invalid UUID: 00000000 (FATAL)
at gcomm/src/pc.cpp:PC():271
Solution:
rename /var/lib/mysql/gvwstate.dat to /var/lib/mysql/gvwstate.dat.bak
service mysql start
-rw-rw---- 1 kolbe kolbe 8.4K Mar 26 17:57 #sql-f3be_1.frm -rw-rw---- 1 kolbe kolbe 24M Mar 26 17:57 #sql-f3be_1.ibd
https://mariadb.com/blog/get-rid-orphaned-innodb-temporary-tables-right-way
design/frontend/mogan/default/template/catalog/layer/view.phtml
moved javascript to the very bottom
<script>
jQuery(document).ready(function(){
jQuery(document).on('click',"#shop-by-header",function(){
jQuery("#shop-by-content").slideToggle();
});
jQuery(document).on('click',"dt[data-toggle='true']",function(){
var elm=jQuery(this),name=jQuery(this).attr('data-name').split('-')[1];
console.log('dd[data-toggle="toggle-'+name+'"]');
jQuery('.toggle-'+name).slideToggle( "slow",function(){
if(elm.text()==='- '){
elm.find('span').text('+ ');
}else{
elm.find('span').text('- ');
}
});
});
});
</script>java
The category page aka product-list page was really slow to load, about 25 seconds plus
To troubleshoot Magento’s cpu usage, first enable varien profiler
http://www.techawaken.com/enable-magento-profiler-identify-magento-performance-bottlenecks/
You can also try aoe_profiler
Found out it was the configurable swatches.
Tried the first method in this post.
http://magento.stackexchange.com/questions/69863/configurable-swatches-slow-site-down
My load time went from 25s to 10s. Then I tried the 2nd post which points to https://github.com/wigman/AjaxSwatches
Load time went down 3s
BTW I am running Magento 1.9.2.1
I used the export all products dataflow as a template then started modifying it from there. Put configurable product at the end.
Added + in front of image url so that it will not add as exclude image http://magento.stackexchange.com/questions/29891/magmi-images-excluded
added 3 columns: media_gallery,super_products_sku,configurable_attributes http://stackoverflow.com/questions/16166425/magmi-importing-configurable-product
Used magmi to import the csv http://sourceforge.net/projects/magmi/
in magmi enabled itemprocessors, “Magmi Optimizer, Magmi Magento Reindexer, Image attriutes processor, On the fly indexer, Configurable Item Processor”
BTW this was done on Magento 1.9.x
copy and paste as csv file and open in csv viewer like openoffice or excel
store,websites,attribute_set,type,category_ids,sku,has_options,name,meta_title,meta_description,image,small_image,thumbnail,gallery,url_key,url_path,custom_design,page_layout,options_container,image_label,small_image_label,thumbnail_label,country_of_manufacture,msrp_enabled,msrp_display_actual_price_type,gift_message_available,gift_wrapping_available,color,status,is_recurring,visibility,tax_class_id,occasion,apparel_type,sleeve_length,fit,size,length,gender,description,short_description,meta_keyword,custom_layout_update,special_from_date,special_to_date,news_from_date,news_to_date,custom_design_from,custom_design_to,price,special_price,weight,msrp,gift_wrapping_price,qty,min_qty,use_config_min_qty,is_qty_decimal,backorders,use_config_backorders,min_sale_qty,use_config_min_sale_qty,max_sale_qty,use_config_max_sale_qty,is_in_stock,low_stock_date,notify_stock_qty,use_config_notify_stock_qty,manage_stock,use_config_manage_stock,stock_status_changed_auto,use_config_qty_increments,qty_increments,use_config_enable_qty_inc,enable_qty_increments,is_decimal_divided,stock_status_changed_automatically,use_config_enable_qty_increments,product_name,store_id,product_type_id,product_status_changed,product_changed_websites,website,_media_image,_media_lable,_media_position,_media_is_disabled,media_gallery,super_products_sku,configurable_attributes
admin,base,Clothing,simple,,taka012c-Royal Blue-L,0,taka Knit Top-Royal Blue-L,,,+http://dreamatico.com/data_images/girl/girl-8.jpg,http://dreamatico.com/data_images/girl/girl-8.jpg,http://dreamatico.com/data_images/girl/girl-8.jpg,,taka-knit-top-royal-blue-l,taka-knit-top-royal-blue-l.html,,1 column,Product Info Column,,,, ,Use config,Use config,No,No,Royal Blue,Enabled,No,Not Visible Individually,Taxable Goods,Casual,Knits,Short Sleeve,,L,,Female,”Loose fitting from the shoulders, open weave knit top. Semi sheer. Slips on. Faux button closure detail on the back. Linen/Cotton. Machine wash.”,The demure taka Knit features a semi sheer open weave and a forgiving silhouette. A nude camisole underneath keeps a stylish but conservative look.,,,3/1/13 0:00,,3/1/13 0:00,,,,210,,1,,,100,0,1,0,0,1,1,1,0,1,1,,,1,0,1,0,1,0,1,0,0,0,1,taka Knit Top-Royal Blue-L,0,simple,,,,,,,,/1/_/1_3.jpg;/2/_/2_2.jpg;/3/_/3_2.jpg;/4/_/4_2.jpg;/5/_/5_2.jpg,,
admin,base,Clothing,simple,,taka012c-Royal Blue-M,0,taka Knit Top-Royal Blue-M,,,+http://dreamatico.com/data_images/girl/girl-8.jpg,http://dreamatico.com/data_images/girl/girl-8.jpg,http://dreamatico.com/data_images/girl/girl-8.jpg,,Taka-knit-top-royal-blue-m,Taka-knit-top-royal-blue-m.html,,1 column,Product Info Column,,,, ,Use config,Use config,No,No,Mint,Enabled,No,Not Visible Individually,Taxable Goods,Casual,Knits,Short Sleeve,,M,,Female,”Loose fitting from the shoulders, open weave knit top. Semi sheer. Slips on. Faux button closure detail on the back. Linen/Cotton. Machine wash.”,The demure taka Knit features a semi sheer open weave and a forgiving silhouette. A nude camisole underneath keeps a stylish but conservative look.,,,3/1/13 0:00,,3/1/13 0:00,,,,210,,1,,,100,0,1,0,0,1,1,1,0,1,1,,,1,0,1,0,1,0,1,0,0,0,1,taka Knit Top-Royal Blue-M,0,simple,,,,,,,,/1/_/1_3.jpg;/2/_/2_2.jpg;/3/_/3_2.jpg;/4/_/4_2.jpg;/5/_/5_2.jpg,,
admin,base,Clothing,configurable,”10,11″,taka012c,1,taka Knit Top,,,+http://7-themes.com/data_images/out/75/7030450-miranda-kerr-smile-girl.jpg,http://7-themes.com/data_images/out/75/7030450-miranda-kerr-smile-girl.jpg,http://7-themes.com/data_images/out/75/7030450-miranda-kerr-smile-girl.jpg,,taka-knit-top,taka-knit-top-1046.html,,1 column,Product Info Column,,,, ,Use config,Use config,No,No,,Enabled,,”Catalog, Search”,Taxable Goods,Casual,Knits,Short Sleeve,,,,Female,”Loose fitting from the shoulders, open weave knit top. Semi sheer. Slips on. Faux button closure detail on the back. Linen/Cotton. Machine wash.”,The demure taka Knit features a semi sheer open weave and a forgiving silhouette. A nude camisole underneath keeps a stylish but conservative look.,,,3/1/13 0:00,,3/1/13 0:00,,,,210,,,,,0,0,1,0,0,1,1,1,0,1,1,,,1,0,1,0,1,0,1,0,0,0,1,taka Knit Top,0,configurable,,,,,,,,https://pbs.twimg.com/profile_images/378800000767456340/d2013134969a6586afd0e9eab6b0449b.jpeg::taka012c;http://f9view.com/wp-content/uploads/2014/05/Cute-Australian-Girl-Mobile-HD-Wallpapers.jpg::taka012c;,”taka012c-Royal Blue-L,taka012c-Royal Blue-M”,”size,color”
Install old version of firefox
https://ftp.mozilla.org/pub/mozilla.org/firefox/releases/
change SSL authorization to “SSL v3 + TLS” once you are able to access Open-e
Problem:
"PHP message: PHP Fatal error: Class 'SoapClient' not found in /usr/share/nginx/html/app/code/core/Mage/Usa/Model/Shipping/Carrier/Fedex.php on line 134" while reading response header from upstream, client: 173.197.173.75, server: papertine.com, request: "GET /zeki893.php HTTP/1.1", upstream: "fastcgi://127.0.0.1:9000", host: "papertine.com"
Fix:
yum install php-soap
first installed mysql query
https://wordpress.org/plugins/query-monitor/
this is a bad ass plugin
this plug lead me to a huge mysql query then found it was a bug in wordpress v4.3
https://wordpress.org/support/topic/high-cpu-load-after-update-to-v43?replies=17#post-7330770
Thank you kalpesh!!!! I’ve had problem for a long time only showing one page of Customers in my ‘Manage Customers’ list and I was running 1.8.1.0. I just upgraded to 1.9.2.1 and finally decided to try to tackle this issue while I was working on the server. Found this post, and now I can see all 5000+ customers.
I wonder why Magento hasn’t fixed this issue since version 1.5!!!!
Copy Db.php file from magento / lib / Varien / Data / Collection / Db.php
Paste it to your local directory so the resultant folder structure would look like this:
magento / app / code / local / Varien / Data / Collection / Db.php
Now open this file to edit and replace getSelectCountSql function with below one
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 |
public function getSelectCountSql()
{
$this->_renderFilters();
$countSelect = clone $this->getSelect();
$countSelect->reset(Zend_Db_Select::ORDER);
$countSelect->reset(Zend_Db_Select::LIMIT_COUNT);
$countSelect->reset(Zend_Db_Select::LIMIT_OFFSET);
$countSelect->reset(Zend_Db_Select::COLUMNS);
if(count($this->getSelect()->getPart(Zend_Db_Select::GROUP)) > 0) {
$countSelect->reset(Zend_Db_Select::GROUP);
$countSelect->distinct(true);
$group = $this->getSelect()->getPart(Zend_Db_Select::GROUP);
$countSelect->columns("COUNT(DISTINCT ".implode(", ", $group).")");
} else {
$countSelect->columns('COUNT(*)');
}
return $countSelect;
}
|
observium server on ubuntu
http://www.observium.org/docs/debian_ubuntu/
observium agent
wget http://x.x.x.x/apache
wget http://x.x.x.x/mysql
wget http://x.x.x.x/nginx
ubuntu
#setup agent apt-get -y install xinetd wget cd /etc/xinetd.d/ wget http://x.x.x.x/observium_agent_xinetd cd /usr/bin/ wget http://x.x.x.x/observium_agent chmod 775 /usr/bin/observium_agent mkdir /usr/lib/observium_agent mkdir /usr/lib/observium_agent/local service xinetd restart #monitor with mysql agent apt-get -y install php5-cli php5-mysql cd /usr/lib/observium_agent/local wget http://x.x.x.x/mysql chmod 775 mysql echo "<?php \$mysql_user = 'observium_mon'; \$mysql_pass='xxx'; ?>" > /usr/lib/observium_agent/local/mysql.cnf mysql -e "GRANT SUPER, REPLICATION SLAVE, PROCESS ON *.* TO 'observium_mon'@'localhost' IDENTIFIED BY 'xxx';" apt-get -y install snmpd cd /usr/bin/ wget http://x.x.x.x/distro chmod 775 distro cd /etc/snmp/ mv snmpd.conf snmpd.conf.orig wget http://x.x.x.x/snmpd.conf service snmpd restart
get the other libraries snmp, ssl, etc
yum install MariaDB-devel ln -s /usr/lib64/mysql/libmysqlclient_r.so.16.0.0 libmysqlclient_r.so ln -s /usr/lib64/mysql/libmysqlclient.so.16.0.0 libmysqlclient.so
then compile
if you get this error during make
common.h:143:18: error: mib.h: No such file or directory
then
cp /usr/include/net-snmp/library/mib.h .
To manage every aspect of the user database, you use the usermod tool.
To change username (it is probably best to do this without being logged in):
usermod -l newUsername oldUsername
This however, doesn’t rename the home folder.
To change home-folder, use
usermod -d /home/newHomeDir -m newUsername
after you changed the username.