SGD - Sistema de Gestão de Demandas

Participe

Repositório

Wiki

Ajuda

Membros

Nenhum(a)

Ver todos(as)

Voltar a SGD - Fórum ...

Alguém já viu este erro no processo de instalação do SGD no PostgreSQL 8.1? Já verifiquei a codificação do cliente e do servidor e estão ambos em UTF8. O que pode esta acontecendo, alguém tem alguma idéia???

(Warning: pg_query() [function.pg-query]: Query failed: ERRO: sequÃªncia de bytes invÃ¡lida para codificaÃ§Ã£o "UTF8": 0xc7c3 HINT: This error can also happen if the byte sequence does not match the encoding expected by the server, which is controlled by "client_encoding". in /var/www/sgd/installation/setup.php on line 361)

Autor: Robson Cruz dos Santos

88 comentários

Wanderson Santiago dos Reis(usuário não autenticado)
16 de Outubro de 2007, 13:11

com o banco como LATIN1, não dá este erro, mas depois de instalado não entra no sistema de jeito algum.

Você conseguiu? estou tentando uma configuração igual a sua PgSQL 8.1 e Debian 4.
- wanderson clerio da silva(usuário não autenticado)
  
  3 de Dezembro de 2007, 15:25
  
  Tentei diversas vezes instalar o sgd com banco de dados postgresql sem sucesso. Apos preencher a tela de instalacao e clicar em salvar e apresentado varias mensagens de erro. O sistema chega a tela de login, porem, e constado nos logs e no banco de dados a falta de varias tabelas e por isso o sistema nao loga.
  - wanderson clerio da silva(usuário não autenticado)
    
    3 de Dezembro de 2007, 15:27
    
    erros
    Warning: pg_connect() [function.pg-connect]: Unable to connect to PostgreSQL server: fe_sendauth: no password supplied in /var/www/sgd/installation/setup.php on line 356
    Warning: pg_last_error() [function.pg-last-error]: No PostgreSQL link opened yet in /var/www/sgd/installation/setup.php on line 357
    Warning: pg_query() [function.pg-query]: No PostgreSQL link opened yet in /var/www/sgd/installation/setup.php on line 361
    Warning: pg_last_error() [function.pg-last-error]: No PostgreSQL link opened yet in /var/www/sgd/installation/setup.php on line 363
    Warning: pg_query() [function.pg-query]: No PostgreSQL link opened yet in /var/www/sgd/installation/setup.php on line 361
    Warning: pg_last_error() [function.pg-last-error]: No PostgreSQL link opened yet in /var/www/sgd/installation/setup.php on line 363
    Warning: pg_query() [function.pg-query]: No PostgreSQL link opened yet in /var/www/sgd/installation/setup.php on line 361
    Warning: pg_last_error() [function.pg-last-error]: No PostgreSQL link opened yet in /var/www/sgd/installation/setup.php on line 363
    Warning: pg_query() [function.pg-query]: No PostgreSQL link opened yet in /var/www/sgd/installation/setup.php on line 361
    Warning: pg_last_error() [function.pg-last-error]: No PostgreSQL link opened yet in /var/www/sgd/installation/setup.php on line 363
    Warning: pg_query() [function.pg-query]: No PostgreSQL link opened yet in /var/www/sgd/installation/setup.php on line 361
    Warning: pg_last_error() [function.pg-last-error]: No PostgreSQL link opened yet in /var/www/sgd/installation/setup.php on line 363
    Warning: pg_query() [function.pg-query]: No PostgreSQL link opened yet in /var/www/sgd/installation/setup.php on line 361
    Warning: pg_last_error() [function.pg-last-error]: No PostgreSQL link opened yet in /var/www/sgd/installation/setup.php on line 363
    Warning: pg_query() [function.pg-query]: No PostgreSQL link opened yet in /var/www/sgd/installation/setup.php on line 361
    Warning: pg_last_error() [function.pg-last-error]: No PostgreSQL link opened yet in /var/www/sgd/installation/setup.php on line 363
    Warning: pg_query() [function.pg-query]: No PostgreSQL link opened yet in /var/www/sgd/installation/setup.php on line 361
    Warning: pg_last_error() [function.pg-last-error]: No PostgreSQL link opened yet in /var/www/sgd/installation/setup.php on line 363
    Warning: pg_query() [function.pg-query]: No PostgreSQL link opened yet in /var/www/sgd/installation/setup.php on line 361
    Warning: pg_last_error() [function.pg-last-error]: No PostgreSQL link opened yet in /var/www/sgd/installation/setup.php on line 363
    Warning: pg_query() [function.pg-query]: No PostgreSQL link opened yet in /var/www/sgd/installation/setup.php on line 361
    Warning: pg_last_error() [function.pg-last-error]: No PostgreSQL link opened yet in /var/www/sgd/installation/setup.php on line 363
    Warning: pg_query() [function.pg-query]: No PostgreSQL link opened yet in /var/www/sgd/installation/setup.php on line 361
    Warning: pg_last_error() [function.pg-last-error]: No PostgreSQL link opened yet in /var/www/sgd/installation/setup.php on line 363
    Warning: pg_query() [function.pg-query]: No PostgreSQL link opened yet in /var/www/sgd/installation/setup.php on line 361
    Warning: pg_last_error() [function.pg-last-error]: No PostgreSQL link opened yet in /var/www/sgd/installation/setup.php on line 363
    Warning: pg_query() [function.pg-query]: No PostgreSQL link opened yet in /var/www/sgd/installation/setup.php on line 361
    Warning: pg_last_error() [function.pg-last-error]: No PostgreSQL link opened yet in /var/www/sgd/installation/setup.php on line 363
    Warning: pg_query() [function.pg-query]: No PostgreSQL link opened yet in /var/www/sgd/installation/setup.php on line 361
    Warning: pg_last_error() [function.pg-last-error]: No PostgreSQL link opened yet in /var/www/sgd/installation/setup.php on line 363
    Warning: pg_query() [function.pg-query]: No PostgreSQL link opened yet in /var/www/sgd/installation/setup.php on line 361
    Warning: pg_last_error() [function.pg-last-error]: No PostgreSQL link opened yet in /var/www/sgd/installation/setup.php on line 363
    Warning: pg_query() [function.pg-query]: No PostgreSQL link opened yet in /var/www/sgd/installation/setup.php on line 361
    Warning: pg_last_error() [function.pg-last-error]: No PostgreSQL link opened yet in /var/www/sgd/installation/setup.php on line 363
    Warning: pg_query() [function.pg-query]: No PostgreSQL link opened yet in /var/www/sgd/installation/setup.php on line 361
    Warning: pg_last_error() [function.pg-last-error]: No PostgreSQL link opened yet in /var/www/sgd/installation/setup.php on line 363
    Warning: pg_query() [function.pg-query]: No PostgreSQL link opened yet in /var/www/sgd/installation/setup.php on line 361
    Warning: pg_last_error() [function.pg-last-error]: No PostgreSQL link opened yet in /var/www/sgd/installation/setup.php on line 363
    Warning: pg_query() [function.pg-query]: No PostgreSQL link opened yet in /var/www/sgd/installation/setup.php on line 361
    Warning: pg_last_error() [function.pg-last-error]: No PostgreSQL link opened yet in /var/www/sgd/installation/setup.php on line 363
    Warning: pg_query() [function.pg-query]: No PostgreSQL link opened yet in /var/www/sgd/installation/setup.php on line 361
    Warning: pg_last_error() [function.pg-last-error]: No PostgreSQL link opened yet in /var/www/sgd/installation/setup.php on line 363
    Warning: pg_query() [function.pg-query]: No PostgreSQL link opened yet in /var/www/sgd/installation/setup.php on line 361
    Warning: pg_last_error() [function.pg-last-error]: No PostgreSQL link opened yet in /var/www/sgd/installation/setup.php on line 363
    Warning: pg_query() [function.pg-query]: No PostgreSQL link opened yet in /var/www/sgd/installation/setup.php on line 361
    Warning: pg_last_error() [function.pg-last-error]: No PostgreSQL link opened yet in /var/www/sgd/installation/setup.php on line 363
    Warning: pg_query() [function.pg-query]: No PostgreSQL link opened yet in /var/www/sgd/installation/setup.php on line 361
    Warning: pg_last_error() [function.pg-last-error]: No PostgreSQL link opened yet in /var/www/sgd/installation/setup.php on line 363
    Warning: pg_query() [function.pg-query]: No PostgreSQL link opened yet in /var/www/sgd/installation/setup.php on line 361
    Warning: pg_last_error() [function.pg-last-error]: No PostgreSQL link opened yet in /var/www/sgd/installation/setup.php on line 363
    Warning: pg_query() [function.pg-query]: No PostgreSQL link opened yet in /var/www/sgd/installation/setup.php on line 361
    Warning: pg_last_error() [function.pg-last-error]: No PostgreSQL link opened yet in /var/www/sgd/installation/setup.php on line 363
    Warning: pg_query() [function.pg-query]: No PostgreSQL link opened yet in /var/www/sgd/installation/setup.php on line 361
    Warning: pg_last_error() [function.pg-last-error]: No PostgreSQL link opened yet in /var/www/sgd/installation/setup.php on line 363
    Warning: pg_query() [function.pg-query]: No PostgreSQL link opened yet in /var/www/sgd/installation/setup.php on line 361
    Warning: pg_last_error() [function.pg-last-error]: No PostgreSQL link opened yet in /var/www/sgd/installation/setup.php on line 363
    Warning: pg_query() [function.pg-query]: No PostgreSQL link opened yet in /var/www/sgd/installation/setup.php on line 361
    Warning: pg_last_error() [function.pg-last-error]: No PostgreSQL link opened yet in /var/www/sgd/installation/setup.php on line 363
    Warning: pg_query() [function.pg-query]: No PostgreSQL link opened yet in /var/www/sgd/installation/setup.php on line 361
    Warning: pg_last_error() [function.pg-last-error]: No PostgreSQL link opened yet in /var/www/sgd/installation/setup.php on line 363
    Warning: pg_query() [function.pg-query]: No PostgreSQL link opened yet in /var/www/sgd/installation/setup.php on line 361
    Warning: pg_last_error() [function.pg-last-error]: No PostgreSQL link opened yet in /var/www/sgd/installation/setup.php on line 363
    Warning: pg_query() [function.pg-query]: No PostgreSQL link opened yet in /var/www/sgd/installation/setup.php on line 361
    Warning: pg_last_error() [function.pg-last-error]: No PostgreSQL link opened yet in /var/www/sgd/installation/setup.php on line 363
    Warning: pg_query() [function.pg-query]: No PostgreSQL link opened yet in /var/www/sgd/installation/setup.php on line 361
    Warning: pg_last_error() [function.pg-last-error]: No PostgreSQL link opened yet in /var/www/sgd/installation/setup.php on line 363
    Warning: pg_query() [function.pg-query]: No PostgreSQL link opened yet in /var/www/sgd/installation/setup.php on line 361
    Warning: pg_last_error() [function.pg-last-error]: No PostgreSQL link opened yet in /var/www/sgd/installation/setup.php on line 363
    Warning: pg_query() [function.pg-query]: No PostgreSQL link opened yet in /var/www/sgd/installation/setup.php on line 361
    Warning: pg_last_error() [function.pg-last-error]: No PostgreSQL link opened yet in /var/www/sgd/installation/setup.php on line 363
    Warning: pg_query() [function.pg-query]: No PostgreSQL link opened yet in /var/www/sgd/installation/setup.php on line 361
    Warning: pg_last_error() [function.pg-last-error]: No PostgreSQL link opened yet in /var/www/sgd/installation/setup.php on line 363
    Warning: pg_query() [function.pg-query]: No PostgreSQL link opened yet in /var/www/sgd/installation/setup.php on line 361
    Warning: pg_last_error() [function.pg-last-error]: No PostgreSQL link opened yet in /var/www/sgd/installation/setup.php on line 363
    Warning: pg_query() [function.pg-query]: No PostgreSQL link opened yet in /var/www/sgd/installation/setup.php on line 361
    Warning: pg_last_error() [function.pg-last-error]: No PostgreSQL link opened yet in /var/www/sgd/installation/setup.php on line 363
    Warning: pg_query() [function.pg-query]: No PostgreSQL link opened yet in /var/www/sgd/installation/setup.php on line 361
    Warning: pg_last_error() [function.pg-last-error]: No PostgreSQL link opened yet in /var/www/sgd/installation/setup.php on line 363
    Warning: pg_query() [function.pg-query]: No PostgreSQL link opened yet in /var/www/sgd/installation/setup.php on line 361
    Warning: pg_last_error() [function.pg-last-error]: No PostgreSQL link opened yet in /var/www/sgd/installation/setup.php on line 363
    Warning: pg_query() [function.pg-query]: No PostgreSQL link opened yet in /var/www/sgd/installation/setup.php on line 361
    Warning: pg_last_error() [function.pg-last-error]: No PostgreSQL link opened yet in /var/www/sgd/installation/setup.php on line 363
    Warning: pg_query() [function.pg-query]: No PostgreSQL link opened yet in /var/www/sgd/installation/setup.php on line 361
    Warning: pg_last_error() [function.pg-last-error]: No PostgreSQL link opened yet in /var/www/sgd/installation/setup.php on line 363
    Warning: pg_query() [function.pg-query]: No PostgreSQL link opened yet in /var/www/sgd/installation/setup.php on line 361
    Warning: pg_last_error() [function.pg-last-error]: No PostgreSQL link opened yet in /var/www/sgd/installation/setup.php on line 363
    Warning: pg_query() [function.pg-query]: No PostgreSQL link opened yet in /var/www/sgd/installation/setup.php on line 361
    Warning: pg_last_error() [function.pg-last-error]: No PostgreSQL link opened yet in /var/www/sgd/installation/setup.php on line 363
    Warning: pg_query() [function.pg-query]: No PostgreSQL link opened yet in /var/www/sgd/installation/setup.php on line 361
    Warning: pg_last_error() [function.pg-last-error]: No PostgreSQL link opened yet in /var/www/sgd/installation/setup.php on line 363
    Warning: pg_query() [function.pg-query]: No PostgreSQL link opened yet in /var/www/sgd/installation/setup.php on line 361
    Warning: pg_last_error() [function.pg-last-error]: No PostgreSQL link opened yet in /var/www/sgd/installation/setup.php on line 363
    Warning: pg_query() [function.pg-query]: No PostgreSQL link opened yet in /var/www/sgd/installation/setup.php on line 361
    Warning: pg_last_error() [function.pg-last-error]: No PostgreSQL link opened yet in /var/www/sgd/installation/setup.php on line 363
    Warning: pg_query() [function.pg-query]: No PostgreSQL link opened yet in /var/www/sgd/installation/setup.php on line 361
    Warning: pg_last_error() [function.pg-last-error]: No PostgreSQL link opened yet in /var/www/sgd/installation/setup.php on line 363
    Warning: pg_query() [function.pg-query]: No PostgreSQL link opened yet in /var/www/sgd/installation/setup.php on line 361
    Warning: pg_last_error() [function.pg-last-error]: No PostgreSQL link opened yet in /var/www/sgd/installation/setup.php on line 363
    Warning: pg_query() [function.pg-query]: No PostgreSQL link opened yet in /var/www/sgd/installation/setup.php on line 361
    Warning: pg_last_error() [function.pg-last-error]: No PostgreSQL link opened yet in /var/www/sgd/installation/setup.php on line 363
    Warning: pg_query() [function.pg-query]: No PostgreSQL link opened yet in /var/www/sgd/installation/setup.php on line 361
    Warning: pg_last_error() [function.pg-last-error]: No PostgreSQL link opened yet in /var/www/sgd/installation/setup.php on line 363
    Warning: pg_query() [function.pg-query]: No PostgreSQL link opened yet in /var/www/sgd/installation/setup.php on line 361
    
    wanderson clerio da silva(usuário não autenticado)
    
    3 de Dezembro de 2007, 15:31
    
    Desconsidere o post anterior, foi postado errado.
    
    wanderson clerio da silva(usuário não autenticado)
    
    3 de Dezembro de 2007, 15:32
    
    Warning: pg_query() [function.pg-query]: Query failed: ERRO: erro de sintaxe em ou prÃ³ximo a "varchar" at character 55 in /var/www/sgd/installation/setup.php on line 361
    Warning: pg_query() [function.pg-query]: Query failed: ERRO: erro de sintaxe em ou prÃ³ximo a "varchar" at character 77 in /var/www/sgd/installation/setup.php on line 361
    Warning: pg_query() [function.pg-query]: Query failed: ERRO: erro de sintaxe em ou prÃ³ximo a "char" at character 79 in /var/www/sgd/installation/setup.php on line 361
    Warning: pg_query() [function.pg-query]: Query failed: ERRO: erro de sintaxe em ou prÃ³ximo a "varchar" at character 68 in /var/www/sgd/installation/setup.php on line 361
    Warning: pg_query() [function.pg-query]: Query failed: ERRO: erro de sintaxe em ou prÃ³ximo a "varchar" at character 72 in /var/www/sgd/installation/setup.php on line 361
    Warning: pg_query() [function.pg-query]: Query failed: ERRO: erro de sintaxe em ou prÃ³ximo a "int4" at character 87 in /var/www/sgd/installation/setup.php on line 361
    Warning: pg_query() [function.pg-query]: Query failed: ERRO: erro de sintaxe em ou prÃ³ximo a "int4" at character 80 in /var/www/sgd/installation/setup.php on line 361
    Warning: pg_query() [function.pg-query]: Query failed: ERRO: erro de sintaxe em ou prÃ³ximo a "int4" at character 91 in /var/www/sgd/installation/setup.php on line 361
    Warning: pg_query() [function.pg-query]: Query failed: ERRO: erro de sintaxe em ou prÃ³ximo a "varchar" at character 85 in /var/www/sgd/installation/setup.php on line 361
    Warning: pg_query() [function.pg-query]: Query failed: ERRO: erro de sintaxe em ou prÃ³ximo a "varchar" at character 51 in /var/www/sgd/installation/setup.php on line 361
    Warning: pg_query() [function.pg-query]: Query failed: ERRO: relaÃ§Ã£o "sistemas" nÃ£o existe in /var/www/sgd/installation/setup.php on line 361
    Warning: pg_query() [function.pg-query]: Query failed: ERRO: erro de sintaxe em ou prÃ³ximo a "int4" at character 61 in /var/www/sgd/installation/setup.php on line 361
    Warning: pg_query() [function.pg-query]: Query failed: ERRO: erro de sintaxe em ou prÃ³ximo a "int4" at character 80 in /var/www/sgd/installation/setup.php on line 361
    Warning: pg_query() [function.pg-query]: Query failed: ERRO: relaÃ§Ã£o "s_usuario_grupo" nÃ£o existe in /var/www/sgd/installation/setup.php on line 361
    
    wanderson clerio da silva(usuário não autenticado)
    
    3 de Dezembro de 2007, 15:36
    
    Warning: pg_query() [function.pg-query]: Query failed: ERRO: erro de sintaxe em ou prÃ³ximo a "varchar" at character 58 in /var/www/sgd/installation/setup.php on line 361
    Warning: pg_query() [function.pg-query]: Query failed: ERRO: relacao "s_grupo" nÃ£o exao "s_grupo" nÃ£o existe in /var/www/sgd/installation/setup.php on line 361
    Warning: pg_query() [function.pg-query]: Query failed: ERRO: relacao ERRO: relaÃ£A relacao ERRO: relaÃ§Ã£o "s_grupo" nÃ£o existe in /var/www/sgd/installation/setup.php on line 361
    Warning: pg_query() [function.pg-query]: Query failed: ERRO: relacaoo "s_grupo" nÃ£o existe in /var/www/sgd/installation/setup.php on line 361
    Warning: pg_query() [function.pg-query]: Query failed: ERRO: relacao£o "s_grupo" nÃ£o existe in /var/www/sgd/installation/setup.php on line 361
    Warning: pg_query() [function.pg-query]: Query failed: ERRO: relacao "s_grupo" nÃ£o existe in /var/www/sgd/installation/setup.php on line 361
    Warning: pg_query() [function.pg-query]: Query failed: ERRO: relacao "s_grupo" nÃ£o existe in /var/www/sgd/installation/setup.php on line 361
    Warning: pg_query() [function.pg-query]: Query failed: ERRO: relacao "s_grupo" nÃ£o existe in /var/www/sgd/installation/setup.php on line 361
    Warning: pg_query() [function.pg-query]: Query failed: ERRO: relacao "s_grupo" nÃ£o existe in /var/www/sgd/installation/setup.php on line 361
    Warning: pg_query() [function.pg-query]: Query failed: ERRO: relacao "s_grupo" nÃ£o existe in /var/www/sgd/installation/setup.php on line 361
    Warning: pg_query() [function.pg-query]: Query failed: ERRO: erro de sintaxe em ou prÃ³ximo a "int4" at character 88 in /var/www/sgd/installation/setup.php on line 361
    Warning: pg_query() [function.pg-query]: Query failed: ERRO: erro de sintaxe em ou prÃ³ximo a "varchar" at character 71 in /var/www/sgd/installation/setup.php on line 361
    Warning: pg_query() [function.pg-query]: Query failed: ERRO: erro de sintaxe em ou prÃ³ximo a "varchar" at character 59 in /var/www/sgd/installation/setup.php on line 361
    Warning: pg_query() [function.pg-query]: Query failed: ERRO: erro de sintaxe em ou prÃ³ximo a "varchar" at character 58 in /var/www/sgd/installation/setup.php on line 361
    Warning: pg_query() [function.pg-query]: Query failed: ERRO: erro de sintaxe em ou prÃ³ximo a "char" at character 48 in /var/www/sgd/installation/setup.php on line 361
    Warning: pg_query() [function.pg-query]: Query failed: ERRO: erro de sintaxe em ou prÃ³ximo a "int" at character 54 in /var/www/sgd/installation/setup.php on line 361
    Warning: pg_query() [function.pg-query]: Query failed: ERRO: erro de sintaxe em ou prÃ³ximo a "varchar" at character 53 in /var/www/sgd/installation/setup.php on line 361
    Warning: pg_query() [function.pg-query]: Query failed: ERRO: erro de sintaxe em ou prÃ³ximo a "int4" at character 54 in /var/www/sgd/installation/setup.php on line 361
    Warning: pg_query() [function.pg-query]: Query failed: ERRO: erro de sintaxe em ou prÃ³ximo a "varchar" at character 55 in /var/www/sgd/installation/setup.php on line 361
    &
    
    wanderson clerio da silva(usuário não autenticado)
    
    3 de Dezembro de 2007, 15:40
    
    Mesmo apos estes erros, renomeando a pasta installation, o sistema chega a tela de login.
    Nao se consegue logar. Verificando os logs do postgresql e as tabelas detectamos a falta de criacao de tabelas e relacionamentos.
    Alguem conseguiu instalar o sistema rodando ceguiu instalar o sistema rodando com postgresql. No windows, o problema se repete.
    %
    
    wanderson clerio da silva(usuário não autenticado)
    
    10 de Dezembro de 2007, 9:58
    
    Infelizmente, estamos abandonando a utilização do SGD.Como usuário, não conseguimos fazer uma instalação satisfatória do sistema e não conseguimos resposta sobre nossos posts. Informamos que tanto o mysql quanto o postgresql estao devidamente instalados e com outros sistemas funcinando normalmente.
    Quem sabe numa proxima versao...

Discussões
Blog
Feed do Repositório

Participação da Reunião de Coordenação Geral do Portal do Software Público

10 de Março de 2014, 11:47, por Desconhecido

Estamos participando hoje(10/04/2014) da Reunião de Coordenação Geral do Portal do Software Público, onde discutiremos sobre o novo portal do software publico, bem como as novas ferramentas e recursos que serão disponibilizados para as comunidades.

sem comentários ainda Leia mais

Quem usa o SGD?

23 de Julho de 2013, 11:42, por Desconhecido

Olá!

sem comentários ainda Leia mais

Visita da Delegação de Moçambique

8 de Maio de 2009, 20:21, por Desconhecido

É com grande satisfação que o SGD foi apresentado para a delegação de Moçambique que esteve no Brasil em março de 2009. Na ocasião o sistema foi apresentado pelos adminstradores da Comunidade SGD, Sr. Rogério Leitão e Sra. Pollyanna Mendes, no Edifício Sede do FNDE - Fundo Nacional de Denvolvimento da Educação.

sem comentários ainda Leia mais

SGD no INEP

16 de Outubro de 2007, 14:35, por Desconhecido

Autor: Rogério de Souza Leitão

sem comentários ainda Leia mais

SGD é apresentado na 5ª Reunião Técnica de Informática - CBTU no Rio de Janeiro

20 de Setembro de 2007, 11:23, por Desconhecido

Autor: Rogério de Souza Leitão

sem comentários ainda Leia mais