Why auth_db module failed when ser is started? What may i do ?!
--- Iqbal iqbal@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@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@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