Hilfe

Alles, was MariaDB und MySQL betrifft, kann hier besprochen werden.

Hilfe

Postby Mario2510 » 07. September 2005 10:58

Habe bei mir einen Chat der mit mysql rennt, mit der früheren version mysql 3.2 ging alles ohne probleme aber mit 4.1 sagt er mir dauernt


==========================================================
CZ ChatServer extended by chiller-zone.de
==========================================================

Error: Could not connect to database with given JDBC url, username and password!
Message: Server configuration denies access to data source
FrettJC version 0.9.1, Copyright (c) 2003 Frederik Kanning
FrettJC comes with ABSOLUTELY NO WARRANTY;
for details and license see file 'license.txt'

wie kann ich das beheben bitte um rat
es ist alles richtig ausgefüllt:

http://www.denchat.at:3306/
der mysql geht

und ausgefüllt gehörts so:

# jbdc-url: jdbc:mysql://[HOST]/[DATABASE]
jdbcurl=jdbc:mysql://localhost/denchat
sqldriver=com.mysql.jdbc.Driver
sqluser=meinusername
sqlpassword=meinpasswort
Mario2510
 
Posts: 13
Joined: 07. September 2005 06:57

Postby Wiedmann » 07. September 2005 12:01

Was steht im Log von MySQL?
Wiedmann
AF Moderator
 
Posts: 17106
Joined: 01. February 2004 12:38
Location: Stuttgart / Germany

hm

Postby Mario2510 » 07. September 2005 12:13

wo find ich die
Mario2510
 
Posts: 13
Joined: 07. September 2005 06:57

Postby Wiedmann » 07. September 2005 12:26

k.a. ich kenn dein System nicht.

Normal im Data-Verzeichnis oder was in der my.cnf angegeben wurde.
Wiedmann
AF Moderator
 
Posts: 17106
Joined: 01. February 2004 12:38
Location: Stuttgart / Germany

Postby Mario2510 » 07. September 2005 12:32

# Example mysql config file for medium systems.
#
# This is for a system with little memory (32M - 64M) where MySQL plays
# a important part and systems up to 128M very MySQL is used together with
# other programs (like a web server)
#
# You can copy this file to
# /etc/my.cnf to set global options,
# mysql-data-dir/my.cnf to set server-specific options (in this
# installation this directory is /opt/lampp/var/mysql) or
# ~/.my.cnf to set user-specific options.
#
# One can in this file use all long options that the program supports.
# If you want to know which options a program support, run the program
# with --help option.

# The following options will be passed to all MySQL clients
[client]
#password = your_password
port = 3306
socket = /opt/lampp/var/mysql/mysql.sock

# Here follows entries for some specific programs

# The MySQL server
[mysqld]
# commented out by lampp security
#port = 3306
port = 0
socket = /opt/lampp/var/mysql/mysql.sock
skip-locking
set-variable = key_buffer=16M
set-variable = max_allowed_packet=1M
set-variable = table_cache=64
set-variable = sort_buffer=512K
set-variable = net_buffer_length=8K
set-variable = myisam_sort_buffer_size=8M
# log-bin deactivated by default since XAMPP 1.4.11
#log-bin
server-id = 1

# Point the following paths to different dedicated disks
tmpdir = /tmp/
#log-update = /path-to-dedicated-directory/hostname

# Uncomment the following if you are using BDB tables
#set-variable = bdb_cache_size=4M
#set-variable = bdb_max_lock=10000

skip-innodb
# Uncomment the following if you are using InnoDB tables
#innodb_data_home_dir = /opt/lampp/var/mysql/
#innodb_data_file_path = ibdata1:10M:autoextend
#innodb_log_group_home_dir = /opt/lampp/var/mysql/
#innodb_log_arch_dir = /opt/lampp/var/mysql/
# You can set .._buffer_pool_size up to 50 - 80 %
# of RAM but beware of setting memory usage too high
#set-variable = innodb_buffer_pool_size=16M
#set-variable = innodb_additional_mem_pool_size=2M
# Set .._log_file_size to 25 % of buffer pool size
#set-variable = innodb_log_file_size=5M
#set-variable = innodb_log_buffer_size=8M
#innodb_flush_log_at_trx_commit=1
#set-variable = innodb_lock_wait_timeout=50

[mysqldump]
quick
set-variable = max_allowed_packet=16M

[mysql]
no-auto-rehash
# Remove the next comment character if you are not familiar with SQL
#safe-updates

[isamchk]
set-variable = key_buffer=20M
set-variable = sort_buffer=20M
set-variable = read_buffer=2M
set-variable = write_buffer=2M

[myisamchk]
set-variable = key_buffer=20M
set-variable = sort_buffer=20M
set-variable = read_buffer=2M
set-variable = write_buffer=2M

[mysqlhotcopy]
interactive-timeout

ich seh da nix von einer log datei
ist debian betriebsystem mit xampp 1.4 habs heute von apachefriens runtergeladen
Mario2510
 
Posts: 13
Joined: 07. September 2005 06:57

Postby Wiedmann » 07. September 2005 12:35

# mysql-data-dir/my.cnf to set server-specific options (in this
# installation this directory is /opt/lampp/var/mysql) or

Ich würde in dem Verzsichnis suchen.

(Allerdings kenn ich die Linux Version nicht)
Wiedmann
AF Moderator
 
Posts: 17106
Joined: 01. February 2004 12:38
Location: Stuttgart / Germany

da gibts nur das wo was drinn steht

Postby Mario2510 » 07. September 2005 12:44

050907 07:42:07 mysqld started
/opt/lampp/sbin/mysqld: ready for connections.
Version: '4.1.13' socket: '/opt/lampp/var/mysql/mysql.sock' port: 3306 Source distribution

Status information:

Current dir: /opt/lampp/var/mysql/
Running threads: 0 Stack size: 196608
Current locks:

Key caches:
default
Buffer_size: 16777216
Block_size: 1024
Division_limit: 100
Age_limit: 300
blocks used: 7
not flushed: 0
w_requests: 0
writes: 0
r_requests: 18
reads: 7


handler status:
read_key: 2
read_next: 33
read_rnd 0
read_first: 2
write: 0
delete 0
update: 0

Table status:
Opened tables: 11
Open tables: 0
Open files: 0
Open streams: 0

Alarm status:
Active alarms: 0
Max used alarms: 1
Next alarm time: 0
050907 8:42:44 [Note] /opt/lampp/sbin/mysqld: Normal shutdown

050907 8:42:44 [Note] /opt/lampp/sbin/mysqld: Shutdown complete


Memory status:
Non-mmapped space allocated from system: 405504
Number of free chunks: 11
Number of fastbin blocks: 0
Number of mmapped regions: 2
Space in mmapped regions: 16781312
Maximum total allocated space: 0
Space available in freed fastbin blocks: 0
Total allocated space: 227544
Total free space: 177960
Top-most, releasable space: 132160
Estimated memory (with thread stack): 17186816

050907 08:42:44 mysqld ended

050907 08:43:10 mysqld started
/opt/lampp/sbin/mysqld: ready for connections.
Version: '4.1.13' socket: '/opt/lampp/var/mysql/mysql.sock' port: 3306 Source distribution
050907 10:06:07 [Note] /opt/lampp/sbin/mysqld: Normal shutdown

050907 10:06:07 [Note] /opt/lampp/sbin/mysqld: Shutdown complete

050907 10:06:07 mysqld ended

050907 10:06:28 mysqld started
/opt/lampp/sbin/mysqld: ready for connections.
Version: '4.1.13' socket: '/opt/lampp/var/mysql/mysql.sock' port: 3306 Source distribution

Status information:

Current dir: /opt/lampp/var/mysql/
Running threads: 0 Stack size: 196608
Current locks:

Key caches:
default
Buffer_size: 16777216
Block_size: 1024
Division_limit: 100
Age_limit: 300
blocks used: 7
not flushed: 0
w_requests: 0
writes: 0
r_requests: 18
reads: 7


handler status:
read_key: 2
read_next: 33
read_rnd 0
read_first: 2
write: 0
delete 0
update: 0

Table status:
Opened tables: 11
Open tables: 0
Open files: 0
Open streams: 0

Alarm status:
Active alarms: 0
Max used alarms: 1
Next alarm time: 0

Memory status:
Non-mmapped space allocated from system: 405504
Number of free chunks: 12
Number of fastbin blocks: 0
Number of mmapped regions: 2
Space in mmapped regions: 16781312
Maximum total allocated space: 0
Space available in freed fastbin blocks: 0
Total allocated space: 227592
Total free space: 177912
Top-most, releasable space: 132160
Estimated memory (with thread stack): 17186816


Status information:

Current dir: /opt/lampp/var/mysql/
Running threads: 0 Stack size: 196608
Current locks:

Key caches:
default
Buffer_size: 16777216
Block_size: 1024
Division_limit: 100
Age_limit: 300
blocks used: 7
not flushed: 0
w_requests: 0
writes: 0
r_requests: 0
reads: 0


handler status:
read_key: 0
read_next: 0
read_rnd 0
read_first: 0
write: 0
delete 0
update: 0

Table status:
Opened tables: 0
Open tables: 0
Open files: 0
Open streams: 0

Alarm status:
Active alarms: 0
Max used alarms: 1
Next alarm time: 0
050907 10:11:01 [Note] /opt/lampp/sbin/mysqld: Normal shutdown

050907 10:11:01 [Note] /opt/lampp/sbin/mysqld: Shutdown complete


Memory status:
Non-mmapped space allocated from system: 405504
Number of free chunks: 19
Number of fastbin blocks: 0
Number of mmapped regions: 2
Space in mmapped regions: 16781312
Maximum total allocated space: 0
Space available in freed fastbin blocks: 0
Total allocated space: 227544
Total free space: 177960
Top-most, releasable space: 86536
Estimated memory (with thread stack): 17186816

050907 10:11:01 mysqld ended

050907 10:11:05 mysqld started
/opt/lampp/sbin/mysqld: ready for connections.
Version: '4.1.13' socket: '/opt/lampp/var/mysql/mysql.sock' port: 3306 Source distribution
050907 10:29:17 [Note] /opt/lampp/sbin/mysqld: Normal shutdown

050907 10:29:17 [Note] /opt/lampp/sbin/mysqld: Shutdown complete

050907 10:29:17 mysqld ended

050907 10:29:21 mysqld started
/opt/lampp/sbin/mysqld: ready for connections.
Version: '4.1.13' socket: '/opt/lampp/var/mysql/mysql.sock' port: 3306 Source distribution
050907 10:46:41 [Note] /opt/lampp/sbin/mysqld: Normal shutdown

050907 10:46:41 [Note] /opt/lampp/sbin/mysqld: Shutdown complete

050907 10:46:41 mysqld ended

050907 10:46:56 mysqld started
/opt/lampp/sbin/mysqld: ready for connections.
Version: '4.1.13' socket: '/opt/lampp/var/mysql/mysql.sock' port: 3306 Source distribution

Status information:

Current dir: /opt/lampp/var/mysql/
Running threads: 0 Stack size: 196608
Current locks:
lock: 0x85bd888:

lock: 0x85d0810:

lock: 0x85cb028:

lock: 0x85c63d0:

lock: 0x85b25e0:

lock: 0x85ad688:


Key caches:
default
Buffer_size: 16777216
Block_size: 1024
Division_limit: 100
Age_limit: 300
blocks used: 7
not flushed: 0
w_requests: 14
writes: 10
r_requests: 186
reads: 9


handler status:
read_key: 65
read_next: 49
read_rnd 0
read_first: 83
write: 3
delete 2
update: 14

Table status:
Opened tables: 18
Open tables: 7
Open files: 13
Open streams: 0

Alarm status:
Active alarms: 0
Max used alarms: 4
Next alarm time: 0






und die heisst v074.err

aber ich kann dir per email gerne die zugangsdaten geben wenn du mir deine mail gibst
Mario2510
 
Posts: 13
Joined: 07. September 2005 06:57

Postby Wiedmann » 07. September 2005 13:13

Mach mal zum Testen in die my.cnf das Querylog mit rein:
Code: Select all
[mysqld]
log

Dann müsste er eine weitere Logdatei erzeugen mit mehr Infos.
Wiedmann
AF Moderator
 
Posts: 17106
Joined: 01. February 2004 12:38
Location: Stuttgart / Germany

ok

Postby Mario2510 » 07. September 2005 13:18

ok hab ich und was jetzt
Mario2510
 
Posts: 13
Joined: 07. September 2005 06:57

ok

Postby Mario2510 » 07. September 2005 13:21

jetzt ist eine .log datei da die v074.log

die dagt das aus wenn ich den chat starten will

--------------


/opt/lampp/sbin/mysqld, Version: 4.1.13-log. started with:
Tcp port: 3306 Unix socket: /opt/lampp/var/mysql/mysql.sock
Time Id Command Argument
050907 14:19:23 1 Connect Client does not support authentication protocol requested by server; consider upgrading MySQL client
050907 14:19:24 2 Connect Client does not support authentication protocol requested by server; consider upgrading MySQL client
3 Connect Client does not support authentication protocol requested by server; consider upgrading MySQL client
4 Connect Client does not support authentication protocol requested by server; consider upgrading MySQL client
050907 14:19:25 5 Connect Client does not support authentication protocol requested by server; consider upgrading MySQL client
6 Connect Client does not support authentication protocol requested by server; consider upgrading MySQL client
050907 14:19:26 7 Connect Client does not support authentication protocol requested by server; consider upgrading MySQL client
8 Connect Client does not support authentication protocol requested by server; consider upgrading MySQL client
9 Connect Client does not support authentication protocol requested by server; consider upgrading MySQL client
050907 14:19:27 10 Connect Client does not support authentication protocol requested by server; consider upgrading MySQL client
11 Connect Client does not support authentication protocol requested by server; consider upgrading MySQL client
12 Connect Client does not support authentication protocol requested by server; consider upgrading MySQL client
050907 14:19:28 13 Connect Client does not support authentication protocol requested by server; consider upgrading MySQL client
14 Connect Client does not support authentication protocol requested by server; consider upgrading MySQL client
050907 14:19:29 15 Connect Client does not support authentication protocol requested by server; consider upgrading MySQL client
Mario2510
 
Posts: 13
Joined: 07. September 2005 06:57

Postby Wiedmann » 07. September 2005 13:27

050907 14:19:23 1 Connect Client does not support authentication protocol requested by server; consider upgrading MySQL client

Das hatte ich mir gedacht. Dein Java-Prog, oder besser "jdbc", ist gegen die alte MySQL-Lib von deinem System gelinkt (Version <MySQL 4.1). Entweder du kompilierst das neu, oder du erzeugst in MySQL das Passwort für den den jdbc-user mit OLD_PASSWORD() und nicht mit PASSWORD().
Wiedmann
AF Moderator
 
Posts: 17106
Joined: 01. February 2004 12:38
Location: Stuttgart / Germany

hm

Postby Mario2510 » 07. September 2005 13:35

kann man es nicht einfacher machen einfach ne version von xampp raufspielen mit mysql 3.2 da ich keinen schimmer hab wie eines von beiden geht
Mario2510
 
Posts: 13
Joined: 07. September 2005 06:57

Postby Wiedmann » 07. September 2005 13:39

da ich keinen schimmer hab wie eines von beiden geht

Wenn du wirklich mit dem XAMPP arbeiten willst, wird es jetzt zumindest Zeit herauszufinden wie man in MySQL Passwörter für User vergibt...

(In der Regel macht man das mit dem phpMyAdmin. Schau dir den einfach mal genauer an und was er dir für Optionen jeweils bietet...)
Wiedmann
AF Moderator
 
Posts: 17106
Joined: 01. February 2004 12:38
Location: Stuttgart / Germany

eigentlich

Postby Mario2510 » 07. September 2005 13:49

nur 2 kein passwort oder passwort
na find nichts kann man nicht irgendwo einen xampp runterladen wo mysql 3.2 drauf ist?
Mario2510
 
Posts: 13
Joined: 07. September 2005 06:57

Postby deepsurfer » 07. September 2005 15:27

chirio Deep
Wie sagte einst der MCP aus Tron auf dem Bildschirm zu schreiben Pflegte
" ... end of communication ... "
User avatar
deepsurfer
AF Moderator
 
Posts: 6440
Joined: 23. November 2004 10:44
Location: Cologne
Operating System: Win-XP / Win7 / Linux -Debian


Return to MariaDB - MySQL

Who is online

Users browsing this forum: No registered users and 5 guests