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
multiple
values ? I try mysql> delete from version where
table_name='trusted';
it's not good
Harry
--- Iqbal iqbal@gigo.co.uk a écrit :
what does select * from version display
Iqbal
harry gaillac wrote:
Ok,
I understand . I use phpmyadmin to manage ser however mysql> select * from version; don't display the
same
result
Harry
--- Iqbal iqbal@gigo.co.uk a écrit :
>now remove all the duplicate rows, leaving
only
> > > >
one
>of each type, eg if >you have alook there are two rows called >domains...remove one, lcr is >also there twice, > >Iqbal > >harry gaillac wrote: > > > > > > > >>here is table version from ser DB: >>+-----------------------+---------------+ >>| 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 | >>| 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 | >>| domain | 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 | >>+-----------------------+---------------+ >>54 rows in set (0.00 sec) >> >>--- Iqbal iqbal@gigo.co.uk a écrit : >> >> >> >> >> >> >> >> >> >>>can u dump your version table here, and let
us
>>> >>> >>> >>> >>> >>> >look > > > > > > >>>at it
=== 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