I think this is a great opportunity to talk about sanitizing one's data before sending it to the DB.

There is two very easy things one can do if programming in PHP.

1) Addslashes - Returns a string with backslashes before characters that need to be escaped. These characters are single quote ('), double quote ("), backslash (\) and NUL (the NULL byte).

2) htmlentities — Convert all applicable characters to HTML entities - this will convert any semicolons not enclosed in quotes into it's html entity.

http://php.net/manual/en/security.database.sql-injection.php

Little Bobby Tables :  http://php.net/manual/en/images/fa7c5b5f326e3c4a6cc9db19e7edbaf0-xkcd-bobby-tables.png

I do not profess to be an expert in this area.  I spent a lot of time looking into this about 10 years ago and still feel like I need to know more.  I'm always eager to learn more in this area.

Please add your thoughts?

Thanks!!
Keith

On 2016-09-14 01:41, der.hans wrote:

Am 14. Sep, 2016 schwätzte Herminio Hernandez, Jr. so:

Should I be consern even if my SQL server is only listening on localhost?

Depends on what you have using it.

If it's the DB for a web site, then it's possible that SQL injection can
be used to modify your database.

For instance, WordPress has lots of security issues, so it likely can be
exploited to use SQL injection to talk to your DB.

ciao,

der.hans

On Mon, Sep 12, 2016 at 1:29 PM, Joseph Sinclair <plug-discussion@stcaz.net>
wrote:

FYI, minor improvement below to lock down a few edge cases (note, this is
primarily for EXT{2,3,4} and other filesystems that support file
attributes).
You'll also need to remove the attribute manually before updating when
patches become available.

On 09/12/2016 12:33 PM, der.hans wrote:

Am 12. Sep, 2016 schwätzte Herminio Hernandez Jr. so:

moin moin,

Basically they mirror the repos. So when it hits debian I will upgrade.

Ah, OK.

You might also want to create a couple of empty files and lock them down.

$datadir can be exploited, so pre-emptively putting empty conf files in
there that can't be changed by mysql is a good idea.

The following is for anyone with questions on locking down the config
files in $datadir.

Presuming $datadir is /var/lib/mysql either of the following will lock
down the files when run as root, but the first will destroy files you
might already have.

# >/var/lib/mysq/my.cnf
# >/var/lib/mysq/.my.cnf
# chmod 000 /var/lib/mysq/{.,}my.cnf

# chattr +i /var/lib/mysq/{.,}my.cnf

Or, with some minimal verification that it's safe...

# for file in /var/lib/mysq/{.,}my.cnf; do
    if [ ! -e $file ] ; then
       >$file
        chmod 000 $file

          chattr +i $file

        ls -l $file

          lsattr $file

    else
        ls -l $file

          lsattr $file

        echo "You might want to check on that"
    fi
done

ciao,

der.hans

Sent from my iPhone

On Sep 12, 2016, at 12:00 PM, der.hans <PLUGd@LuftHans.com> wrote:

Am 12. Sep, 2016 schwätzte Herminio Hernandez Jr. so:

moin moin,

Thanks have some SQL in DO droplets. Will be looking for this.

Will DigitalOcean automagically apply the patches for you?

I would expect it's in their best interest.

I'm certain DreamHost is already upgraded. GoDaddy is probably rolling

it

out already, but I no longer know anyone on the team over there, so am

not

sure how quick they will be.

This is admittedly one of the advantages of cloud. The infrastructure
providers can centrally test and roll out for everyone. The

disadvantage

is if it's something that affects you, but they don't know or care

about

it :).

ciao,

der.hans

Sent from my iPhone

On Sep 12, 2016, at 11:18 AM, der.hans <PLUGd@LuftHans.com> wrote:

moin moin,

a MySQL remote exploit was announced this morning. Percona and

MariaDB

already have fixes that have not yet hit the distros.

https://www.percona.com/blog/2016/09/12/percona-server-

critical-update-cve-2016-6662

http://legalhackers.com/advisories/MySQL-Exploit-

Remote-Root-Code-Execution-Privesc-CVE-2016-6662.html

Watch for updates.

ciao,

der.hans
--
#  http://www.LuftHans.com/        http://www.PhxLinux.org/
#  Fairy Tale, n.: A horror story to prepare children for the

newspapers.

---------------------------------------------------
PLUG-discuss mailing list - PLUG-discuss@lists.phxlinux.org
To subscribe, unsubscribe, or to change your mail settings:
http://lists.phxlinux.org/mailman/listinfo/plug-discuss

---------------------------------------------------
PLUG-discuss mailing list - PLUG-discuss@lists.phxlinux.org
To subscribe, unsubscribe, or to change your mail settings:
http://lists.phxlinux.org/mailman/listinfo/plug-discuss

--
#  http://www.LuftHans.com/        http://www.PhxLinux.org/
#  "You go to Afghanistan and you swallow enough dust that you'll pass

an

#  adobe brick." -- Robin Williams, 03Aug2006
---------------------------------------------------
PLUG-discuss mailing list - PLUG-discuss@lists.phxlinux.org
To subscribe, unsubscribe, or to change your mail settings:
http://lists.phxlinux.org/mailman/listinfo/plug-discuss

---------------------------------------------------
PLUG-discuss mailing list - PLUG-discuss@lists.phxlinux.org
To subscribe, unsubscribe, or to change your mail settings:
http://lists.phxlinux.org/mailman/listinfo/plug-discuss

---------------------------------------------------
PLUG-discuss mailing list - PLUG-discuss@lists.phxlinux.org
To subscribe, unsubscribe, or to change your mail settings:
http://lists.phxlinux.org/mailman/listinfo/plug-discuss

---------------------------------------------------
PLUG-discuss mailing list - PLUG-discuss@lists.phxlinux.org
To subscribe, unsubscribe, or to change your mail settings:
http://lists.phxlinux.org/mailman/listinfo/plug-discuss

---------------------------------------------------
PLUG-discuss mailing list - PLUG-discuss@lists.phxlinux.org
To subscribe, unsubscribe, or to change your mail settings:
http://lists.phxlinux.org/mailman/listinfo/plug-discuss

--

Keith Smith

---------------------------------------------------
PLUG-discuss mailing list - PLUG-discuss@lists.phxlinux.org
To subscribe, unsubscribe, or to change your mail settings:
http://lists.phxlinux.org/mailman/listinfo/plug-discuss