similar to: tracking user activities on a site

I got it to work by changing scheduled_end_date= nil to self.scheduled_end_date= nil. I believe these statements should be equivilent. I don''t know Ruby/Rails well enough to know when, if or why that should matter. Can someone educate me please? I want to believe this framework is ready for production work, but silently dropping data is a very big problem. I expect that I''ve

hey friends, We are running 2 Centos servers 4.0 and 4.4 in our office for various activies like Mailing, Web Services, Database, CVS, FTP,Samba, Squid etc. We have about 100+ users on those servers , many users don't have shell on these servers (/sbin/nologin set as default shell) and some has shell (/bin/bash). We want to monitor the user activities of those users who have shell means

Hi everyone, I am desperately looking for a method to interpolate strings within an SQL statement as follows: I get a lot of rows out of a database (in my example POSITION_to_ZIPCODE Database with holds records for German ZIP Code <--> Gauss-Krueger Coordinate System ) and want this to be selected and computed individually row by row as follows: library(RODBC) channel <-

Hi, I am using Realtime for sip configuration. When there is an INVITE which arrives at asterisk asterisk makes the following selects: Nov 20 10:37:10] DEBUG[31852]: res_config_mysql.c:651 mysql_reconnect: MySQL RealTime: Everything is fine. [Nov 20 10:37:10] DEBUG[31852]: res_config_mysql.c:138 realtime_mysql: MySQL RealTime: Retrieve SQL: SELECT * FROM sip_conf WHERE name = 'tzl' [Nov

I got postfix and PostfixAdmin working and I am trying to get Dovecot to use the same SQL databases. This is all it says when I telnet in: [root at fedora dovecot]# telnet 192.168.1.200 143 Trying 192.168.1.200... Connected to 192.168.1.200. Escape character is '^]'. * BYE Disconnected: Auth process broken Connection closed by foreign host. [root at fedora dovecot]#

Hello, I am trying to get Dovecot 2.3.1 to track lastlogins of users. I'm using a MySQL database. When I log in I am getting this in the error log: 2018-04-02 18:24:21 imap(user at domain.com)<61855><6R0rDeVodcl/AAAB>: Error: last_login_dict: Failed to write value for user user at domain.com: dict-server returned failure: sql dict: commit failed: Field 'name' doesn't

Hello, I have a serious problem with dovecot and mbox format. dovecot returns the same UIDL for new messages and as result some MUAs don't retrieve new mail. UIDs returned by UIDL command look like 000000*1c*49006cec And there is a moment when dovecot stops incrementing marked digits. In other words when new message arrive to mbox, UIDL command returns used UID. I'll show with example:

Hello, I'm accessing a MySQL database from inside R and had a problem with a function. In the database, there is data from years 1985 to 2007 that I would like to retrieve. I can easily get the data from one year by the following: info1985=dbGetQuery(con, statement='the SQL query') Inside the statement, I have a column that is set to the desired year (e.g. table.column=1985) through

Hello, I would like to know if there is a SAMBA feature () that tracks users' login/logout (by name and not by IP address) accessing the shares. Maybe by using Unix command lines, do you know into which log files these information are stored in ? ie "Share ID" Date Time "Username" logged in "Share ID" Date Time "Username" logged off ? I tried

A new version of sqldf, version 0.2-0, has been uploaded to CRAN and should be available on most mirrors by now. NEW - works with the new version of DBI package, DBI 0.2-5. The default action of this version of DBI quotes those column names in select statements that are SQL reserved words (rather than appending __1 to them which was the previous default action). As a result it should no

A new version of sqldf, version 0.2-0, has been uploaded to CRAN and should be available on most mirrors by now. NEW - works with the new version of DBI package, DBI 0.2-5. The default action of this version of DBI quotes those column names in select statements that are SQL reserved words (rather than appending __1 to them which was the previous default action). As a result it should no

can anybody identify why the CLI is issuing a failure message while debug shows everything is fine???? this makes no sense to me. also, why is the username being updated? this has got to be wrong from CLI -- SIP Seeding '52221' at 52221@192.168.70.26:5060 for 3600 -- SIP Seeding '52221' at 52221@192.168.70.26:5060 for 3600 Dec 24 12:16:35 NOTICE[15776]:

Unfortunately logs files are generated in /var/log/samba but they are all empty, do you know the reason ? My smb.conf : [global] log level = 1 auth_audit:3 vfs:2 log file = /var/log/samba/log.%U.%m max log size = 1000 logging = syslog [Share] vfs objects = full_audit full_audit:prefix = %u|%I|%m|%P|%S full_audit:success = connect disconnect full_audit:success = mkdir rename unlink rmdir pwrite

Found the issue. In the association table (categories.products) it is very important to use lowercase column names. I.e, product_id and category_id. I had Product_id and Category_id in SQL.... Gildas -----Original Message----- From: rails-bounces-1W37MKcQCpIf0INCOvqR/iCwEArCW2h5@public.gmane.org [mailto:rails-bounces-1W37MKcQCpIf0INCOvqR/iCwEArCW2h5@public.gmane.org] On Behalf Of Cherruel,

Greetings. I have an application which is used to track jobs and payments. The billables table contains columns "job_date", "amount" and "receipt" which indicate the date of the job, the amount due and whether or not payment has been received, respectively. In addition to tracking and manipulating individual jobs, the application is also used to generate aggregate

Hi, I have a working asterisk 1.4.0 with Mysql Realtime configuration, and today I encountered this error. Now, I have no acces to any information in mysql realtime, so nothing work now !!!!! [Jan 24 10:32:40] DEBUG[31070] res_config_mysql.c: MySQL RealTime: Everything is fine. [Jan 24 10:32:40] DEBUG[31070] res_config_mysql.c: MySQL RealTime: Retrieve SQL: SELECT * FROM extensions

I have a standalone batch program that is going to move data between two databases. I am taking advantage of the AR connection semantics in database.yml to get connections to these two DBs. But I want to do all of my DB access at the DBI/DBD level for performance reasons. I am having trouble getting access to the underlying DBI handle so that I can prepare SQL statements, execute them etc.

Hello, I'm running dovecot 2.2 and trying to do last login tracking. I am using a MySQL database. When a user logs in I get this in the log: 2018-04-07 16:55:14 imap(user at example.com)<54415><BmevY0hpMN5/AAAB>: Error: last_login_dict: Failed to write value for user user at example.com: dict-server returned failure: sql dict: commit failed: Field 'name' doesn't have

Hi, I am trying to get * log to mssql server. I have odbc and freetds configured, but my insert query is missing calldate which is a NOT NULL field in database schema. cdr_adaptive_odbc: Insert failed on 'sqlserver:cdr'. CDR failed: INSERT INTO cdr (clid,src,dst,dcontext,channel,lastapp,lastdata,duration,billsec,disposition,amaflags,uniqueid) VALUES

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