[Serusers] ser don't start nedd help

harry gaillac gaillacharry at yahoo.fr
Fri Jun 3 19:15:23 CEST 2005


Why auth_db module failed when ser is started?
What may i do ?!

--- Iqbal <iqbal at gigo.co.uk> a écrit :

> okay so you have managed to get rid of all the
> duplicates, now just your 
> version is incorrect.
> 
> I have pasted my tables,
> 
> +-----------------------+---------------+
> | table_name            | table_version |
> +-----------------------+---------------+
> | gw                    |             1 |
> | lcr                   |             1 |
> | gw_grp                |             1 |
> | realm                 |             1 |
> | subscriber            |             5 |
> | reserved              |             1 |
> | phonebook             |             1 |
> | pending               |             4 |
> | missed_calls          |             2 |
> | location              |             6 |
> | grp                   |             2 |
> | event                 |             1 |
> | aliases               |             6 |
> | active_session        |             1 |
> | acc                   |             2 |
> | config                |             1 |
> | silo                  |             3 |
> | domain                |             1 |
> | uri                   |             2 |
> | server_monitoring     |             1 |
> | server_monitoring_agg |             1 |
> | trusted               |             1 |
> | usr_preferences       |             1 |
> | preferences_types     |             1 |
> | admin_privileges      |             1 |
> | calls_forwarding      |             1 |
> | speed_dial            |             1 |
> +-----------------------+---------------+
> 
> harry gaillac wrote:
> 
> >I drop create ser db.
> >However when I start ser i get :
> >serveur1:~# tail /var/log/syslog
> >Jun  3 18:39:01 serveur1 /USR/SBIN/CRON[2616]:
> (root)
> >CMD (  [ -d /var/lib/php4 ] && find /var/lib/php4/
> >-type f -cmin +$(/usr/lib/php4/maxlifetime) -print0
> |
> >xargs -r -0 rm)
> >Jun  3 18:44:02 serveur1 /usr/sbin/ser[2729]:
> Maxfwd
> >module- initializing
> >Jun  3 18:44:02 serveur1 /usr/sbin/ser[2729]:
> >permissions - initializing
> >Jun  3 18:44:02 serveur1 /usr/sbin/ser[2729]:
> WARNING:
> >File not found: /etc/ser/permissions.allow
> >Jun  3 18:44:02 serveur1 /usr/sbin/ser[2729]:
> Default
> >allow file (/etc/ser/permissions.allow) not found
> =>
> >empty rule set
> >Jun  3 18:44:02 serveur1 /usr/sbin/ser[2729]:
> WARNING:
> >File not found: /etc/ser/permissions.deny
> >Jun  3 18:44:02 serveur1 /usr/sbin/ser[2729]:
> Default
> >deny file (/etc/ser/permissions.deny) not found =>
> >empty rule set
> >Jun  3 18:44:02 serveur1 /usr/sbin/ser[2729]:
> AVPops -
> >initializing
> >Jun  3 18:44:02 serveur1 /usr/sbin/ser[2729]:
> >auth_db:str_fixup: Invalid table version (use
> >ser_mysql.sh reinstall)
> >Jun  3 18:44:02 serveur1 /usr/sbin/ser[2729]:
> ERROR:
> >fix_expr : fix_actions error
> >
> >
> >version table from phpmyadmin:
> >Résultat de la requête SQL
> >
> >Serveur: localhost
> >Base de données: ser
> >Généré le : Vendredi 03 Juin 2005 à 18:39
> >Généré par: phpMyAdmin 2.6.2 / MySQL
> >4.0.24_Debian-10-log
> >requête SQL: SELECT * FROM `version` LIMIT 0, 30;
> >Enregistrements: 27
> >table_name 	table_version
> >subscriber 	5
> >reserved 	1
> >phonebook 	1
> >pending 	4
> >missed_calls 	2
> >location 	6
> >grp 	2
> >event 	1
> >aliases 	6
> >active_sessions 	1
> >acc 	2
> >config 	1
> >silo 	3
> >realm 	1
> >domain 	1
> >uri 	1
> >server_monitoring 	1
> >server_monitoring_agg 	1
> >trusted 	1
> >usr_preferences 	2
> >usr_preferences_types 	1
> >admin_privileges 	1
> >calls_forwarding 	1
> >speed_dial 	2
> >gw 	1
> >gw_grp 	1
> >lcr 	1
> >
> >Version table with command:
> >+-----------------------+---------------+
> >| table_name            | table_version |
> >+-----------------------+---------------+
> >| subscriber            |             5 |
> >| reserved              |             1 |
> >| phonebook             |             1 |
> >| pending               |             4 |
> >| missed_calls          |             2 |
> >| location              |             6 |
> >| grp                   |             2 |
> >| event                 |             1 |
> >| aliases               |             6 |
> >| active_sessions       |             1 |
> >| acc                   |             2 |
> >| config                |             1 |
> >| silo                  |             3 |
> >| realm                 |             1 |
> >| domain                |             1 |
> >| uri                   |             1 |
> >| server_monitoring     |             1 |
> >| server_monitoring_agg |             1 |
> >| trusted               |             1 |
> >| usr_preferences       |             2 |
> >| usr_preferences_types |             1 |
> >| admin_privileges      |             1 |
> >| calls_forwarding      |             1 |
> >| speed_dial            |             2 |
> >| gw                    |             1 |
> >| gw_grp                |             1 |
> >| lcr                   |             1 |
> >+-----------------------+---------------+
> >27 rows in set (0.01 sec)
> >
> >
> >--- Iqbal <iqbal at gigo.co.uk> a écrit :
> >
> >  
> >
> >>they should be identical, do u keep logs of
> queries
> >>sent to Mysql , if 
> >>so look at them when u use phpmyadmin, and also
> >>manual queries, and you 
> >>will see what is actually being sent, the log will
> >>usually be in 
> >>/var/log on the machine with the DB
> >>
> >>Iqbal
> >>
> >>harry gaillac wrote:
> >>
> >>    
> >>
> >>>Why datas from phpmyadmin are not equal to 
> >>>mysql> select * from version;
> >>>
> >>>Is it a bug ? 
> >>>--- Iqbal <iqbal at gigo.co.uk> a écrit :
> >>>
> >>> 
> >>>
> >>>      
> >>>
> >>>>whats the error, I cut and pasted that query and
> >>>>        
> >>>>
> >>it
> >>    
> >>
> >>>>deleted the row,
> >>>>
> >>>>Iqbal
> >>>>
> >>>>harry gaillac wrote:
> >>>>
> >>>>   
> >>>>
> >>>>        
> >>>>
> >>>>>Do you know the right SQL command to delete
> >>>>>     
> 
=== message truncated ===



	

	
		
_____________________________________________________________________________ 
Découvrez le nouveau Yahoo! Mail : 1 Go d'espace de stockage pour vos mails, photos et vidéos ! 
Créez votre Yahoo! Mail sur http://fr.mail.yahoo.com




More information about the sr-users mailing list