JBidWatcher: Problem bei loading Auctions in Verbindung mit mySQL

Dieses Thema im Forum "Anwendungen" wurde erstellt von Allrounder, 10.10.2014.

  1. #1 Allrounder, 10.10.2014
    Allrounder

    Allrounder Grünschnabel

    Dabei seit:
    10.10.2014
    Beiträge:
    4
    Zustimmungen:
    0
    Moin Moin,

    ich habe das Problem bei JBidWatcher, dass ich das Programm in Verbindung mit einer mySQL-Datenbank nutzen möchte... Leider hängt sich das Programm jedes mal auf wenn ich in den options die Datenbank eintrage. :think:
    Ich vermute, dass das Program die datenbank nicht erreicht, aber wieso? Ich bin am ende meines Latein :oldman Ich hänge hier einmal meine Errorlogs und Config-Dateien an... Vielleicht kann mir jemand sagen wo das Problem liegt...?!

    Meine Option:
    MySQL Host: 192.168.0.109
    MySQL Port: 3306
    Database: jbidwatcher
    Username: Flo
    Password: ***

    Errorlog von JBidWatcher
    Code:
    Fri Oct 10 18:17:59 UTC 2014: JBidwatcher 2.5.6-11-gac197d6
    Fri Oct 10 18:17:59 UTC 2014: Oracle Corporation Java, version 1.8.0 on Linux
    Fri Oct 10 18:17:59 UTC 2014: Logging to /home/pi/.jbidwatcher/errors.1.log
    Fri Oct 10 18:18:02 UTC 2014: Upgrading error
    com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure
    
    Last packet sent to the server was 1 ms ago.
            at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
            at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
            at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
            at java.lang.reflect.Constructor.newInstance(Constructor.java:408)
            at com.mysql.jdbc.Util.handleNewInstance(Util.java:406)
            at com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:1074)
            at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2120)
            at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:723)
            at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:46)
            at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
            at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
            at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
            at java.lang.reflect.Constructor.newInstance(Constructor.java:408)
            at com.mysql.jdbc.Util.handleNewInstance(Util.java:406)
            at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:302)
            at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:282)
            at java.sql.DriverManager.getConnection(DriverManager.java:664)
            at java.sql.DriverManager.getConnection(DriverManager.java:208)
            at com.jbidwatcher.util.db.Database.setup(Database.java:95)
            at com.jbidwatcher.util.db.Database.<init>(Database.java:62)
            at com.jbidwatcher.Upgrader.upgrade(Upgrader.java:26)
            at com.jbidwatcher.app.JBidWatch.main(JBidWatch.java:429)
            at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
            at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
            at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
            at java.lang.reflect.Method.invoke(Method.java:483)
            at com.simontuffs.onejar.Boot.run(Boot.java:342)
            at com.simontuffs.onejar.Boot.main(Boot.java:168)
    Caused by: com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure
    
    Last packet sent to the server was 0 ms ago.
            at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
            at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
            at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
            at java.lang.reflect.Constructor.newInstance(Constructor.java:408)
            at com.mysql.jdbc.Util.handleNewInstance(Util.java:406)
            at com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:1074)
            at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:335)
            at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2043)
            ... 21 more
    Caused by: java.net.ConnectException: Connection refused
            at java.net.PlainSocketImpl.socketConnect(Native Method)
            at java.net.AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.java:345)
            at java.net.AbstractPlainSocketImpl.connectToAddress(AbstractPlainSocketImpl.java:206)
            at java.net.AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:188)
            at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:392)
            at java.net.Socket.connect(Socket.java:589)
            at java.net.Socket.connect(Socket.java:538)
            at java.net.Socket.<init>(Socket.java:434)
            at java.net.Socket.<init>(Socket.java:244)
            at com.mysql.jdbc.StandardSocketFactory.connect(StandardSocketFactory.java:253)
            at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:284)
            ... 22 more
    Fri Oct 10 18:18:15 UTC 2014: Scripting is not enabled.
    Fri Oct 10 18:18:32 UTC 2014: JBidwatcher: java.lang.RuntimeException: Can't access the auctions database table
    java.lang.RuntimeException: Can't access the auctions database table
            at com.jbidwatcher.util.db.ActiveRecord.openDB(ActiveRecord.java:32)
            at com.jbidwatcher.auction.AuctionInfo.getRealDatabase(AuctionInfo.java:397)
            at com.jbidwatcher.auction.AuctionInfo.getDatabase(AuctionInfo.java:394)
            at com.jbidwatcher.util.db.ActiveRecord.count(ActiveRecord.java:63)
            at com.jbidwatcher.auction.AuctionInfo.count(AuctionInfo.java:428)
            at com.jbidwatcher.ui.AuctionsManager.loadAuctionsFromDatabase(AuctionsManager.java:217)
            at com.jbidwatcher.app.JBidWatch.<init>(JBidWatch.java:654)
            at com.jbidwatcher.app.JBidWatch.main(JBidWatch.java:477)
            at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
            at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
            at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
            at java.lang.reflect.Method.invoke(Method.java:483)
            at com.simontuffs.onejar.Boot.run(Boot.java:342)
            at com.simontuffs.onejar.Boot.main(Boot.java:168)
    Caused by: com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure
    
    Last packet sent to the server was 1 ms ago.
            at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
            at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
            at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
            at java.lang.reflect.Constructor.newInstance(Constructor.java:408)
            at com.mysql.jdbc.Util.handleNewInstance(Util.java:406)
            at com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:1074)
            at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2120)
            at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:723)
            at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:46)
            at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
            at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
            at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
            at java.lang.reflect.Constructor.newInstance(Constructor.java:408)
            at com.mysql.jdbc.Util.handleNewInstance(Util.java:406)
            at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:302)
            at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:282)
            at java.sql.DriverManager.getConnection(DriverManager.java:664)
            at java.sql.DriverManager.getConnection(DriverManager.java:208)
            at com.jbidwatcher.util.db.Database.setup(Database.java:95)
            at com.jbidwatcher.util.db.Database.<init>(Database.java:62)
            at com.jbidwatcher.util.db.Table.<init>(Table.java:59)
            at com.jbidwatcher.util.db.ActiveRecord.openDB(ActiveRecord.java:29)
            ... 13 more
    Caused by: com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure
    
    Last packet sent to the server was 0 ms ago.
            at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
            at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
            at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
            at java.lang.reflect.Constructor.newInstance(Constructor.java:408)
            at com.mysql.jdbc.Util.handleNewInstance(Util.java:406)
            at com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:1074)
            at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:335)
            at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2043)
            ... 28 more
    Caused by: java.net.ConnectException: Connection refused
            at java.net.PlainSocketImpl.socketConnect(Native Method)
            at java.net.AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.java:345)
            at java.net.AbstractPlainSocketImpl.connectToAddress(AbstractPlainSocketImpl.java:206)
            at java.net.AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:188)
            at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:392)
            at java.net.Socket.connect(Socket.java:589)
            at java.net.Socket.connect(Socket.java:538)
            at java.net.Socket.<init>(Socket.java:434)
            at java.net.Socket.<init>(Socket.java:244)
            at com.mysql.jdbc.StandardSocketFactory.connect(StandardSocketFactory.java:253)
            at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:284)
            ... 29 more



    Meine Datenbanken
    Code:
    mysql> show databases;
    +--------------------+
    | Database           |
    +--------------------+
    | information_schema |
    | jbidwatcher        |
    | mysql              |
    | performance_schema |
    +--------------------+
    4 rows in set (0.01 sec)
    
    Meine Datenbankuser
    Code:
    +------------------+-----------+
    | User             | Host      |
    +------------------+-----------+
    | root             | 127.0.0.1 |
    | root             | ::1       |
    | Flo                    | localhost |
    | debian-sys-maint | localhost |
    | root             | localhost |
    | root             | rpi01     |
    +------------------+-----------+
    
    Rechtevergabe
    Code:
    +---------------------------------------------------------------------------------------------------------------------+
    | Grants for Flo@localhost                                                                                   |
    +---------------------------------------------------------------------------------------------------------------------+
    | GRANT USAGE ON *.* TO 'Flo'@'localhost' IDENTIFIED BY PASSWORD '*622387879E304BB84DA4911547EF72DE9796ED3E' |
    | GRANT ALL PRIVILEGES ON `jbidwatcher`.* TO 'PlathFlo'@'localhost'                                               |
    +---------------------------------------------------------------------------------------------------------------------+
    
    Datenbank Konfig
    Code:
    #
    # The MySQL database server configuration file.
    #
    # You can copy this to one of:
    # - "/etc/mysql/my.cnf" to set global options,
    # - "~/.my.cnf" to set user-specific options.
    #
    # One can use all long options that the program supports.
    # Run program with --help to get a list of available options and with
    # --print-defaults to see which it would actually understand and use.
    #
    # For explanations see
    # http://dev.mysql.com/doc/mysql/en/server-system-variables.html
    
    # This will be passed to all mysql clients
    # It has been reported that passwords should be enclosed with ticks/quotes
    # escpecially if they contain "#" chars...
    # Remember to edit /etc/mysql/debian.cnf when changing the socket location.
    [client]
    port            = 3306
    socket          = /var/run/mysqld/mysqld.sock
    
    # Here is entries for some specific programs
    # The following values assume you have at least 32M ram
    
    # This was formally known as [safe_mysqld]. Both versions are currently pars$
    [mysqld_safe]
    socket          = /var/run/mysqld/mysqld.sock
    nice            = 0
    
    [mysqld]
    #
    # * Basic Settings
    #
    user            = mysql
    pid-file        = /var/run/mysqld/mysqld.pid
    socket          = /var/run/mysqld/mysqld.sock
    port            = 3306
    basedir         = /usr
    datadir         = /var/lib/mysql
    tmpdir          = /tmp
    lc-messages-dir = /usr/share/mysql
    skip-external-locking
    #
    # Instead of skip-networking the default is now to listen only on
    # localhost which is more compatible and is not less secure.
    bind-address            = 0.0.0.0
    #
    # * Fine Tuning
    #
    key_buffer              = 16M
    max_allowed_packet      = 16M
    thread_stack            = 192K
    thread_cache_size       = 8
    # This replaces the startup script and checks MyISAM tables if needed
    # the first time they are touched
    myisam-recover         = BACKUP
    #max_connections        = 100
    #table_cache            = 64
    #thread_concurrency     = 10
    # * Query Cache Configuration
    #
    query_cache_limit       = 1M
    query_cache_size        = 16M
    #
    # * Logging and Replication
    #
    # Both location gets rotated by the cronjob.
    # Be aware that this log type is a performance killer.
    # As of 5.1 you can enable the log at runtime!
    #general_log_file        = /var/log/mysql/mysql.log
    #general_log             = 1
    #
    # Error logging goes to syslog due to /etc/mysql/conf.d/mysqld_safe_syslog.c$
    #
    # Here you can see queries with especially long duration
    #log_slow_queries       = /var/log/mysql/mysql-slow.log
    #long_query_time = 2
    #log-queries-not-using-indexes
    #
    # The following can be used as easy to replay backup logs or for replication.
    # note: if you are setting up a replication slave, see README.Debian about
    #       other settings you may need to change.
    #server-id              = 1
    #log_bin                        = /var/log/mysql/mysql-bin.log
    expire_logs_days        = 10
    max_binlog_size         = 100M
    #binlog_do_db           = include_database_name
    #binlog_ignore_db       = include_database_name
    #
    # * InnoDB
    #
    # InnoDB is enabled by default with a 10MB datafile in /var/lib/mysql/.
    # Read the manual for more InnoDB related options. There are many!
    #
    # * Security Features
    #
    # Read the manual, too, if you want chroot!
    # chroot = /var/lib/mysql/
    #
    # For generating SSL certificates I recommend the OpenSSL GUI "tinyca".
    [mysqldump]
    quick
    quote-names
    max_allowed_packet      = 16M
    
    [mysql]
    #no-auto-rehash # faster start of mysql but no tab completition
    
    [isamchk]
    key_buffer              = 16M
    
    #
    # * IMPORTANT: Additional settings that can override those from this file!
    #   The files must end with '.cnf', otherwise they'll be ignored.
    !includedir /etc/mysql/conf.d/
    
     
  2. Anzeige

    Schau dir mal diese Kategorie an. Dort findest du bestimmt etwas.
    Registrieren bzw. einloggen, um diese und auch andere Anzeigen zu deaktivieren
Thema:

JBidWatcher: Problem bei loading Auctions in Verbindung mit mySQL

Die Seite wird geladen...

JBidWatcher: Problem bei loading Auctions in Verbindung mit mySQL - Ähnliche Themen

  1. Raspbian: Starten einer Java-GUI Anwendung beim Systemstart (JBidWatcher)

    Raspbian: Starten einer Java-GUI Anwendung beim Systemstart (JBidWatcher): Moin Moin, ich möchte das Programm "JBidWatcher" auf meinem Raspberry mit Raspbian nach dem start der GUI ausführen. Dafür habe ich bereits...
  2. Virtualboxproblem

    Virtualboxproblem: Hallo Folgnedes Problem: Ich kann ohne Probleme In Debian-Sid, 64Bit und virtualbox-dkms Unixoide installieren, wenn es sich um eine...
  3. grub-pc Probleme bei upgrade

    grub-pc Probleme bei upgrade: Hallo, ich habe beim dist-upgrade folgendes Problem: ---------- Nach dieser Operation werden 0 B Plattenplatz zusätzlich benutzt. Trigger für...
  4. Problem bei apt-get upgrade (Kali 2.0)

    Problem bei apt-get upgrade (Kali 2.0): Hi, seit paar Tagen habe ich einige Probs. Dachte es sei mal an der Zeit für ein Update und nun tauchen da einige Fehler auf: Es müssen noch 0 B...
  5. Probleme mit YUM

    Probleme mit YUM: Hallo, ich habe CentOs 7 als Dualboot mit Windows 7 auf einen Dell Latitude E5510 installiert. Dies hat soweit auch alles geklappt. Leider habe...