[Serusers] ser don't start nedd help

[Iqbal]

can u post the ser debug,

Iqbal

harry gaillac wrote:

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