Re: [CentOS] Use postfix and spamd on CentOS 6 - looking for a shortest guide

2014-08-12 Thread Alexander Farber
Hello again, here is my solution on how to use Postfix + Spamassassin on CentOS in 4 steps: 1) yum install spamassassin 2) useradd spam 3) Add the following line to /etc/postfix/header_checks: /^Subject: \[SPAM\]/ DISCARD 4) Add the following lines to /etc/postfix/master.cf: smtp

[CentOS] Use postfix and spamd on CentOS 6 - looking for a shortest guide

2014-08-11 Thread Alexander Farber
Hello fellow CentOS-users, on the net there are lots of Spamassassin related HOWTOs - describing how to create a shell script for Postfix and how to install Spamassassin and start its spamd daemon - step by step. Additionally antivirus setups are described... But I have a strong feeling, that

Re: [CentOS] Use postfix and spamd on CentOS 6 - looking for a shortest guide

2014-08-11 Thread Alexander Farber
scratch. (Unless I have misunderstood your question, then I am sorry). Regards Alex On Mon, Aug 11, 2014 at 1:04 PM, Adam King ki...@sghs.org.uk wrote: whats your database user in spamd.conf? - Original Message - From: Alexander Farber alexander.far...@gmail.com So I have installed

Re: [CentOS] Use postfix and spamd on CentOS 6 - looking for a shortest guide

2014-08-11 Thread Alexander Farber
Hello again, here is what I'm trying at my CentOS 6.5: 1) Installed postfix and spamassassin packages 2) Configured postfix - it works well (I omit details here) 3) Added -x to the SPAMDOPTIONS in /etc/sysconfig/spamassassin 4) Added the following 2 lines to the /etc/postfix/master.cf: smtp

[CentOS] How to update MySQL with CentOS 6 in most unintrusive way - in regard to perl and PHP packages

2014-08-05 Thread Alexander Farber
Dear fellow CentOS users, for my few hobby projects (web games + forums) I have been using CentOS 5 (then 6) with Drupal and PostgreSQL plus few custom PHP and Perl scripts written by mysef. Since PostgreSQL version delivered with CentOS package has been a bit dated, I always used the PGDG

Re: [CentOS] don't use centos 7 as a developer workstation

2014-08-04 Thread Alexander Farber
Oh noes, are sed and gzip not included? On Sun, Aug 3, 2014 at 1:19 PM, Farkas Levente lfar...@lfarkas.org wrote: Don't use CentOS 7 as a developer workstation since currently there is not included any developer IDE. ___ CentOS mailing list

Re: Air apps easily decompiled and hacked

2014-02-28 Thread Alexander Farber
Yes, Justin, you can see, but there is nothing secret there :-) The app secret is used to build a query to Facebook/etc. to get data. The app secret is appended to the query string and a hash is produced. If you sniff the resulting hashed data from the network - you win nothing as attacker.

Re: Air apps easily decompiled and hacked

2014-02-27 Thread Alexander Farber
Facebook - yes you can The 3 other social networks I mentioned - no you can't On Fri, Feb 28, 2014 at 12:17 AM, Doug McCune d...@dougmccune.com wrote: Here's the relevant part directly from the Facebook docs: Therefore the App Secret or an App Access token should never be included in any

Re: Air apps easily decompiled and hacked

2014-02-25 Thread Alexander Farber
-1 since someone can take your app, decompile it, comment/shortcircuit the IAP/DRM and compile it back - as a cracked version... Or if you use any OAuth stuff - find the secret inside the app and then use it to impersonate other users. On Thu, Feb 20, 2014 at 1:59 AM, Joseph Balderson

Re: Air apps easily decompiled and hacked

2014-02-25 Thread Alexander Farber
You can't keep OAuth secret or any other secrets at the server side. If you keep it there, your app needs to download it - then the attacker can do it as well. You need something secret to be at the app. And the ease of decomilation doesn't help there.

Re: Air apps easily decompiled and hacked

2014-02-25 Thread Alexander Farber
Hello, On Tue, Feb 25, 2014 at 3:07 PM, Tom Chiverton t...@extravision.com wrote: On 25/02/2014 13:44, Alexander Farber wrote: And there was no way to store the OAuth app secret string on the server. And thus I know that my app is vulnerable (for impersonation of other users) and the ease

Re: Air apps easily decompiled and hacked

2014-02-25 Thread Alexander Farber
Hello Alex and Tom, I am not sure, where native apps hold the app secret for the OAuth. For Facebook you can use its native Android/iOS SDKs... But for other social networks you have to use the OAuth flow. I was just trying to make the point that sometimes you don't have other options than to

Re: Do not send mails to addresses with more than 3 dots in username part

2013-11-23 Thread Alexander Farber
Hello Peter and others, On Sat, Nov 23, 2013 at 1:38 AM, Peter pe...@pajamian.dhs.org wrote: On 11/23/2013 12:38 AM, Alexander Farber wrote: /etc/postfix/header_checks: /^To: \S+\.\S+\.\S+\.\s...@gmail.com mailto:s...@gmail.com$/i DISCARD /etc/postfix/main.cf http://main.cf

Re: Do not send mails to addresses with more than 3 dots in username part

2013-11-23 Thread Alexander Farber
Does this doc really apply to my situation? (I'd like to discard some of the mails sent out by my CMS) On Sat, Nov 23, 2013 at 11:42 AM, tejas sarade tejas.a.sar...@gmail.comwrote: http://www.postfix.org/SMTPD_ACCESS_README.html Regards Alex

Re: Do not send mails to addresses with more than 3 dots in username part

2013-11-23 Thread Alexander Farber
/virtual On Sat, Nov 23, 2013 at 3:16 PM, tejas sarade tejas.a.sar...@gmail.comwrote: I would like to know current recipient restrictions. What is the output of following command. grep smtpd_recipient_restrictions /etc/postfix/main.cf On Sat, Nov 23, 2013 at 4:43 PM, Alexander Farber

Re: Do not send mails to addresses with more than 3 dots in username part

2013-11-23 Thread Alexander Farber
postconf |grep smtpd_recipient_restrictions smtpd_recipient_restrictions = permit_mynetworks, reject_unauth_destination

Re: Do not send mails to addresses with more than 3 dots in username part

2013-11-23 Thread Alexander Farber
I see, thanks to you both! The #danger doc not probably doesn't apply here, but still good to know.

Do not send mails to addresses with more than 3 dots in username part

2013-11-22 Thread Alexander Farber
Hello, I run a Drupal 7 website on a CentOS 6.4 server with postfix-2.6.6-2.2.el6_1.x86_64. In the last few months the amount of fake users trying to register at my website has increased dramatically - I get 2 or 3 of such registrations per minute. Mostly they have fake mail adresses with many

Re: Do not send mails to addresses with more than 3 dots in username part

2013-11-22 Thread Alexander Farber
Should I use smtp_header_checks here? I have also asked the question at http://serverfault.com/questions/556723/silently-drop-outgoing-mails-to-us-er-n-a-megmail-com-more-than-3-dots-in-user (And I apologize for my mail being not in plain text - I use Gmail and they have changed their interface

Re: Do not send mails to addresses with more than 3 dots in username part

2013-11-22 Thread Alexander Farber
On Fri, Nov 22, 2013 at 10:45 AM, li...@rhsoft.net li...@rhsoft.net wrote: problems needs to be solved on the root cause not worked around somewhere else No, at the moment I am looking for the Postfix workaround. I'd like my postfix to drop OUTGOING mail silently if addressed to

Re: Do not send mails to addresses with more than 3 dots in username part

2013-11-22 Thread Alexander Farber
I think I'd like to use smtp_header_checks with DISCARD action - but http://postfix.org/header_checks.5.html says such a combination is not supported?

Re: Do not send mails to addresses with more than 3 dots in username part

2013-11-22 Thread Alexander Farber
Hello, I know regexes well - but can't figure out, where to applly them in Postfix, since smtp_header_checks with DISCARD action seems not to be supported with OUTGOING mail? On Fri, Nov 22, 2013 at 11:22 AM, Robert Schetterer r...@sys4.de wrote: Am 22.11.2013 10:48, schrieb Alexander Farber

Re: Do not send mails to addresses with more than 3 dots in username part

2013-11-22 Thread Alexander Farber
Thanks, I agree with all general advices... But for now I just want to stop the flood (and also Drupal is difficult to modify for me + I don't want to add CAPTCHA to my already overloaded reg. form, etc., etc.). So the following seems to work for me for now - /etc/postfix/header_checks: /^To:

Re: Do not send mails to addresses with more than 3 dots in username part

2013-11-22 Thread Alexander Farber
I admin this website for 3 years already and despite it being just a small obscure card game - there haven't been a month without a challenge, where I had to go and change something manually. This postfix workaround is pretty perfect for now, I enjoy looking at maillog right now and see the Nov

Re: Do not send mails to addresses with more than 3 dots in username part

2013-11-22 Thread Alexander Farber
Yes, Reindl, thanks again for all these _obvious_ advices, while I was just asking a specific Postfix-related one. On Fri, Nov 22, 2013 at 1:03 PM, li...@rhsoft.net li...@rhsoft.net wrote: my last post in this thread because we are going off-topic discard messages on a MTA is the *last

Re: Do not send mails to addresses with more than 3 dots in username part

2013-11-22 Thread Alexander Farber
I've spent last 2 hours with Drupal CAPTCHA module - the default image and math captchas didn't stop any spam user at all - I could see fake users still registering - every few seconds (scary!). I have uploaded a russian font then and configured the CAPTCHA to use russian letters only (since my

Re: Do not send mails to addresses with more than 3 dots in username part

2013-11-22 Thread Alexander Farber
Yes, ok - it's my fault. Next time I will ask a Postfix question here, I shouldn't forget to add a disclaimer and please no CMS or web admin advice needed ;-)

[GENERAL] Tuning 9.3 for 32 GB RAM

2013-11-14 Thread Alexander Farber
Hello, do these changes please look okay for a PostgreSQL 9.3 running on CentOS 6.4 server with 32 GB RAM (with Drupal 7 and few custom PHP scripts) postgresql.conf: shared_buffers = 4096MB work_mem = 32MB checkpoint_segments = 32 log_min_duration_statement = 1 sysctl.conf:

Re: [GENERAL] Tuning 9.3 for 32 GB RAM

2013-11-14 Thread Alexander Farber
Hello, my problem with http://wiki.postgresql.org/wiki/Tuning_Your_PostgreSQL_Server is that it never mentions larger amounts of RAM, so while reading it I always wonder how up-to-date it is...

Re: [GENERAL] Tuning 9.3 for 32 GB RAM

2013-11-14 Thread Alexander Farber
And pgtune is 4 years old...

Re: [GENERAL] Tuning 9.3 for 32 GB RAM

2013-11-14 Thread Alexander Farber
wal_buffers = 8MB checkpoint_segments = 16 shared_buffers = 7680MB max_connections = 80 Is it really okay? Isn't 22GB too high? And how does it know that max_connections =80 is enough in my case? (I use pgbouncer). Regards Alex On Thu, Nov 14, 2013 at 4:04 PM, Alexander Farber alexander.far

[GENERAL] Can't find /var/lib/pgsql/9.3/data/global/pg_auth

2013-11-13 Thread Alexander Farber
Hello, on CentOS 6.4 I'm moving from 8.4 to 9.3, but can not find the file /var/lib/pgsql/9.3/data/global/pg_auth which I need for the pg_bouncer. Does anybody please know where to find that file? My packages: postgresql93-9.3.1-1PGDG.rhel6.x86_64 pgdg-centos93-9.3-1.noarch

Re: [GENERAL] Can't find /var/lib/pgsql/9.3/data/global/pg_auth

2013-11-13 Thread Alexander Farber
, Alexander Farber wrote: on CentOS 6.4 I'm moving from 8.4 to 9.3, but can not find the file /var/lib/pgsql/9.3/data/global/pg_auth which I need for the pg_bouncer. Does anybody please know where to find that file? It was removed about 4 years before. You can use mkauth.py to generate the auth

[CentOS] Tuning MySQL - what's the best place for mysqld parameters?

2013-11-11 Thread Alexander Farber
Hello CentOS users, for a Wordpress website I have installed mysql-server-5.1.69-1.el6_4.x86_64 and run /usr/bin/mysql_secure_installation on a CentOS 6.4 machine with mucho RAM (32 GB) and I wonder, what would be the best place for the mysqld parameters descibed at

Re: Interactive Fullscreen since FlashPlayer 11.3

2013-09-20 Thread Alexander Farber
Yes and check this workaround: http://stackoverflow.com/questions/18558443/full-screen-interactive-mode-the-allow-button-click-is-passed-to-the-applicat On 9/19/13, Krüger, Olaf okrue...@edscha.com wrote: Since FlashPlayer 11.3 full keyboard input is possible in fullscreen mode and that's

[CentOS] How to use watchdog daemon with hardware watchdog driver interface?

2013-09-18 Thread Alexander Farber
Good morning! On a CentOS 6.4 / 64 bit server I have installed the watchdog 5.5 package. The rpm -qi watchdog states: The watchdog program can be used as a powerful software watchdog daemon or may be alternately used with a hardware watchdog device such as the IPMI hardware watchdog driver

Re: [CentOS] How to use watchdog daemon with hardware watchdog driver interface?

2013-09-18 Thread Alexander Farber
Hello Steve, yes, I have that device: # ll /dev/watchdog crw-rw 1 root root 10, 130 Sep 17 23:21 /dev/watchdog # ps uawwx|grep w[a]tchdog root 6 0.0 0.0 0 0 ?SSep17 0:00 [watchdog/0] root10 0.0 0.0 0 0 ?SSep17 0:00

[CentOS] MySQL 5.1.69 at CentOS 6.4 doesn't know enable-named-pipe?

2013-09-13 Thread Alexander Farber
Hello, I've only had experience with PostgreSQL sofar, but have now to install MySQL (and WordPress) on a CentOS 6.4 /64 bit server. I have installed the mysql-5.1.69-1.el6_4.x86_64 package and executed the following commands: # chkconfig mysqld on # service mysqld start # /usr/bin/mysqladmin

Re: [CentOS] MySQL 5.1.69 at CentOS 6.4 doesn't know enable-named-pipe?

2013-09-13 Thread Alexander Farber
Thank you, that was it. I didn't realize mysqld-nt means Windows only ___ CentOS mailing list CentOS@centos.org http://lists.centos.org/mailman/listinfo/centos

Re: [visualization-api] Re: Hide a row (aka series) in Google chart

2013-09-03 Thread Alexander Farber
That's done by the hideColumn() in my code, where i is a series number. -- You received this message because you are subscribed to the Google Groups Google Visualization API group. To unsubscribe from this group and stop receiving emails from it, send an email to

Re: FULL_SCREEN_INTERACTIVE mode: the ³Allow² button click is passed to the application

2013-09-02 Thread Alexander Farber
Hello Alex, http://stackoverflow.com/questions/18558443/full-screen-interactive-mode-the-allow-button-click-is-passed-to-the-applicat Someone on StackOverflow suggested the FullScreenEvent? Did you try that? I will try that, do you please have an advice on what component in Flex suits best to

Re: JSON to XML

2013-09-02 Thread Alexander Farber
Perl is a good tool for that :-)

FULL_SCREEN_INTERACTIVE mode: the “Allow” button click is passed to the application

2013-09-01 Thread Alexander Farber
Hello fellow Flex users, has anybody already struggled with the Allow button click being (wrongly) passed to the Flex web application as described at http://stackoverflow.com/questions/18558443/full-screen-interactive-mode-the-allow-button-click-is-passed-to-the-applicat Maybe I could put a

[CentOS] Make server reboot by itself instead of dropping to kernel debugger

2013-08-23 Thread Alexander Farber
Hello, on OpenBSD if you put ddb.panic=0 into /etc/sysctl.conf, the server won't drop into debugger on kernel panic. Is there please a similar setting for CentOS 6.4 / 64 bit? The background is that I have a new dedicated server with Haswell CPU and once a month it is stuck, displaying kernel

Re: [CentOS] Make server reboot by itself instead of dropping to kernel debugger

2013-08-23 Thread Alexander Farber
I've ended up doing this (hope it's valid for CentOS 6.4): # echo 10 /proc/sys/kernel/panic # echo kernel.panic=10 /etc/sysctl.conf ___ CentOS mailing list CentOS@centos.org http://lists.centos.org/mailman/listinfo/centos

Re: [CentOS] Make server reboot by itself instead of dropping to kernel debugger

2013-08-23 Thread Alexander Farber
Thank you, I have this # dmesg|grep -i watch NMI watchdog enabled, takes one hw-pmu counter. iTCO_wdt: Intel TCO WatchDog Timer Driver v1.07rh do you have any tips or doc pointers? ___ CentOS mailing list CentOS@centos.org

Re: [CentOS] Make server reboot by itself instead of dropping to kernel debugger

2013-08-23 Thread Alexander Farber
Ok, sorry - I've found the man watchdog and man watchdog.conf ___ CentOS mailing list CentOS@centos.org http://lists.centos.org/mailman/listinfo/centos

Re: [CentOS] Make server reboot by itself instead of dropping to kernel debugger

2013-08-23 Thread Alexander Farber
I am not sure though, if I need to start the watchdog daemon at all - because I altready have these lines in my dmesg: iTCO_vendor_support: vendor-support=0 iTCO_wdt: Intel TCO WatchDog Timer Driver v1.07rh iTCO_wdt: Found a Lynx Point TCO device (Version=2, TCOBASE=0x1860) iTCO_wdt: initialized.

[jira] [Created] (FLEX-33660) ensureIndexIsVisible() does not work for spark.components.List

2013-08-10 Thread Alexander Farber (JIRA)
Alexander Farber created FLEX-33660: --- Summary: ensureIndexIsVisible() does not work for spark.components.List Key: FLEX-33660 URL: https://issues.apache.org/jira/browse/FLEX-33660 Project: Apache

[jira] [Updated] (FLEX-33660) ensureIndexIsVisible() does not work for spark.components.List

2013-08-10 Thread Alexander Farber (JIRA)
[ https://issues.apache.org/jira/browse/FLEX-33660?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Alexander Farber updated FLEX-33660: Description: The method ensureIndexIsVisible() does not really work, when an item has been

[jira] [Updated] (FLEX-33660) ensureIndexIsVisible() does not work for spark.components.List

2013-08-10 Thread Alexander Farber (JIRA)
[ https://issues.apache.org/jira/browse/FLEX-33660?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Alexander Farber updated FLEX-33660: Description: The method ensureIndexIsVisible() does not really work, when an item has been

[jira] [Updated] (FLEX-33660) ensureIndexIsVisible() does not work for spark.components.List

2013-08-10 Thread Alexander Farber (JIRA)
[ https://issues.apache.org/jira/browse/FLEX-33660?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Alexander Farber updated FLEX-33660: Description: The method ensureIndexIsVisible() does not really work, when an item has been

[GENERAL] Syntax error at or near “on”

2013-07-14 Thread Alexander Farber
Hello! In PostgreSQL 8.4.13 why do I please get the syntax error ERROR: syntax error at or near on LINE: ... references balkan_users(id) check (id author) on delete ... for the following 2 statements? create table balkan_users ( id varchar(32) primary key, first_name

[GENERAL] Re: Syntax error at or near “on”

2013-07-14 Thread Alexander Farber
Nevermind, got the answer here: http://stackoverflow.com/questions/17638774/syntax-error-at-or-near-on -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

[CentOS] CentOS 6.4 with VMWare Fusion on MBA 2013

2013-07-12 Thread Alexander Farber
Hello, is anybody successfully using CentOS 6.4 with VMWare Fusion 5 on a Macbook? I have tried moving a CentOS 6.4 VM from VMWare Workstation on Win 7 (where it works well) to VMWare Fusion on a Macbook Air (2013) and when it boots it says: Detected CPU family 6 model 69 unsupported

Re: [visualization-api] How to make a SERIES line dashed in Google Line Chart?

2013-06-26 Thread Alexander Farber
Hello Sergey and others, On Wed, Jun 26, 2013 at 3:46 PM, Sergey Grabkovsky gra...@google.comwrote: Hi! I'm not entirely sure why you say that the certainty role doesn't work for you, since it works on a per-series basis. Here is a jsfiddle that shows this with your data

[GENERAL] Calculate a quotient for a count of boolean values (true or false)

2013-06-11 Thread Alexander Farber
Hello! In a PostgreSQL 8.4.13 why doesn't this please deliver a floating value (a quotient between 0 and 1): select id, count(nullif(nice, false)) - count(nullif(nice, true)) / count(nice) as rating from pref_rep where nice is not null group by id ; id

Re: [GENERAL] Calculate a quotient for a count of boolean values (true or false)

2013-06-11 Thread Alexander Farber
Hello, On Tue, Jun 11, 2013 at 11:59 AM, Alban Hertroys haram...@gmail.com wrote: Because you're calculating a - (b/c) instead of (a-b)/c On 11 June 2013 11:51, Alexander Farber alexander.far...@gmail.com wrote: http://stackoverflow.com/questions/17040692/calculate-a-quotient-in-one-table

Re: [visualization-api] Re: Hide a row (aka series) in Google chart

2013-06-06 Thread Alexander Farber
Hello Andrew, On Tue, Jun 4, 2013 at 7:13 PM, asgallant drew_gall...@abtassoc.com wrote: I wrote a hack that shows/hides series by clicking on legend labels (hidden series are greyed out in the legend): http://jsfiddle.net/asgallant/6gz2Q/. thank you for the code! Because I have multiple

Re: [visualization-api] Re: Interval role i-lines are not displayed in Google line chart

2013-05-31 Thread Alexander Farber
Thank you, yes, switching the columns has helped me and now in fact I'm struggling with the quotes: http://stackoverflow.com/questions/16859776/how-to-avoid-putting-quotes-around-numbers-with-perl-json-module It seems to me that it is a bug in Google charts: why do they misinterpret my numeric

Re: [visualization-api] Re: Interval role i-lines are not displayed in Google line chart

2013-05-31 Thread Alexander Farber
Yes, thank you, but this still doesn't work for float numbers :-( On Fri, May 31, 2013 at 4:52 PM, asgallant drew_gall...@abtassoc.com wrote: Most charts don't have a problem with it, but there are some that do. It is something the visualization team could certainly correct for, but

Re: [visualization-api] Re: Interval role i-lines are not displayed in Google line chart

2013-05-31 Thread Alexander Farber
Thank you! On Fri, May 31, 2013 at 5:34 PM, asgallant drew_gall...@abtassoc.com wrote: There is a javascript solution: for (var i = 0; i x.getNumberOfColumns(); i++) { if (x.getColumnType() == 'number') { for (var j = 0; j x.getNumberOfRows(); j++) { x.setValue(j,

Re: [GENERAL] Re: Matching uppercased russian words (\x0410-\x042F) in UTF8 database 8.4.13

2013-03-22 Thread Alexander Farber
Hello, unfortunately octal doesn't seem to work either - On Tue, Mar 19, 2013 at 7:03 PM, Tom Lane t...@sss.pgh.pa.us wrote: Alexander Farber alexander.far...@gmail.com writes: # select 'АБВГД' ~ '^[\u0410-\u042F]{2,}$'; WARNING: nonstandard use of escape in a string literal I think

[GENERAL] Referencing parts captured by round brackets in a regex in 8.4.13

2013-03-22 Thread Alexander Farber
Hello, how to get rid of this warning on a PostgreSQL 8.4.13 prompt? # select 'axyz' ~ '(.)\1\1'; WARNING: nonstandard use of escape in a string literal LINE 1: select 'axyz' ~ '(.)\1\1'; ^ HINT: Use the escape string syntax for escapes, e.g., E'\r\n'.

Re: [GENERAL] Referencing parts captured by round brackets in a regex in 8.4.13

2013-03-22 Thread Alexander Farber
Thank you, this works better, but - On Fri, Mar 22, 2013 at 3:57 PM, Rob Sargent robjsarg...@gmail.com wrote: On 03/22/2013 08:53 AM, Alexander Farber wrote: # select 'axyz' ~ '(.)\1\1'; WARNING: nonstandard use of escape in a string literal LINE 1: select 'axyz' ~ '(.)\1\1

Re: [GENERAL] Referencing parts captured by round brackets in a regex in 8.4.13

2013-03-22 Thread Alexander Farber
Thanks, I finally get it - this works fine: # select 'axyz' ~ E'(.)\\1\\1'; ?column? -- t (1 row) # select 'ОШИБББКА' ~ E'(.)\\1\\1'; ?column? -- t (1 row) -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription:

Re: [GENERAL] Re: Matching uppercased russian words (\x0410-\x042F) in UTF8 database 8.4.13

2013-03-22 Thread Alexander Farber
My insert trigger for 8.4.13 works now: http://sqlfiddle.com/#!11/c74a1/3 Thank you for you help -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

[GENERAL] Re: Matching uppercased russian words (\x0410-\x042F) in UTF8 database 8.4.13

2013-03-19 Thread Alexander Farber
\n'. ?column? -- f (1 row) On Tue, Mar 19, 2013 at 4:10 PM, Alexander Farber alexander.far...@gmail.com wrote: http://sqlfiddle.com/#!11/8a494/4 -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org

Re: [GENERAL] Using psql to feed a file line by line to a table column

2013-03-14 Thread Alexander Farber
Thank you - On Thu, Mar 14, 2013 at 10:40 AM, Ian Lawrence Barwick barw...@gmail.com wrote: I also have an INSERT trigger on my table, can I return a NULL from it or something similar? Yes, if you test for the presence of the word you can return NULL and the row will be discarded. See

Re: [GENERAL] Using psql to feed a file line by line to a table column

2013-03-13 Thread Alexander Farber
Thank you, this was indeed the (uneeded) semicolon at end of the COPY line. May I ask another question - On Tue, Mar 12, 2013 at 6:24 PM, Ian Lawrence Barwick barw...@gmail.com wrote: 2013/3/13 Alexander Farber alexander.far...@gmail.com: I have a list of 40 non-english words, each

[GENERAL] Using psql to feed a file line by line to a table column

2013-03-12 Thread Alexander Farber
Hello, I have a list of 40 non-english words, each on a separate line and in UTF8 format, which I'd like to put in the word column of the following table (also in UTF8 and 8.4.13): create table good_words ( word varchar(64) primary key, verified boolean not null default

Re: [GENERAL] Using psql to feed a file line by line to a table column

2013-03-12 Thread Alexander Farber
Unfortunately doesn't work - On Tue, Mar 12, 2013 at 5:53 PM, Ian Lawrence Barwick barw...@gmail.com wrote: 2013/3/13 Alexander Farber alexander.far...@gmail.com: I have a list of 40 non-english words, each on a separate line and in UTF8 format, which I'd like to put in the word column

[GENERAL] Change owner for all tables in a database in one batch

2013-03-06 Thread Alexander Farber
Hello, by accident I have wrong owner for all tables in my 8.4.13 database: bukvy= select * from pg_tables where tableowner = 'skat'; schemaname | tablename | tableowner | tablespace | hasindexes | hasrules | hastriggers

Re: [GENERAL] Finding matching words in a word game

2013-03-06 Thread Alexander Farber
Thanks, will try that (the dumb approach) too :-) Still working on my dictionary (will be auto-generated by a script). On Wed, Mar 6, 2013 at 2:57 PM, Chris Angelico ros...@gmail.com wrote: words = {} for word in dictionary: # provide a dictionary somehow - maybe from a file/db

[GENERAL] Finding matching words in a word game

2013-03-05 Thread Alexander Farber
Hello, is there maybe a clever way of finding all possible words from a given set of letters by means of PostgreSQL (i.e. inside the database vs. scanning all database rows by a PHP script, which would take too long) - if the dictionary is kept in a simple table like: create table good_words (

Re: [GENERAL] Finding matching words in a word game

2013-03-05 Thread Alexander Farber
Or I could add integer columns 'a', 'b', ... ,'z' to the table On Tue, Mar 5, 2013 at 10:29 AM, Alexander Farber alexander.far...@gmail.com wrote: create table good_words ( word varchar(16) primary key, stamp timestamp default current_timestamp ); http://stackoverflow.com

[CentOS] Finding matching words in a word game

2013-03-05 Thread Alexander Farber
Hello, is there maybe a clever way of finding all possible words from a given set of letters by means of PostgreSQL (i.e. inside the database vs. scanning all database rows by a PHP script, which would take too long) - if the dictionary is kept in a simple table like: create table good_words (

Re: [CentOS] Finding matching words in a word game

2013-03-05 Thread Alexander Farber
I apologize - sent to a wrong mailing list! ___ CentOS mailing list CentOS@centos.org http://lists.centos.org/mailman/listinfo/centos

[GENERAL] Re: explain analyze a procedure verbosely - to find which statement in it takes longer

2013-02-07 Thread Alexander Farber
of its time in the pref_cards, thorugh the FK rid? Which index would be to add here best? Regards Alex On Wed, Feb 6, 2013 at 11:03 AM, Alexander Farber create or replace function pref_delete_user(_id varchar, _reason varchar) returns void as $BODY$ begin

[GENERAL] Re: explain analyze a procedure verbosely - to find which statement in it takes longer

2013-02-07 Thread Alexander Farber
for constraint pref_discuss_rid_fkey: time=115.801 calls=3022 Trigger for constraint pref_votes_rid_fkey: time=74.814 calls=3022 Total runtime: 1316.472 ms (8 rows) On Thu, Feb 7, 2013 at 11:34 AM, Alexander Farber alexander.far...@gmail.com wrote: # explain analyze delete from pref_rounds r

[GENERAL] explain analyze a procedure verbosely - to find which statement in it takes longer

2013-02-06 Thread Alexander Farber
Hello, I've read in the docs, that every table should better have primary key and so I've rearranged my 8.4.13 database: added primary keys to each table (some of the primary keys are pairs of columns) and dropped all other indices. And I've probably dropped few indices too many, because a

[GENERAL] Adding PRIMARY KEY: Table contains duplicated values

2013-02-04 Thread Alexander Farber
Hello, when trying to add a forgotten primary key pair to a PostgreSQL 8.4.13 table I get the error: # \d pref_rep Table public.pref_rep Column |Type | Modifiers

Re: [GENERAL] Adding PRIMARY KEY: Table contains duplicated values

2013-02-04 Thread Alexander Farber
Thank you - On Mon, Feb 4, 2013 at 3:26 PM, Andrew Jaimes andrewjai...@hotmail.com wrote: SELECT id, author, count(1) FROM pref_rep GROUP BY id, author HAVING count(1) 1 From: alexander.far...@gmail.com

Re: [GENERAL] Adding PRIMARY KEY: Table contains duplicated values

2013-02-04 Thread Alexander Farber
; ^ On Mon, Feb 4, 2013 at 3:36 PM, Alexander Farber alexander.far...@gmail.com wrote: http://stackoverflow.com/questions/14688523/adding-primary-key-table-contains-duplicated-values -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http

Re: [GENERAL] Adding PRIMARY KEY: Table contains duplicated values

2013-02-04 Thread Alexander Farber
Unfortunately that fails - On Mon, Feb 4, 2013 at 3:55 PM, Adrian Klaver adrian.kla...@gmail.com wrote: On 02/04/2013 06:45 AM, Alexander Farber wrote: Trying to delete the older of the duplicated pairs: How about: SELECT id, author, count(1), max(stamp) as maxx FROM pref_rep GROUP

Re: [GENERAL] Adding PRIMARY KEY: Table contains duplicated values

2013-02-04 Thread Alexander Farber
Thank you - On Mon, Feb 4, 2013 at 5:06 PM, Andreas Kretschmer akretsch...@spamfence.net wrote: # alter table pref_rep add primary key(id, author); NOTICE: ALTER TABLE / ADD PRIMARY KEY will create implicit index pref_rep_pkey for table pref_rep ERROR: could not create unique index

Re: [GENERAL] Optimizing select count query which often takes over 10 seconds

2013-01-31 Thread Alexander Farber
On Wed, Jan 30, 2013 at 2:06 PM, Kevin Grittner kgri...@ymail.com wrote: update pref_users set medals = 0 where medals 0; Thank you all for your insightful comments This has cured my cronjob -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your

Re: [GENERAL] Optimizing select count query which often takes over 10 seconds

2013-01-29 Thread Alexander Farber
Hello Kevin, On Wed, Jan 30, 2013 at 12:09 AM, Kevin Grittner kgri...@ymail.com wrote: Alexander Farber alexander.far...@gmail.com wrote: update pref_users set medals = 0; UPDATE 223456 You're probably going to like your performance a lot better if you modify that to: update pref_users

Re: [GENERAL] Optimizing select count query which often takes over 10 seconds

2013-01-27 Thread Alexander Farber
Hello - On Fri, Jan 25, 2013 at 7:42 PM, Jeff Janes jeff.ja...@gmail.com wrote: On Thu, Jan 24, 2013 at 1:57 AM, Alexander Farber alexander.far...@gmail.com wrote: LOG: duration: 12590.394 ms statement: select count(id) from ( select id, row_number

Re: [GENERAL] Optimizing select count query which often takes over 10 seconds

2013-01-24 Thread Alexander Farber
Hello - On Thu, Jan 24, 2013 at 3:39 PM, Alban Hertroys haram...@gmail.com wrote: On 24 January 2013 10:57, Alexander Farber alexander.far...@gmail.com wrote: # explain analyze select count(id) from ( select id, row_number() over(partition by yw order by money

PG_OLDQUERY_WAIT and pg_result

2013-01-21 Thread Alexander Farber
Hello, is calling pg_result() necessary, when using code like this? use constant SQL_OPTIONS = {pg_async = PG_ASYNC + PG_OLDQUERY_WAIT}; eval { my $dbh = DBI-connect_cached(DSN, DBUSER, DBPASS, { private_no_cache = __FILE__.__LINE__,

Re: [GENERAL] Sending several commands simultaneously to PostgreSQL 8.4

2013-01-21 Thread Alexander Farber
To make my question more concrete: if I'd like to round-robin 6 PostgreSQL connections from my Perl script - how should I change my code: eval { my $dbh = DBI-connect_cached(DSN, DBUSER, DBPASS, { AutoCommit = 1, PrintWarn = 1,

Re: [GENERAL] Sending several commands simultaneously to PostgreSQL 8.4

2013-01-21 Thread Alexander Farber
I would like to add a private key to make my dbh's different throughout my script: eval { my $dbh = DBI-connect_cached(DSN, DBUSER, DBPASS, { AutoCommit = 1, MY_PRIVATE_KEY = __FILE__.__LINE__, ### -- HERE

Re: Using postfix in CentOS 6 to relay mails to first.l...@gmail.com

2013-01-18 Thread Alexander Farber
Hello Wietse - On Wed, Jan 16, 2013 at 2:43 PM, Wietse Venema wie...@porcupine.org wrote: Alexander Farber: HOWEVER, there is one problem that you need to be aware of. If your machine forwards SPAM to gmail, then gmail will decide that your server is a spammer. Gmail may then file good mail

Re: Using postfix in CentOS 6 to relay mails to first.l...@gmail.com

2013-01-16 Thread Alexander Farber
Hello - On Tue, Jan 15, 2013 at 3:05 PM, Wietse Venema wie...@porcupine.org wrote: http://www.postfix.org/BASIC_CONFIGURATION_README.html with CentOS 6 I've ended up adding inet_interfaces = all virtual_alias_domains = videoskat.de balkan-preferans.de to /etc/postfix/main.cf and

Re: [CentOS] Using postfix in CentOS 6 to relay mails to first.l...@gmail.com

2013-01-16 Thread Alexander Farber
Hello - On Tue, Jan 15, 2013 at 3:05 PM, Wietse Venema wie...@porcupine.org wrote: http://www.postfix.org/BASIC_CONFIGURATION_README.html with CentOS 6 I've ended up adding inet_interfaces = all virtual_alias_domains = videoskat.de balkan-preferans.de to /etc/postfix/main.cf and

Using postfix in CentOS 6 to relay mails to first.l...@gmail.com

2013-01-15 Thread Alexander Farber
Hello, I'm using: # cat /etc/*release CentOS release 6.3 (Final) # rpm -qa | grep post postfix-2.6.6-2.2.el6_1.x86_64 on 2 servers: preferans.de and (yes, funny name) static.103.78.9.176.clients.your-server.de I own several domains and would like all incoming mails addressing those domains to

Re: Using postfix in CentOS 6 to relay mails to first.l...@gmail.com

2013-01-15 Thread Alexander Farber
Thanks for replying - On Tue, Jan 15, 2013 at 1:55 PM, Wietse Venema wie...@porcupine.org wrote: Alexander Farber: And have opened port 25 in the firewall: But now when I send a mail to s...@videoskat.de there is nothing to see in postfix logs: Nothing happens unless a connection is made

Re: Using postfix in CentOS 6 to relay mails to first.l...@gmail.com

2013-01-15 Thread Alexander Farber
Hello - On Tue, Jan 15, 2013 at 2:36 PM, Reindl Harald h.rei...@thelounge.net wrote: so the domain videoskat.de is not listed in your postfix config mydestination local_recipient_maps did you read any documentation or are you starting blindly from the centos-defaults and try to figure all

[CentOS] Using postfix in CentOS 6 to relay mails to first.l...@gmail.com

2013-01-15 Thread Alexander Farber
Hello fellow CentOS users, I'm using: # cat /etc/*release CentOS release 6.3 (Final) # rpm -qa | grep post postfix-2.6.6-2.2.el6_1.x86_64 on 2 servers: preferans.de and (yes, funny name) static.103.78.9.176.clients.your-server.de I own several domains and would like all incoming mails

<    1   2   3   4   5   6   7   8   9   10   >