Bug#904013: clamav-freshclam: it breaks also logcheck integration
Package: clamav-freshclam
Version: 0.102.4+dfsg-0+deb10u1
Followup-For: Bug #904013
Dear Maintainer,
logging the timestamp inside the message break also the logcheck rules.
For example the first logcheck (ignore.d.server) rule states:
^\w{3} [ :0-9]{11} [._[:alnum:]-]+ freshclam\[[0-9]+\]: ClamAV update process
started at .*$
But the message written in the logs is:
Aug 20 18:26:53 mail freshclam[15525]: Thu Aug 20 18:26:53 2020 -> ClamAV
update process started at Thu Aug 20 18:26:53 2020
As you can see, the timestamp written after the process id is NOT matched by
the logcheck rule.
You can solve the issue by altering all the rules, inserting a regexp to match
the timestamp as follows:
^\w{3} [ :0-9]{11} [._[:alnum:]-]+ freshclam\[[0-9]+\]: \w{3} \w{3} [ :0-9]{16}
-> ClamAV update process started at .*$
But the best thing, imho is to avoid printing the timestamp inside the message,
since rsyslog already writes the timestamp at the beginning of the log record.
Thanks,
Luca
-- Package-specific info:
--- configuration ---
Checking configuration files in /etc/clamav
Config file: clamd.conf
---
AlertExceedsMax disabled
PreludeEnable disabled
PreludeAnalyzerName = "ClamAV"
LogFile = "/var/log/clamav/clamav.log"
LogFileUnlock disabled
LogFileMaxSize = "4294967295"
LogTime = "yes"
LogClean disabled
LogSyslog disabled
LogFacility = "LOG_LOCAL6"
LogVerbose disabled
LogRotate = "yes"
ExtendedDetectionInfo = "yes"
PidFile disabled
TemporaryDirectory disabled
DatabaseDirectory = "/var/lib/clamav"
OfficialDatabaseOnly disabled
LocalSocket = "/var/run/clamav/clamd.ctl"
LocalSocketGroup = "clamav"
LocalSocketMode = "666"
FixStaleSocket = "yes"
TCPSocket disabled
TCPAddr disabled
MaxConnectionQueueLength = "15"
StreamMaxLength = "26214400"
StreamMinPort = "1024"
StreamMaxPort = "2048"
MaxThreads = "12"
ReadTimeout = "180"
CommandReadTimeout = "5"
SendBufTimeout = "200"
MaxQueue = "100"
IdleTimeout = "30"
ExcludePath disabled
MaxDirectoryRecursion = "15"
FollowDirectorySymlinks disabled
FollowFileSymlinks disabled
CrossFilesystems = "yes"
SelfCheck = "3600"
DisableCache disabled
VirusEvent disabled
ExitOnOOM disabled
AllowAllMatchScan = "yes"
Foreground disabled
Debug disabled
LeaveTemporaryFiles disabled
User = "clamav"
Bytecode = "yes"
BytecodeSecurity = "TrustSigned"
BytecodeTimeout = "6"
BytecodeUnsigned disabled
BytecodeMode = "Auto"
DetectPUA disabled
ExcludePUA disabled
IncludePUA disabled
ScanPE = "yes"
ScanELF = "yes"
ScanMail = "yes"
ScanPartialMessages disabled
PhishingSignatures = "yes"
PhishingScanURLs = "yes"
HeuristicAlerts = "yes"
HeuristicScanPrecedence disabled
StructuredDataDetection disabled
StructuredMinCreditCardCount = "3"
StructuredMinSSNCount = "3"
StructuredSSNFormatNormal = "yes"
StructuredSSNFormatStripped disabled
ScanHTML = "yes"
ScanOLE2 = "yes"
AlertBrokenExecutables disabled
AlertEncrypted disabled
AlertEncryptedArchive disabled
AlertEncryptedDoc disabled
AlertOLE2Macros disabled
AlertPhishingSSLMismatch disabled
AlertPhishingCloak disabled
AlertPartitionIntersection disabled
ScanPDF = "yes"
ScanSWF = "yes"
ScanXMLDOCS = "yes"
ScanHWP3 = "yes"
ScanArchive = "yes"
ForceToDisk disabled
MaxScanTime = "12"
MaxScanSize = "104857600"
MaxFileSize = "26214400"
MaxRecursion = "16"
MaxFiles = "1"
MaxEmbeddedPE = "10485760"
MaxHTMLNormalize = "10485760"
MaxHTMLNoTags = "2097152"
MaxScriptNormalize = "5242880"
MaxZipTypeRcg = "1048576"
MaxPartitions = "50"
MaxIconsPE = "100"
MaxRecHWP3 = "16"
PCREMatchLimit = "1"
PCRERecMatchLimit = "5000"
PCREMaxFileSize = "26214400"
OnAccessMountPath disabled
OnAccessIncludePath disabled
OnAccessExcludePath disabled
OnAccessExcludeRootUID disabled
OnAccessExcludeUID disabled
OnAccessExcludeUname disabled
OnAccessMaxFileSize = "5242880"
OnAccessDisableDDD disabled
OnAccessPrevention disabled
OnAccessExtraScanning disabled
OnAccessCurlTimeout = "5000"
OnAccessMaxThreads = "5"
OnAccessRetryAttempts disabled
OnAccessDenyOnError disabled
DevACOnly disabled
DevACDepth disabled
DevPerformance disabled
DevLiblog disabled
DisableCertCheck disabled
AlgorithmicDetection = "yes"
BlockMax disabled
PhishingAlwaysBlockSSLMismatch disabled
PhishingAlwaysBlockCloak disabled
PartitionIntersection disabled
OLE2BlockMacros disabled
ArchiveBlockEncrypted disabled
Config file: freshclam.conf
---
LogFileMaxSize = "4294967295"
LogTime = "yes"
LogSyslog disabled
LogFacility = "LOG_LOCAL6"
LogVerbose disabled
LogRotate = "yes"
PidFile disabled
DatabaseDirectory = "/var/lib/clamav"
Foreground disabled
Debug disabled
UpdateLogFile = "/var/log/clamav/freshclam.log"
DatabaseOwner = "clamav"
Checks = "24"
DNSDatabaseInfo = "current.cvd.clamav.net"
DatabaseMirror = "db.local.clamav.net", "database.clamav.net"
PrivateMirror disabled
MaxAttempts = "5"
ScriptedUpdates = "yes"
TestDatabases = "yes"
CompressLocalDatabase disabled
ExtraDatabase disabled
ExcludeDatabase disabled
DatabaseCustomURL disabled
HTTPProxyServer disabled
Bug#683666: RFH: gradle -- Groovy based build system
Hi there, I'm not a debian developer, but we use gradle for the everyday job in our company. Let me know if I can help. Regards, Luca
Bug#700851: logcheck-database: postfix ignore.d.server now logs on the same line sasl_method, sasl_username AND sasl_sender, rule must be updated
Package: logcheck-database
Severity: normal
postfix has changed log formats, now it includes sasl_sender in log lines.
The rule at ./ignore.d.server/postfix:109
^\w{3} [ :[:digit:]]{11} [._[:alnum:]-]+ postfix/smtpd\[[[:digit:]]+\]:
[[:alnum:]]+: client=[^[:space:]]+, sasl_method=[-[:alnum:]]+,
sasl_username=[-_.@[:alnum:]]+$
must be updated with:
^\w{3} [ :[:digit:]]{11} [._[:alnum:]-]+ postfix/smtpd\[[[:digit:]]+\]:
[[:alnum:]]+: client=[^[:space:]]+, sasl_method=[-[:alnum:]]+,
sasl_username=[-_.@[:alnum:]]+, sasl_sender=[-_.@[:alnum:]]+$
-- System Information:
Debian Release: 6.0.6
APT prefers stable-updates
APT policy: (500, 'stable-updates'), (500, 'stable')
Architecture: amd64 (x86_64)
Kernel: Linux 2.6.32-5-amd64 (SMP w/4 CPU cores)
Locale: LANG=en_US.UTF-8, LC_CTYPE=en_US.UTF-8 (charmap=UTF-8)
Shell: /bin/sh linked to /bin/dash
--
To UNSUBSCRIBE, email to debian-bugs-dist-requ...@lists.debian.org
with a subject of "unsubscribe". Trouble? Contact listmas...@lists.debian.org
Bug#597286: pgadmin: cannot change ownership of db object on a schema other than public
Package: pgadmin3 Version: 1.8.4-3 Severity: normal File: pgadmin I log-in into a DB server as supaeruser (postgres, I mean). I open a database, and point an object THAT IS NOT ON PUBLIC SCHEMA (for example a table "my_table" on the schema "my_schema"). I right-click on it and try to change owner (let's say that the original owner was "my_owner" and I try to set to "other_owner"). If "my_schema" is not on search_path of postgres user, pgadmin complains that "my_table" doesn't exists. I guess that, when working with objects out of search path, pgadmin shoud prefix them with schema name, that is, it should not issue the command: ALTER TABLE my_table OWNER TO other_owner; (it fails because my_table is out of search path) but ALTER TABLE my_schema.my_table OWNER TO other_owner; (it works, since it was specified table full path) Note that the first command works fine if issued from a sql window, because (I guess) it changes search_path before opening the session. Quick hack: alter search path of postgres user setting it to my_schema, then logout and login again. Now the command works. Remember to set back the search path of postgres user before quitting. Regards, Luca Arzeni -- System Information: Debian Release: 5.0.5 APT prefers stable APT policy: (500, 'stable') Architecture: i386 (i686) Kernel: Linux 2.6.26-2-686 (SMP w/1 CPU core) Locale: LANG=C, LC_CTYPE=C (charmap=ANSI_X3.4-1968) Shell: /bin/sh linked to /bin/bash Versions of packages pgadmin3 depends on: ii libc6 2.7-18lenny4 GNU C Library: Shared libraries ii libgcc1 1:4.3.2-1.1 GCC support library ii libpq5 8.3.11-0lenny1 PostgreSQL C client library ii libstdc++6 4.3.2-1.1The GNU Standard C++ Library v3 ii libwxbase2.8-0 2.8.7.1-1.1+lenny1 wxBase library (runtime) - non-GUI ii libwxgtk2.8-0 2.8.7.1-1.1+lenny1 wxWidgets Cross-platform C++ GUI t ii libxml2 2.6.32.dfsg-5+lenny1 GNOME XML library ii libxslt1.1 1.1.24-2 XSLT processing library - runtime ii pgadmin3-data 1.8.4-3 graphical administration tool for Versions of packages pgadmin3 recommends: ii pgagent 1.8.4-3job scheduler for PostgreSQL ii postgresql-client-8.3 [po 8.3.11-0lenny1 front-end programs for PostgreSQL pgadmin3 suggests no packages. -- no debconf information -- To UNSUBSCRIBE, email to debian-bugs-dist-requ...@lists.debian.org with a subject of "unsubscribe". Trouble? Contact listmas...@lists.debian.org
Bug#518626: kmail: missing /usr/local/bin/chiasmus while scanning crypto backends
Package: kmail Version: 4:3.5.9-5 Severity: important When I choose rescan from: Configure->Security->crypto backends, Kmail displays a popup complaining that there is no /usr/local/bin/chiasmus while scanning for Chiasmus support. Note: Chiasmus checkbox is disabled and cannot be enabled (which may be fine, but then kmail shoudn't search Chiasmus). Luca -- System Information: Debian Release: 5.0 APT prefers stable APT policy: (500, 'stable') Architecture: i386 (i686) Kernel: Linux 2.6.26-1-686 (SMP w/1 CPU core) Locale: LANG=en_US.UTF-8, LC_CTYPE=en_US.UTF-8 (charmap=UTF-8) Shell: /bin/sh linked to /bin/bash Versions of packages kmail depends on: ii kdebase-kio-plug 4:3.5.9.dfsg.1-6core I/O slaves for KDE ii kdelibs4c2a 4:3.5.10.dfsg.1-0lenny1 core libraries and binaries for al ii kdepim-kio-plugi 4:3.5.9-5 KDE pim I/O Slaves ii libart-2.0-2 2.3.20-2Library of functions for 2D graphi ii libaudio21.9.1-5 Network Audio System - shared libr ii libc62.7-18 GNU C Library: Shared libraries ii libfontconfig1 2.6.0-3 generic font configuration library ii libfreetype6 2.3.7-2 FreeType 2 font engine, shared lib ii libgcc1 1:4.3.2-1.1 GCC support library ii libice6 2:1.0.4-1 X11 Inter-Client Exchange library ii libidn11 1.8+20080606-1 GNU libidn library, implementation ii libjpeg626b-14 The Independent JPEG Group's JPEG ii libkcal2b4:3.5.9-5 KDE calendaring library ii libkdepim1a 4:3.5.9-5 KDE PIM library ii libkleopatra14:3.5.9-5 KDE GnuPG interface libraries ii libkmime24:3.5.9-5 KDE MIME interface library ii libkpimidentitie 4:3.5.9-5 KDE PIM user identity information ii libksieve0 4:3.5.9-5 KDE mail/news message filtering li ii libmimelib1c2a 4:3.5.9-5 KDE mime library ii libpng12-0 1.2.27-2PNG library - runtime ii libqt3-mt3:3.3.8b-5+b1 Qt GUI Library (Threaded runtime v ii libsm6 2:1.0.3-2 X11 Session Management library ii libstdc++6 4.3.2-1.1 The GNU Standard C++ Library v3 ii libx11-6 2:1.1.5-2 X11 client-side library ii libxcursor1 1:1.1.9-1 X cursor management library ii libxext6 2:1.0.4-1 X11 miscellaneous extension librar ii libxft2 2.1.12-3FreeType-based font drawing librar ii libxi6 2:1.1.4-1 X11 Input extension library ii libxinerama1 2:1.0.3-2 X11 Xinerama extension library ii libxrandr2 2:1.2.3-1 X11 RandR extension library ii libxrender1 1:0.9.4-2 X Rendering Extension client libra ii libxt6 1:1.0.5-3 X11 toolkit intrinsics library ii perl 5.10.0-19 Larry Wall's Practical Extraction ii zlib1g 1:1.2.3.3.dfsg-12 compression library - runtime Versions of packages kmail recommends: ii kmailcvt 4:3.5.9-5 KDE KMail mail folder converter ii procmail 3.22-16Versatile e-mail processor Versions of packages kmail suggests: pn clamav | f-prot-installer (no description available) ii gnupg 1.4.9-3GNU privacy guard - a free PGP rep ii gnupg-agent 2.0.9-3.1 GNU privacy guard - password agent ii kaddressbook 4:3.5.9-5 KDE NG addressbook application ii kleopatra 4:3.5.9-5 KDE Certificate Manager ii pinentry-gtk2 [pinentry-x11] 0.7.5-2.1 GTK+-2-based PIN or pass-phrase en pn spamassassin | bogofilter | a (no description available) -- no debconf information -- To UNSUBSCRIBE, email to debian-bugs-dist-requ...@lists.debian.org with a subject of "unsubscribe". Trouble? Contact listmas...@lists.debian.org
Bug#480909: nfs-kernel-server: anonuid seems not to work properly
Package: nfs-kernel-server Version: 1:1.0.10-6+etch.1 Severity: important I'm trying to setup a shared directory for all guys on my lan. So I set up the server to export a dir, mapping all users/group to a single one. This is my server's exports: >cat /etc/exports /var/lib/amadego/ 192.168.144.0/255.255.255.0(secure,async,rw,all_squash,anonuid=1000,anongid=1000) Just to be shure: >cat /var/lib/nfs/etab /var/lib/amadego 192.168.144.0/255.255.255.0(rw,async,wdelay,hide,nocrossmnt,secure,root_squash,all_squash,subtree_check,secure_locks,acl,mapping=identity,anonuid=1000,anongid=1000) So the options have been read properly. Now, on the clients I can mount the directory, and, for every user I can create files (even if the have different user/group id's). Problem is: if user A (id=1000) creates a file on the shared dir, he can read and modify the file; but if user B (id=1001) creates a file, he can do this but immediately gets a warning: $ touch amadego/workspace/step4 touch: setting times of `amadego/workspace/step4': Permission denied So it seems that he can create the file, but not modify it. This is confirmed by the following command: $ echo pippo>> amadego/workspace/step4 bash: amadego/workspace/step4: Permission denied looking at the permissions, I have a little light on the problem: $ ls -ld amadego/workspace drwxrwxrwx 8 amadego amadego 456 May 12 19:10 amadego/workspace So, the user CAN create the file because he is granted to manage the file by the directory permissions, but cannot change the file contents because that is ruled by file permissions: $ ls -ltr amadego/workspace/step4 -rw-r--r-- 1 amadego amadego 0 May 12 19:10 amadego/workspace/step4 My conclusion is: user is seen as belonging to user/group "others", and the server is ignoring the anonuid/anongid settings. The strange thing is that, on create, the user is mapped properly, since the file is created with right user/group. Thanks, Luca -- System Information: Debian Release: 4.0 APT prefers stable APT policy: (500, 'stable') Architecture: i386 (i686) Shell: /bin/sh linked to /bin/bash Kernel: Linux 2.6.18-6-686 Locale: LANG=C, LC_CTYPE=C (charmap=ANSI_X3.4-1968) Versions of packages nfs-kernel-server depends on: ii lib 2.3.6.ds1-13etch5GNU C Library: Shared libraries ii lib 1.39+1.40-WIP-2006.11.14+dfsg-2etch1 common error description library ii lib 0.10-4 A mechanism-switch gssapi library ii lib 1.4.4-7etch5 MIT Kerberos runtime libraries ii lib 0.18-0 An nfs idmapping library ii lib 0.14-2etch3 allows secure rpc communication us ii lib 7.6.dbs-13 Wietse Venema's TCP wrappers libra ii lsb 3.1-15~bpo.1 Linux Standard Base 3.1 init scrip ii nfs 1:1.0.10-6+etch.1NFS support files common to client ii ucf 2.0020 Update Configuration File: preserv nfs-kernel-server recommends no packages. -- no debconf information -- To UNSUBSCRIBE, email to [EMAIL PROTECTED] with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]
Bug#466416: backuppc corrupts its data if they are on a reiserfs partition
Package: backuppc Version: 2.1.2-6 Severity: important I can state the problem this way: "backuppc corrupts a reiserfs partition" and "a ls or find command running on a corrupted reiserfs partition hangs the server". I'm using backuppc since 2004, under sid; that time I had compiled backuppc by miself, since it was not in the package list. Then I migrated to sarge (using backuppc included in the release) and now I'm using it with etch. I'm always been using reiserfs for the data partition, with two HD in RAID 1 configuration. More or less one time a year, backuppc hanged the backup server. Looking for a solution I discovered that the data partition was corrupted and simply by running an "ls" or a "find" command in the incriminated dir, the server hangs and stops responding to the console or the network. The problem was caused by the BackupPC script that was running an ls or similar command in that dir, and it hanged the system. I'm not able to determine the cause of the corruption. The server is powered using an UPS, and I'm (almost) sure that has no other problem (that is, excluding the problem that I'm now reporting); smartmontools is up an running, no HD error or HW falure was detected. I can imagine only three possible causes for these hangs: - the high number of links that backuppc creates in its data directory; - the too nested directory structure that backuppc uses for the backupped pc; - the long names that backuppc uses for the linked filenames The backupped network has only 6 machines, all running debian linux. The backup server has also a SCSI adapter that holds a 4GB streamer that I use for a weekly tape backups. I know that people is making bigger backups (mine is only 60 GB for data partition) and on bigger networks (more than 100 pc, according to various mailing list), so I'm not pushing neither backuppc nor reiserfs to their limits. I know also that reiserfs should not have problem on managing data directory; also, we use it as our fs for all machines, and since 2003 we had no problem with it, excluding 2 HD that were defective (and that were detected by smartmon tool, so it was not a problem of reiserfs). In my understanding the problem it's caused by the interaction between them (reiserfs and backuppc). The problem was solved by running reiserfsck --rebuild-tree; this is the log that was produced: ### Pass 0 ### block 6428678: The number of items (26624) is incorrect, should be (1) - corrected block 6428678: The free space (500) is incorrect, should be (4048) - corrected pass0: vpf-10110: block 6428678, item (0): Unknown item type found [68288 0 0xfffce853 ??? (15)] - deleted pass0: vpf-10590: block 13076527, item 3: Wrong order of items - change the object_id of the key [10156796 10156879 0x1 DIR (3)] to 10156815 5229398 directory entries were hashed with "r5" hash. ### Pass 1 ### ### Pass 2 ### ### Pass 3 # ### Pass 3a (lost+found pass) # Please, if you think that this is a bug of reiserfs, direct me to the reiserfs package that I shoud file this bug (or it is a kernel problem?) Thanks, Luca -- System Information: Debian Release: 4.0 APT prefers stable APT policy: (500, 'stable') Architecture: i386 (i686) Shell: /bin/sh linked to /bin/bash Kernel: Linux 2.6.18-6-686 Locale: LANG=C, LC_CTYPE=C (charmap=ANSI_X3.4-1968) Versions of packages backuppc depends on: ii adduser3.102 Add and remove users and groups ii apache2-mpm-prefork [apach 2.2.3-4+etch3 Traditional model for Apache HTTPD ii debconf [debconf-2.0] 1.5.11etch1 Debian configuration management sy ii dpkg 1.13.25 package maintenance system for Deb ii exim4 4.63-17 metapackage to ease exim MTA (v4) ii exim4-daemon-light [mail-t 4.63-17 lightweight exim MTA (v4) daemon ii libarchive-zip-perl1.16-1Module for manipulation of ZIP arc ii libcompress-zlib-perl 1.42-2Perl module for creation and manip ii perl [libdigest-md5-perl] 5.8.8-7etch1 Larry Wall's Practical Extraction ii perl-suid 5.8.8-7etch1 Runs setuid Perl scripts ii samba-common 3.0.24-6etch9 Samba common files used by both th ii smbclient 3.0.24-6etch9 a LanManager-like simple client fo ii tar1.16-2etch1 GNU tar ii wwwconfig-common 0.0.48Debian web auto configuration backuppc recommends no packages. -- debconf information: * backuppc/add-lines: true * backuppc/configuration-note: -- To UNSUBSCRIBE, email to [EMAIL PROTECTED] with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]
Bug#387256: pgadmin3: missing schema parameter during backup (missing pg_dump --schema=schema option)
Package: pgadmin3 Version: 1.4.0-0.3.release.sarge.2 Severity: normal Tags: patch I define two or more schemas in a database (say schema1 and schema2) and restrict user access to them (say user1 can work on schema1 only, and user2 can work on schema2 only). user1 creates table "addressbook" in schema1 user2 creates table "addressbook" in schema2 They work fine on their tables, but if user1 select table addressbook in pgadmin3 object browser and tries to backup that table, pgadmin3 refuses to execute the requested operation saying that user1 has not enough rights to access table addressbook. Problem is: pgadmin3 invokes command line tool pg_dump, without specifying the --schema=schema1 option in the command line. Solution/Patch: add --schema=schemaNameOfTheSelectedTable to the command line of pg_dump -- System Information: Debian Release: 3.1 APT prefers unstable APT policy: (500, 'unstable') Architecture: i386 (i686) Kernel: Linux 2.6.11.5-686-smp-p4-w4l-himem Locale: LANG=en_US, LC_CTYPE=en_US (charmap=ISO-8859-1) Versions of packages pgadmin3 depends on: ii libc6 2.3.2.ds1-22 GNU C Library: Shared libraries an ii libgcc1 1:3.4.3-13sarge1 GCC support library ii libpq37.4.7-6sarge2 PostgreSQL C client library ii libssl0.9.7 0.9.7e-3sarge2 SSL shared libraries ii libstdc++51:3.3.5-13 The GNU Standard C++ Library v3 ii libwxgtk2.6-0 2.6.1.0-0.pgadmin3.sarge.1 wxWidgets Cross-platform C++ GUI t ii pgadmin3-data 1.4.0-0.3.release.sarge.2 Graphical administration tool for -- no debconf information -- To UNSUBSCRIBE, email to [EMAIL PROTECTED] with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]
Bug#322199: firebird2-classic-server: Missing sql for functions of ib_udf and fbudf
Package: firebird2-classic-server Version: 1.5.1-4 Severity: normal Tags: patch UDF (user defined libraries) are extensions library to firebird sql engine; to use them (fbudf.so ib_udf.so) you need to register the sql functions in the server engine. These are two scripts missing from the debian package, that are in the original distribution from firebirdsql site. I attach them here, but they need to be distributed with the package. -- System Information: Debian Release: testing/unstable APT prefers testing APT policy: (500, 'testing') Architecture: i386 (i686) Shell: /bin/sh linked to /bin/bash Kernel: Linux 2.6.8-7-686-w4l Locale: LANG=C, LC_CTYPE=C (charmap=ANSI_X3.4-1968) Versions of packages firebird2-classic-server depends on: ii firebird2-server-common 1.5.1-4 Common files for Firebird - a RDBM ii libc6 2.3.2.ds1-22 GNU C Library: Shared libraries an ii libfirebird2-classic1.5.1-4 Library files for Firebird Classic ii libgcc1 1:4.0.1-2GCC support library ii libncurses5 5.4-9Shared libraries for terminal hand ii libstdc++5 1:3.3.5-13 The GNU Standard C++ Library v3 firebird2-classic-server recommends no packages. -- no debconf information /* * * The contents of this file are subject to the Initial * Developer's Public License Version 1.0 (the "License"); * you may not use this file except in compliance with the * License. You may obtain a copy of the License at * http://www.ibphoenix.com/idpl.html. * * Software distributed under the License is distributed on * an "AS IS" basis, WITHOUT WARRANTY OF ANY KIND, either * express or implied. See the License for the specific * language governing rights and limitations under the License. * * * The Original Code was created by Claudio Valderama C. for IBPhoenix. * The development of the Original Code was sponsored by Craig Leonardi. * * Copyright (c) 2001 IBPhoenix * All Rights Reserved. */ /*This file defines the new udfs for firebird.*/ set sql dialect 3; --FBUDF_API paramdsc* idNvl(paramdsc* v, paramdsc* v2) declare external function invl int by descriptor, int by descriptor returns int by descriptor entry_point 'idNvl' module_name 'fbudf'; --FBUDF_API paramdsc* idNvl(paramdsc* v, paramdsc* v2) declare external function i64nvl numeric(18,0) by descriptor, numeric(18,0) by descriptor returns numeric(18,0) by descriptor entry_point 'idNvl' module_name 'fbudf'; --FBUDF_API paramdsc* idNvl(paramdsc* v, paramdsc* v2) declare external function dnvl double precision by descriptor, double precision by descriptor returns double precision by descriptor entry_point 'idNvl' module_name 'fbudf'; --FBUDF_API paramdsc* sNvl(paramdsc* v, paramdsc* v2, paramdsc* rc) declare external function snvl varchar(100) by descriptor, varchar(100) by descriptor, varchar(100) by descriptor returns parameter 3 entry_point 'sNvl' module_name 'fbudf'; --FBUDF_API paramdsc* iNullIf(paramdsc* v, paramdsc* v2) declare external function inullif int by descriptor, int by descriptor returns int by descriptor entry_point 'iNullIf' module_name 'fbudf'; --FBUDF_API paramdsc* dNullIf(paramdsc* v, paramdsc* v2) declare external function dnullif double precision by descriptor, double precision by descriptor returns double precision by descriptor entry_point 'dNullIf' module_name 'fbudf'; --FBUDF_API paramdsc* iNullIf(paramdsc* v, paramdsc* v2) declare external function i64nullif numeric(18,4) by descriptor, numeric(18,4) by descriptor returns numeric(18,4) by descriptor entry_point 'iNullIf' module_name 'fbudf'; --FBUDF_API paramdsc* sNullIf(paramdsc* v, paramdsc* v2, paramdsc* rc) declare external function snullif varchar(100) by descriptor, varchar(100) by descriptor, varchar(100) by descriptor returns parameter 3 entry_point 'sNullIf' module_name 'fbudf'; --FBUDF_API char* DOW(ISC_DATE* v, char* rc) declare external function dow timestamp, varchar(15) returns parameter 2 entry_point 'DOW' module_name 'fbudf'; --FBUDF_API char* SDOW(ISC_DATE* v, char* rc) declare external function sdow timestamp, varchar(5) returns parameter 2 entry_point 'SDOW' module_name 'fbudf'; --FBUDF_API paramdsc* right(paramdsc*, short* rl, paramdsc* rc) declare external function sright varchar(100) by descriptor, smallint, varchar(100) by descriptor returns parameter 3 entry_point 'right' module_name 'fbudf'; --FBUDF_API ISC_TIMESTAMP* addDay(ISC_TIMESTAMP* v, int ndays) declare external function addDay timestamp, int returns timestamp entry_point 'addDay' module_name 'fbudf'; --FBUDF_API ISC_TIMESTAMP* addWeek(ISC_TIMESTAMP* v, int nweeks) declare external function addWeek timestamp, int returns timestamp entry_point 'addWeek' module_name 'fbudf'; --FBUDF_API ISC_TIMESTAMP* addMonth(ISC_TIMESTAMP* v, int nmonths) declare external function addMonth timestamp, int returns timestamp entry_point 'addMonth' module_name 'fbud
