> i am using qmailtoaster 64 bit > > vpopmail, centos 6 64 bit > mysql database > > vpopmail has every domain as a seperate table example That's weird. What's the use? > if my domain name is : xxxxx.com then the table is > xxxxx_com > > i edited the config.php of the change_sqlpass plugin as advised here > https://forums.gentoo.org/viewtopic-t-410886-start-0.html > > but i am getting error as such (i enabled debup in the change_sqlpass plugin > ) > > DATABASE ERROR: could not lookup salt: SELECT SUBSTRING(pw_passwd,4,9) FROM > vpopmail WHERE pw_name = "hosting" ---- DB Error: no such table > > it seems that the change_sqlpass expects all the userids to be stored in a > single table instead of seperate tables per domain No, it expects you to give it a query that works. Make sure your query fits your schema. Use the mysql command line client to test if you're not sure. End of story. -- Paul Lesniewski SquirrelMail Team Please support Open Source Software by donating to SquirrelMail! http://squirrelmail.org/donate_paul_lesniewski.php ------------------------------------------------------------------------------ New Year. New Location. New Benefits. New Data Center in Ashburn, VA. GigeNET is offering a free month of service with a new server in Ashburn. Choose from 2 high performing configs, both with 100TB of bandwidth. Higher redundancy.Lower latency.Increased capacity.Completely compliant. http://p.sf.net/sfu/gigenet ----- squirrelmail-users mailing list Posting guidelines: http://squirrelmail.org/postingguidelines List address: squirrelmail-users@xxxxxxxxxxxxxxxxxxxxx List archives: http://news.gmane.org/gmane.mail.squirrelmail.user List info (subscribe/unsubscribe/change options): https://lists.sourceforge.net/lists/listinfo/squirrelmail-users
