Re: mysql
On Friday 08 February 2002 23:53, Erol wrote: Hi, I have a mysql server on FreeBsd OS and I want to transfer all the database to Debian Linux. Is it possible and How can I do that ? Thanks, erol Hello Erol, for me the best way to do that is: go in the mysql dbase directory (ex. /var/lib/mysq/your_dbase) and brutally copy recursively, your_dbase dir that contains all your .MYD, .MYI and .frm files, in your newdbasesystem. Also there is al lot of ways and utilities in the mysq.com site on how-to replicate and syncronize database. fabrizio -- Fabrizio Tivano WAN System Administrator SAD Trasporto Locale S.p.a. Corso Italia 13/N 39100 BOLZANO e-mail : [EMAIL PROTECTED] Tel: +390471450268 Fax: +390471450253 -- To UNSUBSCRIBE, email to [EMAIL PROTECTED] with a subject of unsubscribe. Trouble? Contact [EMAIL PROTECTED]
Re: mysql
On Tue, 2002-04-09 at 10:28, Fabrizio Tivano wrote: On Friday 08 February 2002 23:53, Erol wrote: I have a mysql server on FreeBsd OS and I want to transfer all the database to Debian Linux. Is it possible and How can I do that ? for me the best way to do that is: go in the mysql dbase directory (ex. /var/lib/mysq/your_dbase) and brutally copy recursively, your_dbase dir that contains all your .MYD, .MYI and .frm files, in your newdbasesystem. I doubt this will work, because those binary files are not in a platform independend format and the format even varies between mysql versions. Also there is al lot of ways and utilities in the mysq.com site on how-to replicate and syncronize database. -- Tot ziens, Bart-Jan -- To UNSUBSCRIBE, email to [EMAIL PROTECTED] with a subject of unsubscribe. Trouble? Contact [EMAIL PROTECTED]
Re: mysql
On Friday 08 February 2002 23:53, Erol wrote: I have a mysql server on FreeBsd OS and I want to transfer all the database to Debian Linux. Is it possible and How can I do that ? Why not, on FreeBsd box; mysqldump --all-databases --add-drop-table --user=root -p filename password: rootpassword scp filename to debian box on debian box; mysql --user=root -p filename password: rootpassword This presumes your debian MySQL database to be empty, the --add-drop-table argument will drop existing tables with the same name replace them. (Including your mysql table containing usernames, passwords privileges). Steve. -- To UNSUBSCRIBE, email to [EMAIL PROTECTED] with a subject of unsubscribe. Trouble? Contact [EMAIL PROTECTED]
which MTA / POP server?
Hi list, I would just like to get some feedback from the list on what would be a good choise for a MTA / POP3 server which will meet the following requirements. * usernames / aliases / etc should be stored in MySQL or PostgreSQL * Should be able to handle a large number of emails * Isn't full of security exploits. I was going to use exim for the MTA with tpop3d from http://www.ex-parrot.com/~chris/tpop3d / as the POP3 server and use vmail-sql to manage the accounts but I found the following difficulties with such a setup. 1. the exim packaged for Debian doesn't have MySQL support, so an apt-get upgrade would break the system if I made my own package. 2. tpop3d and vmail-sql don't have Debian packages so it would be a matter of keeping up with these software packages and building my own debs every time a new release came out. Yes I know this last reason isn't a terribly good one, but it is enough to make me consider the alternatives. Alternative 1. Qmail + vpopmail. I noticed the vpopmail package for debian is several versions behind that on the inter7 web site. Also the vpopmail-mysql package appears to be broken and doesn't query the MySQL database like it should, I ended up having to build my own deb package of this to correct the problem. Alternative 2. postfix and cyrus imapd/pop3d 1. postfix does have MySQL support 2. Cyrus appears to cope quite hapilly with MySQL The only flaw with this set up is that it doesn't really allow for checking your mail on the local system via mutt or something, not a huge problem but a slight inconvenience. Does anyone else have any recommendations on what would be a good configuration to handle the type of mail setup I am aiming for? Any feedback would be most helpful. Thanks
Re: which MTA / POP server?
--On Dienstag, 9. April 2002 08:09 +1000 Dj Statik [EMAIL PROTECTED] wrote: [...] Alternative 2. postfix and cyrus imapd/pop3d 1. postfix does have MySQL support 2. Cyrus appears to cope quite hapilly with MySQL The only flaw with this set up is that it doesn't really allow for checking your mail on the local system via mutt or something, not a huge problem but a slight inconvenience. I'm running cyrus (with sendmail) and I have no problems reading mail with mutt. Neither via pop3 nor imap. Cheers, Marcel -- To UNSUBSCRIBE, email to [EMAIL PROTECTED] with a subject of unsubscribe. Trouble? Contact [EMAIL PROTECTED]
Re: mysql
MYD, .MYI and .frm files, in your newdbasesystem. I doubt this will work, because those binary files are not in a platform independend format and the format even varies between mysql versions. Also there is al lot of ways and utilities in the mysq.com site on how-to replicate and syncronize database. bart, it work... i've been tested importing a dbase from MySQL 3.23.49 to 3.23.39 whitout loss any loss of data and error. same way to use 'standard' mysqldump command fabrizio. -- To UNSUBSCRIBE, email to [EMAIL PROTECTED] with a subject of unsubscribe. Trouble? Contact [EMAIL PROTECTED]
Re[2]: users in apache
I saw something about Apache 2.0 where is it possible to have only user permission, I will look at it and try and send more... Regards Michal Novotny 9. dubna 2002 1:50:56, Craig Sanders [EMAIL PROTECTED] pise: On Mon, Apr 08, 2002 at 07:23:47PM +0200, Michal Novotny wrote: Is it possible to run/switch apache to user defined by User directive? Situation: Apache running www-data.www-data In home dirs users have their data (html etc.) with permission 600 and with user.www-data Now it is not possible to get any html (permission denied) ofcourse, because of permissions, but I don't want to set it 660, because then other user in that group can read/overwrite data/htmls. all files to be served by apache *MUST* be readable by user and/or group www-data. all directories in the path to the files *MUST* be readable and executable by user and/or group www-data. this means that they should either be owned by www-data and at least mode 400 (or 500 for directories), or they should be in group www-data and at least 440 (or 550 for directories). alternatively, files must be world-readable and directories must be world readable executable. the default is for files to be owned by the user, and mode 644 and for directories to be owned by the user and mode 755. you don't have any choice in this. if you want to serve pages, then the pages must be accessible by the apache process. or, to put it another way, apache can't serve a file it doesn't have permission to access. for CGI scripts, you can use suexec (comes with apache) or cgiwrap (separate package) or similar program to make the script run as a particular user. as a security precaution, both suexec and cgiwrap have quite strict policies on what they will run...but cgiwrap is more flexible. craig -- To UNSUBSCRIBE, email to [EMAIL PROTECTED] with a subject of unsubscribe. Trouble? Contact [EMAIL PROTECTED]
Re: which MTA / POP server?
On Tue, Apr 09, 2002 at 08:09:20AM +1000, Dj Statik wrote: Should be able to handle a large number of emails * Isn't full of security exploits. IMHO, This means qmail. [1] 1. the exim packaged for Debian doesn't have MySQL support, so an apt-get upgrade would break the system if I made my own package. 2. You can hold the package after installing your own. You can also divert the core binaries, in case an accidental install occurs. It is manageable, but I do prefer debian core packages when available. tpop3d and vmail-sql don't have Debian packages so it would be a matter of keeping up with these software packages and building my own debs every time a new release came out. If this is an ISP production mail system, rethink #2. You won't want to make *ANY* changes without lots of testing in a non-production environment. The point I'm making is the overhead of making your own debs should be insignificant to the testing you'll be doing before installing *any* debs (your own or debian produced). Alternative 1. Qmail + vpopmail. This is the one I've chosen. I noticed the vpopmail package for debian is several versions behind that on the inter7 web site. Also the vpopmail-mysql package appears to be broken and doesn't query the MySQL database like it should, I ended up having to build my own deb package of this to correct the problem. If you know a little C and debian's packaging system, you won't have any trouble pulling down vpopmail 5.2 and building packages. Alternative 2. postfix and cyrus imapd/pop3d Don't know anything about either of these. The only flaw with this set up is that it doesn't really allow for checking your mail on the local system via mutt or something, not a huge problem but a slight inconvenience. I think you're saying the only way you can support users w/ download problems is to use your favorite pop-3 mail reader. It sure is nice to pull up mutt locally the few times it's an issue. Does anyone else have any recommendations on what would be a good configuration to handle the type of mail setup I am aiming for? You've given zero information about your environment, business size, number of email accounts, staff capabilities, etc... give some more context so we don't end up wasting our time. [1] IMHO. I don't want to start a religeous war over MTA choices. -- Ted Deppner http://www.psyber.com/~ted/ -- To UNSUBSCRIBE, email to [EMAIL PROTECTED] with a subject of unsubscribe. Trouble? Contact [EMAIL PROTECTED]
Re: slapd and pam_ldap in debian?
I am using pam_ldap without any trouble on a test system running testing. It has been some while since I set the thing up, but it was pretty straightforward, once all the ldap entries were created. Have you checked what your auth.log says? -- Paul Fleischer // ProGuy [EMAIL PROTECTED] PGP key fingerprint: 755A 9FB3 F7E4 DB62 8154 C5D6 381B BBCD 7BE1 FF30 Registered Linux User #166300 http://counter.li.org man, 2002-04-08 kl. 12:06 skrev Roger Abrahamsson: Hello Finally figured I would test this out and try authenticating with LDAP and see if it could be something. However my testsetup absolutely refuses to work with pam_ldap, and I wondered if anyone here got that working? I use Debian/sid and latest packages there, but dont want to use sasl/kerberos. Will pam_ldap in debian work without sasl, or at least without kerberos, without a recompile? I have verified that it is not my acl's in ldap with giving * full write access to all, and it did not help, and besides ldapadd works, if I do a simple bind... only error message I get is that I get an error in binding if I supply binddn,bindpw and rootbinddn in ldap_conf, and the dn and password is correct since I can use it in ldapadd. I am totally mystified here.. Any help would be appreciated.. Regards Roger A -- To UNSUBSCRIBE, email to [EMAIL PROTECTED] with a subject of unsubscribe. Trouble? Contact [EMAIL PROTECTED] signature.asc Description: This is a digitally signed message part
Re: Re[2]: users in apache
tir, 2002-04-09 kl. 13:20 skrev Michal Novotny: I saw something about Apache 2.0 where is it possible to have only user permission, I will look at it and try and send more... There is a MPM module called perchild under development, although I haven't got it to work properly yet (or at all, actually). But, I ran into this patch for 1.3.20 which does something equalent: http://luxik.cdi.cz/~devik/apache/ However, I am not sure if this patch doesn't introduce some security issues, and I haven't even tried it myself yet. And yes, I am looking very much forward to that feature in apache 2.0 too, it would resolve a great number of problems for me ; -- Paul Fleischer // ProGuy [EMAIL PROTECTED] PGP key fingerprint: 755A 9FB3 F7E4 DB62 8154 C5D6 381B BBCD 7BE1 FF30 Registered Linux User #166300 http://counter.li.org signature.asc Description: This is a digitally signed message part
Re: Software for www portal management
Does anybody know a software (open source of cause) for portal management ? You can add phpwebsite to the list. -- To UNSUBSCRIBE, email to [EMAIL PROTECTED] with a subject of unsubscribe. Trouble? Contact [EMAIL PROTECTED]