If you've entered a domain during install the script will send an email
to the address you enter from that postmaster account. The script will
test smtps, submission, and imaps.
Check the dspam password in /etc/dspam.conf
Check if the mysql.sock exists where dspam.conf is looking.
dspam.conf setting should look like this.
# --- MySQL ---
#
# Storage driver settings: Specific to a particular storage driver.
Uncomment
# the configuration specific to your installation, if applicable.
#
MySQLServer /var/lib/mysql/mysql.sock
#MySQLPort
MySQLUser dspam
MySQLPass p4ssw3rd
MySQLDb dspam
MySQLCompress true
MySQLReconnect true
Check and see if the dspam portion of the install script was accomplished
echo -e "\n"
MYSQLPW=$password
credfile=~/sql.cnf
echo -e "[client]\nuser=root\npassword='$MYSQLPW'\nhost=localhost" >
$credfile
.
.
.
echo "Dropping Dspam database if it exists already..."
mysql --defaults-extra-file=$credfile -e "use dspam" &> /dev/null
[ "$?" = "0" ] && mysqldump --defaults-extra-file=$credfile dspam >
dspam.sql \
&& mysql --defaults-extra-file=$credfile -e "drop
database dspam" \
&& echo "dspam db saved to dspam.sql and dropped..."
# Get dspam db structure
wget https://raw.githubusercontent.com/qmtoaster/dspam/master/dspamdb.sql
if [ "$?" != "0" ]; then
echo "Error downloading dspam db: ($?), exiting..."
exit 1
fi
# Create dspam with correct permissions
echo "Creating Dspam database..."
mysqladmin --defaults-extra-file=$credfile reload
mysqladmin --defaults-extra-file=$credfile refresh
mysqladmin --defaults-extra-file=$credfile create dspam
mysqladmin --defaults-extra-file=$credfile reload
mysqladmin --defaults-extra-file=$credfile refresh
echo "Adding dspam users and privileges..."
mysql --defaults-extra-file=$credfile -e "CREATE USER dspam@localhost
IDENTIFIED BY 'p4ssw3rd'"
mysql --defaults-extra-file=$credfile -e "GRANT ALL PRIVILEGES ON
dspam.* TO dspam@localhost"
mysqladmin --defaults-extra-file=$credfile reload
mysqladmin --defaults-extra-file=$credfile refresh
echo "Done with dspam database..."
mysql --defaults-extra-file=$credfile dspam < dspamdb.sql
mysqladmin --defaults-extra-file=$credfile reload
mysqladmin --defaults-extra-file=$credfile refresh
# End DSpam DB install
On 2/19/2024 7:50 AM, Gary Bowling wrote:
Another question.. What is this question for when the script runs? I'm
not sure what it's for or how to answer it.
Enter a valid remote email account to which QMT will send mail via
Submission & SMTPS:
Thanks, gb
On 2/19/2024 9:36 AM, Eric Broch wrote:
Not sure what went wrong...did a search...
Can't connect to local MySQL server through socket
'/var/mysql/mysql.sock' (38) - Stack Overflow
<https://stackoverflow.com/questions/5376427/cant-connect-to-local-mysql-server-through-socket-var-mysql-mysql-sock-38>
On 2/19/2024 6:55 AM, Gary Bowling wrote:
Can't connect to local MySQL server through socket
'/var/lib/mysql/mysql.sock
---------------------------------------------------------------------
To unsubscribe, e-mail: qmailtoaster-list-unsubscr...@qmailtoaster.com
For additional commands, e-mail: qmailtoaster-list-h...@qmailtoaster.com
