Re: [Samba] Problems with MySQL backend.
Hello everyone, again: I have not received any single message from you regarding the changes in 3.0.21 - maybe that's why no one responed? Maybe the message simply did not get through? I asked again in Bugzilla to re-send that message, but I still received no message (but thanks to Volker the code works again). So, what changes are you proposing for 3.0.22 that will render the pdb_mysql module unusable? And why are you introducing such changes into the stable tree, so that every now and then a fix for the modules is important? Please shed a light, I really don't know what's going on at the moment... :-) Can the MySQL bug (#3369) have something to do with the changes you introduced or is this something different that exists longer? Thanks Florian -- To unsubscribe from this list go to the following URL and read the instructions: https://lists.samba.org/mailman/listinfo/samba
Re: [Samba] Problems with MySQL backend.
On 1/5/06, Jeremy Allison [EMAIL PROTECTED] wrote: On Wed, Jan 04, 2006 at 07:41:44PM +0100, Florian Effenberger wrote: I use the pdb_mysql module in an environment with about 100 clients and 1.500 users. We have a self-written web interface, and Samba and the web interface are based on the pdb_mysql module. However, I am no programmer, so I need your help. I can test, debug and act as a contact person, however, I need someone supporting me as a developer, as I can't code a single line. :-) Do you see any chance in this? Ok, then you can be the tester for this but we still need a maintainer. I don't have the free time to do the code on this. Is there anyone who depends on this who can maintain the code. Jeremy. Ok, I think it's time to someone say I will maintain this. So I'm saying it :-) I can maintain pdb_*sql code - I depends on pdb_pgsql, but I think it is effective to maintain both mysql and pgsql together. Jeremy, do you think if it will be useful to create samba-sql mail list for these who take interest on samba pdb_*sql modules? Filip Jirsák -- Filip Jirsák [EMAIL PROTECTED] -- To unsubscribe from this list go to the following URL and read the instructions: https://lists.samba.org/mailman/listinfo/samba
Re: [Samba] Problems with MySQL backend.
On 1/5/06, Gerald (Jerry) Carter [EMAIL PROTECTED] wrote: This really boils down to a communication problem. Developers are expected to subscribe to both the samba-cvs and the samba-technical lists. The samba-pdbsql alias is really only intended for use in bugzilla (default owner of pdb_sql component). OK, bugzilla is probably the best place for discussion about several pdb*sql modules problems - it is public, so everyone can find if someone else works on some problem or tested it and so on. In a perfect world, everyone would know what's going on in every aspect of the code tree. But that's doesn't scale very well. It's a big code base. The only realy way to deal with this is to eat our own dogfood. A simple small test server running the SAMBA_3_0 tree (updated every few days or so). That way, when something in the pdb*sql modules break, whether intentionally or not, you will know immediately. At this moment I ca't have two small test servers - one for mysql and another for pgsql. So I can test code for mysql it it can compile and start, but I'm not able to test it for longer time. For pgsql I can do this. It will be great if for example Florian can test pdb_mysql more. Filip, you and I should stay in closer contact. I'll try to remember to ping you when there is any relevant developments that I think you should be aware of. OK, thanks a lot. I will look tomorrow and within weekend on current CVS code and I will try to tidy pdb_sql issues in bugzilla so we will know what is critical, what is already done etc. Cheers, Filip -- Filip Jirsák [EMAIL PROTECTED] -- To unsubscribe from this list go to the following URL and read the instructions: https://lists.samba.org/mailman/listinfo/samba
Re: [Samba] Problems with MySQL backend.
On Wed, Jan 04, 2006 at 07:41:44PM +0100, Florian Effenberger wrote: I use the pdb_mysql module in an environment with about 100 clients and 1.500 users. We have a self-written web interface, and Samba and the web interface are based on the pdb_mysql module. However, I am no programmer, so I need your help. I can test, debug and act as a contact person, however, I need someone supporting me as a developer, as I can't code a single line. :-) Do you see any chance in this? Ok, then you can be the tester for this but we still need a maintainer. I don't have the free time to do the code on this. Is there anyone who depends on this who can maintain the code. Jeremy. -- To unsubscribe from this list go to the following URL and read the instructions: https://lists.samba.org/mailman/listinfo/samba
Re: [Samba] Problems with MySQL backend.
Hi Filip, Ok, I think it's time to someone say I will maintain this. So I'm saying it :-) I can maintain pdb_*sql code - I depends on pdb_pgsql, but I think it is effective to maintain both mysql and pgsql together. Jeremy, do you think if it will be useful to create samba-sql mail list for these who take interest on samba pdb_*sql modules? thanks a lot for taking this over! We have a [EMAIL PROTECTED] alias (but no real mailing list). Messages sent there get to a group of persons who want to contribute to the development of the SQL module. Jerry, can you add Filip to this alias? Thanks Florian -- To unsubscribe from this list go to the following URL and read the instructions: https://lists.samba.org/mailman/listinfo/samba
Re: [Samba] Problems with MySQL backend.
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Florian Effenberger wrote: thanks a lot for taking this over! We have a [EMAIL PROTECTED] alias (but no real mailing list). Messages sent there get to a group of persons who want to contribute to the development of the SQL module. Jerry, can you add Filip to this alias? He's already on it :-) This really boils down to a communication problem. Developers are expected to subscribe to both the samba-cvs and the samba-technical lists. The samba-pdbsql alias is really only intended for use in bugzilla (default owner of pdb_sql component). In a perfect world, everyone would know what's going on in every aspect of the code tree. But that's doesn't scale very well. It's a big code base. The only realy way to deal with this is to eat our own dogfood. A simple small test server running the SAMBA_3_0 tree (updated every few days or so). That way, when something in the pdb*sql modules break, whether intentionally or not, you will know immediately. Filip, you and I should stay in closer contact. I'll try to remember to ping you when there is any relevant developments that I think you should be aware of. cheers, jerry = Alleviating the pain of Windows(tm) --- http://www.samba.org Centeris --- http://www.centeris.com There's an anonymous coward in all of us. --anonymous -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.2 (MingW32) Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org iD8DBQFDvSGZIR7qMdg1EfYRAkjfAKDi8pNXFZEo65I4PwBfovmejA+53ACfbvTq Q6UcP9WqOLtR+OZe8FWo9eU= =YETn -END PGP SIGNATURE- -- To unsubscribe from this list go to the following URL and read the instructions: https://lists.samba.org/mailman/listinfo/samba
Re: [Samba] Problems with MySQL backend.
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Filip Jirsák wrote: OK, bugzilla is probably the best place for discussion about several pdb*sql modules problems - it is public, so everyone can find if someone else works on some problem or tested it and so on. Bugzilla is good for individual issues. The samba-technical ml is best for interaction with other Samba developers (like Jeremy Volker). At this moment I ca't have two small test servers - one for mysql and another for pgsql. So I can test code for mysql it it can compile and start, but I'm not able to test it for longer time. For pgsql I can do this. It will be great if for example Florian can test pdb_mysql more. Sounds like a good plan. If testing resources become an issue, let me know and I'll try to work out a better solution for you. OK, thanks a lot. I will look tomorrow and within weekend on current CVS code and I will try to tidy pdb_sql issues in bugzilla so we will know what is critical, what is already done etc. Thanks. Much appreciated. Ping me if you have questions. cheers, jerry = Alleviating the pain of Windows(tm) --- http://www.samba.org Centeris --- http://www.centeris.com There's an anonymous coward in all of us. --anonymous -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.2 (MingW32) Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org iD8DBQFDvTrCIR7qMdg1EfYRAh8EAJ9kRowm6ycd+nGs+8SQP1R5IzhouwCgkBjL i/RdiVejdAK8xTRDLFTIzrc= =O5GV -END PGP SIGNATURE- -- To unsubscribe from this list go to the following URL and read the instructions: https://lists.samba.org/mailman/listinfo/samba
Re: [Samba] Problems with MySQL backend.
Hi Jerry, He's already on it :-) :-) This really boils down to a communication problem. Developers are expected to subscribe to both the samba-cvs and the samba-technical lists. The samba-pdbsql alias is really only intended for use in bugzilla (default owner of pdb_sql component). Okay, that makes sense. Filip, Darrell, will you subscribe to this lists? I could, too, but I guess as a non-developer I can't do much with this... :-) A simple small test server running the SAMBA_3_0 tree (updated every few days or so). That way, when something in the pdb*sql modules break, whether intentionally or not, you will know immediately. Filip already told he can set up two test servers, so that should work. Currently, I have one production machine which I can test new releases of the module on in the evening (it's in a school, thus no users after 6 or 7 pm). Will see if I can re-activate two old machines in-house and test there as well. Filip, if you want, you can give me RDP and SSH access so I can debug on your machines as well. But that's not necessary (RDP is insecure). Filip, you and I should stay in closer contact. I'll try to remember to ping you when there is any relevant developments that I think you should be aware of. Thanks for that offer, Jerry! I really appreciate all your (all Samba developers) work in this matter! I know you don't really want this module as it's not so widely used, so I appreciate your support even more! Thanks! :-) Could you please ping the whole pdbsql list when something new happens? (Or, at least, write to me as well.) Thanks! Florian -- To unsubscribe from this list go to the following URL and read the instructions: https://lists.samba.org/mailman/listinfo/samba
Re: [Samba] Problems with MySQL backend.
Hi, At this moment I ca't have two small test servers - one for mysql and another for pgsql. So I can test code for mysql it it can compile and start, but I'm not able to test it for longer time. For pgsql I can do this. It will be great if for example Florian can test pdb_mysql more. Can do, see my last message. :-) OK, thanks a lot. I will look tomorrow and within weekend on current CVS code and I will try to tidy pdb_sql issues in bugzilla so we will know what is critical, what is already done etc. Thanks a lot, Filip! Florian -- To unsubscribe from this list go to the following URL and read the instructions: https://lists.samba.org/mailman/listinfo/samba
Re: [Samba] Problems with MySQL backend.
Hi, Bugzilla is good for individual issues. The samba-technical ml is best for interaction with other Samba developers (like Jeremy Volker). I'll subscribe to this and see how much traffic it is. :-) Sounds like a good plan. If testing resources become an issue, let me know and I'll try to work out a better solution for you. I have three terminal servers (i.e., XP SP2 machines with RDP open) and SSH access to our PDC to test. However, I can't give anyone else access as it is a restricted network. Florian -- To unsubscribe from this list go to the following URL and read the instructions: https://lists.samba.org/mailman/listinfo/samba
Re: [Samba] Problems with MySQL backend.
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Jeremy Allison wrote: It needs a maintainer who will support it and fix bugs. Without that it is always in danger of breaking and being removed from the tree. We *really* need someone to step up to this, none of the regular Team have time available at the moment to do this. gahhhthe maintainers are all at the [EMAIL PROTECTED] alias which gets all bugs assigned to the pdb_sql component in bugzilla. cheers, jerry -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.2 (MingW32) Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org iD8DBQFDu+pGIR7qMdg1EfYRAvjKAKDVz7XxEyGW8Ym1gSTuoYGHKa0r1gCg4DYr H8eTXUs9JGRLstElp/yfmAE= =8n+w -END PGP SIGNATURE- -- To unsubscribe from this list go to the following URL and read the instructions: https://lists.samba.org/mailman/listinfo/samba
Re: [Samba] Problems with MySQL backend.
On Wed, Jan 04, 2006 at 09:31:18AM -0600, Gerald (Jerry) Carter wrote: -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Jeremy Allison wrote: It needs a maintainer who will support it and fix bugs. Without that it is always in danger of breaking and being removed from the tree. We *really* need someone to step up to this, none of the regular Team have time available at the moment to do this. gahhhthe maintainers are all at the [EMAIL PROTECTED] alias which gets all bugs assigned to the pdb_sql component in bugzilla. Yes, but none of them *responded*, did they. Jeremy. -- To unsubscribe from this list go to the following URL and read the instructions: https://lists.samba.org/mailman/listinfo/samba
Re: [Samba] Problems with MySQL backend.
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Jeremy Allison wrote: gahhhthe maintainers are all at the [EMAIL PROTECTED] alias which gets all bugs assigned to the pdb_sql component in bugzilla. Yes, but none of them *responded*, did they. Did anyone file a bug ? Or just post to the list? Mail them and light a fire. cheers, jerry -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.2 (MingW32) Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org iD8DBQFDu+y6IR7qMdg1EfYRAmVFAKDf288jQu6SrOua3DDhtgeE5tqXLgCcCrp7 89REVjT2O4Xy3N/ts/lVkSY= =z12x -END PGP SIGNATURE- -- To unsubscribe from this list go to the following URL and read the instructions: https://lists.samba.org/mailman/listinfo/samba
Re: [Samba] Problems with MySQL backend.
On Wed, Jan 04, 2006 at 09:41:46AM -0600, Gerald (Jerry) Carter wrote: -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Jeremy Allison wrote: gahhhthe maintainers are all at the [EMAIL PROTECTED] alias which gets all bugs assigned to the pdb_sql component in bugzilla. Yes, but none of them *responded*, did they. Did anyone file a bug ? Or just post to the list? Mail them and light a fire. I sent an urgent message before release stating there'd been passdb changes and asking for someone to fix the SQL db backends. No one responded. There are more changes coming in 3.0.22 of course. Jeremy. -- To unsubscribe from this list go to the following URL and read the instructions: https://lists.samba.org/mailman/listinfo/samba
Re: [Samba] Problems with MySQL backend.
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Jeremy Allison wrote: On Wed, Jan 04, 2006 at 09:41:46AM -0600, Gerald (Jerry) Carter wrote: -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Jeremy Allison wrote: gahhhthe maintainers are all at the [EMAIL PROTECTED] alias which gets all bugs assigned to the pdb_sql component in bugzilla. Yes, but none of them *responded*, did they. Did anyone file a bug ? Or just post to the list? Mail them and light a fire. I sent an urgent message before release stating there'd been passdb changes and asking for someone to fix the SQL db backends. No one responded. There are more changes coming in 3.0.22 of course. Wellif we don't get any response before the 3.0.22 rc releases, we'll disable it. How's that sound? cheers, jerry = Alleviating the pain of Windows(tm) --- http://www.samba.org Centeris --- http://www.centeris.com There's an anonymous coward in all of us. --anonymous -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.2 (MingW32) Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org iD8DBQFDu/BXIR7qMdg1EfYRAtGyAKDSnia9YsfF1RZvZOk6KE0p/M+ARACdGLff lUqR2OtqRq7C2iBauzX6VVM= =gKBO -END PGP SIGNATURE- -- To unsubscribe from this list go to the following URL and read the instructions: https://lists.samba.org/mailman/listinfo/samba
Re: [Samba] Problems with MySQL backend.
On Wed, Jan 04, 2006 at 09:57:12AM -0600, Gerald (Jerry) Carter wrote: Wellif we don't get any response before the 3.0.22 rc releases, we'll disable it. How's that sound? Works for me... We can't have unmaintained code in the tree. Jeremy. -- To unsubscribe from this list go to the following URL and read the instructions: https://lists.samba.org/mailman/listinfo/samba
Re: [Samba] Problems with MySQL backend.
On Wed, Jan 04, 2006 at 06:50:20PM +0100, Florian Effenberger wrote: Hello everyone, again: I have not received any single message from you regarding the changes in 3.0.21 - maybe that's why no one responed? Maybe the message simply did not get through? It seems so, I'm sorry if that's the case. I did try and notify people so this would not break. I asked again in Bugzilla to re-send that message, but I still received no message (but thanks to Volker the code works again). It's not important now, what's more important is ensuring that the SQL modules are maintained going forward. So, what changes are you proposing for 3.0.22 that will render the pdb_mysql module unusable? Volker (and others) are making passdb backend changes. You need to keep testing it with the SQL module as these changes are made to make sure it keeps working. No one else is testing it so the interface is fragile. And why are you introducing such changes into the stable tree, so that every now and then a fix for the modules is important? Please shed a light, I really don't know what's going on at the moment... :-) Because we need to. It's like the Linux kernel module interface. We need to keep changing it to fix architecture problems. Can the MySQL bug (#3369) have something to do with the changes you introduced or is this something different that exists longer? Haven't reviewed that bug - we need someone who will do that (review the bugs) and maintain the module - no matter what gets done. Of course the maintainer also gets to argue and complain and *help* design the passdb changes :-). Jeremy. -- To unsubscribe from this list go to the following URL and read the instructions: https://lists.samba.org/mailman/listinfo/samba
Re: [Samba] Problems with MySQL backend.
Hi Jeremy, It seems so, I'm sorry if that's the case. I did try and notify people so this would not break. no problem, the most important thing to me is that we can find a solution that everyone is happy with. It's not important now, what's more important is ensuring that the SQL modules are maintained going forward. Agreed. Volker (and others) are making passdb backend changes. You need to keep testing it with the SQL module as these changes are made to make sure it keeps working. No one else is testing it so the interface is fragile. Testing the interface is no problem. My problem, however, is fixing bugs or changing/adapting functionality. (See below) Haven't reviewed that bug - we need someone who will do that (review the bugs) and maintain the module - no matter what gets done. Of course the maintainer also gets to argue and complain and *help* design the passdb changes :-). I use the pdb_mysql module in an environment with about 100 clients and 1.500 users. We have a self-written web interface, and Samba and the web interface are based on the pdb_mysql module. However, I am no programmer, so I need your help. I can test, debug and act as a contact person, however, I need someone supporting me as a developer, as I can't code a single line. :-) Do you see any chance in this? Looking forward to working with you! Florian -- To unsubscribe from this list go to the following URL and read the instructions: https://lists.samba.org/mailman/listinfo/samba
Re: [Samba] Problems with MySQL backend.
On Fri, Dec 30, 2005 at 02:27:37PM +0100, Mario Lipinski wrote: After all i want to stay with MySQL now. Are there any reasons from the point of database structure and SQL itself not to use it as a backend, apart from the status of the backend itself now? It needs a maintainer who will support it and fix bugs. Without that it is always in danger of breaking and being removed from the tree. We *really* need someone to step up to this, none of the regular Team have time available at the moment to do this. Jeremy. -- To unsubscribe from this list go to the following URL and read the instructions: https://lists.samba.org/mailman/listinfo/samba
Re: [Samba] Problems with MySQL backend.
On Tue, 2005-12-27 at 18:22 +0100, Mario Lipinski wrote: Hello, i just set up Samba 3.0.20b on a new machine as PDC with the MySQL passdb backend and experiencing problems with the connection to the SQL-Server. The connection gets lost and is not created again. So i have to restart Samba for authentication and so on to work again... Is there a reason why you chose to use the MySQL backend? If this is a new setup, then I strongly suggest using the LDAP backend. It is more mature (has spent more time in critical environments) and is maintained. After restarting Samba everthing is fine - for a while. I think Samba must try to recreate the connection. Is there some switch for that? I don't think the code was expecting the connections to be dropped. Andrew Bartlett -- Andrew Bartletthttp://samba.org/~abartlet/ Authentication Developer, Samba Team http://samba.org Student Network Administrator, Hawker College http://hawkerc.net signature.asc Description: This is a digitally signed message part -- To unsubscribe from this list go to the following URL and read the instructions: https://lists.samba.org/mailman/listinfo/samba
Re: [Samba] Problems with MySQL backend.
Am Freitag, den 30.12.2005, 23:11 +1100 schrieb Andrew Bartlett: On Tue, 2005-12-27 at 18:22 +0100, Mario Lipinski wrote: i just set up Samba 3.0.20b on a new machine as PDC with the MySQL passdb backend and experiencing problems with the connection to the SQL-Server. The connection gets lost and is not created again. So i have to restart Samba for authentication and so on to work again... Is there a reason why you chose to use the MySQL backend? If this is a new setup, then I strongly suggest using the LDAP backend. We are using the MySQL backend since Samba 3 pre beta and went quite well with it. It makes (automated) manipulation to the user database easier for us. For example we need to adjust the database with an external one regulary. And maintaining LDAP (we were using it with Samba 2) was quite difficult. It might also be a personal preference since I am familiar with (My)SQL. After all i want to stay with MySQL now. Are there any reasons from the point of database structure and SQL itself not to use it as a backend, apart from the status of the backend itself now? It is more mature (has spent more time in critical environments) and is maintained. After restarting Samba everthing is fine - for a while. I think Samba must try to recreate the connection. Is there some switch for that? I don't think the code was expecting the connections to be dropped. I think we don't have to discuss the circumstances (e.g. logrotate, maintainance) under which the connection to the db server might drop. So I think there is really a need to implement this. If there is no maintainance at the moment (I read in bugzilla there was again) or nobody is willing to fix this I might give it a try myself getting familiar with the backend and trying to implement handling of dropped connections. -- Mario Lipinski VOIP: +49 511 696045510 SystemadministrationFax: +49 721 151-207196 Gymnasium Salzgitter-BadE-Mail: [EMAIL PROTECTED] Internet: http://www.gymszbad.de signature.asc Description: Dies ist ein digital signierter Nachrichtenteil -- To unsubscribe from this list go to the following URL and read the instructions: https://lists.samba.org/mailman/listinfo/samba
