Mailing List Archive


Back to the month index Back to the list index
Mario Sergio Fujikawa Ferreira (lioux@GNS.com.br)
Thu, 2 Jan 1997 11:51:14 -0200 (EDT) 

From: Mario Sergio Fujikawa Ferreira <lioux@GNS.com.br>
Message-Id: <199701021351.LAA20287@srv1-bsb.GNS.com.br>
Subject: [mSQL] Strange Database Access Denied
Date: Thu, 2 Jan 1997 11:51:14 -0200 (EDT)

        I wrote standalone program using the same functions to debug it.
        It ran smoothly with my userid. When tried against the radius server userid, it did not.
        Both users have write access to the database through the acl rules.
        I was wondering about the rfc931 option, yet I enabled the radius user ident lookups: nothing happened.
        I became so desesperated I began trying a simple plain insert query. Voila, it works with my userid and does not with the radius server one.
        My userid is a common one, no privileges, just as the radius server one.
        I did this program based on a idea of one of list users. Here is the test source:

#ifndef __MSQL_RADIUS__
# define __MSQL_RADIUS__

#include <msql.h>
#include <stdio.h>

void save_msql_record (void);
void msql_error (void);

void save_msql_record () {

        char buffer [512];
        int msql_handle,dbh,sth;

        sprintf (buffer, "insert into log (datloglog,input_octets,output_octets,tempo) values ('19961231152031loomy',10,30,10)");

                msql_handle = msqlConnect ((char *) NULL);

                if (msql_handle == -1) {
                   msql_error ();
                   return;
                }

                dbh = msqlSelectDB (msql_handle, "extrato_online");

                if (dbh == -1) {
                   msql_error ();
                   return;
                }

                sth = msqlQuery (msql_handle, buffer);

                if (sth == -1) {
                   msql_error ();
                   return;
                }

                /* msqlFreeResult (sth); */

                msqlClose (msql_handle);

}

void msql_error (void) {

        fprintf (stderr,"MSQL Error: %s\n", msqlErrMsg);

}

main () {
        save_msql_record ();
}
#endif

        Any ideas?

        Thanks,
                Mario Ferreira.

----- End of forwarded message from Mail Delivery Subsystem -----
--------------------------------------------------------------------------
To remove yourself from the Mini SQL mailing list send a message containing
"unsubscribe" to "unsubscribe" to msql-list-request@bunyip.com. Send a message containing
"info msql-list" to majordomo@bunyip.com for info on monthly archives of
the list. For more help, mail owner-msql-list@bunyip.com NOT the msql-list!