Mail server's - GameCreators Forum

Author

Message

AlexI

19

Years of Service

User Offline

Joined: 31st Dec 2004

Location: UK

Posted: 20th Nov 2006 19:43 Edited at: 20th Nov 2006 19:53

Link

Hi,
How can i make a mail sever on linux? I know on windows there's some good freeware called mercury mail, but im making a linux server so...

I am currently using Suse Linux 10.2

Any ideas?
Thanks,
Alex

Back to top

Profile PM

Nicholas Thompson

20

Years of Service

User Offline

Joined: 6th Sep 2004

Location: Bognor Regis, UK

Posted: 20th Nov 2006 20:15

Link

Most server's come with Sendmail by default, but the other is Postfix. Google one of those two and you'll find an infinite number of tutorials on the subject.

WARNING: INCORRECTLY SETUP MAIL SERVER'S CAN ALLOW EXTERNAL PEOPLE TO RELAY MAIL THROUGH YOU AND GET YOU INTO SERIOUS TROUBLE. I WILL NOT TELL YOU HOW TO FIX THIS AS I DONT KNOW - I'M JUST WARNING YOU!!!

[center]

Back to top

Profile PM Email Website

AlexI

19

Years of Service

User Offline

Joined: 31st Dec 2004

Location: UK

Posted: 20th Nov 2006 20:31

Link

thanks

Is there any SQL epxerts here?

why wont this SQL code execute

+ Code Snippet

CREATE USER 'user'@ 'localhost' IDENTIFIED BY 'pass';

GRANT SELECT , 
INSERT ,

UPDATE ,
DELETE ,
CREATE ,
DROP ,
FILE ,
INDEX ,
ALTER ,
CREATE TEMPORARY TABLES ,
CREATE VIEW ,
SHOW VIEW ,
CREATE ROUTINE,
ALTER ROUTINE,
EXECUTE ON * . * TO 'user' @ 'localhost' IDENTIFIED BY 'pass' WITH MAX_QUERIES_PER_HOUR 0 MAX_CONNECTIONS_PER_HOUR 0 MAX_UPDATES_PER_HOUR 0 MAX_USER_CONNECTIONS 0 ;

Thanks,
Alex

Back to top

Profile PM

adr

21

Years of Service

User Offline

Joined: 21st May 2003

Location: Job Centre

Posted: 20th Nov 2006 23:54 Edited at: 20th Nov 2006 23:56

Link

I assume you're using MySQL....

"CREATE USER" is a priviledge, not a command. Just try

+ Code Snippet

GRANT ALL ON *.* TO 'user'@'localhost' IDENTIFIED BY 'pass'

and take it from there.

I can't say that I recommend Postfix - although it's easier than sendmail, I don't think it's as plug and play as you'd like. I've heard good things about qmail.

EDIT : I await a thread titled "What's an open relay?"

I'm superfly TNT

Back to top

Profile PM Website

AlexI

19

Years of Service

User Offline

Joined: 31st Dec 2004

Location: UK

Posted: 21st Nov 2006 08:33 Edited at: 21st Nov 2006 08:35

Link

Ok, i have got this SQL code to work

by changing it around abit

+ Code Snippet

CREATE USER 'user' IDENTIFIED BY 'pass';
GRANT SELECT , 
INSERT ,

UPDATE ,
DELETE ,
CREATE ,
DROP ,
FILE ,
INDEX ,
ALTER ,
CREATE TEMPORARY TABLES ,
CREATE VIEW ,
SHOW VIEW ,
CREATE ROUTINE,
ALTER ROUTINE,
EXECUTE ON * . * TO 'user'  IDENTIFIED BY 'pass' WITH MAX_QUERIES_PER_HOUR 0 MAX_CONNECTIONS_PER_HOUR 0 MAX_UPDATES_PER_HOUR 0 MAX_USER_CONNECTIONS 0 ;

CREATE DATABASE `user` ;

At the moment it creates a user called user and with password pass it also creates a databse called user

How can i make it so thta "user" can only access the "user" database?
Thanks,
Alex

Back to top

Profile PM

Nicholas Thompson

20

Years of Service

User Offline

Joined: 6th Sep 2004

Location: Bognor Regis, UK

Posted: 21st Nov 2006 09:24

Link

+ Code Snippet

GRANT ALL ON databasename.* TO 'user'@'localhost' IDENTIFIED BY 'pass'

or google...

[center]

Back to top

Profile PM Email Website

Sorry your browser is not supported!

Geek Culture / Mail server's