[Serusers] Errors during startup

Jan Janak jan at iptel.org
Thu Sep 29 15:59:21 CEST 2005


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 at 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 at a is
  different than serro at 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.




More information about the sr-users mailing list