On 29-09-2005 21:25, Ronald Wiplinger wrote:
Sep 29 19:44:11 dns ser: WARNING: fix_socket_list:
could not rev.
resolve 192.168.0.254
Sep 29 19:44:11 dns ser: WARNING: fix_socket_list: could not rev.
resolve 192.168.0.254
Sep 29 19:44:11 dns /usr/local/sbin/ser[19346]: Maxfwd module- initializing
Sep 29 19:44:11 dns /usr/local/sbin/ser[19346]: new_connection(): Access
denied for user: 'serro@localhost' (Using password: YES)
Sep 29 19:44:11 dns /usr/local/sbin/ser[19346]: db_init(): Could not
create a connection
Sep 29 19:44:11 dns /usr/local/sbin/ser[19346]: ERROR: auth_db_ver:
unable to open database connection
Sep 29 19:44:11 dns /usr/local/sbin/ser[19346]: auth_db:str_fixup():
Error while querying table version
Sep 29 19:44:11 dns /usr/local/sbin/ser[19346]: ERROR: fix_expr :
fix_actions error
Q:
1. Where do the Warning 192.168.0.254 come from? My network does not use
192.168.0.x
It is either configured in the configuration file using listen
directive, or one of your network interfaces has this address, or the
domain name SER is configured with resolves to the IP address.
2. Access denied is most likely the error for all
following errors. Note
the quote marks, they are around the entire name and not
'serro'@'localhost' I am not sure if that makes a difference.
The access to the database is for me not clear in the moment. We have a
user ser with password serpassword and a user serro with password
serropassword. We have also admin with the password adminpassword.
I don't find the user/passwords in the config files.
In mysql you also need to specify the hostname, that is, serro@a is
different than serro@localhost, ser_mysql.sh uses the following
statements to create users:
# Users: ser is the regular user, serro only for reading
GRANT ALL PRIVILEGES ON $1.* TO $USERNAME IDENTIFIED BY '$DEFAULT_PW';
GRANT ALL PRIVILEGES ON $1.* TO ${USERNAME}@$DBHOST IDENTIFIED BY
'$DEFAULT_PW';
GRANT SELECT ON $1.* TO $ROUSER IDENTIFIED BY '$RO_PW';
GRANT SELECT ON $1.* TO ${ROUSER}@$DBHOST IDENTIFIED BY '$RO_PW';
where $USERNAME, $DEFAULT_PW, $DBHOST, $ROUSER, $RO_PW are variables
that will be expanded. In this case ROUSER will be replaced with serro
and DBHOST will be replaced with localhost.
Jan.