Neue Datenbank erstellen - Fehler

    • Furo
      Furo
      Silber
      Dabei seit: 06.04.2007 Beiträge: 11.046
      Hab den Elephant heute Nacht installiert und wollts direkt mal testen, allerdings ist es mir nicht möglich eine Datenbank zu erstellen.

      Kommt dann immer:

      Es konnte keine Verbindung zum Datenbankserver aufgestellt werden!

      Erweiterte Informationen:

      Failed to establish a connection to `localhost`.



      Muss ich da noch irgendwas anders einstellen? War davon ausgegangen, dass die regulären Einstellungen ausreichen :(
  • 6 Antworten
    • 6Wishmaster6
      6Wishmaster6
      Black
      Dabei seit: 16.01.2005 Beiträge: 3.807
      ist ein problem mit der aktuellen Version. Probiere bitte die Version noch einmal die wir heuite abend releasen.

      Wenn du jetzt bereits testen möchtest lege ich dir die Version v32 ans Herz, die funktioniert überall super, nur nicht so auf FullTilt.

      Die heute abend soll natpürlich alle problem beheben.
    • Furo
      Furo
      Silber
      Dabei seit: 06.04.2007 Beiträge: 11.046
      Gut dann warte ich solange, hatte den Elephant vorher noch nie getestet :)
    • Furo
      Furo
      Silber
      Dabei seit: 06.04.2007 Beiträge: 11.046
      Hab die neue Version installiert, Fehlermeldung kommt immer noch.
      Muss ich vielleicht irgendwas bei dem Postblabla umstellen?

      Bei PT gehts doch auch ohne so ne Datenbank, kann man das nicht noch anders regeln?
    • OJayPoker
      OJayPoker
      Bronze
      Dabei seit: 27.07.2007 Beiträge: 1.034
      Hallo,

      auf Windows XP mit SP2 bekomme ich bei der Installation von Elephant folgende Fehlermeldungen von meinem PostgreSQL-Server (neuer DB-Name, den ich während der Installation von E anlegen lassen wollte: 'testdb3'):

      Kann mir jemand helfen?? Welche SQL-Kommandos feuert ihr da auf den DB-Server ab? Wo werden diese Kommandos mitgeloggt?? Wenn ich danach in die DB schaue wurden wenige Tabellen angelegt, aber klappte halt wohl nicht alles. Woran könnte das liegen? Andere User bekommen anscheinend eine funktionierende DB angelegt. Liegt es an meiner PostgreSQL-Version (8.0.7)???


      $ FATAL: database "testdb3" does not exist
      FATAL: database "testdb3" does not exist
      ERROR: syntax error at or near "ENUM" at character 26
      ERROR: type "limittype" does not exist
      ERROR: syntax error at or near "ENUM" at character 23
      ERROR: type "origin" does not exist
      ERROR: syntax error at or near "ENUM" at character 21
      ERROR: type "card" does not exist
      ERROR: syntax error at or near "ENUM" at character 30
      ERROR: type "combinedcards" does not exist
      ERROR: syntax error at or near "ENUM" at character 26
      ERROR: type "gamephase" does not exist
      ERROR: syntax error at or near "ENUM" at character 28
      ERROR: type "blindserror" does not exist
      ERROR: syntax error at or near "ENUM" at character 23
      ERROR: type "action" does not exist
      ERROR: syntax error at or near "ENUM" at character 26
      ERROR: type "moneytype" does not exist
      ERROR: syntax error at or near "ENUM" at character 23
      ERROR: type "valuta" does not exist
      ERROR: syntax error at or near "ENUM" at character 28
      ERROR: type "commenttype" does not exist
      ERROR: syntax error at or near "ENUM" at character 29
      ERROR: type "longposition" does not exist
      ERROR: syntax error at or near "ENUM" at character 30
      ERROR: type "shortposition" does not exist
      ERROR: type "moneytype" does not exist
      ERROR: relation "public.archive" does not exist
      NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "category_pkey" f
      or table "category"
      ERROR: type "commenttype" does not exist
      ERROR: relation "comment" does not exist
      ERROR: relation "public.comment" does not exist
      ERROR: function nextval(regclass) does not exist
      HINT: No function matches the given name and argument types. You may need to ad
      d explicit type casts.
      ERROR: relation "public.comment_on_player" does not exist
      ERROR: type "card" does not exist
      ERROR: relation "game" does not exist
      ERROR: relation "game" does not exist
      ERROR: relation "game" does not exist
      ERROR: relation "public.game" does not exist
      ERROR: function nextval(regclass) does not exist
      HINT: No function matches the given name and argument types. You may need to ad
      d explicit type casts.
      ERROR: relation "public.gamechat" does not exist
      ERROR: type "card" does not exist
      ERROR: relation "gameplayer" does not exist
      ERROR: relation "gameplayer" does not exist
      ERROR: relation "public.gameplayer" does not exist
      ERROR: type "action" does not exist
      ERROR: relation "gamesequence" does not exist
      ERROR: relation "gamesequence" does not exist
      ERROR: relation "gamesequence" does not exist
      ERROR: relation "public.gamesequence" does not exist
      ERROR: function nextval(regclass) does not exist
      HINT: No function matches the given name and argument types. You may need to ad
      d explicit type casts.
      ERROR: relation "gametable" does not exist
      ERROR: relation "public.gametable" does not exist
      NOTICE: CREATE TABLE will create implicit sequence "gametype_game_type_id_seq1"
      for serial column "gametype.game_type_id"
      ERROR: type "limittype" does not exist
      ERROR: relation "gametype" does not exist
      ERROR: relation "gametype" does not exist
      ERROR: relation "public.gametype" does not exist
      NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "media_content_pk
      ey" for table "media_content"
      ERROR: function nextval(regclass) does not exist
      HINT: No function matches the given name and argument types. You may need to ad
      d explicit type casts.
      ERROR: relation "public.player" does not exist
      LOG: could not receive data from client: Software caused connection abort
      LOG: unexpected EOF on client connection
      NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "playerstat_pkey"
      for table "playerstat"
      NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "playlist_pkey" f
      or table "playlist"
      NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "playlist_item_pk
      ey" for table "playlist_item"
      NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "portal_pkey" for
      table "portal"
      NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "quiz_pkey" for t
      able "quiz"
      NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "quiz_answer_pkey
      " for table "quiz_answer"
      NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "realplayer_pkey"
      for table "realplayer"
      ERROR: type "combinedcards" does not exist
      ERROR: relation "public.sorted_cards" does not exist
      ERROR: type "limittype" does not exist
      ERROR: relation "tournament" does not exist
      ERROR: relation "public.tournament" does not exist
      NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "trmt_payoutstruc
      ture_pkey" for table "trmt_payoutstructure"
      NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "trmt_player_pkey
      " for table "trmt_player"
      NOTICE: CREATE TABLE will create implicit sequence "unclear_id_seq1" for serial
      column "unclear.id"
      NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "unclear_pkey" fo
      r table "unclear"
      NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "uploader_pkey" f
      or table "uploader"
      NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "version_pkey" fo
      r table "version"
      ERROR: relation "public.player" does not exist
      ERROR: relation "public.player" does not exist
      ERROR: invalid byte sequence for encoding "UNICODE": 0xdf
      ERROR: relation "public.sorted_cards" does not exist
      ERROR: relation "gametype" does not exist
      ERROR: relation "player" does not exist
      ERROR: relation "gametable" does not exist
      ERROR: relation "gamechat" does not exist
      ERROR: relation "tournament" does not exist
      ERROR: relation "public.archive" does not exist
      ERROR: relation "game" does not exist
      ERROR: cannot cast type text to boolean
      LOG: could not receive data from client: Connection reset by peer
      ERROR: relation "gametype" does not exist
      LOG: unexpected EOF on client connection
      ERROR: relation "player" does not exist
      ERROR: relation "gametable" does not exist
      ERROR: relation "gamechat" does not exist
      ERROR: relation "tournament" does not exist
      ERROR: relation "public.archive" does not exist
      ERROR: relation "game" does not exist
      ERROR: cannot cast type text to boolean
      LOG: could not receive data from client: Software caused connection abort
      LOG: unexpected EOF on client connection
      ERROR: relation "gametype" does not exist
      ERROR: relation "player" does not exist
      ERROR: relation "gametable" does not exist
      ERROR: relation "gamechat" does not exist
      ERROR: relation "tournament" does not exist
      ERROR: relation "public.archive" does not exist
      ERROR: relation "game" does not exist
      ERROR: relation "sorted_cards" does not exist
      ERROR: relation "sorted_cards" does not exist
      ERROR: relation "player" does not exist
      ERROR: relation "player" does not exist
      ERROR: relation "sorted_cards" does not exist
      ERROR: relation "sorted_cards" does not exist
      ERROR: relation "sorted_cards" does not exist
      ERROR: relation "sorted_cards" does not exist
      ERROR: relation "sorted_cards" does not exist
      ERROR: relation "sorted_cards" does not exist
      ERROR: relation "sorted_cards" does not exist
      ERROR: relation "sorted_cards" does not exist
      LOG: could not receive data from client: Connection reset by peer
      LOG: could not receive data from client: Connection reset by peer
      LOG: unexpected EOF on client connection
      LOG: could not receive data from client: Connection reset by peer
      LOG: unexpected EOF on client connection
      LOG: unexpected EOF on client connection
      ERROR: relation "player" does not exist
      ERROR: relation "sorted_cards" does not exist
      ERROR: relation "sorted_cards" does not exist
      ERROR: relation "sorted_cards" does not exist
      ERROR: relation "sorted_cards" does not exist
      ERROR: relation "sorted_cards" does not exist
      ERROR: relation "sorted_cards" does not exist
    • Furo
      Furo
      Silber
      Dabei seit: 06.04.2007 Beiträge: 11.046
      Bei mir klappt jetzt alles danke :)
    • 6Wishmaster6
      6Wishmaster6
      Black
      Dabei seit: 16.01.2005 Beiträge: 3.807
      Ja du brauchst PostgreSQL 8.3.

      Bitete nach Analeitung im Alphaforum deinstallieren und den Elephant einmal frisch aufsetzten (er installiert postgresql 8.3 direkt mit).

      How-To: Deinstallation von PostgreSQL