change_sqlpass plugin

classic Classic list List threaded Threaded
2 messages Options
Reply | Threaded
Open this post in threaded view
|

change_sqlpass plugin

Rajesh M-3
hi

i am using qmailtoaster 64 bit

vpopmail, centos 6 64 bit
mysql database

vpopmail has every domain as a seperate table example
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

could somebody please guide me as to how i can resolve this ?

i dont want to use poppassd or qmailadmin within squirrelmail

thank you very much for your time and help,

rajesh


------------------------------------------------------------------------------
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: [hidden email]
List archives: http://news.gmane.org/gmane.mail.squirrelmail.user
List info (subscribe/unsubscribe/change options): https://lists.sourceforge.net/lists/listinfo/squirrelmail-users
Reply | Threaded
Open this post in threaded view
|

Re: change_sqlpass plugin

Paul Lesniewski
> 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: [hidden email]
List archives: http://news.gmane.org/gmane.mail.squirrelmail.user
List info (subscribe/unsubscribe/change options): https://lists.sourceforge.net/lists/listinfo/squirrelmail-users