Posts

Showing posts from June, 2020

How do I connect to cloud storage files from Google Data Studio?

gs://mobile-operator-data/vodafone_co_uk/2020-06-24/products_2020-06-24.csv bucket url mobile-operator-data/vodafone_co_uk/2020-06-24/products_2020-06-24.csv Make sure you don't have gs:// in your path... A lot of documentation said to have this but it won't work if you keep it (at least for me)

How do I troubleshoot instance connection timeout errors in Amazon VPC?

Resolution Review the following settings in your configuration: Public and Elastic IP addresses Verify that your instance has an associated  public IP address  or  Elastic IP address  using  Determining Your Public, Private, and Elastic IP Addresses . Be sure to use this IP address when connecting to the instance. System and instance status checks Verify that your instance is passing  system and instance status checks . Security groups Add a rule  to your security groups to allow access to your instance from your IP address using SSH. Network ACLs Verify that network ACLs allow access to your instance over SSH from your IP address as follows. For a sample configuration, see  Example: Controlling Access to Instances in a Subnet . Sign in to the  Amazon EC2 console . In the navigation pane under  Instances , choose  Instances . In the content pane, select your instance. Choose the  Description  view. Note the  Subnet ID . Sign in to the  Amazon VPC console . In the navigation pane under 

Invalid command 'SSLEngine', perhaps misspelled or defined by a module not included in the server configuration

It turned out I did enabled ssl module but i had to do it again and it works, here is the command: sudo a2enmod ssl Now restart apache like so  service apache2 restart no more error, FIXED!

Home directory not being created

Add the below entry in /etc/login.defs and save: CREATE_HOME yes Now, try to create user accounts. It will create the home directory

DNS not reflecting globally

check ns1 and ns2 records and deactivate cloudflare CDN abd check A record for that domain like if it is ns1.skyblooga.com then for ns and skybloggs IP address should be same  dig @192.227.67.74 cloudflare.com A   dig @192.227.67.74 pretech.co.in MX    dig @192.227.75.135 pretech.co.in MX dig @192.227.84.98 pretech.co.in MX

Ftp overwrite 550 error

You really should use SFTP problem resolved

Wordpress keeps redirecting to install-php after migration

I had a similar problem. I got the install.php after moving files and creating a new database. It seems the install screen shows up it there is a problem finding the correct database tables. I fixed the problem by changing the following settings to be correct: // ** MySQL settings - You can get this info from your web host ** // /** The name of the database for WordPress */ define ( 'DB_NAME' , 'HikeforLife_dev11' ); /** MySQL database username */ define ( 'DB_USER' , 'HikeforLife_dev11' ); $table_prefix = 'wphk_' ; search table prefix it is fiffrent from wp_collate

How to fix the WordFence wordfence-waf.php problem

PHP Fatal error: Unknown: Failed opening required '/var/www/html/wordfence-waf.php' (include_path='.:/usr/share/php') in Unknown on line 0 php_value auto_prepend_file '/home/public_html/wordfence-waf.php' egrep -Rw * -e ' php_value auto_prepend_file ' in user home directory outside public_html

How to Fix the 500 Internal Server Error in WordPress

How to resolve 500 internal server error Most of the time, you can have the 500 internal server error solved in 6 steps: 1. Turn on debugging Whenever WordPress throws you a white screen of death or a server error, I recommend turning your debugging on. While this may not fix the problem, it may give you more insight into what’s going on. You can turn debugging on by editing your site’s  wp-config.php  file. Once you’ve accessed this file, search for  WP_DEBUG  within. If you find it, you should be able to set it to “true”. If you don’t see it in there, you’ll need to create it yourself. Either way, at the end of the day, you should have a line that looks like this: define( "WP_DEBUG", true ); Once saved, reload your site to see if anything has changed. If you’re lucky, the server error may disappear and might be replaced with a different error, one that actually tells you where the issue is. If this is the case, take a look at where the error is located. If it is within a pl

Installing PhpyMyAdmin on Webmin/Virtualmin

virtualmin> install script > available script > php myadmin

named not starting

root@server named]# systemctl status  named -l                 ● named.service - Berkeley Internet Name Domain (DNS)   Loaded: loaded (/usr/lib/systemd/system/named.service; disabled; vendor preset: disabled)  Drop-In: /etc/systemd/system/named.service.d           └─cpanel.conf   Active: failed (Result: exit-code) since Tue 2020-06-23 14:18:13 CEST; 3min 45s ago  Process: 33648 ExecStartPre=/bin/bash -c if [ ! "$DISABLE_ZONE_CHECKING" == "yes" ]; then /usr/sbin /named-checkconf -z "$NAMEDCONF"; else echo "Checking of zone files is disabled"; fi (code=exited, st atus=1/FAILURE)                                                                                         Jun 23 14:18:13 server bash[33648]: external/streamsafrica.com/IN: bad zone this is the error external/streamsafrica.com/IN: bad zone  /usr/sbin /named-checkconf -z "$NAMEDCONF" execute this zone streamsafrica.com/IN: NS 'ns1.first-ns.de.streamsafrica.com' has

Remote_smtp defer 53 retry time not reached any Host

Post old, but if anyone wants to try ... Today I needed, and solved, see how I did: Try, #Delete files: CODE:  SELECT ALL rm /var/spool/exim/db/* rm /var/spool/exim/input/* rm /var/spool/exim/msglog/* rm /var/log/exim/* #Clear file: CODE:  SELECT ALL > /var/log/dovecot.log #Then restart Exim4 OR Restart VPS CODE:  SELECT ALL service exim restart You may get an error in exim_mainlog while sending an email as below, 2014-04-01 12:01:41 [10040] 1Wb2Kq-0002bq-UH == admin@domain.com R=dkim_lookuphost T=dkim_remote_smtp defer (-53): retry time not reached for any host First off, you have to ensure that remote smtp server is accepting connections on 25/tcp by telnet commnad,   #  telnet host.hostname.com 25 Trying 192.168.0.1... Connected to host.hostname.com. 220-host.hostname.com ESMTP Exim 4.80.1 #2 Wed, 01 Jan 2014 11:14:46 +0530 220-We do not authorize the use of this system to transport unsolicited, 220 and/or bulk e-mail. Next step is to tidy up exim database in case of you database

Exim Smarthost Multiple domains and credentials Mailgun

0 I have the same setup (VPS + WHM/cPanel + Exim + Mailgun) and after doing some online research, I've found a few helpful websites regarding this topic and managed to come out with the correct configuration. Below are the solutions that I'm currently using on my VPS and hope it will help you as well. It should solve your "via" problem and might solve the intermittent "550 5.7.1 Relaying denied" error from Mailgun as well: Go to the "Exim Configuration Editor" in WHM. Choose "Advanced Editor" and insert the configuration below: Section: AUTH mailgun_login: driver = plaintext public_name = LOGIN hide client_send = ": ${extract{login}{${lookup{$sender_address_domain}lsearch{/etc/exim_mailgun}{$value}fail}}} : ${extract{password}{${lookup{$sender_address_domain}lsearch{/etc/exim_mailgun}{$value}fail}}}" Section: ROUTERSTART mailgun: driver = manualroute domains = ! +local_domains transport = mailgun_transport route_list = "* s

cyberpanel

Install CyberPanel Control Panel Now you can start CyberPanel Control Panel Installation by running the following command: cd /usr/local/src && wget https://cyberpanel.net/install.sh && sh install.sh ySQL root password: To find out the password of your MySQL root, use the following command: more /etc/cyberpanel/mysqlPassword If you want to change your MySQL root password at anytime, you can do that by using the command below: nano /etc/cyberpanel/mysqlPassword Change the password, save the file and exit. You will also need to update the password in the settings file that is located at  /usr/local/CyberCP/CyberCP/settings.py  file under  rootdb  entry by using the command below: nano /usr/local/CyberCP/CyberCP/settings.py Once done, run the following command: systemctl restart lscpd mariadb.service - MariaDB database server Loaded: loaded (/lib/systemd/system/mariadb.service; enabled; vendor preset: enabled) Active: activating (auto-restart) (Result: signal) since