Post Reply 
 
Thread Rating:
  • 1 Votes - 4 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Error after Login
06-07-2013, 09:39 PM
Post: #1
Error after Login
Hello
I just installed webERP on my webserver. I set the admin password and tried to log in, but I only get the following error.

Warning: mysqli_connect(): (HY000/2002): No such file or directory in /kunden/351322_8001/web/2039205/A2039205/www/webERP/includes/ConnectDB_mysqli.inc on line 17

Warning: mysqli_set_charset() expects parameter 1 to be mysqli, boolean given in /kunden/351322_8001/web/2039205/A2039205/www/webERP/includes/ConnectDB_mysqli.inc on line 23
Connect failed: No such file or directory
Click here to try logging in again

I changed the port in Connect_DB files to the one used for the MYSQL database amd tried with changing mysqli to mysql in the config.php page, but then i get another, similar, error. Is there anything else I coudld look for to make it work?
Visit this user's website Find all posts by this user
Quote this message in a reply
06-12-2013, 01:01 AM
Post: #2
RE: Error after Login
In the ConnectDB_mysqli.inc file it looks like this below. Does anyone know what to do with this issue?

1 <?php
2
3 /* $Id: ConnectDB_mysqli.inc 5785 2012-12-29 04:47:42Z daintree $ */
4
5 /* PeterMoulding.com
6 20071102 Change from mysql to mysqli;
7 20071102 Add $db to DB_escape_string();
8 */
9
10 define ('LIKE','LIKE');
11
12 if (!isset($mysqlport)){
13 $mysqlport = 3306;
14 }
15 global $db; // Make sure it IS global, regardless of our context
16
17 $db = mysqli_connect($host , $DBUser, $DBPassword,$_SESSION['DatabaseName'], $mysqlport);
18 //$result=DB_query('SET sql_mode = ANSI', $db);
19
20
21 //this statement sets the charset to be used for sending data to and from the db server
22 //if not set, both mysqli server and mysqli client/library may assume otherwise
23 mysqli_set_charset($db, 'utf8');
Visit this user's website Find all posts by this user
Quote this message in a reply
06-12-2013, 06:57 AM
Post: #3
RE: Error after Login
Can you install phpMyAdmin on your host?

Could you post the output of phpinfo(); so we can see your setup - I suspect something is wrong with your mysql set up.

Phil Daintree
webERP Admin
Logic Works Ltd
http://www.logicworks.co.nz
Visit this user's website Find all posts by this user
Quote this message in a reply
06-12-2013, 03:29 PM
Post: #4
RE: Error after Login
Thanks for the reply. myphpadmin is preconfigured on my webserver throu my service provider.
See my php settings here:
http://all.christianseiler.ch/php.php
Visit this user's website Find all posts by this user
Quote this message in a reply
06-13-2013, 06:52 AM
Post: #5
RE: Error after Login
Tim has made the following comments - although I note from above that you have tried mysql option and this did not work either - there is a configuration issue with your mysql server

Quote:> Warning: mysqli_connect(): (HY000/2002): No such file or directory in /kunden/351322_8001/web/2039205/A2039205
> /www/webERP/includes/ConnectDB_mysqli.inc on line 17
>
> Warning: mysqli_set_charset() expects parameter 1 to be mysqli, boolean given in /kunden/351322_8001/web/2039205
> /A2039205/www/webERP/includes/ConnectDB_mysqli.inc on line 23
> Connect failed: No such file or directory
> Click here to try logging in again

The file that it is talking about is the mysqli socket. Looking at his phpinfo() output something is wrong with his mysqli setup, and that socket has no value. However mysql does have a default socket value, so I suggest he changes the DBType in config.php to be mysql rather than mysqli.

Also he should tell his provider of this issue.

Thanks
Tim

Phil Daintree
webERP Admin
Logic Works Ltd
http://www.logicworks.co.nz
Visit this user's website Find all posts by this user
Quote this message in a reply
Post Reply 


Forum Jump:


User(s) browsing this thread: 1 Guest(s)