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@localhost can have different password
than root(a)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(a)fokus.fraunhofer.de>
To: "H?kan" <hakan(a)sm6tpn.mine.nu>
Cc: <serusers(a)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_Ad…
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(a)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(a)lists.iptel.org
http://lists.iptel.org/mailman/listinfo/serusers
_______________________________________________
Serusers mailing list
serusers(a)lists.iptel.org
http://lists.iptel.org/mailman/listinfo/serusers
_______________________________________________
Serusers mailing list
serusers(a)lists.iptel.org
http://lists.iptel.org/mailman/listinfo/serusers