______________________________________________________________________________

                        SuSE Security Announcement

        Package:                postgresql
        Announcement-ID:        SuSE-SA:2002:038
        Date:                   Monday, Oct 21th 2002 17:30 MEST
        Affected products:      7.0, 7.1, 7.2, 7.3, 8.0
                                SuSE eMail Server 3.1
                                SuSE eMail Server III
        Vulnerability Type:     remote privilege escalation
        Severity (1-10):        3
        SuSE default package:   no
        Cross References:       CAN-2002-0972

    Content of this advisory:
        1) security vulnerability resolved: several buffer overflows
           problem description, discussion, solution and upgrade information
        2) pending vulnerabilities, solutions, workarounds:
            - mod_php4
            - kon2
        3) standard appendix (further information)

______________________________________________________________________________

1)  problem description, brief discussion, solution, upgrade information

    The PostgreSQL Object-Relational DBMS was found vulnerable to several
    security related buffer overflow problems.
    The buffer overflows are located in:
      * handling long datetime input
      * lpad() and rpad() function with multibyte
      * repeat() function
      * TZ and SET TIME ZONE environment variables
    These bugs could just be exploited by attackers who have access to the
    postgresql server to gain the privileges postgres user ID .

    The PostgreSQL package is not installed by default.
    A temporary fix is not known.

    Please download the update package for your distribution and verify its
    integrity by the methods listed in section 3) of this announcement.
    Then, install the package using the command "rpm -Fhv file.rpm" to apply
    the update.
    Our maintenance customers are being notified individually. The packages
    are being offered to install from the maintenance web.



    i386 Intel Platform:

    SuSE-8.0
        
        295a8b92176718fa0f31d8753b086e3d
    SuSE-8.0
        
        ce9a41bcb3711a369168e6b412881e6d
    SuSE-8.0
        
        c39f7b4bf8474b05a690168cb1580cc9
    SuSE-8.0
        
        f30d7656ac76b508d02a40fdbab90c4d
    SuSE-8.0
        
        9b371b39106a4f79ca56d1b03b66eac5
    SuSE-8.0
        
        b153e3e6ea61e35fb14c4264beecd577
    SuSE-8.0
        
        1a1f7922e167f37378f52b59fbde7651
    SuSE-8.0
        
        ac259e05005d1cbaf1f34f27ef9b92c7
    SuSE-8.0
        
        b5145ffd46e3bf6471c87dcfe1c411b2
    SuSE-8.0
        
        866925a31b6e5529440bf08ac787ad7a
    SuSE-8.0
        
        77bdf60627640b8a6baaccd73f2eef9a
    SuSE-8.0
        
        e570f6b712bd5a4752a18b8cf1fab9ff
    SuSE-8.0
        
        49362f0d17092e2da8adae5bf81f1906
    SuSE-8.0
        
      4ab42090bd625e5c1cf1741fc05a685a
    SuSE-8.0
        
      11ada7e5e749e78eb98d82f7b1846aa6
    SuSE-8.0
        
      968526d469a4450550ab4ba5b6f83027
    SuSE-8.0
        
      e7b986baf11871378560d9c2fa61b717
    SuSE-8.0
        
      ad7359f18de98e9bbdb77e92ff0de37f
    SuSE-8.0
        
      b7d92162a97d27e63e8bee03abff0716
    SuSE-8.0
        
      65aba6a9afd5d38efca03cdf708597f2
    SuSE-8.0
        
      547ce19ff0921855fdedbd2f644725cc
    SuSE-8.0
        
        3097e791c00a11b4fd53914009677eb2
    SuSE-8.0
        
        6a41815ed8de498044b9e58851232135
    SuSE-8.0
        
        959c2270454ee03bd639b34d677ee1a7
    SuSE-8.0
        
        e8fd82140e1ffd6e29f53bda5d8598ed
    SuSE-8.0
        
        7ea684c3a96ec347921dba32d70e905e
    source rpm:
        
        a41380367f2b198c697f7d3409769633

    SuSE-7.3
        
      666fafcf35e113ce1a4f36c79abac810
    SuSE-7.3
        
      f69d09bbcfcf41c36f929de48b48282a
    SuSE-7.3
        
      fd4de823cfc05743a9919eaedf
    SuSE-7.3
        
        1d5d8b74cae636cd10baa3a6c419bd14
    SuSE-7.3
        
        da9a94d3a582ce37f353a82af8934d5c
    SuSE-7.3
        
        a86c849130f63036b8d66f9880c91d98
    SuSE-7.3
        
        ab55332c9a8742b456dbf44079b93c62
    SuSE-7.3
        
        8f40f336912f9c11222aa8e75a8f42d0
    SuSE-7.3
        
        8e87f0fb3b8b44824ae53cf364f7452d
    SuSE-7.3
        
        738aabbc7c2f86443b6f2f37bdaf45e1
    SuSE-7.3
        
        d2741442b2d87d665a400dd20efdd379
    SuSE-7.3
        
        122befa7a0b5021e85f7348ec1e959f4
    SuSE-7.3
        
        9eab7b2c22e0c82f327fd1685a3d9eb1
    source rpm:
        
        df2bbdb0e393e98175277351a3ded1ac


    Sparc Platform:

    Due to lack of resources new packages will be made available later without
    any further notice.


    AXP Alpha Platform:

    Due to lack of resources new packages will be made available later without
    any further notice.


    PPC Power PC Platform:

    SuSE-7.3
        
        e67b7b469ffd9cc90d674159270cb5c9
    SuSE-7.3
        
        ee2f6f8d149fc651e88e7b183a33727e
    SuSE-7.3
        
        58e9b9d3e8939fbe8d243ff183d2950d
    SuSE-7.3
        
        018928248f9052ee0e92a143e35fed44
    SuSE-7.3
        
        1d906d52a9de9020bea1cb0f62dcfb1b
    SuSE-7.3
        
        d7fd91833f8b6cf62334351c1114bc30
    SuSE-7.3
        
        ea2bba775ec4b4518e63f9130d5cf7d6
    SuSE-7.3
        
        265b8715c2961cf6e6c53745c14d9c5e
    SuSE-7.3
        
        48b0aeb6aacdc4e6a756ff47914bbfa8
    SuSE-7.3
        
        5b1a62fe810df234d10a64b7fdba2481
    SuSE-7.3
        
        c6aa4f989319efb9217df0d1cae51103
    SuSE-7.3
        
        ec661b2e8e483bda2d3587556f17010f
    SuSE-7.3
        
        06de87a238751fe6113fb0f8dbe11dd1
    source rpm:
        
        c98a8567cb2c9f7d0c2b095fed7daeb1

    SuSE-7.1
        
        8e005c33619240fda1461fb35c08c9b5
    SuSE-7.1
        
        06d51dd04c9490064bc4a07c81ee9f24
    SuSE-7.1
        
        e1c07b01422f37c656481c1a6566698e
    SuSE-7.1
        
        c897de110479618be9b122cdc897442e
    SuSE-7.1
        
        26e09530d4aba750a93dac74d68aeded
    SuSE-7.1
        
        1cc6f6f78dd5459ac3b7573bb40951fd
    SuSE-7.1
        
        a38f645bc5ba6046ee2de0fae2be3ee5
    SuSE-7.1
        
        d0a90015bae1937411f2e424c8d0f2f3
    SuSE-7.1
        
        967d48e91bed1a41d0a236024d01c95f
    SuSE-7.1
        
        2d7e5e348404c467a8bb3a54dbddd4eb
    SuSE-7.1
        
        10500a645eabc14f806e08f43bf238e7
    source rpm:
        
        49ad314541f098a1f24884a22049275a

______________________________________________________________________________

2)  Pending vulnerabilities in SuSE Distributions and Workarounds:

    - mod_php4
      There was a mistake in Advisory SuSE-SA:2002:036 in section
      "Affected products". SuSE 7.0 and 7.1 are _not_ vulnerable.

    - kon2
      There is a vulnerability in kon2, a Japanese input manager for the
      VGA console, that can be exploited by local users to obtain root
      privilege. We recommend to un-install kon2.

__________________________________________________________________________

3)  standard appendix: authenticity verification, additional information

  - Package authenticity verification:

    SuSE update packages are available on many mirror ftp servers all over
    the world. While this service is being considered valuable and important
    to the free and open source software community, many users wish to be
    sure about the origin of the package and its content before installing
    the package. There are two verification methods that can be used
    independently from each other to prove the authenticity of a downloaded
    file or rpm package:
    1) md5sums as provided in the (cryptographically signed) announcement.
    2) using the internal gpg signatures of the rpm package.

    1) execute the command
        md5sum 
       after you downloaded the file from a SuSE ftp server or its mirrors.
       Then, compare the resulting md5sum with the one that is listed in the
       announcement. Since the announcement containing the checksums is
       cryptographically signed (usually using the key security@suse.de),
       the checksums show proof of the authenticity of the package.
       We disrecommend to subscribe to security lists which cause the
       email message containing the announcement to be modified so that
       the signature does not match after transport through the mailing
       list software.
       Downsides: You must be able to verify the authenticity of the
       announcement in the first place. If RPM packages are being rebuilt
       and a new version of a package is published on the ftp server, all
       md5 sums for the files are useless.

    2) rpm package signatures provide an easy way to verify the authenticity
       of an rpm package. Use the command
        rpm -v --checksig 
       to verify the signature of the package, where  is the
       filename of the rpm package that you have downloaded. Of course,
       package authenticity verification can only target an un-installed rpm
       package file.
       Prerequisites:
        a) gpg is installed
        b) The package is signed using a certain key. The public part of this
           key must be installed by the gpg program in the directory
           ~/.gnupg/ under the user's home directory who performs the
           signature verification (usually root). You can import the key
           that is used by SuSE in rpm packages for SuSE Linux by saving
           this announcement to a file ("announcement.txt") and
           running the command (do "su -" to be root):
            gpg --batch; gpg < announcement.txt | gpg --import
           SuSE Linux distributions version 7.1 and thereafter install the
           key "build@suse.de" upon installation or upgrade, provided that
           the package gpg is installed. The file containing the public key
           is placed at the top-level directory of the first CD (pubring.gpg)
           and at   .


  - SuSE runs two security mailing lists to which any interested party may
    subscribe:

    suse-security@suse.com
        -   general/linux/SuSE security discussion.
            All SuSE security announcements are sent to this list.
            To subscribe, send an email to
                <suse-security-subscribe@suse.com>.

    suse-security-announce@suse.com
        -   SuSE's announce-only mailing list.
            Only SuSE's security announcements are sent to this list.
            To subscribe, send an email to
                <suse-security-announce-subscribe@suse.com>.

    For general information or the frequently asked questions (FAQ)
    send mail to:
        <suse-security-info@suse.com> or
        <suse-security-faq@suse.com> respectively.

    ====================================================================    SuSE's security contact is <security@suse.com> or <security@suse.de>.
    The <security@suse.de> public key is listed below.
    ====================================================================______________________________________________________________________________

    The information in this advisory may be distributed or reproduced,
    provided that the advisory is not modified in any way. In particular,
    it is desired that the clear-text signature shows proof of the
    authenticity of the text.
    SuSE Linux AG makes no warranties of any kind whatsoever with respect
    to the information contained in this security advisory.

Type Bits/KeyID    Date       User ID
pub  2048R/3D25D3D9 1999-03-06 SuSE Security Team <security@suse.de>
pub  1024D/9C800ACA 2000-10-19 SuSE Package Signing Key <build@suse.de>

-----BEGIN PGP PUBLIC KEY BLOCK-----
Version: GnuPG v1.0.6 (GNU/Linux)
Comment: For info see  The GNU Privacy Guard

mQGiBDnu9IERBACT8Y35+2vv4MGVKiLEMOl9GdST6MCkYS3yEKeueNWc+z/0Kvff
4JctBsgs47tjmiI9sl0eHjm3gTR8rItXMN6sJEUHWzDP+Y0PFPboMvKx0FXl/A0d
M+HFrruCgBlWt6FA+okRySQiliuI5phwqkXefl9AhkwR8xocQSVCFxcwvwCglVcO
QliHu8jwRQHxlRE0tkwQQI0D+wfQwKdvhDplxHJ5nf7U8c/yE/vdvpN6lF0tmFrK
XBUX+K7u4ifrZlQvj/81M4INjtXreqDiJtr99Rs6xa0ScZqITuZC4CWxJa9GynBE
D3+D2t1V/f8l0smsuYoFOF7Ib49IkTdbtwAThlZp8bEhELBeGaPdNCcmfZ66rKUd
G5sRA/9ovnc1krSQF2+sqB9/o7w5/q2qiyzwOSTnkjtBUVKn4zLUOf6aeBAoV6NM
CC3Kj9aZHfA+ND0ehPaVGJgjaVNFhPi4x0e7BULdvgOoAqajLfvkURHAeSsxXIoE
myW/xC1sBbDkDUIBSx5oej73XCZgnj/inphRqGpsb+1nKFvF+rQoU3VTRSBQYWNr
YWdlIFNpZ25pbmcgS2V5IDxidWlsZEBzdXNlLmRlPohcBBMRAgAcBQI57vSBBQkD
wmcABAsKAwQDFQMCAxYCAQIXgAAKCRCoTtronIAKyl8sAJ98BgD40zw0GHJHIf6d
NfnwI2PAsgCgjH1+PnYEl7TFjtZsqhezX7vZvYCIRgQQEQIABgUCOnBeUgAKCRCe
QOMQAAqrpNzOAKCL512FZvv4VZx94TpbA9lxyoAejACeOO1HIbActAevk5MUBhNe
LZa/qM2JARUDBRA6cGBvd7LmAD0l09kBATWnB/9An5vfiUUE1VQnt+T/EYklES3t
XXaJJp9pHMa4fzFa8jPVtv5UBHGee3XoUNDVwM2OgSEISZxbzdXGnqIlcT08TzBU
D9i579uifklLsnr35SJDZ6ram51/CWOnnaVhUzneOA9gTPSr+/fT3WeVnwJiQCQ3
0kNLWVXWATMnsnT486eAOlT6UNBPYQLpUprF5Yryk23pQUPAgJENDEqeU6iIO9Ot
1ZPtB0lniw+/xCi13D360o1tZDYOp0hHHJN3D3EN8C1yPqZd5CvvznYvB6bWBIpW
cRgdn2DUVMmpU661jwqGlRz1F84JG/xe4jGuzgpJt9IXSzyohEJB6XG5+D0BiF0E
ExECAB0FAjxqqTQFCQoAgrMFCwcKAwQDFQMCAxYCAQIXgAAKCRCoTtronIAKyp1f
AJ9dR7saz2KPNwD3U+fy/0BDKXrYGACfbJ8fQcJqCBQxeHvt9yMPDVq0B0W5Ag0E
Oe70khAIAISR0E3ozF/la+oNaRwxHLrCet30NgnxRROYhPaJB/Tu1FQokn2/Qld/
HZnh3TwhBIw1FqrhWBJ7491iAjLR9uPbdWJrn+A7t8kSkPaF3Z/6kyc5a8fas44h
t5h+6HMBzoFCMAq2aBHQRFRNp9Mz1ZvoXXcI1lk1l8OqcUM/ovXbDfPcXsUVeTPT
tGzcAi2jVl9hl3iwJKkyv/RLmcusdsi8YunbvWGFAF5GaagYQo7YlF6UaBQnYJTM
523AMgpPQtsKm9o/w9WdgXkgWhgkhZEeqUS3m5xNey1nLu9iMvq9M/iXnGz4sg6Q
2Y+GqZ+yAvNWjRRou3zSE7Bzg28MI4sAAwYH/2D71Xc5HPDgu87WnBFgmp8MpSr8
QnSs0wwPg3xEullGEocolSb2c0ctuSyeVnCttJMzkukL9TqyF4s/6XRstWirSWaw
JxRLKH6Zjo/FaKsshYKf8gBkAaddvpl3pO0gmUYbqmpQ3xDEYlhCeieXS5MkockQ
1sj2xYdB1xO0ExzfiCiscUKjUFy+mdzUsUutafuZ+gbHog1CN/ccZCkxcBa5IFCH
ORrNjq9pYWlrxsEn6ApsG7JJbM2besW1PkdEoxak74z1senh36m5jQvVjA3U4xq1
wwylxadmmJaJHzeiLfb7G1ZRjZTsB7fyYxqDzMVul6o9BSwO/1XsIAnV1uuITAQY
EQIADAUCOe70kgUJA8JnAAAKCRCoTtronIAKyksiAJsFB3/77SkH3JlYOGrEe1Ol
0JdGwACeKTttgeVPFB+iGJdiwQlxasOfuXyITAQYEQIADAUCPGqpWQUJCgCCxwAK
CRCoTtronIAKyofBAKCSZM2UFyta/fe9WgITK9I5hbxxtQCfX+0ar2CZmSknn3co
SPihn1+OBNyZAQ0DNuEtBAAAAQgAoCRcd7SVZEFcumffyEwfLTcXQjhKzOahzxpo
omuF+HIyU4AGq+SU8sTZ/1SsjhdzzrSAfv1lETACA+3SmLr5KV40Us1w0UC64cwt
A46xowVq1vMlH2Lib+V/qr3b1hE67nMHjysECVx9Ob4gFuKNoR2eqnAaJvjnAT8J
/LoUC20EdCHUqn6v+M9t/WZgC+WNR8cq69uDy3YQhDP/nIan6fm2uf2kSV9A7ZxE
GrwsWl/WX5Q/sQqMWaU6r4az98X3z90/cN+eJJ3vwtA+rm+nxEvyev+jaLuOQBDf
ebh/XA4FZ35xmi+spdiVeJH4F/ubaGlmj7+wDOF3suYAPSXT2QAFEbQlU3VTRSBT
ZWN1cml0eSBUZWFtIDxzZWN1cml0eUBzdXNlLmRlPokBFQMFEDbhLUfkWLKHsco8
RQEBVw4H/1vIdiOLX/7hdzYaG9crQVIk3QwaB5eBbjvLEMvuCZHiY2COUg5QdmPQ
8SlWNZ6k4nu1BLcv2g/pymPUWP9fG4tuSnlUJDrWGm3nhyhAC9iudP2u1YQY37Gb
B6NPVaZiYMnEb4QYFcqv5c/r2ghSXUTYk7etd6SW6WCOpEqizhx1cqDKNZnsI/1X
11pFcO2N7rc6byDBJ1T+cK+F1Ehan9XBt/shryJmv04nli5CXQMEbiqYYMOu8iaA
8AWRgXPCWqhyGhcVD3LRhUJXjUOdH4ZiHCXaoF3zVPxpeGKEQY8iBrDeDyB3wHmj
qY9WCX6cmogGQRgYG6yJqDalLqrDOdmJARUDBRA24S0Ed7LmAD0l09kBAW04B/4p
WH3f1vQn3i6/+SmDjGzUu2GWGq6Fsdwo2hVM2ym6CILeow/K9JfhdwGvY8LRxWRL
hn09j2IJ9P7H1Yz3qDf10AX6V7YILHtchKT1dcngCkTLmDgC4rs1iAAl3f089sRG
BafGPGKv2DQjHfR1LfRtbf0P7c09Tkej1MP8HtQMW9hPkBYeXcwbCjdrVGFOzqx+
AvvJDdT6a+oyRMTFlvmZ83UV5pgoyimgjhWnM1V4bFBYjPrtWMkdXJSUXbR6Q7Pi
RZWCzGRzwbaxqpl3rK/YTCphOLwEMB27B4/fcqtBzgoMOiaZA0M5fFoo54KgRIh0
zinsSx2OrWgvSiLEXXYKiEYEEBECAAYFAjseYcMACgkQnkDjEAAKq6ROVACgjhDM
/3KM+iFjs5QXsnd4oFPOnbkAnjYGa1J3em+bmV2aiCdYXdOuGn4ZiQCVAwUQN7c7
whaQN/7O/JIVAQEB+QP/cYblSAmPXxSFiaHWB+MiUNw8B6ozBLK0QcMQ2YcL6+Vl
D+nSZP20+Ja2nfiKjnibCv5ss83yXoHkYk2Rsa8foz6Y7tHwuPiccvqnIC/c9Cvz
dbIsdxpfsi0qWPfvX/jLMpXqqnPjdIZErgxpwujas1n9016PuXA8K3MJwVjCqSKI
RgQQEQIABgUCOhpCpAAKCRDHUqoysN/3gCt7AJ9adNQMbmA1iSYcbhtgvx9ByLPI
DgCfZ5Wj+f7cnYpFZI6GkAyyczG09sE=LRKC
-----END PGP PUBLIC KEY BLOCK-----