<div>hello! i'm following the ser howto that i got at iptel.org and i'm having errors when following these...</div> <div> </div> <H2 class=SECTION><A name=AEN214>3.2. Adding an admin for your realm</A></H2> <div>Now that we have a working database and ser is configured to use it, we need to add some users and at least one of them should have administrator privileges. The administrator role becomes important if you want to use a web management tool such as serweb. </div> <div>Basic account manipulation can be performed with the serctl script, located in /usr/sbin. </div> <div>To add a user use these commands </div><PRE class=SCREEN> serctl add JoeUser qwerty joe@mydomain.com </PRE> <div>The system notify for <SPAN class=QUOTE>"Type MySQL Password"</SPAN>, the default password is <SPAN class=QUOTE>"heslo"</SPAN> </div> <div>To make JoeUser an administrator, we need to logon to MySQL and modify the database. </div> <div><PRE class=SCREEN>mysql> connect ser;
mysql> update subscriber set perms=?admin? where USER_ID=?JoeUser?; Query OK, 1 row affected (0.00 sec) Rows matched: 1 Changed: 1 Warnings: 0 mysql> select * from subscriber; | 4cefa7a4d3c8c2dbf6328520bd873a19 | JoeUser | qwerty | | | | joe@mydomain.com | 2002-12-02 19:20:41 | 2002-12-02 20:29:46 | 80e0f273b2067d40277b49ff842bb9e3 | o | | | c79a8f8f08596baa84bb02c88884426d | mydomain.com | f322c94b8b2fbe557d43ab3ac9e05b3a | admin | 1 | America/Los_Angeles |</PRE> <div></div> <div>The third from last field shows that Joe has been assigned admin privileges. </div> <div>At this point Joe can logon to our server, but since he is the only user, there is not much he can do. We can now add additional users using the serctl script, or now is a good time to look at installing serweb, which will allow users to subscribe to our service. </div> <div> </div> <div> </div> <div>sql gives me an error saying check the
manual that came with my mysql dist. and says an error from ?admin? where USER_ID=?JoeUser?. can anyone help me here..... :(</div> <div> </div> <div>ryan</div><p>
<hr size="1"><FONT face=Arial size=-1>Do you Yahoo!?<BR>Try the new <A href="http://sg.rd.yahoo.com/mail/ph/footer/def/*http://beta.ph.yahoo.com/">Yahoo! Philippines</A> Front Page!</FONT>