[Serusers] ser don't start nedd help
harry gaillac
gaillacharry at yahoo.fr
Fri Jun 3 19:15:23 CEST 2005
Why auth_db module failed when ser is started?
What may i do ?!
--- Iqbal <iqbal at gigo.co.uk> a écrit :
> okay so you have managed to get rid of all the
> duplicates, now just your
> version is incorrect.
>
> I have pasted my tables,
>
> +-----------------------+---------------+
> | table_name | table_version |
> +-----------------------+---------------+
> | gw | 1 |
> | lcr | 1 |
> | gw_grp | 1 |
> | realm | 1 |
> | subscriber | 5 |
> | reserved | 1 |
> | phonebook | 1 |
> | pending | 4 |
> | missed_calls | 2 |
> | location | 6 |
> | grp | 2 |
> | event | 1 |
> | aliases | 6 |
> | active_session | 1 |
> | acc | 2 |
> | config | 1 |
> | silo | 3 |
> | domain | 1 |
> | uri | 2 |
> | server_monitoring | 1 |
> | server_monitoring_agg | 1 |
> | trusted | 1 |
> | usr_preferences | 1 |
> | preferences_types | 1 |
> | admin_privileges | 1 |
> | calls_forwarding | 1 |
> | speed_dial | 1 |
> +-----------------------+---------------+
>
> harry gaillac wrote:
>
> >I drop create ser db.
> >However when I start ser i get :
> >serveur1:~# tail /var/log/syslog
> >Jun 3 18:39:01 serveur1 /USR/SBIN/CRON[2616]:
> (root)
> >CMD ( [ -d /var/lib/php4 ] && find /var/lib/php4/
> >-type f -cmin +$(/usr/lib/php4/maxlifetime) -print0
> |
> >xargs -r -0 rm)
> >Jun 3 18:44:02 serveur1 /usr/sbin/ser[2729]:
> Maxfwd
> >module- initializing
> >Jun 3 18:44:02 serveur1 /usr/sbin/ser[2729]:
> >permissions - initializing
> >Jun 3 18:44:02 serveur1 /usr/sbin/ser[2729]:
> WARNING:
> >File not found: /etc/ser/permissions.allow
> >Jun 3 18:44:02 serveur1 /usr/sbin/ser[2729]:
> Default
> >allow file (/etc/ser/permissions.allow) not found
> =>
> >empty rule set
> >Jun 3 18:44:02 serveur1 /usr/sbin/ser[2729]:
> WARNING:
> >File not found: /etc/ser/permissions.deny
> >Jun 3 18:44:02 serveur1 /usr/sbin/ser[2729]:
> Default
> >deny file (/etc/ser/permissions.deny) not found =>
> >empty rule set
> >Jun 3 18:44:02 serveur1 /usr/sbin/ser[2729]:
> AVPops -
> >initializing
> >Jun 3 18:44:02 serveur1 /usr/sbin/ser[2729]:
> >auth_db:str_fixup: Invalid table version (use
> >ser_mysql.sh reinstall)
> >Jun 3 18:44:02 serveur1 /usr/sbin/ser[2729]:
> ERROR:
> >fix_expr : fix_actions error
> >
> >
> >version table from phpmyadmin:
> >Résultat de la requête SQL
> >
> >Serveur: localhost
> >Base de données: ser
> >Généré le : Vendredi 03 Juin 2005 à 18:39
> >Généré par: phpMyAdmin 2.6.2 / MySQL
> >4.0.24_Debian-10-log
> >requête SQL: SELECT * FROM `version` LIMIT 0, 30;
> >Enregistrements: 27
> >table_name table_version
> >subscriber 5
> >reserved 1
> >phonebook 1
> >pending 4
> >missed_calls 2
> >location 6
> >grp 2
> >event 1
> >aliases 6
> >active_sessions 1
> >acc 2
> >config 1
> >silo 3
> >realm 1
> >domain 1
> >uri 1
> >server_monitoring 1
> >server_monitoring_agg 1
> >trusted 1
> >usr_preferences 2
> >usr_preferences_types 1
> >admin_privileges 1
> >calls_forwarding 1
> >speed_dial 2
> >gw 1
> >gw_grp 1
> >lcr 1
> >
> >Version table with command:
> >+-----------------------+---------------+
> >| table_name | table_version |
> >+-----------------------+---------------+
> >| subscriber | 5 |
> >| reserved | 1 |
> >| phonebook | 1 |
> >| pending | 4 |
> >| missed_calls | 2 |
> >| location | 6 |
> >| grp | 2 |
> >| event | 1 |
> >| aliases | 6 |
> >| active_sessions | 1 |
> >| acc | 2 |
> >| config | 1 |
> >| silo | 3 |
> >| realm | 1 |
> >| domain | 1 |
> >| uri | 1 |
> >| server_monitoring | 1 |
> >| server_monitoring_agg | 1 |
> >| trusted | 1 |
> >| usr_preferences | 2 |
> >| usr_preferences_types | 1 |
> >| admin_privileges | 1 |
> >| calls_forwarding | 1 |
> >| speed_dial | 2 |
> >| gw | 1 |
> >| gw_grp | 1 |
> >| lcr | 1 |
> >+-----------------------+---------------+
> >27 rows in set (0.01 sec)
> >
> >
> >--- Iqbal <iqbal at gigo.co.uk> a écrit :
> >
> >
> >
> >>they should be identical, do u keep logs of
> queries
> >>sent to Mysql , if
> >>so look at them when u use phpmyadmin, and also
> >>manual queries, and you
> >>will see what is actually being sent, the log will
> >>usually be in
> >>/var/log on the machine with the DB
> >>
> >>Iqbal
> >>
> >>harry gaillac wrote:
> >>
> >>
> >>
> >>>Why datas from phpmyadmin are not equal to
> >>>mysql> select * from version;
> >>>
> >>>Is it a bug ?
> >>>--- Iqbal <iqbal at gigo.co.uk> a écrit :
> >>>
> >>>
> >>>
> >>>
> >>>
> >>>>whats the error, I cut and pasted that query and
> >>>>
> >>>>
> >>it
> >>
> >>
> >>>>deleted the row,
> >>>>
> >>>>Iqbal
> >>>>
> >>>>harry gaillac wrote:
> >>>>
> >>>>
> >>>>
> >>>>
> >>>>
> >>>>>Do you know the right SQL command to delete
> >>>>>
>
=== message truncated ===
_____________________________________________________________________________
Découvrez le nouveau Yahoo! Mail : 1 Go d'espace de stockage pour vos mails, photos et vidéos !
Créez votre Yahoo! Mail sur http://fr.mail.yahoo.com
More information about the sr-users
mailing list