List:MySQL++« Previous MessageNext Message »
From:Jim Date:January 7 2008 1:59pm
Subject:Re: mysql++ 3.0 beta2 Connecting troubles
View as plain text  
Bart Verstraete wrote:
> Jonathan Wakely schreef:
>> On 06/01/2008, Bart Verstraete <bartverstraete@stripped> wrote:
>>  
>>> Why wont this work?
>>>
>>> m_connected = connect("TEST", "127.0.0.1", "user", "pw", 3307);
>>>
>>> It compiles without an error but while connecting it trows a exception
>>> "Access denied ....blablabla". The db is tunneled via ssh on port 3307
>>>     
>>
>> It's almost certainly nothing to do with mysql++ - try connecting to
>> the same DB through the same ssh tunnel using the `mysql' command line
>> client and see if that works.
>> If that fails as well then obviously the reason mysql++ fails to
>> connect is that you don't have permission to access the DB using that
>> setup.
>>
>> Jon
>>
>>   
> Thats the problem, I can connect to the remote db thought the tunnel 
> with 'mysql', 'mysql-admin', 'mysql-query-browser', etc.  But not  
> with mysql++3.0 the only thing it says 'Access denied no permission' 
> or something but with te same user and pw I can connect with 'mysql' 
> and others. Pls help.
>
Try running a program using the mysql api.  If it works OK then it may 
be a mysql++ problem but if you can't get a program using the mysql api 
working, it isn't mysql++.

This should get you started:

Testm.cpp
#include <mysql/mysql.h>
#include <string>
#include <iostream>
#define AMYSQL_PORT 3307

using namespace std;

int main(int argc, char **argv)
{

    static MYSQL *conptr, *tptr;
    string host="";
    string uname="";
    string upass="";
    string db="";
    conptr = mysql_init (conptr);
    tptr = mysql_real_connect (
               conptr, host.c_str(), uname.c_str(), upass.c_str(), 
db.c_str(), AMYSQL_PORT, NULL, 0);
    if(tptr == NULL) {
        cout <<"Failed to connect"<<endl;
    }
}

Of course, fill in the empty strings with something that will work.

Jim.
Thread
mysql++ 3.0 beta2 Connecting troublesBart Verstraete6 Jan
  • Re: mysql++ 3.0 beta2 Connecting troublesJonathan Wakely6 Jan
    • Re: mysql++ 3.0 beta2 Connecting troublesBart Verstraete7 Jan
      • Re: mysql++ 3.0 beta2 Connecting troublesJim7 Jan
        • Re: mysql++ 3.0 beta2 Connecting troublesBart Verstraete8 Jan
          • Re: mysql++ 3.0 beta2 Connecting troublesJim9 Jan
            • Re: mysql++ 3.0 beta2 Connecting troublesBart Verstraete10 Jan
              • Re: mysql++ 3.0 beta2 Connecting troublesBart Verstraete10 Jan
                • Re: mysql++ 3.0 beta2 Connecting troublesBart Verstraete10 Jan
                  • Re: mysql++ 3.0 beta2 Connecting troublesWarren Young11 Jan
  • Re: mysql++ 3.0 beta2 Connecting troublesWarren Young7 Jan
    • Re: mysql++ 3.0 beta2 Connecting troublesBart Verstraete8 Jan
      • Re: mysql++ 3.0 beta2 Connecting troublesWarren Young8 Jan
        • Re: mysql++ 3.0 beta2 Connecting troublesBart Verstraete8 Jan
          • Re: mysql++ 3.0 beta2 Connecting troublesWarren Young8 Jan
            • Re: mysql++ 3.0 beta2 Connecting troublesBart Verstraete10 Jan
              • Re: mysql++ 3.0 beta2 Connecting troublesWarren Young11 Jan