MySQL4+ confixx und nun fehler?

[bastilein]

Ich habe einen server auf dem nun schon längere zeit
suse 9.1
mysql 4
confixx 3.0.3
läuft...

jetzt wollte einer meiner kunden eine datenbank über confixx anlegen und erhält folgenden error...:

Code: Select all

Warning: mysql_connect(): Access denied for user: 'wwwrun@localhost' (Using password: NO) in /srv/www/confixx/html/user/db_mysql_anlegen.php on line 96

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /srv/www/confixx/html/user/db_mysql_anlegen.php on line 14

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /srv/www/confixx/html/user/db_mysql_anlegen.php on line 14

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /srv/www/confixx/html/user/db_mysql_anlegen.php on line 14

was ist da für ein fehler passiert?

[Anonymous]

Steht doch da oben :

Warning: mysql_connect(): Access denied for user: 'wwwrun@localhost'

Wieso versucht dein Confixx als User wwwrun auf die Db zuzugreifen?
Ã?berprüfe doch mal deine Confixx Config.

[bastilein]

das habe ich auch schon gedacht...
aber ich nehm an das das wwwrun korrekt ist...

ich hab halt leider keinen 2ten server mit confixx wo ich es nachschauen könnte ob es den stimmt....
das ist das problem...

aber ich nehm halt mal an das das stimmt...


kannst mir vielleicht infos geben wenn du confixx hast.. (sory für das duzen..)

[Anonymous]

Also standart ist, das confixx auch als user confixx auf die Db zugreift.

Ist bei mir jedenfalls so .. vor allem:

(Using password: NO)

würde mich an deiner stelle schon stutzig machen.

[bastilein]

ich habe jetzt mal die /root/confixx/confixx_main.conf
durchgeschaut.. und da ist alles korrekt eingetragen denk ich...


das wwwrun
kommt im apache vor:

Code: Select all

## apache

# group used by Apache (Group in httpd.conf!)
$apacheGroup = 'www';
$apacheUser = 'wwwrun';

die confixx datenbank:

Code: Select all

# dbs
$dbType = 'mysql';
$dbServer = 'localhost';
$dbUser = 'confixx';
$dbPw = '12345678';
$dbDB = 'confixx';
$mysqlUserServer = '';
$mysqlUserUser = '';
$mysqlUserPw = '';
$mysql_homeDir = '';
$use_mysqlshell = '';
$mysql_host = '123.456.789.101';
$mysql_sock = '/var/lib/mysql/mysql.sock';

Und hier mal die komplette confixx_main.conf (daten gändert versteht sich)

Code: Select all

[size=9]#### CONFIXX MAIN CONFIGFILE ####
#### created Thu Aug 19 20:03:35 2004 ###

## general

# e.g. Linux, FreeBSD
$OSTYPE = 'Linux';

# Confixx Version
$version = '3.0.3';

# location of webusers homedirs
$user_homeDir = '/home/htdocs';

# directory where Confixx is installed
$installDir = '/root/confixx';

# users with shell access get this shell
$stdShell = '/bin/bash';

# group of Confixx webusers
$userGroup = 'ftponly';

# group of Confixx mailusers
$popGroup = 'poponly';

# uid of userGroup
$giduser = '102';

# uid of popGroup
$gidpop = '103';

# location of passwd file
$passwdDir = '/etc/passwd';

# location of shadow file
$shadowDir = '/etc/shadow';

# location of group file
$groupDir = '/etc/group';

# lowest uid for users created with Confixx
$min_uid = '635';

# highest uid for users created with Confixx
$max_uid = '65000';

# local hostname
$hostname = 'p12345678.pureserver.info';

# location of pidfiles for Confixx programs
$PIDDir = '/root/confixx/run';

# prefix for all Confixx users
$user_prefix = 'web';

# language for all shell based Confixx applications
$language = 'de';

# compatible languagefiles need to be greater or equals
$langfileversion = '3.0.3';

# files used for DirectoryIndex if WAP is activated (seperated by :)
$index_wap = '';

# files used for DirectoryIndex if PHP is activated (seperated by :)
$index_php = '';

# files used for DirectoryIndex if SSI is activated (seperated by :)
$index_ssi = '';

# files used for DirectoryIndex (seperated by :)
$index_html = '';

# show mail traffic in webinterface
$show_emailtransfer = '1';

# max number of possible email recipients in webinterface
$max_emailrcpts = '10';

# disable usage of md5 for passwords
$disable_md5 = '0';

# compatibility for Virtuozzo (default is 0)
$virtuozzo = '0';

# create /home/www/web1/./ passwd entries (e.g. ssh-chroot)
$dot_passwd = '0';


## process management

# pm_*_reload: full command to be used to reload daemon, if empty Confixx uses signals
# pm_*_start: full command to be used to stard daemon, if not running _after_ reload
# pm_*_user: username of process (used for finding process to send signal)
# pm_*_name: name of process (used for finding process to send signal)

$pm_apache_reload = '/etc/init.d/apache2 reload';
$pm_apache_start = '/etc/init.d/apache2 start';
$pm_apache_user = '';
$pm_apache_name = '';
$pm_mail_reload = '';
$pm_mail_start = '';
$pm_mail_user = '';
$pm_mail_name = '';
$pm_bind_reload = '';
$pm_bind_start = '';
$pm_bind_user = '';
$pm_bind_name = '';
$pm_spamassassin_reload = '/etc/init.d/spamd restart';
$pm_spamassassin_start = '/etc/init.d/spamd start';
$pm_spamassassin_user = '';
$pm_spamassassin_name = '';
$pm_ftpd_noscript = '';
$pm_ftpd_reload = '';
$pm_ftpd_start = '';

## apache

# group used by Apache (Group in httpd.conf!)
$apacheGroup = 'www';
$apacheUser = 'wwwrun';

# rotate logfile if greater than value (kb) after analysis
$apacheBackupSize = '10240';

# day on which logfiles will be rotated, ignoring size on this day (0=Sun, set to 8 to disable)
$apacheBackupDay = '1';

# 1: rotate logfiles in user's homedir, 0: rotate to $apacheBackupDir
$apacheBackupLocal = '1';

# keep _old_ logfiles for X days
$apacheBackupExpire = '90';

# location where to keep rotated logfiles (if not user's homedir)
$apacheBackupDir = '/var/log/apache2/old';

# location of general Apache logfiles for Confixx and symlinks to user's logfiles
$apacheLogDir = '/var/log/apache2/confixx';

# value used as <IfDefine value> for ssl entries in confixx_vhost.conf, defaults to SSL
$apacheDefSSL = 'SSL';

# Confixx web pages user's homedir
$confixx_homeDir = '/srv/www/confixx';

# location of Confixx web pages
$confixx_htmlDir = '/srv/www/confixx/html';

# location of Confixx web cgis
$confixx_cgiDir = '/srv/www/confixx/html/cgi-bin';

# location of Confixx web pages temporary dir (e.g. php upload)
$confixx_tmpDir = '/srv/www/confixx/tmp';

# location of Confixx web pages bin dir
$confixx_binDir = '/srv/www/confixx/bin';

# location of Confixx web pages sbin dir
$confixx_sbinDir = '/srv/www/confixx/sbin';

# location of Apache's httpd.conf
$httpd_conf = '/etc/apache2/httpd.conf';

# location of Confixx vhosts file for Apache (included by mhost.conf)
$vhost_conf = '/etc/apache2/confixx_vhost.conf';

# location of Confixx main Apache config file (included by httpd.conf)
$mhost_conf = '/etc/apache2/confixx_mhost.conf';

# uid of $apacheGroup
$gidapache = '8';

# uid of Confixx web pages user
$confixx_uid = '631';

# gid of Confixx web pages user
$confixx_gid = '101';

# name of Confixx web pages user
$confixx_user = 'confixx';

# group of Confixx web pages user
$confixx_group = 'confixx';

# location of ssl .key files
$sslKeyDir = '/etc/apache2/ssl.key';

# location of ssl .crt files
$sslCrtDir = '/etc/apache2/ssl.crt';

# location if fpfake.conf (FrontPage Apache config file)
$fpfake = '/etc/apache2/fpfake';

# location of FrontPage installation
$fp_homeDir = '/usr/local/frontpage';

# uid of FrontPage files
$fp_uid = '1';

# gid of FrontPage files
$fp_gid = '1';

# Apache base dir for config files (has subdirectory conf!)
$apache_root = '/etc/apache2';

# have seperate /cgi-bin/ for subdomains
$local_cgi = '';

# disable "AllowOverride All" for FrontPage webs (requires patched FrontPage)
$secure_fp = '';

# do not write NameVirtualHost for list of ips (seperated by :)
$excludeNVH = '';

# number of bytes to be added to every entry in Apache logfile analysis (default is 0!)
$httpbytes = '0';

# type of webserver ( apache1.3 | apache2.0 )
$httpd = 'apache2.0';


## email

# used mta ( sendmail | postfix | qmail )
$mta = 'postfix';

# location of mailspool directory
$mailSpool = '/var/spool/mail';

# type of maildrop ( /var/spool/mail/USER | HOMEDIR/Mailbox | HOMEDIR/Maildir/ )
$maildrop = '';

# name of Mailbox file
$mailBoxName = '';

# location of email virtusertable file
$virtUserTableDB = '/etc/postfix/confixx_virtualUsers';

# location of email local domains file
$localDomainsFile = '/etc/postfix/confixx_localDomains';

# location of makemap binary (sendmail only)
$bin_makemap = '';

# location of postmap binary (postfix only)
$bin_postmap = '/usr/sbin/postmap';

# location of postfix binary (postfix only)
$bin_postfix = '/usr/sbin/postfix';

# location of newaliases binary (sendmail & postfix)
$bin_newaliases = '/usr/bin/newaliases';

# location of mta main config file
$MailConfigFile = '/etc/postfix/main.cf';

# location of mail users homedir
$pop_homeDir = '';

# location of aliases binary (sendmail & postfix)
$aliases = '/etc/aliases';

# location of autoresponder.pl
$bin_autorespond = '/usr/bin/autoresponder.pl';

# XXX
$use_autorespond = '1';

# uid used by mta to run local scripts (e.g. autoresponder.pl)
$mta_uid = '51';

# gid used by mta to run local scripts (e.g. autoresponder.pl)
$mta_gid = '51';

# location of sendmail binary (to send mails from local)
$bin_sendmail = '/usr/sbin/sendmail';

# mail users get real homedir (ignoring $maildrop)
$mail_realHome = ''; 

# 1: mta is on localhost, 0: mta is on remote host
$mail_server = '1';

# XXX
$bin_confixxevent = '';

# XXX
$use_events = '1';


## scponly

# shell used for scp/sftp feature
$scponly_shell = '';

# name of directory in $user_homeDir with chroot-environment
$scponly_chroot = '';


## maillist
# directory where majordomo is installed
$majordomo_home = '/usr/lib/majordomo'; 

# location of majordomo wrapper binary
$majordomo_wrapper = '/usr/lib/majordomo/wrapper';

# majordomo mailinglists dir
$majordomo_ldir = '/var/lib/majordomo/lists';

# majordomo username
$majordomo_user = 'mdom';


## IDN support

# XXX
$idn_shell =  '/usr/local/bin/idnconv';

# XXX
$idn_vendor = 'idnkit';

# XXX
$iconv_shell = '';


## spam protection

# XXX
$spamassassin_support = '0';

# path to spamassassin configuration file (local.cf)
$spamassassinConfig = '/etc/mail/spamassassin/local.cf';

# set this argument to the uid under which you spamassassin daemon is running
# (check '-u' option of 'spamd')
# if no value specified, than it is supposed then your spamd is running 
# under the root user
$spamassassinUid = '';

## cold fusiomn

# XXX
$coldfusion_support = '1';


## cronjobs

# XXX
$cronjobs_support = '1';

## bins

# location of find binary
$bin_find = '/usr/bin/find';

# location of cp binary
$bin_cp = '/bin/cp';

# location of grep binary
$bin_grep = '/bin/grep';

# location of chown binary
$bin_chown = '/bin/chown';

# location of chmod binary
$bin_chmod = '/bin/chmod';

# location of rm binary
$bin_rm = '/bin/rm';

# location of du binary
$bin_du = '/usr/bin/du';

# location of ifconfig binary
$bin_ifconfig = '/sbin/ifconfig';

# location of webalizer binary
$bin_webalizer = '/usr/bin/webalizer';

# location of FrontPage binary (fpsrvadm.exe for 2000, owsadm.exe for 2002)
$bin_fpsrvadm = '/usr/local/frontpage/version5.0/bin/owsadm.exe';

# location of openssl binary
$bin_openssl = '/usr/bin/openssl';

# location for psql binary (if PostgreSQL is used)
$bin_psql = '';

# location of mysql binary
$bin_mysql = '/usr/bin/mysql';

# location of gzip binary
$bin_gzip = '/bin/gzip';

# location of tar binary
$bin_tar = '/bin/tar';

# location of unzip binary
$bin_unzip = '/usr/bin/unzip';

# XXX
$bin_iconv = '';

# XXX
$bin_idn = '';

# XXX
$bin_su = '/bin/su';

#quota
$use_quota = '1';
$mail_quota = '0';
$user_quota = '1';
$majordomo_quota = '0';
$inode_std = '0';

# ftp
$ftpDaemon = 'vsftpd';
$ftpConfFile = '/etc/vsftpd.conf';
$ftpLogFile = '/var/log/xferlog';
$ftpbytes = '0';
$chrootUsers = '/etc/chrootUsers';
$ftpEmail = '';

# dbs
$dbType = 'mysql';
$dbServer = 'localhost';
$dbUser = 'confixx';
$dbPw = '1234567';
$dbDB = 'confixx';
$mysqlUserServer = '';
$mysqlUserUser = '';
$mysqlUserPw = '';
$mysql_homeDir = '';
$use_mysqlshell = '';
$mysql_host = '123.456.789.101';
$mysql_sock = '/var/lib/mysql/mysql.sock';

# cgis
$mail_pop3Server = 'localhost';

# dns
$dns_server = '0';
$dns_type = 'bind';
$dns_dir = '';
$dns_extension = '.db';
$dns_configure = '';
$dns_serverid = '';

$rpm_version_flag = '0';
$no_questions_mode = '0';

##

$no_pipelog_mode = '0';

## confixx updates
$new_version_url = 'http://updates.confixx.de/';

     ### ENDE ####

$db_address = 'DBI:mysql:confixx:localhost;mysql_socket=/var/lib/mysql/mysql.sock';
[/size]

[Anonymous]

Ich kanns grad nich vergleichen, weil mein confixx Server gerade umzieht, aber für mich siehts gut aus.

[lufthansen]

was sagt die datei ?
cat /home/www/confixx/settings.inc.php
oder wo auch immer die bei dir liegen mag ?
und mysql4 war shcon immer installiert ?

[bastilein]

die settings.inc.php
liegt bei mir:

/srv/www/confixx/settings.inc.php

und sagst:

Code: Select all

<?
#### CONFIXX PHP CONFIG FILE ####
    ### created at Thu Aug 19 20:03:35 2004 ###

define( "MaxPwdLength", 12 );

$version = '3.0.3';
$langfileversion = '3.0.3';
$default_language = 'de';
$user_prefix = 'web'; # do not edit!!
$hostname = 'p1234567.pureserver.info';
$bindir = '/srv/www/confixx/bin';
$sbindir = '/srv/www/confixx/sbin';
$tmp_dir = '/srv/www/confixx/tmp';

$db_type = 'mysql';
$db_db = 'confixx';
$db_host = 'localhost';
$db_user = 'confixx';
$db_pass = '1234567';
$mysql_user_host = '';
$mysql_user_user = '';
$mysql_user_pass = '';
$mysql_host = '123.123.456.789';

$mail_pop3Server = 'localhost';

$fehlerfarbe = '#FF9900';
$color_dark_grey = '#CCCCCC';
$color_light_grey = '#EEEEEE';
$color_blue = '#000066';
$color_arrow = '#A0CCFF';
$show_emailtransfer = '1';
$max_emailrcpts = '10';
$disable_md5 = '0';

$show_dotfiles = '1';

     ### END ####
?>

[lufthansen]

damit sollte dien prob dochgeklärt sein :D
einfach die daten da eintragen und ZACK sollte alles funze n:D

[bastilein]

und wie soll das bitte aussehen?`
kannst mir das mal bitte schreiben wie du es meinst...

weil ich versteh das nicht..
die daten die da jetzt stehen stimmen doch auch oder?


(zumal es den user wwwrun)
habe grad mal über yast
nachgesehen garnicht gibt...

[lufthansen]

$mysql_user_host = '';
$mysql_user_user = '';
$mysql_user_pass = '';

die datenangeben

[bastilein]

und sollte da jetzt der user confixx einegtragen werden oder der user wwwrun


(da der user wwwrun ja auch in der fehlermeldung verlangt wird..

das komische ist ja aber der user wwwrun existirt nicht im yast control center unter user...

wen ch ihn anlegen sollte weis ich aber nicht wie...

ich habs jetzt mal mit dem user confixx und desen passwort und als host localhost probiert..

beim anlegen der DB war aber immer noch der fehler vorhanden...


alles was verschwand ist die erze zeile:
Warning: mysql_connect(): Access denied for user: 'wwwrun@localhost' (Using password: YES) in /srv/www/confixx/html/user/db_mysql_anlegen.php on line 96


aber der rest...:
ist noch da:

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /srv/www/confixx/html/user/db_mysql_anlegen.php on line 34

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /srv/www/confixx/html/user/db_mysql_anlegen.php on line 34

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /srv/www/confixx/html/user/db_mysql_anlegen.php on line 34

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /srv/www/confixx/html/user/db_mysql_anlegen.php on line 14

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /srv/www/confixx/html/user/db_mysql_anlegen.php on line 14

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /srv/www/confixx/html/user/db_mysql_anlegen.php on line 14

[lufthansen]

also nochmal =)
wwwrun ist der webserver user der wird zu nem mysql connect eigentlich immer nur dann genommen wenn keiner eigenr user angeben ist ...
und wie willst du mysql zugansdaten eines webservers users angeben ?????


du musst da die gleichen daten eintragen wie in der confixx_main.conf

$dbServer = 'localhost';
$dbUser = 'confixx';
$dbPw = '12345678';
$dbDB = 'confixx';

[/quote]

[antondollmaier]

$mysql_user_host = '';
$mysql_user_user = '';
$mysql_user_pass = '';

die datenangeben

richtig ... aber da bitte die daten vom mysql-root-user ... sonst kann der ja keine dbs erstellen ... oder du gibst dem confixx-user das recht, dbs zu erstellen ...

[bastilein]

hehe...
das habe ich schon verstanden..
aber ich habe ja die confixx mysql datenbank root daten eingetragen und trotzdem noch die fehler meldung.. nur eben ohne die erste zeile

die ist dann nicht mehr da aber der rest schon..:

Warning: mysql_connect(): Access denied for user: 'wwwrun@localhost' (Using password: YES) in /srv/www/confixx/html/user/db_mysql_anlegen.php on line 96

[gamecrash]

Ã?hm, was hast Du als $mysql_user_user = ''; eingegeben?

[bastilein]

also ich habe ja beides ausprobiert...

einmal wwwrun
und einmal confixx

mit dem user confixx kamm ich weiter..
es war dann eben nicht mehr die Fehlermeldung:

Code: Select all

Warning: mysql_connect(): Access denied for user: 'wwwrun@localhost' (Using password: NO) in /srv/www/confixx/html/user/db_mysql_anlegen.php on line 96 

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /srv/www/confixx/html/user/db_mysql_anlegen.php on line 14 

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /srv/www/confixx/html/user/db_mysql_anlegen.php on line 14 

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /srv/www/confixx/html/user/db_mysql_anlegen.php on line 14 

sondern nur noch die Fehlermeldung:

Code: Select all

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /srv/www/confixx/html/user/db_mysql_anlegen.php on line 14 

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /srv/www/confixx/html/user/db_mysql_anlegen.php on line 14 

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /srv/www/confixx/html/user/db_mysql_anlegen.php on line 14 

aber Fehlermeldung ist und bleibt Fehler weil eben trotzdem nichts angelegt wird :-(

[sascha]

Ein Passwort solltest du auch angeben.

[bastilein]

ich habe das selbe passwort genommen wie es auch in der confixx_main.conf steht..

das master-mysql pw

wie es auch der root benutzt ..

und trotzdem fehler

[bastilein]

also jetzt geht es wieder...

ich haeb in der settings.inc.php

mal den user root eingetragen und jetzt geht das confixx wieder.....

das problem ist halt vorher ging es mit dem standart user und auf einmal nicht mehr...

naja egal *G* jetzt geht
es ja...


ich sollte mal von mysql die logs aktivieren wo mach ich das den?
und wo werden die dann gespeichetr?

[tomek]

Code: Select all

vi /etc/my.cnf (oder wo die sich befindet)

In der Sektion [mysqld] folgendes einfügen z.B.:

Code: Select all

log = /var/log/mysql/mysql.log