[Serusers] ser don't start nedd help
harry gaillac
gaillacharry at yahoo.fr
Fri Jun 3 18:45:12 CEST 2005
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
> >>>
> >>>
> >>multiple
> >>
> >>
> >>>values ?
> >>>I try
> >>>mysql> delete from version where
> >>>
> >>>
> >>table_name='trusted';
> >>
> >>
> >>>it's not good
> >>>
> >>>Harry
> >>>
> >>>--- Iqbal <iqbal at 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 at 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 at 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
More information about the sr-users
mailing list