Uspjeo sam da podignem Sermyadmin verziju 2.0.1a, no medjutim sad ne mogu da se ulogujem kao admin sa defaultnim usernamom i passwordom.
Vjerovatno je problem u mysql bazi.
Sad me zanima gdje bi trebao dodati username i password tj. u koju tabelu u opensips bazi sa admin privilegijama. Da li u tabelu "subscriber" ?
kada u tabelu "subscriber" koja izgleda kao ispod pokusam dodati usera sa admin privilegijama dobijem>
Code:
mysql> select*from subscriber;
+----+----------+--------------+----------+---------------+----------------------------------+----------------------------------+------+---------+---------------+---------------+-------+---------------------+-----------+-------------+----------+---------+-----------+-------------+-------+-------------------+----------------+---------+----------+
| id | username | domain | password | email_address | ha1 | ha1b | rpid | version | password_hash | auth_username | class | datetime_created | domain_id | countrycode | areacode | role_id | caller_id | domain_name | email | opensips_username | vmail_password | credits | pre_paid |
+----+----------+--------------+----------+---------------+----------------------------------+----------------------------------+------+---------+---------------+---------------+-------+---------------------+-----------+-------------+----------+---------+-----------+-------------+-------+-------------------+----------------+---------+----------+
| 1 | 1000 | opensips.org | 1000 | | 99cee0333ad98b1c77413f76243b7675 | b22f5956d1eb95619bfe816a6b9832f0 | NULL | 0 | | | User | 2008-01-01 00:00:00 | 1 | NULL | NULL | 1 | NULL | NULL | NULL | NULL | NULL | NULL | NULL |
| 2 | 2000 | opensips.org | 2000 | | d24f1cd07a238c83bfea55b4246d9525 | a5cf718029e9c4227571b35aae6c3381 | NULL | 0 | | | User | 2008-01-01 00:00:00 | 1 | NULL | NULL | 1 | NULL | NULL | NULL | NULL | NULL | NULL | NULL |
+----+----------+--------------+----------+---------------+----------------------------------+----------------------------------+------+---------+---------------+---------------+-------+---------------------+-----------+-------------+----------+---------+-----------+-------------+-------+-------------------+----------------+---------+----------+
Code:mysql> INSERT INTO `subscriber` (`id`, `username`, `domain`, `password`, `email_address`, `ha1`, `ha1b`, `rpid`, `version`, `password_hash`, `auth_username`, `class`, `datetime_created`, `domain_id`, `countrycode`, `areacode`, `role_id`, `caller_id`, `domain_name`, `email`, `opensips_username`, `vmail_password`, `credits`, `pre_paid`) VALUES
-> (1, 'admin', 'sermyadmin.org', 'secret', '
[email protected]', 'e2df32663fbff3bb2bd22ed7a4a35636', '7d9f741c07c122817e51c4fc817b15dd', NULL, 12, 'e5e9fa1ba31ecd1ae84f75caaa474f3a663f05f4', '
[email protected]', 'User', '2008-01-01 00:00:00', 1, '1', '305', 3, NULL, 'sermyadmin.org', '
[email protected]', 'admin', 'setup', NULL, NULL);
ERROR 1062 (23000): Duplicate entry '1' for key 'PRIMARY'
Na mjestu "id" postavio vrijednost 3 (jer sam vec imao upisano u bazi dva korisnika) ....i upis je prosao, kao i uspjesno logiranje u sermyadmin.
PROBLEM RIJESEN
[Ovu poruku je menjao scenarist dana 25.07.2010. u 14:03 GMT+1]