skylendar / Tickets / #4 libadate not found in installation, psql

#4 libadate not found in installation, psql

Milestone: 1.0

Status: open

Owner: Christophe

Labels: sql (1)

Updated: 2024-09-03

Created: 2024-06-24

Creator: Camilo Villavicencio

Private: No

Hi Cristoph. Last night i found your skylendar software, read about its features and i really want use it. I didn't found a package so i decided compile it. (meanwhile i readed the shame on you file; good experiment to confirm the sadly reality of this hyperconnected century where's hard find people who take five minutes to send, at least, an alarm about something not working, in a literally free gift from some kind person).
Well, i compiled and it runs, but when im trying setup with skydmin i get this log:

´´´
psql:/usr/share/skylendar/installskydb.sql:9: NOTICE: la extensión «plpgsql» ya existe, omitiendo
psql:/usr/share/skylendar/installskydb.sql:980: WARNING: Initial Level
psql:/usr/share/skylendar/installskydb.sql:980: WARNING: Level 4.0.3
psql:/usr/share/skylendar/installskydb.sql:980: WARNING: Level 4.1
psql:/usr/share/skylendar/installskydb.sql:980: WARNING: Level 4.1.1
psql:/usr/share/skylendar/installskydb.sql:980: NOTICE: el tipo de retorno adate está inconcluso
psql:/usr/share/skylendar/installskydb.sql:980: ERROR: no se pudo acceder al archivo «libadate»: No existe el fichero o el directorio
CONTEXTO: sentencia SQL: «CREATE FUNCTION adate_input(cstring) RETURNS adate AS 'libadate', 'adate_input' LANGUAGE C IMMUTABLE»
función PL/pgSQL inline_code_block en la línea 456 en sentencia SQL
psql:/usr/share/skylendar/installskydb.sql:986: ERROR: no existe la relación «interpret»
LÍNEA 2: SELECT COALESCE((SELECT Text FROM Interpret WHERE Lang =...
^
psql:/usr/share/skylendar/installskydb.sql:988: ERROR: no existe la relación «data»
psql:/usr/share/skylendar/installskydb.sql:990: ERROR: no existe la relación «data_idx_seq»
psql:/usr/share/skylendar/installskydb.sql:992: ERROR: no existe la relación «typeicons»
psql:/usr/share/skylendar/installskydb.sql:994: ERROR: no existe la función getinter(character varying, character)
psql:/usr/share/skylendar/installskydb.sql:1001: ERROR: no existe el rol «skyusers»

CREATE VIEW
CREATE EXTENSION
SET
CREATE FUNCTION
[...]
CREATE FUNCTION
DROP VIEW
DROP FUNCTION
[...]
CREATE VIEW
ANALYZE

Installation finished !

Now, click on [...]
´´´

i've experience with mysql, so i can generally understand generic sql language (crud, and a bit more) but i can't get whats going wrong and how i can fix it.

Can you give me a hand or orientation to get skylendar works? i really appreciate your work and i really want to use it. Have a nice day, and happy solstices. Thanks.

Camilo

Related

Discussion

David Jarvie - 2024-08-26

I downloaded skylendar-5.1.0.1-x86_64.deb from your website and installed on Debian 12 (bookworm), and got the same errors as reported by Camilo (with slightly different line numbers). The version of postgresql on my system is 15.8. Like Camilo, I would very much like to try out skylendar but am now stuck.

In case it's useful to see the English language version of the error messages, here is what was displayed on my system:

psql:/usr/local/share/skylendar/installskydb.sql:9: NOTICE: extension "plpgsql" already exists, skipping
psql:/usr/local/share/skylendar/installskydb.sql:978: WARNING: Initial Level
psql:/usr/local/share/skylendar/installskydb.sql:978: WARNING: Level 4.0.3
psql:/usr/local/share/skylendar/installskydb.sql:978: WARNING: Level 4.1
psql:/usr/local/share/skylendar/installskydb.sql:978: WARNING: Level 4.1.1
psql:/usr/local/share/skylendar/installskydb.sql:978: NOTICE: return type adate is only a shell
psql:/usr/local/share/skylendar/installskydb.sql:978: ERROR: could not access file "libadate": No such file or directory
CONTEXT: SQL statement "CREATE FUNCTION adate_input(cstring) RETURNS adate AS 'libadate', 'adate_input' LANGUAGE C IMMUTABLE"
PL/pgSQL function inline_code_block line 454 at SQL statement
psql:/usr/local/share/skylendar/installskydb.sql:984: ERROR: relation "interpret" does not exist
LINE 2: SELECT COALESCE((SELECT Text FROM Interpret WHERE Lang =...
^
psql:/usr/local/share/skylendar/installskydb.sql:986: ERROR: relation "data" does not exist
psql:/usr/local/share/skylendar/installskydb.sql:988: ERROR: relation "data_idx_seq" does not exist
psql:/usr/local/share/skylendar/installskydb.sql:990: ERROR: relation "typeicons" does not exist
psql:/usr/local/share/skylendar/installskydb.sql:992: ERROR: function getinter(character varying, character) does not exist
psql:/usr/local/share/skylendar/installskydb.sql:999: ERROR: role "skyusers" does not exist

CREATE VIEW
...

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
- Christophe - 2024-08-26
  
  Thank you for reporting issues. It's so rare...
  libadate must be copied in the postgresql library dir. In my case
  /usr/lib/postgresql15/lib64
  
  However, it is hard to find out for every distro where this dir is located.
  Remember that I have almost no help or contribution for the project. So, glitches occur
  
  On Monday, August 26, 2024 at 07:30:14 PM GMT+2, David Jarvie <djar@users.sourceforge.net> wrote:
  
  I downloaded skylendar-5.1.0.1-x86_64.deb from your website and installed on Debian 12 (bookworm), and got the same errors as reported by Camilo (with slightly different line numbers). The version of postgresql on my system is 15.8. Like Camilo, I would very much like to try out skylendar but am now stuck.
  
  In case it's useful to see the English language version of the error messages, here is what was displayed on my system:
  
  psql:/usr/local/share/skylendar/installskydb.sql:9: NOTICE: extension "plpgsql" already exists, skipping
  psql:/usr/local/share/skylendar/installskydb.sql:978: WARNING: Initial Level
  psql:/usr/local/share/skylendar/installskydb.sql:978: WARNING: Level 4.0.3
  psql:/usr/local/share/skylendar/installskydb.sql:978: WARNING: Level 4.1
  psql:/usr/local/share/skylendar/installskydb.sql:978: WARNING: Level 4.1.1
  psql:/usr/local/share/skylendar/installskydb.sql:978: NOTICE: return type adate is only a shell
  psql:/usr/local/share/skylendar/installskydb.sql:978: ERROR: could not access file "libadate": No such file or directory
  CONTEXT: SQL statement "CREATE FUNCTION adate_input(cstring) RETURNS adate AS 'libadate', 'adate_input' LANGUAGE C IMMUTABLE"
  PL/pgSQL function inline_code_block line 454 at SQL statement
  psql:/usr/local/share/skylendar/installskydb.sql:984: ERROR: relation "interpret" does not exist
  LINE 2: SELECT COALESCE((SELECT Text FROM Interpret WHERE Lang =...
  ^
  psql:/usr/local/share/skylendar/installskydb.sql:986: ERROR: relation "data" does not exist
  psql:/usr/local/share/skylendar/installskydb.sql:988: ERROR: relation "data_idx_seq" does not exist
  psql:/usr/local/share/skylendar/installskydb.sql:990: ERROR: relation "typeicons" does not exist
  psql:/usr/local/share/skylendar/installskydb.sql:992: ERROR: function getinter(character varying, character) does not exist
  psql:/usr/local/share/skylendar/installskydb.sql:999: ERROR: role "skyusers" does not exist
  
  CREATE VIEW
  ...
  
  [tickets:#4] libadate not found in installation, psql
  
  Status: open
  Milestone: 1.0
  Labels: sql
  Created: Mon Jun 24, 2024 06:19 PM UTC by Camilo Villavicencio
  Last Updated: Mon Jun 24, 2024 06:19 PM UTC
  Owner: Christophe
  
  Hi Cristoph. Last night i found your skylendar software, read about its features and i really want use it. I didn't found a package so i decided compile it. (meanwhile i readed the shame on you file; good experiment to confirm the sadly reality of this hyperconnected century where's hard find people who take five minutes to send, at least, an alarm about something not working, in a literally free gift from some kind person).
  Well, i compiled and it runs, but when im trying setup with skydmin i get this log:
  
  ´´´
  psql:/usr/share/skylendar/installskydb.sql:9: NOTICE: la extensión «plpgsql» ya existe, omitiendo
  psql:/usr/share/skylendar/installskydb.sql:980: WARNING: Initial Level
  psql:/usr/share/skylendar/installskydb.sql:980: WARNING: Level 4.0.3
  psql:/usr/share/skylendar/installskydb.sql:980: WARNING: Level 4.1
  psql:/usr/share/skylendar/installskydb.sql:980: WARNING: Level 4.1.1
  psql:/usr/share/skylendar/installskydb.sql:980: NOTICE: el tipo de retorno adate está inconcluso
  psql:/usr/share/skylendar/installskydb.sql:980: ERROR: no se pudo acceder al archivo «libadate»: No existe el fichero o el directorio
  CONTEXTO: sentencia SQL: «CREATE FUNCTION adate_input(cstring) RETURNS adate AS 'libadate', 'adate_input' LANGUAGE C IMMUTABLE»
  función PL/pgSQL inline_code_block en la línea 456 en sentencia SQL
  psql:/usr/share/skylendar/installskydb.sql:986: ERROR: no existe la relación «interpret»
  LÍNEA 2: SELECT COALESCE((SELECT Text FROM Interpret WHERE Lang =...
  ^
  psql:/usr/share/skylendar/installskydb.sql:988: ERROR: no existe la relación «data»
  psql:/usr/share/skylendar/installskydb.sql:990: ERROR: no existe la relación «data_idx_seq»
  psql:/usr/share/skylendar/installskydb.sql:992: ERROR: no existe la relación «typeicons»
  psql:/usr/share/skylendar/installskydb.sql:994: ERROR: no existe la función getinter(character varying, character)
  psql:/usr/share/skylendar/installskydb.sql:1001: ERROR: no existe el rol «skyusers»
  
  CREATE VIEW
  CREATE EXTENSION
  SET
  CREATE FUNCTION
  [...]
  CREATE FUNCTION
  DROP VIEW
  DROP FUNCTION
  [...]
  CREATE VIEW
  ANALYZE
  
  Installation finished !
  
  Now, click on [...]
  ´´´
  
  i've experience with mysql, so i can generally understand generic sql language (crud, and a bit more) but i can't get whats going wrong and how i can fix it.
  
  Can you give me a hand or orientation to get skylendar works? i really appreciate your work and i really want to use it. Have a nice day, and happy solstices. Thanks.
  
  Camilo
  
  Sent from sourceforge.net because you indicated interest in https://sourceforge.net/p/skylendar/tickets/4/
  
  To unsubscribe from further messages, please visit https://sourceforge.net/auth/subscriptions/
  
  Related
  
  Tickets: #4
  
  alternate
  
  If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
  - Christophe - 2024-08-31
    
    got something ?
    
    On Monday, August 26, 2024 at 08:52:40 PM GMT+2, C. <skylendar@yahoo.com> wrote:
    
    Thank you for reporting issues. It's so rare...
    libadate must be copied in the postgresql library dir. In my case
    /usr/lib/postgresql15/lib64
    
    However, it is hard to find out for every distro where this dir is located.
    Remember that I have almost no help or contribution for the project. So, glitches occur
    
    On Monday, August 26, 2024 at 07:30:14 PM GMT+2, David Jarvie <djar@users.sourceforge.net> wrote:
    
    I downloaded skylendar-5.1.0.1-x86_64.deb from your website and installed on Debian 12 (bookworm), and got the same errors as reported by Camilo (with slightly different line numbers). The version of postgresql on my system is 15.8. Like Camilo, I would very much like to try out skylendar but am now stuck.
    
    In case it's useful to see the English language version of the error messages, here is what was displayed on my system:
    
    psql:/usr/local/share/skylendar/installskydb.sql:9: NOTICE: extension "plpgsql" already exists, skipping
    psql:/usr/local/share/skylendar/installskydb.sql:978: WARNING: Initial Level
    psql:/usr/local/share/skylendar/installskydb.sql:978: WARNING: Level 4.0.3
    psql:/usr/local/share/skylendar/installskydb.sql:978: WARNING: Level 4.1
    psql:/usr/local/share/skylendar/installskydb.sql:978: WARNING: Level 4.1.1
    psql:/usr/local/share/skylendar/installskydb.sql:978: NOTICE: return type adate is only a shell
    psql:/usr/local/share/skylendar/installskydb.sql:978: ERROR: could not access file "libadate": No such file or directory
    CONTEXT: SQL statement "CREATE FUNCTION adate_input(cstring) RETURNS adate AS 'libadate', 'adate_input' LANGUAGE C IMMUTABLE"
    PL/pgSQL function inline_code_block line 454 at SQL statement
    psql:/usr/local/share/skylendar/installskydb.sql:984: ERROR: relation "interpret" does not exist
    LINE 2: SELECT COALESCE((SELECT Text FROM Interpret WHERE Lang =...
    ^
    psql:/usr/local/share/skylendar/installskydb.sql:986: ERROR: relation "data" does not exist
    psql:/usr/local/share/skylendar/installskydb.sql:988: ERROR: relation "data_idx_seq" does not exist
    psql:/usr/local/share/skylendar/installskydb.sql:990: ERROR: relation "typeicons" does not exist
    psql:/usr/local/share/skylendar/installskydb.sql:992: ERROR: function getinter(character varying, character) does not exist
    psql:/usr/local/share/skylendar/installskydb.sql:999: ERROR: role "skyusers" does not exist
    
    CREATE VIEW
    ...
    
    [tickets:#4] libadate not found in installation, psql
    
    Status: open
    Milestone: 1.0
    Labels: sql
    Created: Mon Jun 24, 2024 06:19 PM UTC by Camilo Villavicencio
    Last Updated: Mon Jun 24, 2024 06:19 PM UTC
    Owner: Christophe
    
    Hi Cristoph. Last night i found your skylendar software, read about its features and i really want use it. I didn't found a package so i decided compile it. (meanwhile i readed the shame on you file; good experiment to confirm the sadly reality of this hyperconnected century where's hard find people who take five minutes to send, at least, an alarm about something not working, in a literally free gift from some kind person).
    Well, i compiled and it runs, but when im trying setup with skydmin i get this log:
    
    ´´´
    psql:/usr/share/skylendar/installskydb.sql:9: NOTICE: la extensión «plpgsql» ya existe, omitiendo
    psql:/usr/share/skylendar/installskydb.sql:980: WARNING: Initial Level
    psql:/usr/share/skylendar/installskydb.sql:980: WARNING: Level 4.0.3
    psql:/usr/share/skylendar/installskydb.sql:980: WARNING: Level 4.1
    psql:/usr/share/skylendar/installskydb.sql:980: WARNING: Level 4.1.1
    psql:/usr/share/skylendar/installskydb.sql:980: NOTICE: el tipo de retorno adate está inconcluso
    psql:/usr/share/skylendar/installskydb.sql:980: ERROR: no se pudo acceder al archivo «libadate»: No existe el fichero o el directorio
    CONTEXTO: sentencia SQL: «CREATE FUNCTION adate_input(cstring) RETURNS adate AS 'libadate', 'adate_input' LANGUAGE C IMMUTABLE»
    función PL/pgSQL inline_code_block en la línea 456 en sentencia SQL
    psql:/usr/share/skylendar/installskydb.sql:986: ERROR: no existe la relación «interpret»
    LÍNEA 2: SELECT COALESCE((SELECT Text FROM Interpret WHERE Lang =...
    ^
    psql:/usr/share/skylendar/installskydb.sql:988: ERROR: no existe la relación «data»
    psql:/usr/share/skylendar/installskydb.sql:990: ERROR: no existe la relación «data_idx_seq»
    psql:/usr/share/skylendar/installskydb.sql:992: ERROR: no existe la relación «typeicons»
    psql:/usr/share/skylendar/installskydb.sql:994: ERROR: no existe la función getinter(character varying, character)
    psql:/usr/share/skylendar/installskydb.sql:1001: ERROR: no existe el rol «skyusers»
    
    CREATE VIEW
    CREATE EXTENSION
    SET
    CREATE FUNCTION
    [...]
    CREATE FUNCTION
    DROP VIEW
    DROP FUNCTION
    [...]
    CREATE VIEW
    ANALYZE
    
    Installation finished !
    
    Now, click on [...]
    ´´´
    
    i've experience with mysql, so i can generally understand generic sql language (crud, and a bit more) but i can't get whats going wrong and how i can fix it.
    
    Can you give me a hand or orientation to get skylendar works? i really appreciate your work and i really want to use it. Have a nice day, and happy solstices. Thanks.
    
    Camilo
    
    Sent from sourceforge.net because you indicated interest in https://sourceforge.net/p/skylendar/tickets/4/
    
    To unsubscribe from further messages, please visit https://sourceforge.net/auth/subscriptions/
    
    Related
    
    Tickets: #4
    
    alternate
    
    If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
    - David Jarvie - 2024-09-02
      
      Did you see my reply below from a week ago?
      
      If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
      - Christophe - 2024-09-02
        
        No ?
        
        On Monday, September 2, 2024 at 02:42:34 PM GMT+2, David Jarvie <djar@users.sourceforge.net> wrote:
        
        Did you see my reply below from a week ago?
        
        [tickets:#4] libadate not found in installation, psql
        
        Status: open
        Milestone: 1.0
        Labels: sql
        Created: Mon Jun 24, 2024 06:19 PM UTC by Camilo Villavicencio
        Last Updated: Mon Aug 26, 2024 08:08 PM UTC
        Owner: Christophe
        
        Hi Cristoph. Last night i found your skylendar software, read about its features and i really want use it. I didn't found a package so i decided compile it. (meanwhile i readed the shame on you file; good experiment to confirm the sadly reality of this hyperconnected century where's hard find people who take five minutes to send, at least, an alarm about something not working, in a literally free gift from some kind person).
        Well, i compiled and it runs, but when im trying setup with skydmin i get this log:
        
        ´´´
        psql:/usr/share/skylendar/installskydb.sql:9: NOTICE: la extensión «plpgsql» ya existe, omitiendo
        psql:/usr/share/skylendar/installskydb.sql:980: WARNING: Initial Level
        psql:/usr/share/skylendar/installskydb.sql:980: WARNING: Level 4.0.3
        psql:/usr/share/skylendar/installskydb.sql:980: WARNING: Level 4.1
        psql:/usr/share/skylendar/installskydb.sql:980: WARNING: Level 4.1.1
        psql:/usr/share/skylendar/installskydb.sql:980: NOTICE: el tipo de retorno adate está inconcluso
        psql:/usr/share/skylendar/installskydb.sql:980: ERROR: no se pudo acceder al archivo «libadate»: No existe el fichero o el directorio
        CONTEXTO: sentencia SQL: «CREATE FUNCTION adate_input(cstring) RETURNS adate AS 'libadate', 'adate_input' LANGUAGE C IMMUTABLE»
        función PL/pgSQL inline_code_block en la línea 456 en sentencia SQL
        psql:/usr/share/skylendar/installskydb.sql:986: ERROR: no existe la relación «interpret»
        LÍNEA 2: SELECT COALESCE((SELECT Text FROM Interpret WHERE Lang =...
        ^
        psql:/usr/share/skylendar/installskydb.sql:988: ERROR: no existe la relación «data»
        psql:/usr/share/skylendar/installskydb.sql:990: ERROR: no existe la relación «data_idx_seq»
        psql:/usr/share/skylendar/installskydb.sql:992: ERROR: no existe la relación «typeicons»
        psql:/usr/share/skylendar/installskydb.sql:994: ERROR: no existe la función getinter(character varying, character)
        psql:/usr/share/skylendar/installskydb.sql:1001: ERROR: no existe el rol «skyusers»
        
        CREATE VIEW
        CREATE EXTENSION
        SET
        CREATE FUNCTION
        [...]
        CREATE FUNCTION
        DROP VIEW
        DROP FUNCTION
        [...]
        CREATE VIEW
        ANALYZE
        
        Installation finished !
        
        Now, click on [...]
        ´´´
        
        i've experience with mysql, so i can generally understand generic sql language (crud, and a bit more) but i can't get whats going wrong and how i can fix it.
        
        Can you give me a hand or orientation to get skylendar works? i really appreciate your work and i really want to use it. Have a nice day, and happy solstices. Thanks.
        
        Camilo
        
        Sent from sourceforge.net because you indicated interest in https://sourceforge.net/p/skylendar/tickets/4/
        
        To unsubscribe from further messages, please visit https://sourceforge.net/auth/subscriptions/
        
        Related
        
        Tickets: #4
        
        alternate
        
        If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
        
        David Jarvie - 2024-09-02
        
        See https://sourceforge.net/p/skylendar/tickets/4/#eb1e
        Sorry - I'm used to using Bugzilla, which doesn't have the facility to reply to a specific message, so I just added a new comment rather than a reply to your message.
        
        If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
        
        Christophe - 2024-09-02
        
        libadate.sp must be moved into the right directory, e.g. postgresql15, but this dir iis not located in the same path for all the distros. So:
        find /usr -name postgresql15
        
        On Monday, September 2, 2024 at 08:03:30 PM GMT+2, David Jarvie <djar@users.sourceforge.net> wrote:
        
        See https://sourceforge.net/p/skylendar/tickets/4/#eb1e
        Sorry - I'm used to using Bugzilla, which doesn't have the facility to reply to a specific message, so I just added a new comment rather than a reply to your message.
        
        [tickets:#4] libadate not found in installation, psql
        
        Status: open
        Milestone: 1.0
        Labels: sql
        Created: Mon Jun 24, 2024 06:19 PM UTC by Camilo Villavicencio
        Last Updated: Mon Sep 02, 2024 12:42 PM UTC
        Owner: Christophe
        
        Hi Cristoph. Last night i found your skylendar software, read about its features and i really want use it. I didn't found a package so i decided compile it. (meanwhile i readed the shame on you file; good experiment to confirm the sadly reality of this hyperconnected century where's hard find people who take five minutes to send, at least, an alarm about something not working, in a literally free gift from some kind person).
        Well, i compiled and it runs, but when im trying setup with skydmin i get this log:
        
        ´´´
        psql:/usr/share/skylendar/installskydb.sql:9: NOTICE: la extensión «plpgsql» ya existe, omitiendo
        psql:/usr/share/skylendar/installskydb.sql:980: WARNING: Initial Level
        psql:/usr/share/skylendar/installskydb.sql:980: WARNING: Level 4.0.3
        psql:/usr/share/skylendar/installskydb.sql:980: WARNING: Level 4.1
        psql:/usr/share/skylendar/installskydb.sql:980: WARNING: Level 4.1.1
        psql:/usr/share/skylendar/installskydb.sql:980: NOTICE: el tipo de retorno adate está inconcluso
        psql:/usr/share/skylendar/installskydb.sql:980: ERROR: no se pudo acceder al archivo «libadate»: No existe el fichero o el directorio
        CONTEXTO: sentencia SQL: «CREATE FUNCTION adate_input(cstring) RETURNS adate AS 'libadate', 'adate_input' LANGUAGE C IMMUTABLE»
        función PL/pgSQL inline_code_block en la línea 456 en sentencia SQL
        psql:/usr/share/skylendar/installskydb.sql:986: ERROR: no existe la relación «interpret»
        LÍNEA 2: SELECT COALESCE((SELECT Text FROM Interpret WHERE Lang =...
        ^
        psql:/usr/share/skylendar/installskydb.sql:988: ERROR: no existe la relación «data»
        psql:/usr/share/skylendar/installskydb.sql:990: ERROR: no existe la relación «data_idx_seq»
        psql:/usr/share/skylendar/installskydb.sql:992: ERROR: no existe la relación «typeicons»
        psql:/usr/share/skylendar/installskydb.sql:994: ERROR: no existe la función getinter(character varying, character)
        psql:/usr/share/skylendar/installskydb.sql:1001: ERROR: no existe el rol «skyusers»
        
        CREATE VIEW
        CREATE EXTENSION
        SET
        CREATE FUNCTION
        [...]
        CREATE FUNCTION
        DROP VIEW
        DROP FUNCTION
        [...]
        CREATE VIEW
        ANALYZE
        
        Installation finished !
        
        Now, click on [...]
        ´´´
        
        i've experience with mysql, so i can generally understand generic sql language (crud, and a bit more) but i can't get whats going wrong and how i can fix it.
        
        Can you give me a hand or orientation to get skylendar works? i really appreciate your work and i really want to use it. Have a nice day, and happy solstices. Thanks.
        
        Camilo
        
        Sent from sourceforge.net because you indicated interest in https://sourceforge.net/p/skylendar/tickets/4/
        
        To unsubscribe from further messages, please visit https://sourceforge.net/auth/subscriptions/
        
        Related
        
        Tickets: #4
        
        alternate
        
        If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
        
        David Jarvie - 2024-09-02
        
        There is no directory postgresql15 on my system. I moved libadate.so into the postgresql/15/lib directory, but the error messages indicated that it is incompatible with postgresql 15:
        
        psql:/usr/local/share/skylendar/installskydb.sql:978: ERROR: incompatible library "/usr/lib/postgresql/15/lib/libadate.so": version mismatch
        DETAIL: Server is version 15, library is version 14.
        
        If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
        
        Christophe - 2024-09-02
        
        ok, in this case, you don't have postgres15, check your postgr version
        
        On Monday, September 2, 2024 at 08:46:04 PM GMT+2, David Jarvie <djar@users.sourceforge.net> wrote:
        
        There is no directory postgresql15 on my system. I moved libadate.so into the postgresql/15/lib directory, but the error messages indicated that it is incompatible with postgresql 15:
        
        psql:/usr/local/share/skylendar/installskydb.sql:978: ERROR: incompatible library "/usr/lib/postgresql/15/lib/libadate.so": version mismatch
        DETAIL: Server is version 15, library is version 14.
        
        [tickets:#4] libadate not found in installation, psql
        
        Status: open
        Milestone: 1.0
        Labels: sql
        Created: Mon Jun 24, 2024 06:19 PM UTC by Camilo Villavicencio
        Last Updated: Mon Sep 02, 2024 06:03 PM UTC
        Owner: Christophe
        
        Hi Cristoph. Last night i found your skylendar software, read about its features and i really want use it. I didn't found a package so i decided compile it. (meanwhile i readed the shame on you file; good experiment to confirm the sadly reality of this hyperconnected century where's hard find people who take five minutes to send, at least, an alarm about something not working, in a literally free gift from some kind person).
        Well, i compiled and it runs, but when im trying setup with skydmin i get this log:
        
        ´´´
        psql:/usr/share/skylendar/installskydb.sql:9: NOTICE: la extensión «plpgsql» ya existe, omitiendo
        psql:/usr/share/skylendar/installskydb.sql:980: WARNING: Initial Level
        psql:/usr/share/skylendar/installskydb.sql:980: WARNING: Level 4.0.3
        psql:/usr/share/skylendar/installskydb.sql:980: WARNING: Level 4.1
        psql:/usr/share/skylendar/installskydb.sql:980: WARNING: Level 4.1.1
        psql:/usr/share/skylendar/installskydb.sql:980: NOTICE: el tipo de retorno adate está inconcluso
        psql:/usr/share/skylendar/installskydb.sql:980: ERROR: no se pudo acceder al archivo «libadate»: No existe el fichero o el directorio
        CONTEXTO: sentencia SQL: «CREATE FUNCTION adate_input(cstring) RETURNS adate AS 'libadate', 'adate_input' LANGUAGE C IMMUTABLE»
        función PL/pgSQL inline_code_block en la línea 456 en sentencia SQL
        psql:/usr/share/skylendar/installskydb.sql:986: ERROR: no existe la relación «interpret»
        LÍNEA 2: SELECT COALESCE((SELECT Text FROM Interpret WHERE Lang =...
        ^
        psql:/usr/share/skylendar/installskydb.sql:988: ERROR: no existe la relación «data»
        psql:/usr/share/skylendar/installskydb.sql:990: ERROR: no existe la relación «data_idx_seq»
        psql:/usr/share/skylendar/installskydb.sql:992: ERROR: no existe la relación «typeicons»
        psql:/usr/share/skylendar/installskydb.sql:994: ERROR: no existe la función getinter(character varying, character)
        psql:/usr/share/skylendar/installskydb.sql:1001: ERROR: no existe el rol «skyusers»
        
        CREATE VIEW
        CREATE EXTENSION
        SET
        CREATE FUNCTION
        [...]
        CREATE FUNCTION
        DROP VIEW
        DROP FUNCTION
        [...]
        CREATE VIEW
        ANALYZE
        
        Installation finished !
        
        Now, click on [...]
        ´´´
        
        i've experience with mysql, so i can generally understand generic sql language (crud, and a bit more) but i can't get whats going wrong and how i can fix it.
        
        Can you give me a hand or orientation to get skylendar works? i really appreciate your work and i really want to use it. Have a nice day, and happy solstices. Thanks.
        
        Camilo
        
        Sent from sourceforge.net because you indicated interest in https://sourceforge.net/p/skylendar/tickets/4/
        
        To unsubscribe from further messages, please visit https://sourceforge.net/auth/subscriptions/
        
        Related
        
        Tickets: #4
        
        alternate
        
        If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
        
        David Jarvie - 2024-09-02
        
        I do have postgresql 15:
        
        psql --version
        psql (PostgreSQL) 15.8 (Debian 15.)8-0+deb12u1
        
        The directory /usr/lib/postgresql/15 is populated with quite a number of files in its bin and lib subdirectories.
        
        If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
        
        Christophe - 2024-09-03
        
        Did you comipile skylendar yourself or use the provided .deb archive ?
        
        On Monday, September 2, 2024 at 10:00:25 PM GMT+2, David Jarvie <djar@users.sourceforge.net> wrote:
        
        I do have postgresql 15:
        
        psql --version
        psql (PostgreSQL) 15.8 (Debian 15.)8-0+deb12u1
        
        The directory /usr/lib/postgresql/15 is populated with quite a number of files in its bin and lib subdirectories.
        
        [tickets:#4] libadate not found in installation, psql
        
        Status: open
        Milestone: 1.0
        Labels: sql
        Created: Mon Jun 24, 2024 06:19 PM UTC by Camilo Villavicencio
        Last Updated: Mon Sep 02, 2024 06:46 PM UTC
        Owner: Christophe
        
        Hi Cristoph. Last night i found your skylendar software, read about its features and i really want use it. I didn't found a package so i decided compile it. (meanwhile i readed the shame on you file; good experiment to confirm the sadly reality of this hyperconnected century where's hard find people who take five minutes to send, at least, an alarm about something not working, in a literally free gift from some kind person).
        Well, i compiled and it runs, but when im trying setup with skydmin i get this log:
        
        ´´´
        psql:/usr/share/skylendar/installskydb.sql:9: NOTICE: la extensión «plpgsql» ya existe, omitiendo
        psql:/usr/share/skylendar/installskydb.sql:980: WARNING: Initial Level
        psql:/usr/share/skylendar/installskydb.sql:980: WARNING: Level 4.0.3
        psql:/usr/share/skylendar/installskydb.sql:980: WARNING: Level 4.1
        psql:/usr/share/skylendar/installskydb.sql:980: WARNING: Level 4.1.1
        psql:/usr/share/skylendar/installskydb.sql:980: NOTICE: el tipo de retorno adate está inconcluso
        psql:/usr/share/skylendar/installskydb.sql:980: ERROR: no se pudo acceder al archivo «libadate»: No existe el fichero o el directorio
        CONTEXTO: sentencia SQL: «CREATE FUNCTION adate_input(cstring) RETURNS adate AS 'libadate', 'adate_input' LANGUAGE C IMMUTABLE»
        función PL/pgSQL inline_code_block en la línea 456 en sentencia SQL
        psql:/usr/share/skylendar/installskydb.sql:986: ERROR: no existe la relación «interpret»
        LÍNEA 2: SELECT COALESCE((SELECT Text FROM Interpret WHERE Lang =...
        ^
        psql:/usr/share/skylendar/installskydb.sql:988: ERROR: no existe la relación «data»
        psql:/usr/share/skylendar/installskydb.sql:990: ERROR: no existe la relación «data_idx_seq»
        psql:/usr/share/skylendar/installskydb.sql:992: ERROR: no existe la relación «typeicons»
        psql:/usr/share/skylendar/installskydb.sql:994: ERROR: no existe la función getinter(character varying, character)
        psql:/usr/share/skylendar/installskydb.sql:1001: ERROR: no existe el rol «skyusers»
        
        CREATE VIEW
        CREATE EXTENSION
        SET
        CREATE FUNCTION
        [...]
        CREATE FUNCTION
        DROP VIEW
        DROP FUNCTION
        [...]
        CREATE VIEW
        ANALYZE
        
        Installation finished !
        
        Now, click on [...]
        ´´´
        
        i've experience with mysql, so i can generally understand generic sql language (crud, and a bit more) but i can't get whats going wrong and how i can fix it.
        
        Can you give me a hand or orientation to get skylendar works? i really appreciate your work and i really want to use it. Have a nice day, and happy solstices. Thanks.
        
        Camilo
        
        Sent from sourceforge.net because you indicated interest in https://sourceforge.net/p/skylendar/tickets/4/
        
        To unsubscribe from further messages, please visit https://sourceforge.net/auth/subscriptions/
        
        Related
        
        Tickets: #4
        
        alternate
        
        If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
        
        David Jarvie - 2024-09-03
        
        I used the provided skylendar-5.1.0.1-x86_64.deb package.
        
        If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
        
        Christophe - 2024-09-03
        
        So, everything seems to be correct
        
        On Tuesday, September 3, 2024 at 02:04:56 PM GMT+2, David Jarvie <djar@users.sourceforge.net> wrote:
        
        I used the provided skylendar-5.1.0.1-x86_64.deb package.
        
        [tickets:#4] libadate not found in installation, psql
        
        Status: open
        Milestone: 1.0
        Labels: sql
        Created: Mon Jun 24, 2024 06:19 PM UTC by Camilo Villavicencio
        Last Updated: Mon Sep 02, 2024 08:00 PM UTC
        Owner: Christophe
        
        Hi Cristoph. Last night i found your skylendar software, read about its features and i really want use it. I didn't found a package so i decided compile it. (meanwhile i readed the shame on you file; good experiment to confirm the sadly reality of this hyperconnected century where's hard find people who take five minutes to send, at least, an alarm about something not working, in a literally free gift from some kind person).
        Well, i compiled and it runs, but when im trying setup with skydmin i get this log:
        
        ´´´
        psql:/usr/share/skylendar/installskydb.sql:9: NOTICE: la extensión «plpgsql» ya existe, omitiendo
        psql:/usr/share/skylendar/installskydb.sql:980: WARNING: Initial Level
        psql:/usr/share/skylendar/installskydb.sql:980: WARNING: Level 4.0.3
        psql:/usr/share/skylendar/installskydb.sql:980: WARNING: Level 4.1
        psql:/usr/share/skylendar/installskydb.sql:980: WARNING: Level 4.1.1
        psql:/usr/share/skylendar/installskydb.sql:980: NOTICE: el tipo de retorno adate está inconcluso
        psql:/usr/share/skylendar/installskydb.sql:980: ERROR: no se pudo acceder al archivo «libadate»: No existe el fichero o el directorio
        CONTEXTO: sentencia SQL: «CREATE FUNCTION adate_input(cstring) RETURNS adate AS 'libadate', 'adate_input' LANGUAGE C IMMUTABLE»
        función PL/pgSQL inline_code_block en la línea 456 en sentencia SQL
        psql:/usr/share/skylendar/installskydb.sql:986: ERROR: no existe la relación «interpret»
        LÍNEA 2: SELECT COALESCE((SELECT Text FROM Interpret WHERE Lang =...
        ^
        psql:/usr/share/skylendar/installskydb.sql:988: ERROR: no existe la relación «data»
        psql:/usr/share/skylendar/installskydb.sql:990: ERROR: no existe la relación «data_idx_seq»
        psql:/usr/share/skylendar/installskydb.sql:992: ERROR: no existe la relación «typeicons»
        psql:/usr/share/skylendar/installskydb.sql:994: ERROR: no existe la función getinter(character varying, character)
        psql:/usr/share/skylendar/installskydb.sql:1001: ERROR: no existe el rol «skyusers»
        
        CREATE VIEW
        CREATE EXTENSION
        SET
        CREATE FUNCTION
        [...]
        CREATE FUNCTION
        DROP VIEW
        DROP FUNCTION
        [...]
        CREATE VIEW
        ANALYZE
        
        Installation finished !
        
        Now, click on [...]
        ´´´
        
        i've experience with mysql, so i can generally understand generic sql language (crud, and a bit more) but i can't get whats going wrong and how i can fix it.
        
        Can you give me a hand or orientation to get skylendar works? i really appreciate your work and i really want to use it. Have a nice day, and happy solstices. Thanks.
        
        Camilo
        
        Sent from sourceforge.net because you indicated interest in https://sourceforge.net/p/skylendar/tickets/4/
        
        To unsubscribe from further messages, please visit https://sourceforge.net/auth/subscriptions/
        
        Related
        
        Tickets: #4
        
        alternate
        
        If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
        
        David Jarvie - 2024-09-03
        
        Except that libadate.so isn't compatible with postgresql 15 on my system.
        
        If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
        
        Christophe - 2024-09-03
        
        Ok, this version is compiled for pg 14
        
        On Tuesday, September 3, 2024 at 06:22:51 PM GMT+2, David Jarvie <djar@users.sourceforge.net> wrote:
        
        Except that libadate.so isn't compatible with postgresql 15 on my system.
        
        [tickets:#4] libadate not found in installation, psql
        
        Status: open
        Milestone: 1.0
        Labels: sql
        Created: Mon Jun 24, 2024 06:19 PM UTC by Camilo Villavicencio
        Last Updated: Tue Sep 03, 2024 12:04 PM UTC
        Owner: Christophe
        
        Hi Cristoph. Last night i found your skylendar software, read about its features and i really want use it. I didn't found a package so i decided compile it. (meanwhile i readed the shame on you file; good experiment to confirm the sadly reality of this hyperconnected century where's hard find people who take five minutes to send, at least, an alarm about something not working, in a literally free gift from some kind person).
        Well, i compiled and it runs, but when im trying setup with skydmin i get this log:
        
        ´´´
        psql:/usr/share/skylendar/installskydb.sql:9: NOTICE: la extensión «plpgsql» ya existe, omitiendo
        psql:/usr/share/skylendar/installskydb.sql:980: WARNING: Initial Level
        psql:/usr/share/skylendar/installskydb.sql:980: WARNING: Level 4.0.3
        psql:/usr/share/skylendar/installskydb.sql:980: WARNING: Level 4.1
        psql:/usr/share/skylendar/installskydb.sql:980: WARNING: Level 4.1.1
        psql:/usr/share/skylendar/installskydb.sql:980: NOTICE: el tipo de retorno adate está inconcluso
        psql:/usr/share/skylendar/installskydb.sql:980: ERROR: no se pudo acceder al archivo «libadate»: No existe el fichero o el directorio
        CONTEXTO: sentencia SQL: «CREATE FUNCTION adate_input(cstring) RETURNS adate AS 'libadate', 'adate_input' LANGUAGE C IMMUTABLE»
        función PL/pgSQL inline_code_block en la línea 456 en sentencia SQL
        psql:/usr/share/skylendar/installskydb.sql:986: ERROR: no existe la relación «interpret»
        LÍNEA 2: SELECT COALESCE((SELECT Text FROM Interpret WHERE Lang =...
        ^
        psql:/usr/share/skylendar/installskydb.sql:988: ERROR: no existe la relación «data»
        psql:/usr/share/skylendar/installskydb.sql:990: ERROR: no existe la relación «data_idx_seq»
        psql:/usr/share/skylendar/installskydb.sql:992: ERROR: no existe la relación «typeicons»
        psql:/usr/share/skylendar/installskydb.sql:994: ERROR: no existe la función getinter(character varying, character)
        psql:/usr/share/skylendar/installskydb.sql:1001: ERROR: no existe el rol «skyusers»
        
        CREATE VIEW
        CREATE EXTENSION
        SET
        CREATE FUNCTION
        [...]
        CREATE FUNCTION
        DROP VIEW
        DROP FUNCTION
        [...]
        CREATE VIEW
        ANALYZE
        
        Installation finished !
        
        Now, click on [...]
        ´´´
        
        i've experience with mysql, so i can generally understand generic sql language (crud, and a bit more) but i can't get whats going wrong and how i can fix it.
        
        Can you give me a hand or orientation to get skylendar works? i really appreciate your work and i really want to use it. Have a nice day, and happy solstices. Thanks.
        
        Camilo
        
        Sent from sourceforge.net because you indicated interest in https://sourceforge.net/p/skylendar/tickets/4/
        
        To unsubscribe from further messages, please visit https://sourceforge.net/auth/subscriptions/
        
        Related
        
        Tickets: #4
        
        alternate
        
        If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

David Jarvie - 2024-08-26

Thanks for your quick reply. I'm a free software developer myself, so I understand the usefulness of bug reports!

I moved libadate.so from the deb package from /usr/lib/postgresql/14/lib/ to /usr/lib/postgresql/15/lib/, but it appears to be incompatible with postgresql 15. After trying again, skydmin shows the following errors:

psql:/usr/local/share/skylendar/installskydb.sql:978: NOTICE: return type adate is only a shell
psql:/usr/local/share/skylendar/installskydb.sql:978: ERROR: incompatible library "/usr/lib/postgresql/15/lib/libadate.so": version mismatch
DETAIL: Server is version 15, library is version 14.
CONTEXT: SQL statement "CREATE FUNCTION adate_input(cstring) RETURNS adate AS 'libadate', 'adate_input' LANGUAGE C IMMUTABLE"
PL/pgSQL function inline_code_block line 454 at SQL statement
psql:/usr/local/share/skylendar/installskydb.sql:984: ERROR: relation "interpret" does not exist
LINE 2: SELECT COALESCE((SELECT Text FROM Interpret WHERE Lang =...
^
psql:/usr/local/share/skylendar/installskydb.sql:986: ERROR: relation "data" does not exist
psql:/usr/local/share/skylendar/installskydb.sql:988: ERROR: relation "data_idx_seq" does not exist
psql:/usr/local/share/skylendar/installskydb.sql:990: ERROR: relation "typeicons" does not exist
psql:/usr/local/share/skylendar/installskydb.sql:992: ERROR: function getinter(character varying, character) does not exist
psql:/usr/local/share/skylendar/installskydb.sql:999: ERROR: role "skyusers" does not exist

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Log in to post a comment.