similar to: samba password mysql

Hi all, I am trying to display collective data from 3 MySQL tables: The query I have, so far, is SELECT c . * , COUNT( m.id ) AS `members` FROM `jos_mls_teams` AS `c` LEFT JOIN `jos_mls_teams_members` AS `m` ON m.teamid = c.id RIGHT JOIN ( SELECT u.name, u.lastvisitDate FROM `jos_users` AS `u` ) ON u.id = m.userid GROUP BY c.id LIMIT 0 , 30 But get the following error: #1248 - Every derived

Greetings, I am trying to add the second virtual mailbox domain (transco.org.au) to an existing Postfix/Dovecot/MySQL mail server. Users of the first virtual mailbox domain (transylvania.org.au) have no problems sending and receiving mail. Users belonging to the second virtual mailbox domain can successfully send mail to outside, however they won't receive the mail, though Postfix

Hello- Sorry if this is a noob question, but I cant seem to get my password_query to work with dovecot + mysql. Im using 'Password verification by SQL server' at: http://wiki2.dovecot.org/AuthDatabase/SQL trying to modify it to work with my encrypted passwords in the DB. Im using the following which isnt working: password_query = SELECT NULL AS password, \ 'Y' as

Hi everybody , Since my version 1.2. I have a problem with the management of quotas. select * from virtual_users; +----+-----------+----------------------------------+---------------------------+----------+----------------+ | id | domain_id | password | email | quota_kb | quota_messages |

Hi, I configured dovecot IMAP for MySQL authentification. --- start dovecot.conf --- auth_userdb = mysql /etc/dovecot/dovecot-mysql.conf auth_passdb = mysql /etc/dovecot/dovecot-mysql.conf --- end dovecot.conf --- --- start dovecot-mysql.conf --- db_host = localhost db_port = 3306 db_unix_socket = /var/run/mysqld/mysqld.sock db = users db_user = users db_passwd = xxx db_client_flags = 0

Hi! I'm playing with a postfix + dovecot + mysql test setup, and noticed something strange. It seems that despite the "username changed" line, auth returns the original username: Apr 17 09:27:34 imap21 dovecot: quota-status: Debug: Loading modules from directory: /usr/lib64/dovecot (...) Apr 17 09:27:34 imap21 dovecot: auth-worker(27661): Debug: sql(ppp at example.net): SELECT

Hi, after deciding to use Dovecot 2.0.8 as a postfix LDA using mysql DB I'm running into some issues. I started to follow, http://wiki.dovecot.org/HowTo/DovecotLDAPostfixAdminMySQL but noticed that the auth settings on the config changed, after looking through the dovecot wiki I think I have that issue fixed. However I still can't get the SQL part to work right, below is what I have on the

Hello list, I was able to get passive mode worked out. I'm really glad I was able to do this. I'm able to log into the ftp server, list directories, enter subdirectories and upload/download files. However my next task is to enable virtual users using mysql. I have installed proftpd-mysql and enabled the sql modules in the config. I found a good article on how to do this here:

Hello all: I am trying to use the mysql command to retrieve information from a mysql database. my example here was formed from using the wiki reference to using the mysql command. The problem is with the fetch command. Here is the macro code: Mysql(QueryString=SELECT\ ivr-password\ from\ users\ where\ ivr-id=${userid}) Mysql(Query r ${connid} ${QueryString}) Mysql(Fetch fetchid ${r} dbuserpass)

Hi, I'm quite new to dovecot but already quite satisfied. Your documentation in the wiki is great but on quota + mysql it is not very clear. Because of the previously mentioned I have got the following note to make which you will hopefully use to adjust your wiki documentation on per-user-quota + mysql. I've searched your mail archive as good as possible and found no messages on this. If

Dear All, I seem to have stumbled across an AGI problem; I have written an AGI Script (bottom of this email); The script does the following; Makes a CDR entry when called Records the call Updates the CDR Finds a corresponding DNIS from the SMDR table (captured via a serial port logger) Matches up the record and updates the CDR. The script works perfectly in my test lab and has been doing so

In my (limited) experience R is more powerful concerning data manipulation. An example: I have a vector holding a user id. Some user ids can appear more than once. Doing SELECT COUNT(DISTINCT userid) on MySQL will take approx. 15 min. Doing length(unique(userid)) will take (almost) no time... So I think the other way round will serve best: Do everything in R and avoid using SQL on the database...

Version: Dovecot 2.0 rc2 I'm testing Dovecot with MySQL quotas but I get always this error for incoming mails: tux dovecot: lmtp(4928): Error: user testuser at dlutt.de: Auth USER lookup failed tux dovecot: auth: Error: mysql: Query failed, retrying: Unknown column 'username' in 'where clause' I dont' know where the field "username" should come from because I

I use dovecot version 1.2.15 and i put quota for all users , now i want to give more size for some emails , i already added the quota to user database , and i added the queries from http://wiki.dovecot.org/Quota/1.1 MySQL: user_query = select uid, gid, home, \ concat('*:bytes=', quota_bytes) as quota_rule \ from users where userid = '%u' # MySQL with userdb prefetch: Remember

Hi, I have a mysql table with fields userid,track,frequency e.g u1,1,10 u1,2,100 u1,3,110 u1,4,200 u1,5,120 u1,6,130 . u2,1,23 . . where "frequency" is the number of times a music track is played by a "userid" I need to turn my 'frequency' table into a rating table (it's for a recommender system). So, for each user, I need to categorise the frequency of tracks

Hi all, I have been putting a small (simple?)dedicated email server together to (ultimately) host a couple of domains. I am currently getting the configuration to work with one domain w/local mbox users and then plan to extend it to virtual users and an additional domain. Dovecot has been a problem to integrate in the configuration. The basic pieces are FC5, Postfix, Dovecot, with

<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"> <html> <head> <meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type"> </head> <body bgcolor="#ffffff" text="#000000"> <pre>Hi, &nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbspI'm running Dovecot v.

Hi I am finishing my mail server config and just trying to get the mysql login working - it fails to connect and thorws the following error Mar 21 21:58:21 mail0 authdaemond: failed to connect to mysql server (server=localhost, userid=courier): Can't connect to local MySQL server through socket '/tmp/mysql.sock.' (2) Mar 21 21:58:21 mail0 couriertcpd: LOGIN FAILED, user=tom at

Hi all, I''m just starting out... the solution to this must be really trivial but can''t figure out what''s wrong. I''m using Webrick + Rails 1.0 The error is: undefined method `useremail'' error What am I missing? Thanks, Lorenzo class User < ActiveRecord::Base set_table_name "\"tblUser\"" set_primary_key

Greetings! It is premature for me to send out a "success procedure for migration" yesterday. I overlooked things and I appologize for to this group. Anyway, after migration, computers, users, groups are all created and filled up with the correct membership. However, I still have the same problem with machine password and user password. Further looking into the detail, it looks