Re: port 3306 help

2003-02-10 Thread Sean Burlington

Ulas B. Baloglu wrote:
Thanks, I stopped the firewall but couldn't find the following 
file /etc/mysql/my.cnf 
my installation folder is /usr/local/mysql but there is no my.cnf there 
also. I used mysql-max-3.23.54a-unknown-linux-sparc.tar.gz for 
installation. 


you might have been better of installing it with the package manager

the my.cnf file is either in a location specified by you or in the 
default location (should be in the install docs)


try the command `locate my.cnf` to find it

I am trying remote for converting old access db to mysql, if you know 
alternate way doing it under linux it will also work for me, 
thanks for the help


well you haven't told us how you are doing the conversion


by the way i am a programmer not a linux admin, guru etc. so forgive me 
if I am writing stupid things, busying the list,

anyway thanks for the help,
ulash
-Original Message-
From: Mathieu Laurent <[EMAIL PROTECTED]>


Which firewall do you use?  iptables, ipchains on your debian? or a 
firewall box with checkpoint, ...


You must also give the privileges to the user of the DB to reach them
in 
remote:

- comment the line skip-networking in /etc/mysql/my.cnf
- update table user, db in db mysql.

Ulas B. Baloglu wrote:



I tried to remote mysql db, but I guess port 3306 is blocked
can anyone send me a method to change firewall settings and unblock


it, 






Re: port 3306 help

2003-02-10 Thread Sean Burlington

Ulas B. Baloglu wrote:

I tried to remote mysql db, but I guess port 3306 is blocked
can anyone send me a method to change firewall settings and unblock it, 
or to stop firewall temporarily.

Thanks,
ulash





mysql isn't network enabled by default

if you want to connect remotely you first have to comment out the 
follwing from /etc/mysql/my.cnf


# The skip-networkin option will no longer be set via debconf menu.
# You have to manually change it if you want networking i.e. the server
# listening on port 3306. The default is "disable" - for security #reasons.
skip-networking

--

Sean



Re: [personal] securing pop3

2003-02-10 Thread Sean Burlington

you don't have to switch smtp servers to do this

the following link describes a method of setting up virtual domain for 
exim/imap


http://www.tty1.net/virtual_domains_de.html

I am fairly sure courier-pop uses the same authentication system

SEan

Gary MacDougall wrote:
Not sure if you care, but qmail has vpopmail, which is a non-passwd file 
based authentation method.
I've been using qmail now for about 3 years solid, and I have to say its 
probably the most secure,

fast and reliable e-mail server out there.
Combine qmail with vpopmail and qmailadmin and you've got a very 
flexible, fast and

secure mail server with good tools for you and your users...

vpopmail allows your to create virtual domains and users without having 
to account them on your

linux box...

g.

Kristof Goossens wrote:


Hello all,

I need to make a pop3 account on my server. I intend to work with 
ipop3d to

provide secure pop3 service. Now I want to provide this service for only
few people, and I don't want them to have an account on the system. 
Well, they

can have a pop3 account, but no other access whatsoever...

I don 't like the idea of giving them an account and setting their 
shell to
/bin/false. So my question is: "Is it possible to create a pop3 
account without

needing to modify the /etc/passwd file?"

thanks in advance,
Kristof
 









Re: port 3306 help

2003-02-10 Thread Sean Burlington
Ulas B. Baloglu wrote:

Thanks, I stopped the firewall but couldn't find the following 
file /etc/mysql/my.cnf 
my installation folder is /usr/local/mysql but there is no my.cnf there 
also. I used mysql-max-3.23.54a-unknown-linux-sparc.tar.gz for 
installation. 

you might have been better of installing it with the package manager

the my.cnf file is either in a location specified by you or in the 
default location (should be in the install docs)

try the command `locate my.cnf` to find it

I am trying remote for converting old access db to mysql, if you know 
alternate way doing it under linux it will also work for me, 
thanks for the help

well you haven't told us how you are doing the conversion



by the way i am a programmer not a linux admin, guru etc. so forgive me 
if I am writing stupid things, busying the list,
anyway thanks for the help,
ulash
-Original Message-
From: Mathieu Laurent <[EMAIL PROTECTED]>


Which firewall do you use?  iptables, ipchains on your debian? or a 
firewall box with checkpoint, ...

You must also give the privileges to the user of the DB to reach them
in 
remote:
- comment the line skip-networking in /etc/mysql/my.cnf
- update table user, db in db mysql.

Ulas B. Baloglu wrote:


I tried to remote mysql db, but I guess port 3306 is blocked
can anyone send me a method to change firewall settings and unblock


it, 




--
To UNSUBSCRIBE, email to [EMAIL PROTECTED]
with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]




Re: port 3306 help

2003-02-10 Thread Sean Burlington
Ulas B. Baloglu wrote:

I tried to remote mysql db, but I guess port 3306 is blocked
can anyone send me a method to change firewall settings and unblock it, 
or to stop firewall temporarily.
Thanks,
ulash




mysql isn't network enabled by default

if you want to connect remotely you first have to comment out the 
follwing from /etc/mysql/my.cnf

# The skip-networkin option will no longer be set via debconf menu.
# You have to manually change it if you want networking i.e. the server
# listening on port 3306. The default is "disable" - for security #reasons.
skip-networking

--

Sean


--
To UNSUBSCRIBE, email to [EMAIL PROTECTED]
with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]



Re: [personal] securing pop3

2003-02-10 Thread Sean Burlington
you don't have to switch smtp servers to do this

the following link describes a method of setting up virtual domain for 
exim/imap

http://www.tty1.net/virtual_domains_de.html

I am fairly sure courier-pop uses the same authentication system

SEan

Gary MacDougall wrote:
Not sure if you care, but qmail has vpopmail, which is a non-passwd file 
based authentation method.
I've been using qmail now for about 3 years solid, and I have to say its 
probably the most secure,
fast and reliable e-mail server out there.
Combine qmail with vpopmail and qmailadmin and you've got a very 
flexible, fast and
secure mail server with good tools for you and your users...

vpopmail allows your to create virtual domains and users without having 
to account them on your
linux box...

g.

Kristof Goossens wrote:

Hello all,

I need to make a pop3 account on my server. I intend to work with 
ipop3d to
provide secure pop3 service. Now I want to provide this service for only
few people, and I don't want them to have an account on the system. 
Well, they
can have a pop3 account, but no other access whatsoever...

I don 't like the idea of giving them an account and setting their 
shell to
/bin/false. So my question is: "Is it possible to create a pop3 
account without
needing to modify the /etc/passwd file?"

thanks in advance,
Kristof
 







--
To UNSUBSCRIBE, email to [EMAIL PROTECTED]
with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]