General > Support

Need some help with database (mysql)

(1/2) > >>

fircx:
Hey guys!

I have linux server with mysql (5.1) apache (2.2) and php (5.3.3) installed. I uploaded Mibew files created database, but I have error while trying to access /install url.


--- Code: ---Could not connect. Please check server settings in config.php. Error: Access denied for user 'webimuser'@'localhost' (using password: YES)
--- End code ---

But I don't have any problem connecting the mysql server with credentials I have in config.php file:


--- Code: ---[root@livechat mibew]# mysql -u webimuser -h localhost -p
Enter password:
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 43
Server version: 5.1.69 Source distribution

Copyright (c) 2000, 2013, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> show databases;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| webim              |
+--------------------+
2 rows in set (0.00 sec)
--- End code ---

here is my config.php


--- Code: ---$mysqlhost = "localhost";
$mysqldb = "webim";
$mysqllogin = "webimuser";
$mysqlpass = "XXXXX";
$mysqlprefix = "";
--- End code ---


I granted all privileges to that user:

grant all privileges on webim.* to 'webimuser'@'localhost' identified by 'xxxxx';

I don't know what else should I do. Maybe there is some problem with php-mysql driver ? 

fircx:
I create test php file to invoke connection and than echo if succeeded:


--- Code: ---<?php
mysql_connect("localhost", "webimuser", "xxxxxx") or die(mysql_error());
echo "Connected to MySQL<br />";
mysql_select_db("webim") or die(mysql_error());
echo "Connected to Database";
?>

--- End code ---

and it works fine so there must be something with config.php file ?

Dmitriy Simushev:
Hi,

May be there is some low level cache in apache, so try to restart it.

ChrisS:
Hi fircx,

1, What version of messenger have you uploaded to the server.
2, Is the server on your pc locally or live hosted.

Have a look @ this thread here http://mibew.org/forums/index.php?topic=169597.0


Sometimes we can't see the wood for the trees
Regards

fircx:
thanks guys for replay!
 
I finally got it working by removing everything, than I download archive again wrote my mysql credentials in config.php file and everything is working perfect now. I'm not quite sure what was the problem but anyways it is fixed.

Version I'm using is Mibew Messenger 1.6.5, 2013-07-24. 

Navigation

[0] Message Index

[#] Next page