From: Fred Z. <fre...@sh...> - 2010-02-26 02:10:07
|
Today I had to remove the change_sqlpass plugin from my server due to a lack of support. Unfortunately this means that I will also have to remove squirrelmail as well. After 4 months of asking questions in various places without a single reply I have been left with no other choice. Regards Fred > OK, I need to clarify here, there seems to be 2 of us on this thread with > a similar problem. I have jumped in on this discussion because I felt my > situation was similar. > > I will attempt to outline my issue in as much detail as I can. > > Background: > I have installed a Debian web server to manage my own domains, websites > and email. I am using Domain Technology Control (DTC) as a control panel > for the server. > > The database containing the tables is called dtc and the table containing > the user information is called pop_access, the columns of interest are as > follows. > > id=user email left of @ > mbox_host=domain, right of @ > crypt=not sure > passwd=password in plain text > fullemail=full email address > > > I have SM installed on my server > I have installed the change_sqlpass plugin and activated it > > I have edited the config.php > > $csp_dsn = 'mysql://DatabaseAdmin:AdminPassword@localhost/dtc'; > So I can connect to the database. > > Now my problem starts. > I simply don't understand how the rest of the connect strings are > configured (what they are asking for) and what type of string I should be > using. Also there are many sections to the configuration that seem to > require different connect strings to different places. > > Example. > //$lookup_password_query = ''; > // TERRIBLE SECURITY: $lookup_password_query = 'SELECT count(*) FROM > users WHERE username = "%1" AND plain_password = "%5"'; > $lookup_password_query = 'SELECT count(*) FROM users WHERE username = > "%1" AND crypt_password = %4'; > > SELECT means what? > FROM means what? > WHERE means what? > What I am asking here is what is the statement asking for. > > I have googled (made things worse), I have read manuals, all to no avail > because everything I have read assumes a level of understanding I simply > don't have. > > I have asked the author of DTC for some assistance, he didn't answer my > questions at all even though he was interested in having the plugin work. > > I have asked in the general SM list and was told to come here. > > I have been attempting to get this operational for more than 3 months now. > And until I can gain some understanding of what the configuration file is > asking for I will never get it configured. > > If someone would be so kind as to hold my hand a little and walk me > through the basics so that I can move forward with this it would be most > appreciated. > > Sorry to be such a pleb. > > Regards > > Fred > > >> Hi, >> If you are using password encryption then you will have to encrypt >> their >> password. In phpmyadmin select the user, edit and find the password >> line. One will say clear,and right under it is crypt. You will see the >> password they selected in both fields. In the crypt field there is a >> drop down menu. Select encrypt for the crypt field and click on Go. It >> will encrypt the password. The clear field remains the password they >> selected. You will have to do this as you are the admin. Let me know if >> that helps. >> John D >> >> >>> I'm using debian lenny mysql 5 and sure - phpmyadmin is not the >>> problem. >>> i'm using it for daily doings. >>> its a private web/mailserver more or less for myself BUT now i want >>> to give my children and my parents access to own emailadresses - and i >>> want them to set there passwords by themself. for them is phpmyadmin >>> nothing to talk abount - they are just 'users' ... >>> Thorsten A.O. >>> >>>> Hi, >>>> I am a bit late to this thread but I may be able to help. What >>>> Database >>>> are you using? What operating system and mail server ex.Postfix? >>>> Do you have phpmyadmin installed? I am running postfix with Mysql. >>>> Using >>>> phpmyadmin for the passwords and adding users is relatively easy. >>>> >>>> John D >>>> >>>>> I have had a not to dissimilar problem and have been trying to sort >>>>> it >>>>> out >>>>> for weeks. >>>>> >>>>> My problem is that I have a serious lack of knowledge. >>>>> >>>>> I have worked out how to connect to the database, but I don't know >>>>> about >>>>> the rest of the connection strings used. >>>>> >>>>> I have exported the database table containing the information that I >>>>> believe to be all the relevant information. >>>>> id=user email left of @ >>>>> mbox_host=domain, right of @ >>>>> crypt=not sure >>>>> passwd=password in plain text >>>>> fullemail=full email address >>>>> >>>>> If someone could point me to where I can find information to help me >>>>> understand what to adjust that would be great. >>>>> >>>>> Or if you are so inclined just provide me with the required strings >>>>> to >>>>> paste to the config file that would also be good. >>>>> >>>>> After more than 3 months of working on this I have reached the end of >>>>> my >>>>> willingness to google anything about this any more. >>>>> >>>>> Regards >>>>> >>>>> Fred >>>>> >>>>>>>>> Sorry - it came to nothing, so i need a ltiitle bit help. >>>>>>>>> I tried to install change_sqlpass for the first time ( i want to >>>>>>>>> add >>>>>>>>> some more users than just me). >>>>>>>>> After the first error COULD NOT FIND PEAR DB LIBRARY i tried a >>>>>>>>> little >>>>>>>>> bit 'googleling' >>>>>>>>> and installed php-pear.Pear list shows me >>>>>>>>> >>>>>>>>> Installed packages, channel pear.php.net: >>>>>>>>> ========================================= >>>>>>>>> Package Version State >>>>>>>>> Archive_Tar 1.3.2 stable >>>>>>>>> Console_Getopt 1.2.3 stable >>>>>>>>> PEAR 1.7.1 stable >>>>>>>>> Structures_Graph 1.0.2 stable >>>>>>>>> >>>>>>>>> include_path in php.ini points to /usr/share/php/PEAR. >>>>>>>>> >>>>>>>>> Whats wrong - where is my big mistake? >>>>>>>> >>>>>>>> Have you got installed php-db? >>>>>>>> Cause it looks like there is no DB lib. >>>>>>> >>>>>>> thx for your note - i really didn't noticed, that i had to install >>>>>>> that >>>>>>> to. (is there a good howto for squirrelmail and change_sqlpass?) >>>>>>> the pear db error is gone - >>>>>>> but the next occured -> Could not make database connection >>>>>>> i think i have to take a more intensive look at the config.php ? >>>>>> >>>>>> Yes. It can't connect to the database unless you configure it with >>>>>> the right information to do so. >>>>>> >>>>>>> again - thanks for your help and if you' ve got any further hints >>>>>>> for >>>>>>> me >>>>>>> - a noob like me is always interestet in that ;) >>>>>>> greetings from germany >>>>>>> thorten >>>>>>> ps >>>>>>> i dont know how it works in this list - if it is not wantetd to >>>>>>> answer >>>>>>> directly - just tell me. >>>>>> >>>>>> READ the mailing list posting guidelines as you were requested to do >>>>>> when you subscribed. Pay attention to the part about not >>>>>> top-posting. >>>>>> >>>>>> -- >>>>>> Paul Lesniewski >>>>>> SquirrelMail Team >>>>>> Please support Open Source Software by donating to SquirrelMail! >>>>>> http://squirrelmail.org/donate_paul_lesniewski.php >>>>>> >>>>>> ------------------------------------------------------------------------------ >>>>>> SOLARIS 10 is the OS for Data Centers - provides features such as >>>>>> DTrace, >>>>>> Predictive Self Healing and Award Winning ZFS. Get Solaris 10 NOW >>>>>> http://p.sf.net/sfu/solaris-dev2dev >>>>>> ----- >>>>>> squirrelmail-plugins mailing list >>>>>> Posting guidelines: http://squirrelmail.org/postingguidelines >>>>>> List address: squ...@li... >>>>>> List archives: http://news.gmane.org/gmane.mail.squirrelmail.plugins >>>>>> List info (subscribe/unsubscribe/change options): >>>>>> https://lists.sourceforge.net/lists/listinfo/squirrelmail-plugins >>>>>> >>>>> >>>>> >>>>> >>>>> ------------------------------------------------------------------------------ >>>>> SOLARIS 10 is the OS for Data Centers - provides features such as >>>>> DTrace, >>>>> Predictive Self Healing and Award Winning ZFS. Get Solaris 10 NOW >>>>> http://p.sf.net/sfu/solaris-dev2dev >>>>> ----- >>>>> squirrelmail-plugins mailing list >>>>> Posting guidelines: http://squirrelmail.org/postingguidelines >>>>> List address: squ...@li... >>>>> List archives: http://news.gmane.org/gmane.mail.squirrelmail.plugins >>>>> List info (subscribe/unsubscribe/change options): >>>>> https://lists.sourceforge.net/lists/listinfo/squirrelmail-plugins >>>>> >>>> >>>> >>>> -- >>>> New knowledge is the most valuable commodity on earth. The more truth >>>> we >>>> have to work with, the richer we become. >>>> >>>> Kurt Vonnegut, Breakfast of Champions >>>> >>>> >>>> ------------------------------------------------------------------------------ >>>> SOLARIS 10 is the OS for Data Centers - provides features such as >>>> DTrace, >>>> Predictive Self Healing and Award Winning ZFS. Get Solaris 10 NOW >>>> http://p.sf.net/sfu/solaris-dev2dev >>>> ----- >>>> squirrelmail-plugins mailing list >>>> Posting guidelines: http://squirrelmail.org/postingguidelines >>>> List address: squ...@li... >>>> List archives: http://news.gmane.org/gmane.mail.squirrelmail.plugins >>>> List info (subscribe/unsubscribe/change options): >>>> https://lists.sourceforge.net/lists/listinfo/squirrelmail-plugins >>>> >>> >>> >>> >>> ------------------------------------------------------------------------------ >>> SOLARIS 10 is the OS for Data Centers - provides features such as >>> DTrace, >>> Predictive Self Healing and Award Winning ZFS. Get Solaris 10 NOW >>> http://p.sf.net/sfu/solaris-dev2dev >>> ----- >>> squirrelmail-plugins mailing list >>> Posting guidelines: http://squirrelmail.org/postingguidelines >>> List address: squ...@li... >>> List archives: http://news.gmane.org/gmane.mail.squirrelmail.plugins >>> List info (subscribe/unsubscribe/change options): >>> https://lists.sourceforge.net/lists/listinfo/squirrelmail-plugins >>> >> >> >> New knowledge is the most valuable commodity on earth. The more truth we >> have to work with, the richer we become. >> >> Kurt Vonnegut, Breakfast of Champions >> >> >> ------------------------------------------------------------------------------ >> SOLARIS 10 is the OS for Data Centers - provides features such as >> DTrace, >> Predictive Self Healing and Award Winning ZFS. Get Solaris 10 NOW >> http://p.sf.net/sfu/solaris-dev2dev >> ----- >> squirrelmail-plugins mailing list >> Posting guidelines: http://squirrelmail.org/postingguidelines >> List address: squ...@li... >> List archives: http://news.gmane.org/gmane.mail.squirrelmail.plugins >> List info (subscribe/unsubscribe/change options): >> https://lists.sourceforge.net/lists/listinfo/squirrelmail-plugins >> > > > > ------------------------------------------------------------------------------ > Download Intel® Parallel Studio Eval > Try the new software tools for yourself. Speed compiling, find bugs > proactively, and fine-tune applications for parallel performance. > See why Intel Parallel Studio got high marks during beta. > http://p.sf.net/sfu/intel-sw-dev > ----- > squirrelmail-plugins mailing list > Posting guidelines: http://squirrelmail.org/postingguidelines > List address: squ...@li... > List archives: http://news.gmane.org/gmane.mail.squirrelmail.plugins > List info (subscribe/unsubscribe/change options): > https://lists.sourceforge.net/lists/listinfo/squirrelmail-plugins > |