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
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
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
.
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
On Fri, 3 Jun 2005 19:15:23 +0200 (CEST) harry gaillac gaillacharry@yahoo.fr wrote:
Why auth_db module failed when ser is started? What may i do ?!
The auth.so module depends on a database module, depending on the one you use like, mysql, postgres, dbtext etc. Do you have mysql.so loadmodule before auth.so ? If you don't try putting a mysql loadmodule before the auth.so line and see what happens.
[]'s
loadmodule "/usr/lib/ser/modules/mysql.so" loadmodule "/usr/lib/ser/modules/sl.so" loadmodule "/usr/lib/ser/modules/tm.so" loadmodule "/usr/lib/ser/modules/rr.so" loadmodule "/usr/lib/ser/modules/maxfwd.so" loadmodule "/usr/lib/ser/modules/usrloc.so" loadmodule "/usr/lib/ser/modules/registrar.so" loadmodule "/usr/lib/ser/modules/uri.so" loadmodule "/usr/lib/ser/modules/nathelper.so" loadmodule "/usr/lib/ser/modules/auth.so" #loadmodule "/usr/lib/ser/modules/auth_db.so" loadmodule "/usr/lib/ser/modules/textops.so" loadmodule "/usr/lib/ser/modules/permissions.so" loadmodule "/usr/lib/ser/modules/group.so" loadmodule "/usr/lib/ser/modules/domain.so" loadmodule "/usr/lib/ser/modules/avpops.so"
--- Felipe Martins fmartins@mundivox.com a écrit :
On Fri, 3 Jun 2005 19:15:23 +0200 (CEST) harry gaillac gaillacharry@yahoo.fr wrote:
Why auth_db module failed when ser is started? What may i do ?!
The auth.so module depends on a database module, depending on the one you use like, mysql, postgres, dbtext etc. Do you have mysql.so loadmodule before auth.so ? If you don't try putting a mysql loadmodule before the auth.so line and see what happens.
[]'s
-- Felipe Martins Mundivox Communications Tecnologia e Projetos fmartins@mundivox.com
Tel.: +55 +21 +3820 8839 Cel.: +55 +21 +9823 8602 Fax.: +55 +21 +3820 8844 www.mundivox.com
Serusers mailing list serusers@lists.iptel.org http://lists.iptel.org/mailman/listinfo/serusers
_____________________________________________________________________________ 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
is the module there, I mean physically
harry gaillac wrote:
loadmodule "/usr/lib/ser/modules/mysql.so" loadmodule "/usr/lib/ser/modules/sl.so" loadmodule "/usr/lib/ser/modules/tm.so" loadmodule "/usr/lib/ser/modules/rr.so" loadmodule "/usr/lib/ser/modules/maxfwd.so" loadmodule "/usr/lib/ser/modules/usrloc.so" loadmodule "/usr/lib/ser/modules/registrar.so" loadmodule "/usr/lib/ser/modules/uri.so" loadmodule "/usr/lib/ser/modules/nathelper.so" loadmodule "/usr/lib/ser/modules/auth.so" #loadmodule "/usr/lib/ser/modules/auth_db.so" loadmodule "/usr/lib/ser/modules/textops.so" loadmodule "/usr/lib/ser/modules/permissions.so" loadmodule "/usr/lib/ser/modules/group.so" loadmodule "/usr/lib/ser/modules/domain.so" loadmodule "/usr/lib/ser/modules/avpops.so"
--- Felipe Martins fmartins@mundivox.com a écrit :
On Fri, 3 Jun 2005 19:15:23 +0200 (CEST) harry gaillac gaillacharry@yahoo.fr wrote:
Why auth_db module failed when ser is started? What may i do ?!
The auth.so module depends on a database module, depending on the one you use like, mysql, postgres, dbtext etc. Do you have mysql.so loadmodule before auth.so ? If you don't try putting a mysql loadmodule before the auth.so line and see what happens.
[]'s
-- Felipe Martins Mundivox Communications Tecnologia e Projetos fmartins@mundivox.com
Tel.: +55 +21 +3820 8839 Cel.: +55 +21 +9823 8602 Fax.: +55 +21 +3820 8844 www.mundivox.com
Serusers mailing list serusers@lists.iptel.org http://lists.iptel.org/mailman/listinfo/serusers
_____________________________________________________________________________ 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
Serusers mailing list serusers@lists.iptel.org http://lists.iptel.org/mailman/listinfo/serusers
.
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@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
.
When ser start it ask me to run "ser_mysql.sh reinstall"' to fix auth_db.so beacause of release don't match
--- Iqbal iqbal@gigo.co.uk a écrit :
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@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 |
=== 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
When ser start it ask me to run "ser_mysql.sh reinstall"' to fix auth_db.so beacause of release don't match
When you install a different version, the mysql tables are diferent ... you have to delete the old ones, or restore, delete and remake all of them ... I had the do the same procedure ... after that all went well ... :o)
now you could try doing that, and recreating, or you could just look at the script and see what table version it is creating and change your version number for that table name in the version table in ser (did that make sense :-)), or you could look at authdb_mod.c and see what table version it is using...could be '3' but again depends on what you have.
I would either drop table and use ser_mysql.sh to reinstall, or just vi ser_mysql.sh and look where it creates the table version, see what version it sets for each table, and set that.
If it does not still wortk after all that, look at the authdb_mod.c module and see what version it wants.
iqbal
harry gaillac wrote:
When ser start it ask me to run "ser_mysql.sh reinstall"' to fix auth_db.so beacause of release don't match
--- Iqbal iqbal@gigo.co.uk a écrit :
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@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 |
=== 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
.
I look authdb_mod.c table version (3) i change ser_mysql.h according to authdb_mod.c I did drop/create/reinstall for tables version however I still get: Jun 4 10:51:02 serveur1 /usr/sbin/ser[3526]: auth_db:str_fixup: Invalid table version (use ser_mysql.sh reinstall) Jun 4 10:51:02 serveur1 /usr/sbin/ser[3526]: ERROR: fix_expr : fix_actions error
--- Iqbal iqbal@gigo.co.uk a écrit :
now you could try doing that, and recreating, or you could just look at the script and see what table version it is creating and change your version number for that table name in the version table in ser (did that make sense :-)), or you could look at authdb_mod.c and see what table version it is using...could be '3' but again depends on what you have.
I would either drop table and use ser_mysql.sh to reinstall, or just vi ser_mysql.sh and look where it creates the table version, see what version it sets for each table, and set that.
If it does not still wortk after all that, look at the authdb_mod.c module and see what version it wants.
iqbal
harry gaillac wrote:
When ser start it ask me to run "ser_mysql.sh reinstall"' to fix auth_db.so beacause of release don't match
--- Iqbal iqbal@gigo.co.uk a écrit :
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@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
=>
=== 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
What is the ser_mysql.sh that you are using ? Is that the old 0.8.14 one or the new one (0.9.0) ?? If you use the old one, you are going to have the same problem ... To avoid this problem try to use the old one to DROP the tables. After that go to the new SER source directory and try the following command to create the tables on the new version:
# make dbinstall
I hope it helps you
Best Regards
On Sat, 4 Jun 2005 10:58:09 +0200 (CEST) harry gaillac gaillacharry@yahoo.fr wrote:
I look authdb_mod.c table version (3) i change ser_mysql.h according to authdb_mod.c I did drop/create/reinstall for tables version however I still get: Jun 4 10:51:02 serveur1 /usr/sbin/ser[3526]: auth_db:str_fixup: Invalid table version (use ser_mysql.sh reinstall) Jun 4 10:51:02 serveur1 /usr/sbin/ser[3526]: ERROR: fix_expr : fix_actions error
--- Iqbal iqbal@gigo.co.uk a écrit :
now you could try doing that, and recreating, or you could just look at the script and see what table version it is creating and change your version number for that table name in the version table in ser (did that make sense :-)), or you could look at authdb_mod.c and see what table version it is using...could be '3' but again depends on what you have.
I would either drop table and use ser_mysql.sh to reinstall, or just vi ser_mysql.sh and look where it creates the table version, see what version it sets for each table, and set that.
If it does not still wortk after all that, look at the authdb_mod.c module and see what version it wants.
iqbal
harry gaillac wrote:
When ser start it ask me to run "ser_mysql.sh reinstall"' to fix auth_db.so beacause of release don't match
--- Iqbal iqbal@gigo.co.uk a écrit :
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@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 > >
=>
=== 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
Serusers mailing list serusers@lists.iptel.org http://lists.iptel.org/mailman/listinfo/serusers
Most likely your ser_mysql.sh is not compatible with the version your ser. Download the latest ser_mysql.sh from
http://cvs.berlios.de/cgi-bin/viewcvs.cgi/*checkout*/ser/sip_router/scripts/ ser_mysql.sh?rev=1.71
Run that script to recreate the DB and your problem will be fixed.
-----Original Message----- From: serusers-bounces@lists.iptel.org [mailto:serusers-bounces@lists.iptel.org] On Behalf Of harry gaillac Sent: Saturday, 4 June 2005 4:07 AM To: Iqbal Cc: serusers@lists.iptel.org Subject: Re: [Serusers] ser don't start nedd help
When ser start it ask me to run "ser_mysql.sh reinstall"' to fix auth_db.so beacause of release don't match
hello,
I did it however:
Jun 4 10:29:12 serveur1 /usr/sbin/ser[2972]: Maxfwd module- initializing Jun 4 10:29:12 serveur1 /usr/sbin/ser[2972]: permissions - initializing Jun 4 10:29:12 serveur1 /usr/sbin/ser[2972]: WARNING: File not found: /etc/ser/permissions.allow Jun 4 10:29:12 serveur1 /usr/sbin/ser[2972]: Default allow file (/etc/ser/permissions.allow) not found => empty rule set Jun 4 10:29:12 serveur1 /usr/sbin/ser[2972]: WARNING: File not found: /etc/ser/permissions.deny Jun 4 10:29:12 serveur1 /usr/sbin/ser[2972]: Default deny file (/etc/ser/permissions.deny) not found => empty rule set Jun 4 10:29:12 serveur1 /usr/sbin/ser[2972]: AVPops - initializing Jun 4 10:29:12 serveur1 /usr/sbin/ser[2972]: auth_db:str_fixup: Invalid table version (use ser_mysql.sh reinstall) Jun 4 10:29:12 serveur1 /usr/sbin/ser[2972]: ERROR: fix_expr : fix_actions error
--- Zeus Ng zeus.ng@isquare.com.au a écrit :
Most likely your ser_mysql.sh is not compatible with the version your ser. Download the latest ser_mysql.sh from
http://cvs.berlios.de/cgi-bin/viewcvs.cgi/*checkout*/ser/sip_router/scripts/
ser_mysql.sh?rev=1.71
Run that script to recreate the DB and your problem will be fixed.
-----Original Message----- From: serusers-bounces@lists.iptel.org [mailto:serusers-bounces@lists.iptel.org] On Behalf Of
harry gaillac
Sent: Saturday, 4 June 2005 4:07 AM To: Iqbal Cc: serusers@lists.iptel.org Subject: Re: [Serusers] ser don't start nedd help
When ser start it ask me to run "ser_mysql.sh reinstall"' to fix auth_db.so beacause of release don't match
_____________________________________________________________________________ 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
-
Felipe Martins -
harry gaillac -
Iqbal -
Zeus Ng