At 05:39 PM 12/6/2002, MANSOOR Usama FTRD/DMR/LON wrote:
>>> My last question/issue is about dependancies. When I started working with SER
>>> I already had MySQL install, version 3.23.36 I believe. I could not get the MySQL
>>> portion integration to work, and found that permissions were not correctly granted.
>>> After manually correcting the permissions, I had errors about the communications
>>> between SER and MySQL. I updated MySQL to the latest stable release and
>>> client programs, and the integration worked with no manual intervention.
>>
>> I personaly use 3.23.52 for development, but I am sure that 3.23.36 works, we use it.
>> What kind of communication error did you get ? Could you send me some error logs ?
>
>I've also had similiar trouble regarding the permissions. I've installed v3.23.52 of MySQL, and run the ser_mysql.sh script, but get the following error message:
>
>Dec 6 14:50:42 localhost /usr/sbin/ser[4766]: connect_db(): Access denied for user: 'user(a)localhost.localdomain' (Using password: YES)
>Dec 6 14:50:42 localhost /usr/sbin/ser[4766]: db_init(): Error while trying to connect database
>
>When I check the permissions I see the following:
>
>mysql> select * from user;
>Where both 'ser' and 'serro' have no privileges at all.
[...]
I guess that's ok -- the user database just tells that these user have no
general privileges to change any database. They are granted permissions
for accessing ser database in the 'db' table.
I have no clue where the error might live. Try manual login using
mysql with the same username and password to get closer to the
problem.
-Jiri
Are you running the script as root? Before upgrading MySQL I did use the grant command,
and managed to get the correct permissions installed. I ran into other problems with the
client libraries, so I did a complete upgrade.
After upgrading the ser_mysql.sh script did everyting it should have and I did not need to
make any changes.
I'm also fairly new to MySQL, but from your error message, it looks like you are running
the script from an account that does not have permissions inside the database.
As root if you run mysql, does it prompt for a password? From your select statement, I
would not expect it to. If it allows you to logon to the database, you can try to assign the
default permissions manually.
Dan
-----Original Message-----
From: MANSOOR Usama FTRD/DMR/LON [mailto:usama.mansoor@rd.francetelecom.com]
Sent: Friday, December 06, 2002 8:40 AM
To: Jan Janak; serusers(a)lists.iptel.org
Subject: RE: RE: [Serusers] SER/SERWeb Howto...
>> My last question/issue is about dependancies. When I started working
>> with SER I already had MySQL install, version 3.23.36 I believe. I
>> could not get the MySQL portion integration to work, and found that
>> permissions were not correctly granted. After manually correcting the
>> permissions, I had errors about the communications between SER and
>> MySQL. I updated MySQL to the latest stable release and client
>> programs, and the integration worked with no manual intervention.
>
> I personaly use 3.23.52 for development, but I am sure that 3.23.36
> works, we use it.
> What kind of communication error did you get ? Could you send me some error logs ?
I've also had similiar trouble regarding the permissions. I've installed v3.23.52 of MySQL, and run the ser_mysql.sh script, but get the following error message:
Dec 6 14:50:42 localhost /usr/sbin/ser[4766]: connect_db(): Access denied for user: 'user(a)localhost.localdomain' (Using password: YES)
Dec 6 14:50:42 localhost /usr/sbin/ser[4766]: db_init(): Error while trying to connect database
When I check the permissions I see the following:
mysql> select * from user;
+-----------------------+-------+------------------+-------------+-------------+-------------+-------------+-------------+-----------+-------------+---------------+--------------+-----------+------------+-----------------+------------+------------+
| Host | User | Password | Select_priv | Insert_priv | Update_priv | Delete_priv | Create_priv | Drop_priv | Reload_priv | Shutdown_priv | Process_priv | File_priv | Grant_priv | References_priv | Index_priv | Alter_priv |
+-----------------------+-------+------------------+-------------+-------------+-------------+-------------+-------------+-----------+-------------+---------------+--------------+-----------+------------+-----------------+------------+------------+
| localhost | root | | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y |
| localhost.localdomain | root | | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y |
| localhost | | | N | N | N | N | N | N | N | N | N | N | N | N | N | N |
| localhost.localdomain | | | N | N | N | N | N | N | N | N | N | N | N | N | N | N |
| % | ser | 4e633cf914a735a0 | N | N | N | N | N | N | N | N | N | N | N | N | N | N |
| localhost | ser | 4e633cf914a735a0 | N | N | N | N | N | N | N | N | N | N | N | N | N | N |
| % | serro | 7cb73a267cb7bd5f | N | N | N | N | N | N | N | N | N | N | N | N | N | N |
| localhost | serro | 7cb73a267cb7bd5f | N | N | N | N | N | N | N | N | N | N | N | N | N | N |
+-----------------------+-------+------------------+-------------+-------------+-------------+-------------+-------------+-----------+-------------+---------------+--------------+-----------+------------+-----------------+------------+------------+
Where both 'ser' and 'serro' have no privileges at all.
This is my first time using MySQL, so I'm not entirely sure how to resolve this. Do I use the 'grant' command, or is did you try something different?
- Usama
_______________________________________________
Serusers mailing list
serusers(a)lists.iptel.org http://lists.iptel.org/mailman/listinfo/serusers
>> My last question/issue is about dependancies. When I started working with SER
>> I already had MySQL install, version 3.23.36 I believe. I could not get the MySQL
>> portion integration to work, and found that permissions were not correctly granted.
>> After manually correcting the permissions, I had errors about the communications
>> between SER and MySQL. I updated MySQL to the latest stable release and
>> client programs, and the integration worked with no manual intervention.
>
> I personaly use 3.23.52 for development, but I am sure that 3.23.36 works, we use it.
> What kind of communication error did you get ? Could you send me some error logs ?
I've also had similiar trouble regarding the permissions. I've installed v3.23.52 of MySQL, and run the ser_mysql.sh script, but get the following error message:
Dec 6 14:50:42 localhost /usr/sbin/ser[4766]: connect_db(): Access denied for user: 'user(a)localhost.localdomain' (Using password: YES)
Dec 6 14:50:42 localhost /usr/sbin/ser[4766]: db_init(): Error while trying to connect database
When I check the permissions I see the following:
mysql> select * from user;
+-----------------------+-------+------------------+-------------+-------------+-------------+-------------+-------------+-----------+-------------+---------------+--------------+-----------+------------+-----------------+------------+------------+
| Host | User | Password | Select_priv | Insert_priv | Update_priv | Delete_priv | Create_priv | Drop_priv | Reload_priv | Shutdown_priv | Process_priv | File_priv | Grant_priv | References_priv | Index_priv | Alter_priv |
+-----------------------+-------+------------------+-------------+-------------+-------------+-------------+-------------+-----------+-------------+---------------+--------------+-----------+------------+-----------------+------------+------------+
| localhost | root | | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y |
| localhost.localdomain | root | | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y |
| localhost | | | N | N | N | N | N | N | N | N | N | N | N | N | N | N |
| localhost.localdomain | | | N | N | N | N | N | N | N | N | N | N | N | N | N | N |
| % | ser | 4e633cf914a735a0 | N | N | N | N | N | N | N | N | N | N | N | N | N | N |
| localhost | ser | 4e633cf914a735a0 | N | N | N | N | N | N | N | N | N | N | N | N | N | N |
| % | serro | 7cb73a267cb7bd5f | N | N | N | N | N | N | N | N | N | N | N | N | N | N |
| localhost | serro | 7cb73a267cb7bd5f | N | N | N | N | N | N | N | N | N | N | N | N | N | N |
+-----------------------+-------+------------------+-------------+-------------+-------------+-------------+-------------+-----------+-------------+---------------+--------------+-----------+------------+-----------------+------------+------------+
Where both 'ser' and 'serro' have no privileges at all.
This is my first time using MySQL, so I'm not entirely sure how to resolve this. Do I use the 'grant' command, or is did you try something different?
- Usama
look at iptel.cfg:
lookup("aliases"); #resolve aliases first
if (!lookup("location")) { # and continue with canonical usernames then..
-Jiri
At 01:09 AM 12/6/2002, Dan Austin wrote:
>So something like this will do what I want?
>
> if (!lookup("location") and !lookup("aliases")) {
> sl_send_reply("404", "Not Found");
> break;
> };
>
># forward to current uri now
> if (!t_relay()) {
> sl_reply_error();
> };
>
>Dan
>-----Original Message-----
>From: Jiri Kuthan [mailto:jiri@iptel.org]
>Sent: Thursday, December 05, 2002 3:57 PM
>To: Dan Austin; serusers(a)lists.iptel.org
>Subject: Re: [Serusers] What are aliases for?
>
>
>I hope to update the admin's guide this week and it should include information on how to set up aliases. Basically,
>we use another "location" table to translate aliases to canonical usernames. The aliases can be maintained via the serctl utilitity, provided SQL persistency is turned on (otherwise they are gone on reboot).
>
>-Jiri
>
>At 11:38 PM 12/5/2002, Dan Austin wrote:
>>My guess based on reading the developers and admin guides is that an
>>account could be aliased to a DID number, or internal extension.
>>
>>In testing it doesn't seem to work that way. With two accounts, on a
>>Cisco IP phone and the other on MSN client, calls can be placed based
>>on the SIP account name, but not the alias.
>>
>>
>>Thanks,
>>Dan
>>_______________________________________________
>>Serusers mailing list
>>serusers(a)lists.iptel.org http://lists.iptel.org/mailman/listinfo/serusers
>
>--
>Jiri Kuthan http://iptel.org/~jiri/
>
>_______________________________________________
>Serusers mailing list
>serusers(a)lists.iptel.org
>http://lists.iptel.org/mailman/listinfo/serusers
--
Jiri Kuthan http://iptel.org/~jiri/
So something like this will do what I want?
if (!lookup("location") and !lookup("aliases")) {
sl_send_reply("404", "Not Found");
break;
};
# forward to current uri now
if (!t_relay()) {
sl_reply_error();
};
Dan
-----Original Message-----
From: Jiri Kuthan [mailto:jiri@iptel.org]
Sent: Thursday, December 05, 2002 3:57 PM
To: Dan Austin; serusers(a)lists.iptel.org
Subject: Re: [Serusers] What are aliases for?
I hope to update the admin's guide this week and it should include information on how to set up aliases. Basically,
we use another "location" table to translate aliases to canonical usernames. The aliases can be maintained via the serctl utilitity, provided SQL persistency is turned on (otherwise they are gone on reboot).
-Jiri
At 11:38 PM 12/5/2002, Dan Austin wrote:
>My guess based on reading the developers and admin guides is that an
>account could be aliased to a DID number, or internal extension.
>
>In testing it doesn't seem to work that way. With two accounts, on a
>Cisco IP phone and the other on MSN client, calls can be placed based
>on the SIP account name, but not the alias.
>
>
>Thanks,
>Dan
>_______________________________________________
>Serusers mailing list
>serusers(a)lists.iptel.org http://lists.iptel.org/mailman/listinfo/serusers
--
Jiri Kuthan http://iptel.org/~jiri/
I hope to update the admin's guide this week and it should
include information on how to set up aliases. Basically,
we use another "location" table to translate aliases to
canonical usernames. The aliases can be maintained via
the serctl utilitity, provided SQL persistency is turned
on (otherwise they are gone on reboot).
-Jiri
At 11:38 PM 12/5/2002, Dan Austin wrote:
>My guess based on reading the developers and admin guides is
>that an account could be aliased to a DID number, or internal
>extension.
>
>In testing it doesn't seem to work that way. With two accounts,
>on a Cisco IP phone and the other on MSN client, calls can be placed
>based on the SIP account name, but not the alias.
>
>
>Thanks,
>Dan
>_______________________________________________
>Serusers mailing list
>serusers(a)lists.iptel.org
>http://lists.iptel.org/mailman/listinfo/serusers
--
Jiri Kuthan http://iptel.org/~jiri/
My guess based on reading the developers and admin guides is
that an account could be aliased to a DID number, or internal
extension.
In testing it doesn't seem to work that way. With two accounts,
on a Cisco IP phone and the other on MSN client, calls can be placed
based on the SIP account name, but not the alias.
Thanks,
Dan
I think kphone (Linux) has STUN support. I heard some rumours about SJPhone,
but have never tried it out.
Out of hard-phones, snom is probably a very cheap alternative right now,
and it has STUN support too. Their old version might have been about $200,
but many folks found its physical design inconvenient. There is a new
version out now, which should be better in this respect.
-Jiri
At 06:28 AM 12/5/2002, Dan Austin wrote:
>I thought this bit would be easy, ask a few friends to register on my server and
>test IM and voice calls. It turns out each and everyone of them has NAT.
>
>A quick run around google tells me if I can find a softphone that supports STUN,
>or can be configured to use the IP address of the NAT gateway and I'll be set.
>
>Unfortunately I cannot find any *free* packages that offer these features. Has
>anyone come across I hate to think I'll have to acquire Cisco phones for my friends
>to continue testing.
>
>While I'm at it, I also was looking to find the least expensive SIP phone on the
>market. All I've found so far are links geared to large enterprises or OEMs, nothing
>a tinkerer could buy.
>
>Thanks,
>Dan
>_______________________________________________
>Serusers mailing list
>serusers(a)lists.iptel.org
>http://lists.iptel.org/mailman/listinfo/serusers
--
Jiri Kuthan http://iptel.org/~jiri/
I thought this bit would be easy, ask a few friends to register on my server and
test IM and voice calls. It turns out each and everyone of them has NAT.
A quick run around google tells me if I can find a softphone that supports STUN,
or can be configured to use the IP address of the NAT gateway and I'll be set.
Unfortunately I cannot find any *free* packages that offer these features. Has
anyone come across I hate to think I'll have to acquire Cisco phones for my friends
to continue testing.
While I'm at it, I also was looking to find the least expensive SIP phone on the
market. All I've found so far are links geared to large enterprises or OEMs, nothing
a tinkerer could buy.
Thanks,
Dan
The file keeps getting bigger, so I've posted it on my website instead of sending
it to the list. http://www.fitawi.com/ser-Howto.html
Updates based on Jiri & Jan's feedback.
New sections:
Using serctl
Client Configuration- Cisco 79XX phones, MSN Messenger 4.6
SIP Status codes
