Marco Antonio Blos de Souza marcoblos

## disable-or-enable-apache-from-whm-cpnale-instalations.md

      
              1 file
            
          
              0 forks
            
          
              0 comments
            
          
              1 star
            
          
                marcoblos
                / disable-or-enable-apache-from-whm-cpnale-instalations.md
            
            
              Last active
              December 25, 2022 10:01
            
              
                Step by step disable Apache in WHM/cPanel and avoid it to restart
              
          
Go to command line in your server and execute service httpd stop OR /etc/init.d/httpd stop


To avoid WHM/cPanel monitor system to restart the apache, execute chkconfig --level 345 httpd off


PS.: if you want that monitor start looking for apache service again, just execute chkconfig --level 345 httpd on
Content from: https://www.b4b.net/members/knowledgebase.php?action=displayarticle&amp;id=10&amp;language=spanish

  
## login-without-password-and-without-copy-key-to-server.md

      
              1 file
            
          
              2 forks
            
          
              0 comments
            
          
              9 stars
            
          
                marcoblos
                / login-without-password-and-without-copy-key-to-server.md
            
            
              Created
              May 26, 2019 05:42
            
              
                Step by step: create a pem file to login without password and without copy local keys to remote server. SSH authentication like AWS EC2.
              
          
Login with account user (not root)

mkdir pem
cd pem
ssh-keygen -b 2048 -f identity -t rsa


Copy public key contents to authorized_keys


## java - spring - rest controller - upload excel file
private String getContent(Cell cell) {
	switch (cell.getCellTypeEnum()) {
		case STRING:
			return cell.getRichStringCellValue().getString();
		case NUMERIC:
			if (DateUtil.isCellDateFormatted(cell)) {
				return cell.getDateCellValue() + "";
			} else {
				return cell.getNumericCellValue() + "";
			}

## explain_proximity_SQL_algorithm.md

      
              1 file
            
          
              0 forks
            
          
              0 comments
            
          
              0 stars
            
          
                marcoblos
                / explain_proximity_SQL_algorithm.md
            
            
              Last active
              September 5, 2017 17:11
            
              
                proximity SQL algorithm
              
          
    Based on:

http://www.arubin.org/files/geo_search.pdf
http://jehiah.cz/a/spatial-proximity-searching-using-latlongs
http://www.plumislandmedia.net/mysql/haversine-mysql-nearest-loc/
https://stackoverflow.com/questions/28847954/what-is-the-best-approach-to-find-all-addresses-that-are-in-a-specific-distance

SELECT rua,
truncate((degrees(acos(


## restartGitlabRHEL.md

      
              1 file
            
          
              0 forks
            
          
              0 comments
            
          
              0 stars
            
          
                marcoblos
                / restartGitlabRHEL.md
            
            
              Last active
              March 14, 2017 23:44
            
          
    sudo gitlab-ctl restart
systemctl restart gitlab-runsvdir.service

  
## restartWifiUbuntu.md

      
              1 file
            
          
              0 forks
            
          
              0 comments
            
          
              0 stars
            
          
                marcoblos
                / restartWifiUbuntu.md
            
            
              Created
              March 14, 2017 12:25
            
              
                Fix Ubuntu WiFi out of range
              
          
    When I updated and restarted my linux distro, wifi showed "out of range", to solve ran:
sudo service network-manager restart
	private String getContent(Cell cell) {
	switch (cell.getCellTypeEnum()) {
	case STRING:
	return cell.getRichStringCellValue().getString();
	case NUMERIC:
	if (DateUtil.isCellDateFormatted(cell)) {
	return cell.getDateCellValue() + "";
	} else {
	return cell.getNumericCellValue() + "";
	}