[Serusers] serweb not working?

[Jan Janak]

Hello,

even if localhost and sip.sm6tpn.mine.nu is the same computer, it does
matter if you specify -h localhost or -h sip.sm6tpn.mine.nu. You can
have a different username and password for each hostname. MySQL simply
takes it as a string, i.e. root at localhost can have different password
than root at sip.sm6tpn.mine.nu.

See mysql manual at http://www.mysql.com There is a detailed description
of mysql authentication system and it also describes how to
create/delete users and set their passwords.

 Jan.

On 01-10 21:27, Daniel-Constantin Mierla wrote:
> I am sorry, too. I am not a MySQL expert. I would try to add another row 
> with IP address (I guess 192.168.10.121) instead of 
> 'sip.sm6tpn.mine.nu'. If doesn't work, post the question on the mysql 
> mailing lists.
> 
> }Daniel
> 
> 
> On 10/1/2003 9:12 PM, H?kan wrote:
> 
> >Hello.
> >
> >Tanks for youre answer. I am sorry. I can not get it right.
> >I can logg in like this.
> >
> >"mysql -u root -p" but not with "mysql -u root -h sip.sm6tpn.mine.nu -p"
> >Even if I kan se
> >
> >| Host                      | User | Pass.....................
> >| localhost                | root  | 123...... | Y          | Y           |
> >Y            |...........
> >| sip.sm6tpn.mine.nu | root  | 123...... | Y          | Y           | Y
> >|.........
> >
> >I do not understand why I can't log in. Localhost and sip.sm6tpn.mine.nu is
> >the very same computer...
> >
> >Regards H?kan
> >
> >----- Original Message ----- 
> >From: "Daniel-Constantin Mierla"
> ><Daniel-Constantin.Mierla at fokus.fraunhofer.de>
> >To: "H?kan" <hakan at sm6tpn.mine.nu>
> >Cc: <serusers at lists.iptel.org>
> >Sent: Wednesday, October 01, 2003 10:32 AM
> >Subject: Re: [Serusers] serweb not working?
> >
> >
> > 
> >
> >>Hello,
> >>the user ser has no access right from host sip.sm6tpn.mine.nu to the
> >>mysql server. See the 'Databse administration' chapter of mysql manual
> >>to learn how to do it.
> >>Useful links:
> >>http://www.mysql.com/documentation/mysql/bychapter/index.html
> >>
> >>   
> >>
> >http://www.mysql.com/documentation/mysql/bychapter/manual_MySQL_Database_Administration.html#User_Account_Management
> > 
> >
> >>Best regards,
> >>Daniel
> >>
> >>On 9/30/2003 10:16 PM, H?kan wrote:
> >>
> >>   
> >>
> >>>My problem is when I go to http://my.domain/admin/index.php I get this
> >>>information:-
> >>>
> >>>Warning: Access denied for user: 'ser at sip.sm6tpn.mine.nu' (Using
> >>>     
> >>>
> >password:
> > 
> >
> >>>YES) in /var/www/phplib/db_mysql.inc on line 73
> >>>Database error: pconnect(192.168.10.121, ser, $Password) failed.
> >>>MySQL Error: ()
> >>>Session halted.
> >>>
> >>>I have installd
> >>>
> >>>ser-0.8.11-0.i386.rpm
> >>>ser-jabber-0.8.11-0.i386.rpm
> >>>ser-mysql-0.8.11-0.i386.rpm
> >>>php-4.1.2-7.i386.rpm
> >>>php-mysql-4.1.2-7.i386.rpm
> >>>mysql-server-3.23.49-3.i386.rpm
> >>>apache-1.3.27-5.i386.rpm
> >>>
> >>>I run RedHat 7.3
> >>>kernel 2.4.20-20.7
> >>>
> >>>I can logging in as ser and serro in mysql. the ser db is there too.
> >>>
> >>>I have folowed Dan Austins SER HowTo but no luck :-(
> >>>
> >>>Please help me. My head is hurting ;-)
> >>>
> >>>regardes Hakan.
> >>>
> >>>
> >>>
> >>>_______________________________________________
> >>>Serusers mailing list
> >>>serusers at lists.iptel.org
> >>>http://lists.iptel.org/mailman/listinfo/serusers
> >>>
> >>>
> >>>
> >>>     
> >>>
> >>_______________________________________________
> >>Serusers mailing list
> >>serusers at lists.iptel.org
> >>http://lists.iptel.org/mailman/listinfo/serusers
> >>
> >>   
> >>
> >
> >
> >
> > 
> >
> 
> 
> _______________________________________________
> Serusers mailing list
> serusers at lists.iptel.org
> http://lists.iptel.org/mailman/listinfo/serusers