Topics

1

General Help & How-To / database install problem

« on: December 11, 2014, 07:09:07 am »

installing on a new server and am running into a problem with the database

on a new install I get this error message:

Creating config database table lm_config - Inserting example config data.
**Error inserting example config data.


and when trying a different way--
uninstalled the database and imported the the tables from my old install
I could see all the data in listmail
but I could not add any lists, users, etc
and was getting an error message:

admin-42-You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ',, from lm_lists where listnum = ''' at line 1




thanks
Franklin

2

General Help & How-To / 1and1 SMTP Question

« on: December 09, 2014, 11:13:27 pm »

decided to make this a new topic


I was thinking about getting a VPS with 1and1 hosting as recomended on the hosting page

but I found this in the forum:
1and1 is blocking smtp connections from the server

-----------------------------
After many emails to 1&1 tech support and my own experience (fsockopen: connection could not be made) it is clear that they are blocking connections from the web server to the SMTP host on both ports 25 and 587.  ListMail does support SMTP authorization - it works with practically -every- other host and used to work on 1&1.  Now, however, it appears 1&1 has a new policy in place to prevent connections to SMTP made from scripts on their web servers.  This can be implemented with a local firewall or other IP-based rule.
----------------------------------------------


is this still true?
so that if I get a vps with 1and1 -- I will not be able to send mail throguh their smtp?


thanks for your input


Franklin

3

General Help & How-To / SMTP with Amazon SES Problem

« on: November 22, 2014, 07:09:46 pm »

I can not get the SMTP Setting with Amazon SES to work

I am getting this error message on the log
[23-Nov-2014 01:39:34 UTC] PHP Warning:  fsockopen(): unable to connect to      email-smtp.us-east-1.amazonaws.com:465 (php_network_getaddresses: getaddrinfo failed: Name or service not known) in /home/shenlong/public_html/connect/editconf.php on line 1894

and this on the test mail settings:
[SMTP Server]
Is enabled?  Yes
Connecting to SMTP server.. Connected!
Verifying username and password... Failed!
The SMTP server is not configured correctly. Check your settings.


I have the
host
port
Auth - login ID and Password

all filled out correctly

and I have tried every port that Amazon has in their help file on connecting to the SMTP server

///////////////////////
STARTTLS

STARTTLS is a means of upgrading an unencrypted connection to an encrypted connection. There are versions of STARTTLS for a variety of protocols; the SMTP version is defined in RFC 3207.

To set up a STARTTLS connection, the SMTP client connects to the Amazon SES SMTP endpoint on port 25, 587, or 2587, issues an EHLO command, and waits for the server to announce that it supports the STARTTLS SMTP extension. The client then issues the STARTTLS command, initiating TLS negotiation. When negotiation is complete, the client issues an EHLO command over the new encrypted connection, and the SMTP session proceeds normally.
TLS Wrapper

TLS Wrapper (also known as SMTPS or the Handshake Protocol) is a means of initiating an encrypted connection without first establishing an unencrypted connection. With TLS Wrapper, the Amazon SES SMTP endpoint does not perform TLS negotiation: it is the client's responsibility to connect to the endpoint using TLS, and to continue using TLS for the entire conversation. TLS Wrapper is an older protocol, but many clients still support it.

To set up a TLS Wrapper connection, the SMTP client connects to the Amazon SES SMTP endpoint on port 465 or 2465. The server presents its certificate, the client issues an EHLO command, and the SMTP session proceeds normally.
///////////////////////



I previously had my listmap pro installation set up to run STMP through a VPS that I had

I no longer have the VPS

and have decided to try Amazon SES

but can't get to work


Here is my SMTP log File that was written

> EHLO localhost

250-email-smtp.amazonaws.com

250-8BITMIME

250-SIZE 10485760

250-STARTTLS

250-AUTH PLAIN LOGIN

250 Ok

LM: AUTH LOGIN Detected

> AUTH LOGIN

530 Must issue a STARTTLS command first


thanks for any help in this matter

Franklin