3 Jun
2005
3 Jun
'05
6:45 p.m.
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(a)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:
=== 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 datas from phpmyadmin are not equal to
mysql> select * from version;
Is it a bug ?
--- Iqbal <iqbal(a)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(a)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(a)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(a)gigo.co.uk> a écrit :
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>>>can u dump your version table here, and let
us
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>look
>>>>>
>>>>>
>>>>>
>>>>>
>>>>>
>>>>>
>>>>>>>at it
3 Jun
3 Jun
7:09 p.m.
New subject: [Serusers] ser don't start nedd help
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(a)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:
=== 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 datas from phpmyadmin are not equal to
mysql> select * from version;
Is it a bug ?
--- Iqbal <iqbal(a)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(a)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(a)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(a)gigo.co.uk> a écrit :
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>>>can u dump your version table here, and let
>>>>>>>
>>>>>>>
us
>>>>>>>>
>>>>>>>>
>>>>>>>>
>>>>>>>>
>>>>>>>>
>>>>>>>>
>>>>>>>>
>>>>>>>>
>>>>>>look
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>>>>at it
>>>>>>>>
>>>>>>>>
7:15 p.m.
New subject: [Serusers] ser don't start nedd help
Why auth_db module failed when ser is started?
What may i do ?!
--- Iqbal <iqbal(a)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:
=== 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 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(a)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(a)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
>>>>
7:48 p.m.
New subject: [Serusers] ser don't start nedd help
On Fri, 3 Jun 2005 19:15:23 +0200 (CEST)
harry gaillac <gaillacharry(a)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(a)mundivox.com
Tel.: +55 +21 +3820 8839
Cel.: +55 +21 +9823 8602
Fax.: +55 +21 +3820 8844
www.mundivox.com
7:52 p.m.
New subject: [Serusers] ser don't start nedd help
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(a)mundivox.com> a écrit :
On Fri, 3 Jun 2005 19:15:23 +0200 (CEST)
harry gaillac <gaillacharry(a)yahoo.fr> wrote:
_____________________________________________________________________________
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 ?!
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(a)mundivox.com
Tel.: +55 +21 +3820 8839
Cel.: +55 +21 +9823 8602
Fax.: +55 +21 +3820 8844
www.mundivox.com
_______________________________________________
Serusers mailing list
serusers(a)lists.iptel.org
http://lists.iptel.org/mailman/listinfo/serusers
7:53 p.m.
New subject: [Serusers] ser don't start nedd help
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(a)mundivox.com> a écrit :
On Fri, 3 Jun 2005 19:15:23 +0200 (CEST)
harry gaillac <gaillacharry(a)yahoo.fr> wrote:
_____________________________________________________________________________
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(a)lists.iptel.org
http://lists.iptel.org/mailman/listinfo/serusers
.
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(a)mundivox.com
Tel.: +55 +21 +3820 8839
Cel.: +55 +21 +9823 8602
Fax.: +55 +21 +3820 8844
www.mundivox.com
_______________________________________________
Serusers mailing list
serusers(a)lists.iptel.org
http://lists.iptel.org/mailman/listinfo/serusers
7:51 p.m.
New subject: [Serusers] ser don't start nedd help
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(a)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:
=== 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 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(a)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(a)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
>>>>>
>>>>>
>>>>>
8:07 p.m.
New subject: [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
--- Iqbal <iqbal(a)gigo.co.uk> a écrit :
can u post the ser debug,
Iqbal
harry gaillac wrote:
=== 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(a)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 |
8:14 p.m.
New subject: [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
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)
--
Felipe Martins
Mundivox Communications
Tecnologia e Projetos
fmartins(a)mundivox.com
Tel.: +55 +21 +3820 8839
Cel.: +55 +21 +9823 8602
Fax.: +55 +21 +3820 8844
www.mundivox.com
8:22 p.m.
New subject: [Serusers] ser don't start nedd help
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(a)gigo.co.uk> a écrit :
can u post the ser debug,
Iqbal
harry gaillac wrote:
=== 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(a)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 |
>>>
>>>
4 Jun
4 Jun
10:58 a.m.
New subject: [Serusers] ser don't start nedd help
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(a)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:
=== 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(a)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(a)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
>>>>
>>>>
>=>
>
6 Jun
6 Jun
3:08 p.m.
New subject: [Serusers] ser don't start nedd help
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(a)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(a)gigo.co.uk> a écrit :
--
Felipe Martins
Mundivox Communications
Tecnologia e Projetos
fmartins(a)mundivox.com
Tel.: +55 +21 +3820 8839
Cel.: +55 +21 +9823 8602
Fax.: +55 +21 +3820 8844
www.mundivox.com
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:
=== 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(a)lists.iptel.org
http://lists.iptel.org/mailman/listinfo/serusers
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(a)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(a)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
>>>>
>>>>
>=>
>
4 Jun
4 Jun
3:14 a.m.
New subject: [Serusers] ser don't start nedd help
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(a)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(a)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
10:31 a.m.
New subject: [Serusers] ser don't start nedd help
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(a)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.
_____________________________________________________________________________
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
-----Original Message-----
From: serusers-bounces(a)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(a)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
6922
days inactive
6925
days old
13 comments
4 participants
participants (4)
-
Felipe Martins -
harry gaillac -
Iqbal -
Zeus Ng