similar to: Beginner: How to use data from external Database

Hello, I've got dovecot going with postfix and MySQL database for user and domain storage. Dovecot handles the authentication. My last login is not working, does anyone have a table example and configs? I looked at the wiki page on the lastlogin plugin but obviously what I'm doing isn't working, I keep getting message write was unsuccessful for the lastlogin ip. I'd appreciate

So I''ve worked through Agile Web Development with Rails and I''m now trying my first little app to get into the swing of things. Its a task tracking app where people can create tasks and assign them to others, and also log time against the tasks. I''m having trouble working out the model relationships. This is what I''ve got so far, but its not right as

hi all : mysql mailbox below : CREATE TABLE `mailbox` ( `username` varchar(255) NOT NULL DEFAULT '', `uid` varchar(255) NOT NULL DEFAULT '', `password` varchar(255) NOT NULL DEFAULT '', `clearpwd` varchar(128) NOT NULL DEFAULT '', `name` varchar(255) NOT NULL DEFAULT '', `mailhost` varchar(255) NOT NULL DEFAULT '', `maildir`

Hello, I have a partially working Realtime Queue using unixODBC and Firebird. I followed the steps on asterisk-guru and the voip-info asterisk message boards but have been having no success. I say that my queue is partially working because callers can join the queue. However the calls do not go to the agents even if the agent is not tied up and is available for calls. So the caller is stuck

Hi group, I try to write a frame to a table (RODBC). I use colnames(temp6) <- c("ind_id","ser_id","period_id","year","calc","mean") sqlSave(channel, temp6, tablename = "series_indices_test",append= TRUE, rownames=FALSE, verbose = FALSE, test = FALSE, nastring = -999999, fast = FALSE) This is giving me an error: Error in

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

Hi friends, I am migrating imap-courier to dovecot, I use openbsd+postfix+imap-courier, and now I'm trying to run openbsd+opensmtpd+dovecot. In the beginning it was a little traumante but it works OpenSMTPD correctly. Now I have configured dovecot, and I hope that your backend authorization is the same database that was used imap-courier. In /var/log/maillog receipt the following error

dovecot 1.0.15 Hello, i try to set quota settings for my users. currentyl i use a mysql table for auth process and now i want to add quotasettings for each individual user. at the moment i have the problem that only global quota is effective and no userquota which is stored in usertable. This is my mysql-usertable: login varchar(255) password varchar(64) home varchar(128) uid int(11) gid

I have the following two tables: create table teams ( id int not null auto_increment, short_name varchar(12) not null, long_name varchar(50) not null, logo varchar(20) not null, primary key (id) ); create table rounds ( id int not null auto_increment, home_team_id int not null, away_team_id int

Hi team, I''m a very newbie RoR user from Spain and I''m developing a blog''s CMS. Why RoR?, coz I think it''s an amazing framework with many posibilities, portable and really powerful, with a young and optimist community, and taking my project I''ve prefered his structure in front of LAMP. Another thing is that I''ve liked to surprise my masters

Hey all I've been running a Dovecot 1X server for awhile. Most of the config was pretty simple using flat files. I'm switching to Dovecot 2X now, and want to switch to using SQL for lookups so I can share info with the Postfix front end. For starters I setup two SIMPLE SQL tables -- a 'users' table and a 'aliases' table, where each user can have many aliases. I want to

Hi, I spent more than 4 days getting done with the "Four Days with Rails" tutorial, mostly because I ran into a few issues that seemed to stop me in my tracks.  But, after looking around, I was able to find the problems and solve them (in whatever way I thought best) :-) I''m posting the whole list of problems that I ran into with "Four Days with Rails" to the list so

Hi all, From the web, I can find a table scheme of sipusers for ARA using. However, I can't find any meaning of each field, especially for the field regserver which is new in the table. Can any tell me more detail about the usage of each field? CREATE TABLE `sip_buddies` ( `id` int(11) NOT NULL auto_increment, `name` varchar(80) NOT NULL default '', `host` varchar(31) NOT NULL

Hi all, I started playing a couple days ago with Rails and it find it very interesting. But I''m a bit stuck with making it work with a concatenated primary key. I want to use my own names for the DB fields and I''m using SQL Server 2005. My tables look roughly like this: CREATE TABLE USERS ( USR_ID VARCHAR(25) NOT NULL PRIMARY KEY, USR_PASS VARCHAR(25) ) CREATE TABLE

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

Hi All: I'd like to use Realtime Static in terms of the performance concern about dynamic realtime. Assume that I create a table: as following: CREATE TABLE `extensions_table` ( `id` int(11) NOT NULL auto_increment, `context` varchar(20) NOT NULL default '', `exten` varchar(20) NOT NULL default '', `priority` tinyint(4) NOT NULL default '0', `app` varchar(20)

Hi all - I have a Player model. The database looks like this: +-------------------+--------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +-------------------+--------------+------+-----+---------+----------------+ | id | int(11) | NO | PRI | NULL | auto_increment | | fname |

>From voicemail.conf: ; Maximum number of messages per folder. If not specified, a default value ; (100) is used. Maximum value for this option is 9999. ;maxmsg=100 ; Maximum length of a voicemail message in seconds ;maxmessage=180 ; Maximum length of greetings in seconds ;maxgreet=60 I would like to configure these parameters on a per mailbox basis using Realtime voicemail. I

Thanks for the input Blair Zajac and Chris (Nolan and Hall), and for others. If all of you have time, please follow this (the question still relates to the previous posts by me): I have provided full steps to reproduce the symptoms. If it matters, I''m running Ruby 1.8.2, Rails 1.0, and MySQL 5.0.15 on Windows XP Professional. 1. First, the setup MySQL ----- create database testdb;

I have defined a web service to return information from a database as follows. class BackendApi < ActionWebService::API::Base api_method :find_all_vobs, :returns => [[:int]] api_method :find_vob_by_id, :expects => [:int], :returns => [Vob] class BackendController < ApplicationController wsdl_service_name ''Backend''