Hi all
I need to run a command that only a role user and root can run, I need to run that command remotely by script but the roles ask for a password.
Ex. from serverA with userA to serverB with userB:
userA can ssh serverB using userB without askink for a password.
ssh userB@serverB... (3 Replies)
Need to recover a replication broken error on the mysql slave server.
I want to force it to resend the binlog file from the begining.
What is the correct value for the: MASTER_LOG_POS ?
0, 1 or 107 ? (2 Replies)
Hi,
I have done setup for openldap master and slave.
Its working fine and replicating also.
But it is working only with plane text password in syncrepl .
How we can use encrypted password here also like we are using in rootpw ?
Below portion is working.
syncrepl rid=101
... (3 Replies)
Hi all,
I am going to implement a script which will use NFS to replicate data between two SCO unix servers. It will take files with mtime -1 and copy the data periodically .In this regard my questions are :
Is this approach good and reliable enough with respect... (2 Replies)
In any given operating system, generally how much of AI software is involved? Is it related to user-friendliness of OS?
What is the future of strong AI? (3 Replies)
my primary dns server is not replicating to secondary. i dont know why. i am running solaris 2.6 on both servers.
what should i do?:confused: (2 Replies)
ODBC_CONNECT(3) 1 ODBC_CONNECT(3)odbc_connect - Connect to a datasourceSYNOPSIS
resource odbc_connect (string $dsn, string $user, string $password, [int $cursor_type])
DESCRIPTION
The connection id returned by this functions is needed by other ODBC functions. You can have multiple connections open at once as long as
they either use different db or different credentials.
With some ODBC drivers, executing a complex stored procedure may fail with an error similar to: "Cannot open a cursor on a stored proce-
dure that has anything other than a single select statement in it". Using SQL_CUR_USE_ODBC may avoid that error. Also, some drivers don't
support the optional row_number parameter in odbc_fetch_row(3). SQL_CUR_USE_ODBC might help in that case, too.
PARAMETERS
o $dsn
- The database source name for the connection. Alternatively, a DSN-less connection string can be used.
o $user
- The username.
o $password
- The password.
o $cursor_type
- This sets the type of cursor to be used for this connection. This parameter is not normally needed, but can be useful for work-
ing around problems with some ODBC drivers. The following constants are defined for cursortype:
o SQL_CUR_USE_IF_NEEDED
o SQL_CUR_USE_ODBC
o SQL_CUR_USE_DRIVER
RETURN VALUES
Returns an ODBC connection or ( FALSE) on error.
EXAMPLES
Example #1
DSN-less connections
<?php
// Microsoft SQL Server using the SQL Native Client 10.0 ODBC Driver - allows connection to SQL 7, 2000, 2005 and 2008
$connection = odbc_connect("Driver={SQL Server Native Client 10.0};Server=$server;Database=$database;", $user, $password);
// Microsoft Access
$connection = odbc_connect("Driver={Microsoft Access Driver (*.mdb)};Dbq=$mdbFilename", $user, $password);
// Microsoft Excel
$excelFile = realpath('C:/ExcelData.xls');
$excelDir = dirname($excelFile);
$connection = odbc_connect("Driver={Microsoft Excel Driver (*.xls)};DriverId=790;Dbq=$excelFile;DefaultDir=$excelDir" , '', '');
?>
SEE ALSO
For persistent connections: odbc_pconnect(3).
PHP Documentation Group ODBC_CONNECT(3)