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:
- 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.
- 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.