1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
|
#include "CTracing.h"
#include "advanced.xpm"
CTracing::CTracing( QWidget* parent, const char* name )
: QWidget( parent, name, 0 )
{
QBoxLayout *playoutTop = new QVBoxLayout( this, 5 );
// Tracing
QGroupBox *pgroupbox = new QGroupBox( this );
pgroupbox->setFrameStyle( QFrame::Box | QFrame::Raised );
pgroupbox->setTitle( QString("Tracing") );
playoutTop->addWidget( pgroupbox, 5 );
QGridLayout *playoutGrid = new QGridLayout( pgroupbox, 3, 2, 5 );
QLabel *plabel1 = new QLabel( "Enabled", pgroupbox, "plabel1" );
pTracing = new QCheckBox( pgroupbox, "pTracing" );
QLabel *plabel3 = new QLabel( "Force Tracing", pgroupbox, "plabel1" );
pForce = new QCheckBox( pgroupbox, "pForce" );
QLabel *plabel2 = new QLabel( "File", pgroupbox, "plabel2" );
pTraceFile = new CFileSelector( pgroupbox, "pTraceFile" );
playoutGrid->addWidget( plabel1, 1, 0 );
playoutGrid->addWidget( pTracing, 1, 1 );
playoutGrid->addWidget( plabel3, 1, 2 );
playoutGrid->addWidget( pForce, 1, 3 );
playoutGrid->addWidget( plabel2, 2, 0 );
playoutGrid->addWidget( pTraceFile, 2, 1 );
// Connection Pooling
pgroupbox = new QGroupBox( this );
pgroupbox->setFrameStyle( QFrame::Box | QFrame::Raised );
pgroupbox->setTitle( QString("Connection Pooling") );
playoutTop->addWidget( pgroupbox, 5 );
playoutGrid = new QGridLayout( pgroupbox, 3, 3, 5 );
playoutGrid->setColStretch( 2, 10 );
plabel1 = new QLabel( "Enabled", pgroupbox, "plabel1" );
pPooling = new QCheckBox( pgroupbox, "pPooling" );
playoutGrid->addWidget( plabel1, 1, 0 );
playoutGrid->addWidget( pPooling, 1, 1 );
// Buttons
playoutGrid = new QGridLayout( playoutTop, 1, 5, 2 );
QPushButton *pSetDefault = new QPushButton( "De&fault", this );
QPushButton *pApply = new QPushButton( "A&pply", this );
playoutGrid->addWidget( pSetDefault, 1, 1 );
playoutGrid->addWidget( pApply, 1, 3 );
// helpt text
QFrame *pframe;
pframe = new QFrame( this, "Frame_7" );
pframe->setFrameStyle( QFrame::Box | QFrame::Raised );
playoutTop->addWidget( pframe, 4 );
playoutGrid = new QGridLayout( pframe, 1, 2, 5 );
plabel1 = new QLabel( pframe, "Label_1" );
plabel1->setGeometry( 20, 20, 32, 32 );
plabel1->setPixmap( xpmAdvanced );
plabel1->setMinimumSize( 32, 32 );
// plabel1->setMaximumSize( 32, 32 );
plabel2 = new QLabel( pframe, "Label_2" );
plabel2->setText( "These options are global. As such, they can only be set by the system administrator or someone else with 'root' access. Turn Tracing on to enable logging of calls. Turn Pooling on to enable Driver Pooling options." );
plabel2->setAlignment( AlignLeft | WordBreak );
playoutGrid->addWidget( plabel1, 0, 0 );
playoutGrid->addWidget( plabel2, 0, 1 );
playoutGrid->setColStretch( 1, 10 );
// init values
char szTracing[10];
char szForce[10];
char szTracingFile[FILENAME_MAX];
char szPooling[10];
char szGUIPlugin[FILENAME_MAX];
SQLGetPrivateProfileString( "ODBC", "Trace", "No", szTracing, sizeof(szTracing), "odbcinst.ini" );
if ( szTracing[0] == '1' || toupper( szTracing[0] ) == 'Y'
|| ( toupper( szTracing[0] ) == 'O' && toupper( szForce[0] ) == 'N' ))
pTracing->setChecked( true );
SQLGetPrivateProfileString( "ODBC", "ForceTrace", "No", szForce, sizeof(szForce), "odbcinst.ini" );
if ( szForce[0] == '1' || toupper( szForce[0] ) == 'Y'
|| ( toupper( szForce[0] ) == 'O' && toupper( szForce[0] ) == 'N' ))
pForce->setChecked( true );
SQLGetPrivateProfileString( "ODBC", "TraceFile", "/tmp/sql.log", szTracingFile, sizeof(szTracingFile)-1, "odbcinst.ini" );
pTraceFile->pLineEdit->setText( szTracingFile );
SQLGetPrivateProfileString( "ODBC", "Pooling", "No", szPooling, sizeof(szPooling), "odbcinst.ini" );
if ( szPooling[0] == '1' || toupper( szPooling[0] ) == 'Y'
|| ( toupper( szPooling[0] ) == 'O' && toupper( szForce[0] ) == 'N' ))
pPooling->setChecked( true );
connect( pSetDefault, SIGNAL(clicked()), SLOT(setDefault()) );
connect( pApply, SIGNAL(clicked()), SLOT(apply()) );
}
CTracing::~CTracing()
{
}
// slots
void CTracing::setDefault()
{
pTracing->setChecked( false );
pTraceFile->pLineEdit->setText( "/tmp/sql.log" );
pPooling->setChecked( false );
}
void CTracing::apply()
{
char szTracing[10];
char szForce[10];
char szTracingFile[FILENAME_MAX+1];
char szPooling[10];
if ( pTracing->isChecked() )
strcpy( szTracing, "Yes" );
else
strcpy( szTracing, "No" );
if ( pForce->isChecked() )
strcpy( szForce, "Yes" );
else
strcpy( szForce, "No" );
if ( pPooling->isChecked() )
strcpy( szPooling, "Yes" );
else
strcpy( szPooling, "No" );
if ( !SQLWritePrivateProfileString( "ODBC", "Trace", szTracing, "odbcinst.ini" ) )
{
QMessageBox::warning( this, "ODBC Config", "Could not apply. Ensure that you are operating as 'root' user." );
return;
}
else
{
strncpy( szTracingFile, pTraceFile->pLineEdit->text().ascii(), FILENAME_MAX );
SQLWritePrivateProfileString( "ODBC", "TraceFile", szTracingFile, "odbcinst.ini" );
SQLWritePrivateProfileString( "ODBC", "ForceTrace", szForce, "odbcinst.ini" );
SQLWritePrivateProfileString( "ODBC", "Pooling", szPooling, "odbcinst.ini" );
}
if ( pTracing->isChecked() )
QMessageBox::information( this, "ODBC Config", "Tracing is turned on.\n\nTracing uses up a lot of disk space as all calls are logged. Ensure that you turn it off as soon as possible." );
if ( pPooling->isChecked() )
QMessageBox::information( this, "ODBC Config", "Connection Pooling is turned on.\n\nMost likely you are intending to use ODBC from a server (such as Apache). If you do not need it; turn it off... it may pose a small security risk." );
}
|
