Server :: Postfix Standalone To Mysql Upgrade?
Feb 16, 2011
I did a basic U9.10 server install of postfix with the minimal config. Added a test user and things worked after a few minutes. I now want to setup a few new things and want to switch to use mysql as the back-end. I have mysql installed, setup postfix.admin which in turn setup the database/tables. Now when I logged in to that admin, the original test user is not there (which is fine), but I created the test domain again, created a user and an outside test failed saying user unknown.
Now I looked through the main.cf page and don't see anything obvious to say hey, put backend is mysql, here is the info. I then noticed via apt that postfix-mysql was not installed, so installed that, I see my .cf was backed up, but still don't see anywhere to connect the 2. So currently mail is still accepted from the test1 user running local. I don't mind wiping everyhing, but is there a simple place to just make a change or 2?
View 1 Replies
ADVERTISEMENT
Jul 1, 2010
venturing into unfamiliar territory so I'm hoping someone can help me and make things a little more understandable for me. I have setup Postfix on a standalone server connected directly to the internet. I have got inbound and outbound email working for the most part, but I am worried about security.My fear is that if I leave port 25 open to the outside world spammers will find this and start relaying mail through it and eventually blacklisting the IP attached to this box.
For now, I am hosting mail for a single domain and single user (me) with a few aliases. I plan on expanding to IMAP and SMTP access from the outside at some point, but for now I've been using Mutt in a shell and it's fine for my needs for now.
Here are my current Postfix settings:
alias_database = hash:/etc/aliases
alias_maps = hash:/etc/aliases
[code]....
View 3 Replies
View Related
Feb 16, 2010
have want to create a mail server with postfix and mysql. When i try to send mail with telnet i receive a error message :
Code:
telnet serveur2 25
Trying 127.0.0.1...
Connected to localhost.localdomain (127.0.0.1).
[code]....
View 2 Replies
View Related
Jul 6, 2011
I tried to install the package from centosplus repo but got the error cannot find libmysqlclient.so.15.Not surprising as I have libmysqlclient.so.18. If not does anyone know how I can build postfix with support for MySQL 5.5. It doesn't help that I have never built a binary before - I found a couple of good tutorials on how to build from source that seem straight forward enough but I have no idea what needs to be specified for the postfix build.
running CentOS 5.6
MySQL5.5 (Remi)
PHP 5.3.6 (Remi)
View 1 Replies
View Related
May 9, 2010
I was following the above guide to get a mail server up and running. The major difference in it all is the fact that my server is running i686, but I compensated for that easily, just a difference in folder/RPM names. [URL]. Otherwise I followed it to a "T." Everything seemed to go smoothly, no trips or falls until the very end.
After installing squirrelmail and trying to login on admin@withfrosted.com returns ERROR:
Connection dropped by IMAP server.
Uncle google tells me to run this command because SELinux is overzealous:
setsebool -P httpd_can_network_connect=1
And that works, and I thought I was home free. However, after that, I'm presented with a new error. However, google told me to send an email to create the mailbox because it wasn't there, yet. So I send a test email on over, but that fails, and so does mailx. Next I created /home/vmail/withfrosted.com/admin while logged into the vmail user for proper permissions. Squirrelmail now logs into the mail box but gives me yet another new error, in which I am now stuck on:
ERROR:
ERROR: Could not complete request.
Query: SELECT "INBOX"
Reason Given: Unable to open this mailbox.
As a summary, because I'm all over the place, here:
1. Can't view the mailbox via Squirrelmail.
2. Can't receive email, tried with mailx and a test email from gmail.
Regarding #2, the gmail test email, from the maillog:
May 9 07:25:45 withfrosted postfix/smtpd[21095]: connect from mail-qy0-f177.google.com[209.85.221.177]
May 9 07:25:45 withfrosted postfix/smtpd[21095]: 26CE516241D: client=mail-qy0-f177.google.com[209.85.221.177]
May 9 07:25:45 withfrosted postfix/cleanup[21104]: 26CE516241D: message-id=<z2pe336661a1005090425zaee8dc71jc3002cb7cb25e0fa@mail.gmail.com>
May 9 07:25:45 withfrosted postfix/qmgr[19083]: 26CE516241D: from=<issact@gmail.com>, size=1866, nrcpt=1 (queue active)
May 9 07:25:45 withfrosted amavis[21024]: (21024-01) (!)connect_to_sql: unable to connect to DSN 'DBI:mysql:database=mail;host=127.0.0.1;port=3306': Can't connect to MySQL server on '127.0.0.1' (13)
May 9 07:25:45 withfrosted amavis[21024]: (21024-01) (!!)TROUBLE in process_request: connect_to_sql: unable to connect to any dataset at (eval 98) line 241, <GEN15> line 5.
May 9 07:25:45 withfrosted amavis[21024]: (21024-01) (!)Requesting process rundown after fatal error
May 9 07:25:45 withfrosted postfix/smtp[21105]: 26CE516241D: to=<admin@withfrosted.com>, relay=127.0.0.1[127.0.0.1]:10024, delay=0.2, delays=0.11/0.01/0.01/0.07, dsn=4.3.2, status=deferred (host 127.0.0.1[127.0.0.1] said: 421 4.3.2 Service shutting down, closing channel (in reply to RCPT TO command))
May 9 07:26:15 withfrosted postfix/smtpd[21095]: disconnect from mail-qy0-f177.google.com[209.85.221.177]
View 4 Replies
View Related
May 10, 2011
Pam-mysql can not connect to the database and below are my configurations.
saslfinger -s Output:
root@mailbackup:/# saslfinger -s
saslfinger - postfix Cyrus sasl configuration Tue May 10 10:12:10 EAT 2011
version: 1.0.2
mode: server-side SMTP AUTH
-- basics --
Postfix: 2.7.2
System: Slackware 13.1.0
-- smtpd is linked to --libsasl2.so.2 => /usr/local/lib/libsasl2.so.2 (0x00007f74ebfb7000)
-- active SMTP AUTH and TLS parameters for smtpd --
-- listing of /usr/lib64/sasl2 --
-- listing of /usr/local/lib/sasl2 --
-- content of /usr/lib64/sasl2/smtpd.conf --
-- content of /usr/local/lib/sasl2/smtpd.conf --
-- active services in /etc/postfix/master.cf --
-- mechanisms on localhost --
View 3 Replies
View Related
Jul 24, 2010
I have mysql server 5.0 installed via binary package on RHEL 5 where I have big databases running on it.
I want to upgrade mysql server to 5.1 without backup/restore of DBs. what is the best way to do this?
I tried yum update mysql-server but RH repo doesnt provide mysql 5.1 yet. and I tried to download mysql-server 5.1 binary packages from mysql.com but I got errors when I did rpm -Uvh mysql-5.1.
View 9 Replies
View Related
May 4, 2010
I tried upgrading mySQL and PHP using up2date and what did it do? Downgraded me from mySQL 4.0.26-standard to 3.23.58 and did nothing with PHP.
[Code]....
View 2 Replies
View Related
Oct 14, 2010
I've got a working Virtual Postfix server running with mysql doing user authentication. I have a support email address set as support@hostname.com, which has 5 aliases associated; user1, user2, user3, user4, and user5. When an email is sent to support@hostname.com, all 5 users receive the email, just as planned. What I'm looking to do is when an email is sent to support@hostname.com to have it rotate through the members of the alias group. That way all members of the group get support emails evenly and not everybody all at once. Is this possible?
View 4 Replies
View Related
Dec 11, 2009
I have to upgrade MySQL 5.0.77-3 to 5.1 for a webaplication.
If I write in Putty "# yam update" , it wont found a newer version of MySQL. how can I update my MySQL Version?
View 3 Replies
View Related
Jun 7, 2011
I think this goes here, but I'm not sure. I decided that XAMPP had been troublesome enough. MySQL never worked. So I decided to instal the LAMP stack offered by YaST. I went about installing it thinking that it would all work. But it seems that I was wrong. So I try to start mysql, and here's what I get:
Code:
the-matrix:~ # mysql start
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/mysql/mysql.sock' (2) or
Code:
the-matrix:~ # rcmysql start
Starting service MySQL warning: /var/mysql/mysql.sock didn't appear within 30 seconds
chmod: cannot access `/var/run/mysql/mysqld.pid': No such file or directory
[Code]...
View 6 Replies
View Related
Jun 2, 2010
i am using liferay5.2(mysql included in the download pack) on fedora. while liferay is working fine but i cannot connect to mysql.i am getting the error
[
[root@localhost ~]# ln -s /var/lib/mysql/mysql.sock /tmp
[root@localhost ~]# /etc/init.d/mysqld start
Timeout error occurred trying to start MySQL Daemon.
[code]....
i didnt find the mysql.sock file in the location /var/lib/mysql/mysql.sock. i cannot find the portal-ext.properties file also to make intial settings.
View 9 Replies
View Related
May 2, 2010
When this happens you have to open a terminal, get the process id for mysql-server-5 then kill that process. Like this:
Code:
ps -A
then from the list of processes that it spits out look at the process id (the number at the beginning of the line) for mysql-server-5.
Now type
Code:
sudo kill -9 XXXXX
where XXXXX is the process id for mysql-server, and enter your password. The upgrade process should now resume.
View 1 Replies
View Related
Aug 11, 2010
Been trying to upgrade home server for several days and it keeps hanging on the mysql upgrade. Here's the what apt-get says code....
View 3 Replies
View Related
Jun 2, 2010
A week or so ago I ran an aptitude safe-upgrade and while it was updating mysql I suffered a power-failure. Now, this never really happens in Holland but of course this once it happened at the worst possible time.
I've tried a lot of different things to get mysql working again, but am running into all kinds of problems. First mysql won't shut off properly (it does startup with the computer but I can't connect to it at all) during an aptitude purge. If I kill the process mysql seems to purge properly, but I guess this is not the case because I wasn't able to install it then.
Things seem to have gone a bit more smoothly this time, however:
Code:
snek@snek-server:~$ sudo aptitude install mysql-server
Reading package lists... Done
Building dependency tree
Reading state information... Done
[Code].....
View 2 Replies
View Related
Sep 25, 2010
is there any HOWTO for configuring Webmin Postfix server with multiple postfix virtual hosts? Seems to be a tough challenge to set it up without any easy manual..
View 1 Replies
View Related
Oct 4, 2010
so i set out to change the default smtp port the server uses because my ISP blocks port 25 and i need the email to work in outlook. this morning i could receive email, but not send it. so i did some research and thought that i needed to edit the master.cf file in /etc/postfix/ by commenting out this line: smtp inet n - n - - smtpd -oand replace it with587 inet n - n - - smtpd (587 being the port i want to use)somewhere along the lines postfix server stopped running and now i cannot get it to start.if i try using SSH it crashes immediately and if i restart it in simple control panel nothing happens
View 7 Replies
View Related
Feb 25, 2011
I recently moved over user from an old box running postfix(v 2.0.16) over to rhel 6 running postfix (v mail_version = 2.6.6). ive tried to make sure all the files are of correct permissions and that the main.cf file is configured corectly. However there is something wrong as when i run postfix: service postfix server i get no error but when checking the status:service postfix status i get: master dead but pid file exists Looking into /var/log/mailog i find this line being the issue:
Feb 25 16:24:39 puny1 postfix/master[3517]: fatal: fifo_listen: create fifo public/pickup: Permission denied
I gather this is a file permission issue and ive tried to make sure the public folder in /var/spool/postfix is correctly set but still no avail.
View 2 Replies
View Related
Mar 30, 2010
i want to remove the raid 1 arrays on our server centos and use standalone drive
View 3 Replies
View Related
Jun 3, 2010
I've installed MySQL using yum on CentOS 5. I'd like to upgrade mysql-5.0.77-4.el5_4.2 to MySQL Community Server 5.1.47. What is the best way to upgrade?
View 2 Replies
View Related
Dec 7, 2010
I'm looking for a purely standalone TFTP server that does not make use of inetd, can be run by non-root users (at non-root port numbers, of course), and if run as root, can do chroot and switch to a non-root user to shed root privileges.
View 3 Replies
View Related
Nov 26, 2010
I want to install SSMTP to (hopefully!) simplify sending MDADM notifications via Gmail. On issuing the command...
Code:
sudo apt-get install ssmtp
I'm informed that...
Code:
The following packages will be removed:
postfix
The following NEW packages will be installed:
ssmtp
However, I believe that MySQL (which I need for my Squeezebox) depends on Postfix. So can I install SSMTP without removing Postfix? Will removing Postfix actually break MySQL? BTW, this is on Ubuntu Server 10.10 64 bit
View 4 Replies
View Related
Jan 3, 2010
Slackware 13 64 - full installation
Postfix from slackbuilds dot org
Dovecot from same
has anyone recompiled Postfix using the Slackbuild script, modifying the script to include support for Cyrus-SASL, OpenLDAP, and MySQL in the build, while retaining Dovecot SASL and TLS? If so I would appreciate it if they could post the CCARGS and AUXLIBS commands. I am having some difficulty getting this working.
View 3 Replies
View Related
Jul 26, 2010
For 3 days now I've been trying to setup a CentOS box with Apache, PHP, MySQL and iRedMail (Postfix/Dovecot) Everything is great apart from Apache, which is returning 403 errors: "You don't have permission to access / on this server.". The apache error_log file says: "[Mon Jul 26 14:02:32 2010] [error] [client x.x.x.x] (13)Permission denied: access to / denied" (I've blanked out my IP). I have no idea what's happening here. Apache works fine until I add my VirtualHost which is:
<VirtualHost mydomainname.com>
DocumentRoot "/home/myuser/public_html"
<Directory "/home/myuser/public_html">
allow from all
Options +Indexes
RewriteEngine On
[Code]...
View 5 Replies
View Related
Mar 11, 2010
Here is what i do: make clean make makefiles CCARGS='-DEF_CONFIG_DIR="/opt/product/postfix-2.6.5/etc"
-DEF_COMMAND_DIR="/opt/product/postfix-2.6.5"
-DEF_DAEMON_DIR="/opt/product/postfix-2.6.5/libexec"
-DEF_MAILQ_PATH="/opt/product/postfix-2.6.5/bin/mailq"
-DEF_DATA_DIR="/opt/product/postfix-2.6.5/lib"
-DEF_NEWALIAS_DIR="/opt/product/postfix-2.6.5/bin/newaliases"
[Code]...
make install then i got this error: postfix: fatal: chdir(/usr/libexec/postfix): No such file or directory make: *** [install] Error 1 I don't understand why it's checking the usr/libexec folder for the daemons although I've set the folder to /opt/product/postfix-2.6.5/libexec in the makefile. Here is also the cat of my makedefs.out:
[Code]....
View 1 Replies
View Related
Jun 17, 2010
I have installed Mysql in Ubuntu 9, for the use of roundcube database.After installing iam getting the error like this
* Stopping MySQL database server mysqld [ OK ]
* Starting MySQL database server mysqld [ OK ]
* Checking for corrupt, not cleanly closed and upgrade needing tables.
So because of this in the roundcube configuration its giving the error message that MYSQL is not installed. So Kindly give me a idea how to solve this.
View 1 Replies
View Related
Aug 25, 2010
I'm having problems connecting to the mysql database on my system. I first noticed this when I was trying to set up the program anymeal. I subsequently tried using MySQL Administrator (mysql-admin), but had no luck. It gives my the following feedback:
Code:
Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
Click the 'Ping' button to see if there is a networking problem. I press the ping button, and it seems to connect.
Code:
View 4 Replies
View Related
Feb 22, 2011
I've been attempting to set up a LAMP for local web development, which meant installing mysql-server. But now have a problem when trying to run mysql, I get:-
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
When trying to downgrade mysql-server I saw that there are dependency problems between the various modules (but can't recall which). But whichever route I truied the results are always the same.
Thought about trying XAMPP but I note that even has it's problems, is there any way I can get a lamp set up on FC14, or must I give it up as a bad job.
Howver, just been trying to again to fix the problems with downgrading mysql and get:-
Error: Package: mysql-server-5.1.55-1.fc14.i686 (@updates)
Requires: mysql(x86-32) = 5.1.55-1.fc14
Removing: mysql-5.1.55-1.fc14.i686 (@updates)
mysql(x86-32) = 5.1.55-1.fc14
View 7 Replies
View Related
Aug 2, 2010
I'm trying to setup wordpress on my server, which of course I need mysql for. I setup a database the other day, which worked perfectly, but I had to start again as I put some information in wrong. Now, I can create a database fine, but when I run
Code:
GRANT ALL ON wordpress.* TO wordpress@localhost IDENTIFIED BY "password";
I get the output:
[code]...
View 13 Replies
View Related
Jun 4, 2009
I have MySQL 5.1.34 and PHP 5.1.6 installed on my system, how do I install php-mysql? Each time I try, it says
mysql-5.0.45-7.el5.i386 from base has depsolving problems
-- > mysql conflicts with mysql-server-community
error: mysql conflicts with mysql-server-community
View 16 Replies
View Related