extDB log und RPT log bitte

ArmA 3: Dedicated Server einrichten unter Windows (mit extDB3 & 64bit) (Altis Life & Tanoa Life) [2025 Tutorial / Guide]
-
- Altis Life
-
nox -
9. August 2015 um 01:48
-
-
- Offizieller Beitrag
okay erleidigt jetzt habe ich das Problem das ich im spiel kein z inventar habe und zum 2 kann ich in der sql keinen char bearbeiten weil keiner drin steht an was liegt das
Du sollst den Fehler bei der Datenbankverbindung auch nicht überspringen in dem du Respawn drückst, das ist nicht Sinn und Zweck des ganzen...
extDB Log gecheckt?
-
ich habe nichts übersprungen bin normal gespant
extDB3: https://bitbucket.org/torndeco/extdb3/wiki/Home
extDB3: Version: 1.025
extDB3: Windows Version
Message: All development for extDB3 is done on a Linux Dedicated Server
Message: If you would like to Donate to extDB3 Development
Message: https://www.paypal.com/cgi-bin/webscr…d=2SUEFTGABTAM2
Message: Also leave a message if there is any particular feature you would like to see added.
Message: Thanks for all the people that have donated.
Message: Torndeco: 18/05/15
extDB3: Found extdb3-conf.ini
extDB3: Detected 8 Cores, Setting up 6 Worker Threads
extDB3: ...
extDB3: ...
extDB3: ...
extDB3: ...
extDB3: ...
extDB3: ...
[14:52:04:636180 +01:00] [Thread 11860] extDB3: SQL: Initialized: Add Quotes around TEXT Datatypes mode: 2
[14:52:04:636427 +01:00] [Thread 11860] extDB3: SQL: Initialized: NULL = ""
[14:52:04:636467 +01:00] [Thread 11860] extDB3: Locked -
ist das der richtige kenne mich jetzt nicht genau mit extDB3 aus
-
okay ich habe es doch übersprungen sry dafür bei mir steht die ganze zeit einrichten das client bitte warten was soll ich tun ?
-
Dann mal bitte die Server und extdb logs hier anhängen
-
- Offizieller Beitrag
Dann fehlen Dir die Runtime Libs denke Ich.
-
nox was ist genau die Runtime Libs ?
-
Hier der Server Log von extdb habe ich leider keine Log
[2017-04-05 19:26:13] Log session started
[2017-04-05 19:26:13] [0,0] SetSteamID( [A:1:0:0] )
[2017-04-05 19:26:13] [1,2] Connect() starting connection (eNetQOSLevelMedium, 162.254.197.40:27017, UDP)
[2017-04-05 19:26:14] [1,2] ConnectionCompleted() (162.254.196.41:27021, UDP)
[2017-04-05 19:26:14] [1,2] RecvMsgClientLogOnResponse() : [A:1:544701448:8369] 'OK'
[2017-04-05 19:34:42] [3,2] LogOff()
[2017-04-05 19:34:42] [2,2] AsyncDisconnect()
[2017-04-05 19:34:42] [2,2] Log session ended
[2017-04-05 19:38:05] Log session started
[2017-04-05 19:38:05] [0,0] SetSteamID( [A:1:0:0] )
[2017-04-05 19:38:06] [1,2] Connect() starting connection (eNetQOSLevelMedium, 162.254.197.41:27019, UDP)
[2017-04-05 19:38:06] [1,2] ConnectionCompleted() (162.254.196.40:27017, UDP)
[2017-04-05 19:38:07] [1,2] RecvMsgClientLogOnResponse() : [A:1:693258248:8369] 'OK'
[2017-04-05 19:40:33] [3,2] LogOff()
[2017-04-05 19:40:33] [2,2] AsyncDisconnect()
[2017-04-05 19:40:33] [2,2] Log session ended
[2017-04-05 19:48:08] Log session started
[2017-04-05 19:48:08] [0,0] SetSteamID( [A:1:0:0] )
[2017-04-05 19:48:08] [1,2] Connect() starting connection (eNetQOSLevelMedium, 162.254.197.42:27017, UDP)
[2017-04-05 19:48:09] [1,2] ConnectionCompleted() (208.78.164.10:27018, UDP)
[2017-04-05 19:48:09] [1,2] RecvMsgClientLogOnResponse() : [A:1:819817478:8369] 'OK'
[2017-04-05 19:56:45] [3,2] LogOff()
[2017-04-05 19:56:45] [2,2] AsyncDisconnect()
[2017-04-05 19:56:45] [2,2] Log session ended
[2017-04-05 21:54:10] Log session started
[2017-04-05 21:54:10] [0,0] SetSteamID( [A:1:0:0] )
[2017-04-05 21:54:10] [1,2] Connect() starting connection (eNetQOSLevelMedium, 162.254.197.42:27017, UDP)
[2017-04-05 21:54:11] [1,2] ConnectionCompleted() (185.25.180.14:27017, UDP)
[2017-04-05 21:54:11] [1,2] RecvMsgClientLogOnResponse() : [A:1:2365071368:8369] 'OK'
[2017-04-05 22:10:00] [3,2] LogOff()
[2017-04-05 22:10:00] [2,2] AsyncDisconnect()
[2017-04-05 22:10:00] [2,2] Log session ended
[2017-04-05 22:10:48] Log session started
[2017-04-05 22:10:48] [0,0] SetSteamID( [A:1:0:0] )
[2017-04-05 22:10:48] [1,2] Connect() starting connection (eNetQOSLevelMedium, 162.254.197.42:27021, UDP)
[2017-04-05 22:10:49] [1,2] ConnectionCompleted() (162.254.197.40:27018, UDP)
[2017-04-05 22:10:49] [1,2] RecvMsgClientLogOnResponse() : [A:1:2544769028:8369] 'OK'
[2017-04-05 22:17:37] [3,2] LogOff()
[2017-04-05 22:17:37] [2,2] AsyncDisconnect()
[2017-04-05 22:17:37] [2,2] Log session ended
[2017-04-05 22:20:34] Log session started
[2017-04-05 22:20:34] [0,0] SetSteamID( [A:1:0:0] )
[2017-04-05 22:20:34] [1,2] Connect() starting connection (eNetQOSLevelMedium, 162.254.197.42:27018, UDP)
[2017-04-05 22:20:35] [1,2] ConnectionCompleted() (155.133.229.251:27020, UDP)
[2017-04-05 22:20:35] [1,2] RecvMsgClientLogOnResponse() : [A:1:2612379648:8369] 'OK'
[2017-04-05 22:23:09] [3,2] LogOff()
[2017-04-05 22:23:09] [2,2] AsyncDisconnect()
[2017-04-05 22:23:09] [2,2] Log session ended -
-
- Offizieller Beitrag
Aktualisierung folgt sobald Ich Zeit finde, werde mir dann auch GoRcon dazu anschauen.
-
- Offizieller Beitrag
Kann ich das ganze auch auf Xampp laufen lassen, da ist ja auch MySQL enthalten ?
Gruß
Ja, allerdings nicht zu empfehlen.
-
Wenn ich die Datenbank in Navicat einfügen möchte taucht im Message Log folgender Fehlercode auf:
[Err] 1046 - No database selected
[Err] CREATE PROCEDURE `deleteEconomyPrices`()
TRUNCATE `economy`;
CREATE PROCEDURE `deleteOldGangs`()
DELETE FROM `gangs` WHERE `active` = 0;
CREATE PROCEDURE `resetLifeVehicles`()
UPDATE vehicles SET `active`= 0;;
CREATE PROCEDURE `deleteDeadVehicles`()
DELETE FROM `vehicles` WHERE `alive` = 0;;
CREATE PROCEDURE `deleteOldMessages`()
TRUNCATE TABLE `messages`;
CREATE PROCEDURE `deleteOldHouses`()
DELETE FROM `houses` WHERE `owned` = 0;
[Err] 1046 - No database selected
[Err] CREATE PROCEDURE `setEconomyPrices`()
NO SQL
INSERT INTO `economy` (`numero`, `ressource`, `sellprice`, `buyprice`, `varprice`, `minprice`, `maxprice`, `factor`, `shoptype`) VALUES
(1, 'apple', 50, 65, 1, 1, 60, '1', 'market'),
(2, 'heroinu', 2250, 0, 5, 1, 4000, '0', 'heroin'),
(3, 'heroinp', 4500, 0, 10, 1, 5000, '2', 'heroin'),
(4, 'salema', 45, 55, 1, 1, 100, '4', 'fishmarket'),
(5, 'ornate', 40, 50, 1, 1, 100, '4', 'fishmarket'),
(6, 'mackerel', 175, 200, 1, 1, 1000, '4', 'fishmarket'),
(7, 'tuna', 700, 900, 1, 1, 2000, '4', 'fishmarket'),
(8, 'mullet', 250, 300, 1, 1, 1000, '4', 'fishmarket'),
(9, 'catshark', 300, 350, 1, 1, 1000, '4', 'fishmarket'),
(10, 'rabbit', 65, 75, 1, 1, 500, '0', 'market'),
(11, 'oilp', 2250, 0, 2, 1, 3500, '3', 'oil'),
(12, 'turtle', 5750, 15000, 10, 1, 8000, '0', 'wongs'),
(13, 'water', 0, 10, 0, 1, 25, '0', 'market'),
(14, 'coffee', 0, 10, 0, 1, 75, '0', 'cop'),
(15, 'turtlesoup', 4500, 15000, 0, 1, 5000, '0', 'wongs'),
(16, 'donuts', 0, 10, 0, 1, 200, '0', 'cop'),
(17, 'marijuana', 3000, 0, 10, 1, 6000, '2', 'heroin'),
(18, 'tbacon', 25, 75, 0, 1, 75, '0', 'market'),
(19, 'lockpick', 750, 4000, 0, 1, 4100, '0', 'market'),
(20, 'redgull', 750, 1000, 0, 1, 1200, '0', 'market'),
(21, 'peach', 65, 70, 1, 1, 100, '1', 'market'),
(22, 'cocaine', 2500, 0, 5, 1, 4500, '0', 'heroin'),
(23, 'cocainep', 5000, 0, 10, 1, 8000, '2', 'heroin'),
(24, 'diamond', 1500, 0, 3, 1, 2000, '3', 'diamond'),
(25, 'diamondc', 3000, 0, 3, 1, 6000, '3', 'diamond'),
(26, 'iron_r', 1500, 0, 3, 1, 3000, '3', 'iron'),
(27, 'copper_r', 1000, 0, 3, 1, 1500, '3', 'iron'),
(28, 'salt_r', 2500, 0, 3, 1, 5000, '3', 'salt'),
(29, 'glass', 1500, 0, 3, 1, 3000, '3', 'glass'),
(30, 'fuelF', 10, 500, 0, 1, 1500, '0', 'market'),
(31, 'spikeStrip', 0, 10, 0, 1, 2000, '0', 'cop'),
(32, 'cement', 1000, 0, 3, 1, 8000, '3', 'cement'),
(33, 'goldbar', 90000, 0, 0, 1, 180000, '0', 'goldbar'),
(34, 'blastingcharge', 10000, 50000, 0, 1, 50000, '0', 'market'),
(35, 'boltcutter', 5000, 8000, 0, 1, 5000, '0', 'market'),
(36, 'defusekit', 0, 10, 0, 1, 2500, '0', 'cop'),
(37, 'storagesmall', 10, 125000, 0, 1, 10, '0', 'market'),
(38, 'storagebig', 10, 250000, 0, 1, 10, '0', 'market'),
(39, 'pickaxe', 700, 1200, 0, 1, 750, '0', 'market'),
(40, 'methu', 1875, 3750, 5, 1, 3600, '2', 'heroin'),
(41, 'methp', 3750, 0, 10, 1, 6500, '2', 'heroin'),
(42, 'bottledwhiskey', 5500, 3750, 5, 1, 6000, '2', 'speakeasy'),
(43, 'bottledbeer', 750, 1250, 5, 1, 1450, '2', 'speakeasy'),
(44, 'whiskey', 1250, 5500, 4, 1, 2500, '2', 'speakeasy'),
(45, 'wine', 1000, 4000, 2, 1, 4500, '2', 'beer'),
(46, 'grapes', 70, 95, 2, 1, 140, '2', 'market'),
(47, 'battery', 50, 100, 0, 1, 100, '2', 'market'),
(48, 'painkillers', 250, 500, 0, 1, 500, '2', 'pharmacy'),
(49, 'mash', 500, 2500, 1, 1, 1500, '2', 'bar'),
(50, 'rye', 2000, 0, 2, 1, 3500, '2', 'bar'),
(51, 'morphium', 100, 1500, 0, 1, 1500, '2', 'pharmacy'),
(52, 'yeast', 2000, 0, 2, 1, 3500, '2', 'pharmacy'),
(53, 'cornmeal', 200, 500, 2, 1, 750, '2', 'bar'),
(54, 'bottles', 50, 100, 1, 1, 100, '2', 'bar'),
(55, 'uranium', 10000, 0, 8, 1, 12500, '2', 'uranium'),
(56, 'kidney', 9000, 15000, 0, 1, 16750, '2', 'pharmacy'),
(57, 'scalpel', 1000, 7500, 0, 1, 7500, '2', 'pharmacy'),
(58, 'beerp', 550, 3750, 3, 1, 1500, '2', 'speakeasy'),
(59, 'mauer', 5, 10, 0, 1, 10, '2', 'cop'),
(60, 'zipties', 5, 500, 0, 1, 500, '2', 'market'),
(61, 'puranium', 250, 1000, 0, 1, 1000, '2', 'uranium'),
(62, 'ipuranium', 3500, 9000, 0, 1, 9000, '2', 'uranium');
--
-- Table structure for table `players`
--
CREATE TABLE IF NOT EXISTS `players` (
`uid` int(12) NOT NULL AUTO_INCREMENT,
`name` varchar(32) NOT NULL,
`playerid` varchar(50) NOT NULL,
`cash` int(100) NOT NULL DEFAULT '0',
`bankacc` int(100) NOT NULL DEFAULT '0',
`coplevel` enum('0','1','2','3','4','5','6') NOT NULL DEFAULT '0',
`cop_licenses` text,
`civ_licenses` text,
`med_licenses` text,
`cop_gear` text NOT NULL,
`med_gear` text NOT NULL,
`mediclevel` enum('0','1','2') NOT NULL DEFAULT '0',
`arrested` tinyint(1) NOT NULL DEFAULT '0',
`aliase
[Msg] Finished - Unsuccessfully -
Du hast keine Database selected. Du musst bei der Datenbank von Arma Rechtsklick machen und darüber die SQL ausführen
-
Okay hat geklappt Danke!
aber dafür erscheint jetzt Frage Spielerinformationen für UID(...)ab und das immer wenn ich den Server starte.
-
dann hänge mal die extDB Logs an.
-
- Offizieller Beitrag
Ariiiba, nutz zum Teufel nochmal Codetags für so lange logs...
-
Bekomme diesen Fehler im Moment :
Code[15:02:07:466570 +02:00] [Thread 17548] extDB2: Database Type: MySQL [15:02:07:510320 +02:00] [Thread 17548] extDB2: Database Session Pool Started [15:02:07:526474 +02:00] [Thread 17548] extDB2: SQL_RAW_V2: Initialized: ADD_QUOTES True
Bzw Frage Spielerinformationen ab
-
bei mir will es auch nicht so richtig
Code: extDB3
Alles anzeigenextDB3: https://bitbucket.org/torndeco/extdb3/wiki/Home extDB3: Version: 1.028 extDB3: Windows Version Message: All development for extDB3 is done on a Linux Dedicated Server Message: If you would like to Donate to extDB3 Development Message: https://www.paypal.com/cgi-bin/webscr?cmd=_s-xclick&hosted_button_id=2SUEFTGABTAM2 Message: Also leave a message if there is any particular feature you would like to see added. Message: Thanks for all the people that have donated. Message: Torndeco: 18/05/15 extDB3: Found extdb3-conf.ini extDB3: Detected 8 Cores, Setting up 6 Worker Threads extDB3: ... extDB3: ... extDB3: ... extDB3: ... extDB3: ... extDB3: ... [22:33:51:147510 +02:00] [Thread 2320] extDB3: Config Error: : No such node (.IP)
Code: extdb3-conf
Alles anzeigen[Main] Version = 1 Randomize Config File = false ;; Randomizes Config File after loading. ;; Recommend to turn on, if you have enabled filepatching on arma. Allow Reset = false ;; Allows 9:RESET, usefull for development work Thread = 0; ;; Option to force number of worker threads for extDB3. ;; Auto = 0, Min = 2, Max = 6 [Log] Flush = true; ;; Flush logfile after each update. ;; Option really only usefull if running DEBUG BUILD [altislife] IP = 127.0.0.1 Port = 3306 Username = altislife Password = ********** Database = altislife
-
- Offizieller Beitrag
Zitat[22:33:51:147510 +02:00] [Thread 2320] extDB3: Config Error: : No such node (.IP)
Suchfunktion regelt.
-