[Serusers] ser don't start nedd help
Iqbal
iqbal at gigo.co.uk
Fri Jun 3 19:09:17 CEST 2005
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
>>>>>
>>>>>
>>>>>
>>>>>
>>>>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