Oscar Vazquez's questions

i'm a little bit lost about how to connect to an external server db.

So basically I create a user with the following query:

CREATE USER 'remote1'@'web-server-ip' IDENTIFIED BY 'password';

GRANT ALL PRIVILEGES ON db_test.* TO 'remote1'@'web-server-ip' IDENTIFIED BY 'password';

When I try to connect from the webserver it says Database 'db_test' does not exist or specified database server user does not have privileges to access this database.

What I'm doing wrong?

Also if I try to import a db on the db server it does not allow me to do that, should I create a new user but with @localhost? and grand privileges with the 'web-server-ip'?

Thanks!

Everytime I try to access to http://server-ip/folder1 it redirects me to http://example.com

I want to access to folder1 but it´s impossible because it's redirected to http://example.com/folder1

Here is my virtual host configuration in /etc/apache2/sites-enabled/000-default-ssl.conf

<VirtualHost *:80>

ServerAdmin webmaster@localhost
ServerName example.com
DocumentRoot /var/www/html/exampleSite/
RewriteEngine On
RewriteCond %{REQUEST_URI} !^/folder1/
RewriteCond %{REQUEST_URI} !^/folder2/
</VirtualHost>

Thanks!

I have an issue with my domain.

I have installed an EV SSL Certificate successfuly, on ssl checker tools it shows me that the certificates is installed and everything is ok. The problem is that in front end I have Not Secure, however I can access with https:

I think that the problem is with Apache configuration. At the beginning I had php page and showed to me site is secure, after changing the php page for the website itself, it shows Not Secure

Here is my virtual host configuration

<VirtualHost *:443>
  ServerAdmin webmaster@localhost
  ServerName subdomain.domain.org/
  DocumentRoot /var/www/html/domainFolder
  SSLEngine on

SSLCertificateFile   /etc/apache2/ssl/file.crt
SSLCertificateKeyFile  /etc/apache2/ssl/file.key
SSLCertificateChainFile    /etc/apache2/ssl/file2.crt

SSLProtocol all -SSLv2 -SSLv3 -TLSv1

<Directory /var/www/html/domain>
Options Indexes FollowSymLinks
AllowOverride All
Require all granted
SetEnv COMPOSER_HOME=~/.composer
</Directory>

</VirtualHost>

Please help

I'm trying to send emails from command line because I need to create a shell script later to send an email.

this is my configuration:

#
# Config file for sSMTP sendmail
#
# The person who gets all mail for userids < 1000
# Make this empty to disable rewriting.
 [email protected]

# The place where the mail goes. The actual machine name is required no
# MX records are consulted. Commonly mailhosts are named mail.domain.com
mailhub=smtp.office365.com:587
[email protected]
AuthPass=Welcome@1
UseTLS=YES
UseSTARTTLS=YES

# Where will the mail seem to come from?
rewriteDomain=domain.org

# The full hostname
hostname=VMDevTG.domain.com.mx

# Are users allowed to set their own From: address?
# YES - Allow the user to specify their own From: address
# NO - Use the system generated From: address
FromLineOverride=YES

When I run :

ssmtp [email protected]

and add the email

To:[email protected]
From:[email protected]
Subject:This is an sSMTP from LINUX!
I am testing sSMTP.

I get the following error:

ssmtp: 554 5.2.0 STOREDRV.Submission.Exception:SendAsDeniedException.MapiExceptionSendAsDenied; Failed to process message due to a permanent exception with message Cannot submit message. 0.35250:0A00AC80, 1.36674:0A000000, 1.61250:00000000, 1.45378:02000000, 1.44866:BC1C0000, 1.36674:0E000000, 1.61250:00000000, 1.45378:C11C0000, 1.44866:E6010000, 16.55847:490E0000, 17.43559:0000000004020000000000000100000000000000, 20.52176:140F6D880000101043050000, 20.50032:140F6D887017000000000000, 0.35180:48050000, 255.23226:0A00B180, 255.27962:0A000000, 255.27962:0E000000, 255.31418:0A00B280, 0.35250:0A000000, 1.36674:32000000, 1.61250:00000000, 1.45378:02000000, 1.44866:01000000, 16.55847:69000000, 17.43559:00000000E8020000000000000800000000000000, 20.52176:140F6D880000101061050000, 20.50032:140F6D887017000003000136, 0.35180:66050000, 255.23226:0A00B780, 255.27962:32000000, 255.17082:DC040000, 0.27745:0A00B880, 4.21921:DC040000, 255.27962:FA000000, 255.1494:0A00B980, 0.38698:0F010480, 0.37692:02000000, 0.37948:0F010480, 5.33852:00000000534D545000324300, 7.36354:010000000000010932324238, 4.56248:DC040000, 7.40748:010000000000010B36343638, 7.57132:000000000000000000000000, 1.63016:32000000, 4.39640:DC040000, 8.45434:ABB7F36F91A190499DCB54E2757EC97A00000000, 5.10786:0000000031352E32302E323135372E3030303A4D57485052323230314D42313432323A33636362643762342D643664342D343939352D623731302D6638633438356465626537380000000000, 255.1750:03000236, 255.31418:A2050000, 0.22753:0A00C280, 255.21817:DC040000, 4.60547:DC040000, 0.21966:0A00C380, 4.30158:DC040000 [Hostname=MWHPR2201MB1422.namprd22.prod.outlook.com]

I'm trying to configure 2 domains (A and B) in the same server with different certificates. The domain A works fine, it has it's own certificates and rules to redirect to it. If I try to access to domain B it displays the following message:

This server could not prove that it is subdomainB.DomainB.com.mx; its security certificate is from subdomainA.domainA.org. This may be caused by a misconfiguration or an attacker intercepting your connection.

Now if I add domain B it does exactly the same but in reverse.

This server could not prove that it is subdomainA.DomainA.com.mx; its security certificate is from subdomainB.domainB.org. This may be caused by a misconfiguration or an attacker intercepting your connection.

Also I lost the redirects to SubdomainA.domainA.org and it access to php page version, not the site itself.

Hope someone can help me. my config:

<VirtualHost *:443>
ServerAdmin webmaster@localhost
ServerName subdomainB.domainB.com.mx
DocumentRoot /var/www/html/

SSLEngine on
SSLCertificateFile /etc/apache2/sslB/certificate.crt
SSLCertificateKeyFile /etc/apache2/sslB/private.key
SSLCertificateChainFile /etc/apache2/sslB/intermediate.crt

SSLProtocol all -SSLv2 -SSLv3 -TLSv1

</VirtualHost>

<VirtualHost *:443>
ServerAdmin webmaster@localhost
ServerName subdomainA.domainA.com.mx
DocumentRoot /var/www/html/

SSLEngine on
SSLCertificateFile /etc/apache2/sslA/certificate.crt
SSLCertificateKeyFile /etc/apache2/sslA/private.key
SSLCertificateChainFile /etc/apache2/sslA/intermediate.crt

SSLProtocol all -SSLv2 -SSLv3 -TLSv1

</VirtualHost>