Visit Our UNIX and Linux User Community

Full Discussion: Unix and databases
Top Forums UNIX for Dummies Questions & Answers Unix and databases Post 15848 by tyranunn on Wednesday 20th of February 2002 02:18:34 PM
Old 02-20-2002
Unix and databases

I had a person ask me if a Sql database can be run with Unix? I don't know can this be done? They only have Sql dba's and no oracle dba but want to use a Unix box????
 
Test Your Knowledge in Computers #294
Difficulty: Easy
Ubuntu is a free and open-source Linux distribution based on Slackware.
True or False?

8 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

ASP and Databases on UNIX?

I have been asked to use ASP on UNIX and I have no idea what the limitations are. I have pages using ASP on NT with SQL7, is there an easy transition for my current pages to work on UNIX? Any help is much appreciated. THX (5 Replies)
Discussion started by: dkropolis
5 Replies

2. Cybersecurity

Security Databases are corrupt. HELP!!

Help! SCO Unix 5.05. A relatievely new system went down on me today. I got the dreaded error: Out of Space on Device (1/42). I was able to clear up some space in the /tmp directory, however, when I try to boot, the system prompts me to go into single user mode and I get the... (2 Replies)
Discussion started by: gseyforth
2 Replies

3. UNIX for Dummies Questions & Answers

Checking which databases are installed

I want to check which databases are installed on my FreeBSD installation. This is what I did: pkg_info | grep mysql How do I check all in one go whether also sqlite, postgresql, firebird is installed? Thanks in advance (3 Replies)
Discussion started by: figaro
3 Replies

4. Solaris

SVM - there are no existing databases.

I am facing problems with SVM installed on vmware workstation on intel platform. I have created replicas and a mirror volume using unmountable slices. But when I reboot my hardware I am not able to execute any SVM cmd's getting an error "there are no existing databases." Below are o/p's of few... (0 Replies)
Discussion started by: rahul_11d
0 Replies

5. Shell Programming and Scripting

Two databases

Hello, I have two databases one is student_Name and another is student_Name1...Two tabled contain 200 records each..I found that near 30 names are entered in both databases..I would like to remove the duplicates..and i have to keep the name which is newly added..Please hepl how to remove... (7 Replies)
Discussion started by: Anjali_vee
7 Replies

6. UNIX for Dummies Questions & Answers

Diff command with databases

How can we compare query results from different databases using Unix diff command from command-line in Ab Initio tool? (1 Reply)
Discussion started by: eshalife
1 Replies

7. Shell Programming and Scripting

Need help in backing up of databases.

Hi Everyone, I am new to DBA stuff. I wonder if anyone can help me. Task is that, I have 10 databases and need to take backups of all the databases using data pump in Unix/Linux, compress them using gzip and use cron to schedule the job twice a day. Appreciate if anyone can help me in... (1 Reply)
Discussion started by: sreepriya0987
1 Replies

8. Programming

MySQL Databases

Hello all again, How do you guys backup your MySQL databases? I have a few programs that have an default back up that make an .sql file which is great but I also use OpenX which runs on PHP and has a database. That does not have an auto-back-up feature so do I just download the... (2 Replies)
Discussion started by: AimyThomas
2 Replies
CUBRID_PCONNECT_WITH_URL(3)						 1					       CUBRID_PCONNECT_WITH_URL(3)

cubrid_pconnect_with_url - Open a persistent connection to CUBRID server

SYNOPSIS
resource cubrid_pconnect_with_url (string $conn_url, [string $userid], [string $passwd]) DESCRIPTION
Establishes a persistent connection to a CUBRID server. cubrid_pconnect_with_url(3) acts very much like cubrid_connect_with_url(3) with two major differences. First, when connecting, the function would first try to find a (persistent) link that's already open with the same host, port, dbname and userid. If one is found, an identifier for it will be returned instead of opening a new connection. Second, the connection to the SQL server will not be closed when the execution of the script ends. Instead, the link will remain open for future use (cubrid_close(3) or cubrid_disconnect(3) will not close links established by cubrid_pconnect_with_url(3)). This type of link is therefore called 'persistent'. <url> ::= CUBRID:<host>:<db_name>:<db_user>:<db_password>:[?<properties>] <properties> ::= <property> [&<property>] <properties> ::= alhosts=<alternative_hosts>[ &rctime=<time>] <properties> ::= login_timeout=<milli_sec> <properties> ::= query_timeout=<milli_sec> <properties> ::= disconnect_on_query_timeout=true|false <alternative_hosts> ::= <standby_broker1_host>:<port> [,<standby_broker2_host>:<port>] <host> := HOSTNAME | IP_ADDR <time> := SECOND <milli_sec> := MILLI SECOND ohost : A host name or IP address of the master database odb_name : A name of the database odb_user : A name of the database user odb_password : A database user password o alhosts : Specifies the broker information of the standby server, which is used for failover when it is impossible to connect to the active server. You can specify multiple brokers for failover, and the connection to the brokers is attempted in the order listed in alhosts o rctime : An interval between the attempts to connect to the active broker in which failure occurred. After a failure occurs, the system connects to the broker specified by althosts (failover), terminates the transaction, and then attempts to connect to the active broker of the master database at every rctime. The default value is 600 seconds. o login_timeout : Timeout value (unit: msec.) for database login. The default value is 0, which means infinite postponement. o query_timeout : Timeout value (unit: msec.) for query request. Upon timeout, a message to cancel requesting a query transferred to server is sent. The return value can depend on the disconnect_on_query_timeout configuration; even though the message to cancel a request is sent to server, that request may succeed. o disconnect_on_query_timeout : Configures a value whether to immediately return an error of function being executed upon timeout. The default value is false. Note ? and : that are used as identifiers in PHP connection URL can't be included in the password. The following is an example of a pass- word that is invalid to use as connection URL because it contains " ?:". $url = "CUBRID:localhost:33000:tdb:dba:12?:?login_timeout=100"; Passwords that contain ? or : may be passed as a separate parameter. $url = "CUBRID:localhost:33000:tbd:::?login_timeout=100"; $conn = cubrid_pconnect_with_url ($url, "dba", "12?"); If user or password is empty,you can't delete " :",the following is an example. $url = "CUBRID:localhost:33000:demodb:::"; PARAMETERS
o $conn_url -A character string that contains server connection information. o $userid -User name for the database. o $passwd -User password. RETURN VALUES
Connection identifier, when process is successful. FALSE, when process is unsuccessful. EXAMPLES
Example #1 cubrid_pconnect_with_url(3) url without properties example <?php $conn_url = "CUBRID:127.0.0.1:33000:demodb:dba::" $con = cubrid_pconnect_with_url ($conn_url); if ($con) { echo "connected successfully"; cubrid_execute($con, "create table person(id int,name char(16))"); $req =cubrid_execute($con, "insert into person values(1,'James')"); if ($req) { cubrid_close_request ($req); cubrid_commit ($con); } else { cubrid_rollback ($con); } cubrid_disconnect ($con); } ?> Example #2 cubrid_pconnect_with_url(3) url with properties example <?php $conn_url = "CUBRID:127.0.0.1:33000:demodb:dba::?althost=10.34.63.132:33088&rctime=100" $con = cubrid_pconnect_with_url ($conn_url); if ($con) { echo "connected successfully"; $req =cubrid_execute($con, "insert into person values(1,'James')"); if ($req) { cubrid_close_request ($req); cubrid_commit ($con); } else { cubrid_rollback ($con); } cubrid_disconnect ($con); } ?> SEE ALSO
cubrid_connect(3), cubrid_pconnect(3), cubrid_pconnect_with_url(3), cubrid_disconnect(3), cubrid_close(3). PHP Documentation Group CUBRID_PCONNECT_WITH_URL(3)

Featured Tech Videos

All times are GMT -4. The time now is 04:42 PM.
Unix & Linux Forums Content Copyright 1993-2020. All Rights Reserved.
Privacy Policy