Mysql connection



  • 1. Where do I set passwd for SMTP AUTH?
    I have sendmail-8.12.10 compiled from source on RH7.2 with cyrus-sasl-1.5.24. I have been trying to set up SMTP AUTH (like everyone else in this group). The EHLO shows AUTH and various methods. The problem is that when trying it from various mail clients, I always get authorization denied. I have tried /usr/lib/sasl/Sendmail.conf with pwcheck_method:saslauthd and run the saslauthd with -a shadow, and also tried with -a pam. Using the unix passwd for the login name doesn't work with these. How do you turn on logging for saslauthd? I have tried pwcheck_method:sasldb - and I notice that /etc/sasldb gets accessed every time I try the passwd from a mail client. I set the passwd with saslpasswd, and /etc/sasldb gets updated (and accessed when I try again), but the passwd I set with saslpasswd does not work. Is sendmail using a special application or realm? I tried setting the application to "sendmail" and also "Sendmail" - no dice. I have no idea what the realm would be. There is no logging that I can find of what username, realm, application, etc is being tried :-( Very frustrated - it is reading the sasldb - but I don't know how to set the passwd. -- Stuart D. Gathman < XXXX@XXXXX.COM > Business Management Systems Inc. Phone: 703 591-0911 Fax: 703 591-6154 "Confutatis maledictis, flamis acribus addictis" - background song for a Microsoft sponsored "Where do you want to go from here?" commercial.
  • 2. list and its one way usage only
    Hi, There is a need sometimes to have a huge list of addresses for temporary use (for example a conference preliminary). Such a list can be defined with using an include statement in the aliases file. It's OK so far but I don't know how to accomplish so that this correspondig address will be usable from our site only. It should be certain that any reply (with its largely private questions) is never sent to the list. Thanks in advance for any hint.
  • 3. How to restrict incoming email from to
    Taylor, Grant ( XXXX@XXXXX.COM ) wrote in comp.mail.sendmail: > Jeff Rife wrote: > > What kind of analysis have you done to show this is the case? > I can't say as I have done any formal analysis of this. I can just > say from the amount of spam that gets through when I do not have > this particular filter running that does not get through when the > filter is running. I think this just indicates that you don't have the right "other" forms of filtering in use. ;-> For me, the #1 stopper is greylisting, although that does have some issues with poorly configured but still legitimate servers. A few whitelisted entries solves those problems. After that, syntactical validation of the "HELO" is the next best stopper. I don't check the "HELO" text against DNS or anything like that...I just look to see if it is RFC-compliant. This will obviously cause problems with MTAs that are really lame, but *all* the "real" ones (sendmail, postfix, etc.) provide an RFC-compliant HELO out of the box, and most have no way other than source code editing to change that. The important thing my logs showed was that *every* time sender validation failed, one of the two above methods also stopped that e-mail. -- Jeff Rife | "Grab a shovel...I'm only one skull | short of a Mouseketeer reunion." | | -- Bender, "Futurama"

Mysql connection

Postby Thibaut Maquet » Mon, 14 Feb 2005 19:04:16 GMT


how to disable the Mysql connection attempt ?
I keep on getting the following message:
Connection to MySQL server failed(Unknown MySQL Server Host 'host')

Cheers !

Thibaut Maquet

Re: Mysql connection

Postby Alexander Dalloz » Tue, 15 Feb 2005 02:09:19 GMT


I which way does it have to do with Sendmail?


Alexander Dalloz | Enger, Germany | new address - new key: 0xB366A773
legal statement:  http://www.**--****.com/ 
Fedora GNU/Linux Core 2 (Tettnang) on Athlon kernel 2.6.10-1.9_FC2smp
Serendipity 18:08:48 up 16 days, 19:39, load average: 0.95, 0.73, 0.58 

Re: Mysql connection

Postby Thibaut Maquet » Mon, 21 Feb 2005 18:26:40 GMT

> I which way does it have to do with Sendmail?

The answer is in my log header :
Feb 20 10:23:22 home sendmail[7690]: starting daemon (8.12.11/SQL-8.12.11-7): SMTP+queueing@00:15:00

Cheers !
 Thibaut Maquet

Similar Threads:

1.ERROR CLOSING CONNECTION: mysql connection close

I am getting following connection error from my python script:

AttributeError: adodb_mysql instance has no attribute 'close'

Here is my relevant code below:

def worker(tq):
    while True:
        host, e = tq.get()

        c = ftplib.FTP(host)
            p = os.path.basename(e)
            download_dir = r'H:/ftp_download/'
            ps_dir = r'H:/ftp_download/'
            filename = download_dir+p
            fp = open(filename, 'wb')
            try: c.retrbinary('RETR %s' % e, fp.write)
            finally: fp.close()
        finally: c.close()
        if (p.lower().endswith('.ps') ):
            partFileName = p.split('.', 1)
            movedFile = download_dir + p
            #movedFile = p
            finalFile = ps_dir + partFileName[0]+'.pdf'
            encode_cmd = r'ps2pdf '+ movedFile + ' '+ finalFile

        conn = adodb.NewADOConnection('mysql')
        conn.Connect('localhost', 'temp', 'temp', 'temp')

        sql = r"update video set pdf_file_path='" +finalFile+r"' where

        cursor = conn.Execute(sql)
        rows = cursor.Affected_Rows()

        cursor = conn.Execute(sql)
        rows = cursor.Affected_Rows()

2.VO2Ado & MySql connection - a working connection string

Just in case someone is trying to connect with VO through the net using
Vo2Ado without  DSN:

cConn := 'DRIVER={MySQL ODBC 3.51

the above seems to work well   ( I had problems using a DSN )

Jus thought it may help some,



3.mySQL connection problem

Hey guys,

I'm using the following code to connect to my remote mysql database. Of
course I changed the server, database name, login/pass info, for my
posting on the web...

//Connect to my database
string connectString="DRIVER={MySQL ODBC 3.51
			OdbcConnection connection = new OdbcConnection(connectString);

if (connection.State == ConnectionState.Open)
   OdbcCommand sqlCommand = new System.Data.Odbc.OdbcCommand("SELECT *
  FROM October",connection);

  OdbcDataReader dataReader = sqlCommand.ExecuteReader();


Anyway, it never gets into my if statement. Using a debugger I can see
that my connection state is closed. I installed the ODBC driver and
added my database connection (which it succesfully connects to) to the
"Data Sources (ODBC)" component of the administrative tools.

What's the problem?

4.HELP!!! MySQL Connection

5.Problem with MySQL connection

I'm trying to get a CreateUserWizard asp component to connect to a MySql
Server. I've installed the latest Mysql connector.

THep roblem is taht even after modifying web, config to connect to the
MySQL server, the ASP.Net application send MS-SQL requests on port 3610
t03618 instead of a MySQL request to port 3306 (but it sends it to the
right IP address).

<asp:CreateUserWizard ID="CreateUserWizard1"
MembershipProvider="userProvider" runat="server">

      <add name="MySQL Data Provider" invariant="MySql.Data.MySqlClient"
description=".Net Framework Data Provider for MySQL"
MySql.Data,Version=, Culture=neutral,

		<add name="MySqlServer"

		<membership defaultProvider="userProvider">
				<add name="userProvider"
connectionStringName="MySqlServer" enablePasswordReset="true"
passwordFormat="Hashed" requiresUniqueEmail="true"
minRequiredNonalphanumericCharacters="0" minRequiredPasswordLength="6"
passwordStrengthRegularExpression="" description="Looser requirements to
create users."/>
		<roleManager enabled="true"/>
		<authentication mode="Forms"/>
		<compilation debug="true">
				<add assembly="MySql.Data, Version=, Culture=neutral,

I've tried to add the Driver and Port attributes to connectionString,but
the compilations fails on them.

Any idea what I did wrong?

Thank you

6. HELP!!! MySQL Connection

7. MySQL connection problem

8. MySQL connection

Return to mail


Who is online

Users browsing this forum: No registered users and 51 guest