[PHP-DB] OCIPLogon , maximum number of sessions apache/php - Oracle
Hi all, Does anyone know how many sessions can be opened by apache/php to Oracle using OCIPlogon, or what parameter setting controls this? TIA Steve -- - Minds are like parachutes, they work best when open Support free speech; visit http://www.efa.org.au/ Heads Together Systems Pty Ltd http://www.hts.com.au Email: [EMAIL PROTECTED] Tel: 612 9982 6767 Fax: 612 9981 3081 -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] OCIPLogon , maximum number of sessions apache/php- Oracle
Hi Michael, So what you are saying is that apache/php will keep opening sessions until oracle runs out of processes or cursors or memory or hits session_per_user maximum ?? I was thinking of experimenting with the profile parameter IDLE_TIME Profile Parameter to make oracle close open sessions after a certain amount of time , have you any experience with this? I have open_cursors = 500 processes = 200 max_enabled_roles = 30 regards Steve At 8:24 AM +0200 9/7/02, Michael Bretterklieber wrote: Hi, this depends on your settings in the initinstance.ora in the directory /opt/oracle/OraHome1/admin/instance/pfile dir. Here are some settings: processes = 150 open_cursors = 300 max_enabled_roles = 30 you also have to set the sizes of the shared-memory pool. bye, Steve Farmer wrote: Hi all, Does anyone know how many sessions can be opened by apache/php to Oracle using OCIPlogon, or what parameter setting controls this? TIA Steve -- -- Michael Bretterklieber LCP JAWA Management Software GmbH Liebenauer Hauptstr. 200 A-8041 GRAZ Tel: ++43-(0)316-403274-12 Fax: ++43-(0)316-403274-10 GSM: ++43-(0)676-93 96 698 [EMAIL PROTECTED] homepage: http://www.jawa.at - privat --- E-mail: [EMAIL PROTECTED] homepage: http://www.inode.at/mbretter -- ...the number of UNIX installations has grown to 10, with more expected... - Dennis Ritchie and Ken Thompson, June 1972 -- - Minds are like parachutes, they work best when open Support free speech; visit http://www.efa.org.au/ Heads Together Systems Pty Ltd http://www.hts.com.au Email: [EMAIL PROTECTED] Tel: 612 9982 6767 Fax: 612 9981 3081 -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] Re: Session data not being deleted on browser close.
Don't cross post such question... All you need to understand is how cookie is managed unless you are passing session id via URL. Read RFC2965 and RFC2964. You probably want to read netscape cookie spec also. -- Yasuo Ohgaki Youngie wrote: Why would my session data not be deleted after my browser is closed? I can set some session variables, close my browser, reopen them and the old values are still present, I can verify this by seeing that the file still containts my session data and values. Thanks John. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] OCIPLogon , maximum number of sessions apache/php - Oracle
Hi, first we when we started up with oracle we had problems with these params: processes, open_cursors, max_enabled_roles After a week or so oracle was not able to allocate shared memory, something like this: ORA-04031: unable to allocate 4200 bytes of shared memory (shared pool,TRIGGER$,sga heap,state objects) ORA-00604: error occurred at (remember I'm allways talking about Oracle under Linux) This had 2 reasons: 1. wrong kernel-params (shared-memory-limits and semaphore-limits) 2. a memory leak in Oracle 8.1.7 (applying patchset 3 resolved this) bye, Steve Farmer wrote: Hi Michael, So what you are saying is that apache/php will keep opening sessions until oracle runs out of processes or cursors or memory or hits session_per_user maximum ?? I was thinking of experimenting with the profile parameter IDLE_TIME Profile Parameter to make oracle close open sessions after a certain amount of time , have you any experience with this? I have open_cursors = 500 processes = 200 max_enabled_roles = 30 regards Steve At 8:24 AM +0200 9/7/02, Michael Bretterklieber wrote: Hi, this depends on your settings in the initinstance.ora in the directory /opt/oracle/OraHome1/admin/instance/pfile dir. Here are some settings: processes = 150 open_cursors = 300 max_enabled_roles = 30 you also have to set the sizes of the shared-memory pool. bye, Steve Farmer wrote: Hi all, Does anyone know how many sessions can be opened by apache/php to Oracle using OCIPlogon, or what parameter setting controls this? TIA Steve -- -- Michael Bretterklieber LCP JAWA Management Software GmbH Liebenauer Hauptstr. 200 A-8041 GRAZ Tel: ++43-(0)316-403274-12 Fax: ++43-(0)316-403274-10 GSM: ++43-(0)676-93 96 698 [EMAIL PROTECTED] homepage: http://www.jawa.at - privat --- E-mail: [EMAIL PROTECTED] homepage: http://www.inode.at/mbretter -- ...the number of UNIX installations has grown to 10, with more expected... - Dennis Ritchie and Ken Thompson, June 1972 -- -- Michael Bretterklieber LCP JAWA Management Software GmbH Liebenauer Hauptstr. 200 A-8041 GRAZ Tel: ++43-(0)316-403274-12 Fax: ++43-(0)316-403274-10 GSM: ++43-(0)676-93 96 698 [EMAIL PROTECTED] homepage: http://www.jawa.at - privat --- E-mail: [EMAIL PROTECTED] homepage: http://www.inode.at/mbretter -- ...the number of UNIX installations has grown to 10, with more expected... - Dennis Ritchie and Ken Thompson, June 1972 -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-DB] Form select field problem
Beau Cheers for that. Option one worked as a way of referring to the field. I made a couple of other 'take-down and rebuilds' but it is now working one hundred percent, and wouldn't without your input. Thanks a whole tonne! :) Keiran -Original Message- From: Beau Lebens [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 09, 2002 2:50 AM To: 'Keiran Wynyard'; [EMAIL PROTECTED] Subject: RE: [PHP-DB] Form select field problem Keiran, A couple possibilities for you; 1. Try referring to the field (in JavaScript) as something like; (might have to play around with this) document.existing[groupchoice[]].selectedIndex 2. Make it so that each selection on the select tag is mirrored into another hidden input field (onSelect=) and then you actually check the hidden field for what values are present and what aren't, throwing an error based on it, rather than on the actual select HTH Beau // -Original Message- // From: Keiran Wynyard [mailto:[EMAIL PROTECTED]] // Sent: Monday, 8 July 2002 5:22 PM // To: [EMAIL PROTECTED] // Subject: [PHP-DB] Form select field problem // // // Hi // // I may be posting this to the wrong place, and if so I // apologise. If someone knows of a // better place to post my query please tell me, and I will. :) // // This problem is about 50% PHP and 50% Javascript, really to // do with how the two interface // with each other. // // Anyhoo, down to the problem. // // I have a Select form item with 'multiple' set. It sends an // array of values to be dissected // and applied to database tables, hence it's name value is // 'groupchoice[]'. This all works // well and good when some value(s) are selected, but obviously // gives an error if the form is // sent with no value selected. What I need to do is come up // with an elegant way of stopping // the form if no entries have been selected (or indeed if all // entries have been deselected). // I have successfully used a Javascript function to do this, // but it only works if the field // is named 'groupchoice'. The part of the function that is // causing the problem is listed // below: // // if (!document.existing.groupchoice.selectedIndex != ) //this works // // if (!document.existing.groupchoice[].selectedIndex != ) // //this gives a syntax error // // Obviously if I call the field 'groupchoice' the information // sent is no longer an array, // and therefore I cannot have multiple selections, which is // imperative. I have thought of // other ways of doing the job, such as having an alert pop-up // if there is an error and then // return them to the form, as opposed to before the form is // sent, but didn't feel that this // was very elegant. // // Have any of you PHP gurus out there experienced this kind of // problem and found a solution? // // I would be greatly appreciative if someone would share their // expertise. // // TIA // Keiran // [EMAIL PROTECTED] // // // // -- // PHP Database Mailing List (http://www.php.net/) // To unsubscribe, visit: http://www.php.net/unsub.php // -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] MSSQL_connect() won't work
Hello all! I am desperately trying to connect to a Win2000 SQL-Server, but I always get the error message: Warning: MS SQL message: Login failed for user 'gn'. (severity 14) in c:\inetpub\wwwroot\test.php on line 11 Warning: MS SQL: Unable to connect to server: SERVER1 in c:\inetpub\wwwroot\test.php on line 11 DATABASE FAILED TO RESPOND. Please help me, because I really don`t know what to do! Best regards, Gabor -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-DB] Build-up of MySQL Sessions
Check out this link for an explanation of the mysql_pconnect funtion: http://www.php.net/manual/en/function.mysql-pconnect.php It explains what a persistent connection is and how it thinks. Unless you have a legitimate need for a persistent connection, try using mysql_connect(). It stays open until the script that opened it stops running or until you say mysql_close(). A connection opened with mysql_pconnect() won't be closed if you call mysql_close(). HTH Rich -Original Message- From: SpamSucks86 [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 09, 2002 12:48 AM To: [EMAIL PROTECTED] Subject: [PHP-DB] Build-up of MySQL Sessions I'm running windows 2000 and the latest releases of PHP and MySQL. All database connections are made with mysql_pconnect(). Connections build up, however. The only person connecting to this webserver at the moment is myself. It seems that it opens connections and doesn't close them, or opens unnecessary ones. How can I fix this? Thanks for any and all help. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-DB] MSSQL_connect() won't work
Does the user 'gn' exist? Are you using the correct password? Does that user have permissions on the database? Hint: Login failed for user 'gn' suggests that there is something wrong with that account... Regards Joakim Andersson -Original Message- From: Gabor Niederlaender [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 09, 2002 12:26 PM To: [EMAIL PROTECTED] Subject: [PHP-DB] MSSQL_connect() won't work Hello all! I am desperately trying to connect to a Win2000 SQL-Server, but I always get the error message: Warning: MS SQL message: Login failed for user 'gn'. (severity 14) in c:\inetpub\wwwroot\test.php on line 11 Warning: MS SQL: Unable to connect to server: SERVER1 in c:\inetpub\wwwroot\test.php on line 11 DATABASE FAILED TO RESPOND. Please help me, because I really don`t know what to do! Best regards, Gabor -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-DB] MSSQL_connect() won't work
Hi! Does the user 'gn' exist? Are you using the correct password? Does that user have permissions on the database? Hint: Login failed for user 'gn' suggests that there is something wrong with that account... That would be fine, but it is not the case. It just won't work! I have read something about all this on the mailing list, but I cannot figure out, how to repair it... Gabor -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] Bug in SQL can you help?
Here is my SQL(used in a PHP script so this isn't ot) SELECT extract(year FROM time), extract(month FROM time), count(*) as monthly_views, time FROM tececo_stats group by extract(year FROM time), extract(month FROM time) order by monthly_views desc limit 1 the problem is that is counts the number of rows in the whole thing not the echoed row. How can I get it count the best days only? -- JJ Harrison [EMAIL PROTECTED] www.tececo.com -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] Getting Percentage of coloumn value
Could some one give me an idea as to what I SQL query could use to get the percentages of each differant colomn value. ie if this was my table: +---+---+ | name | id | +---+---+ | foobar | 1 | | foobar | 2 | | foobar | 3 | | barfoo | 4 | +---+---+ I would get this result(Then later do stuff with it in PHP): +---++ | name | percent | +---++ | foobar | 75| | barfoo | 25| +---++ Thanks in advance, -- JJ Harrison [EMAIL PROTECTED] www.tececo.com -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] Executing PHP script through image
I am making a stats program. When the nessicary include file is included it does a reverse-DNS lookup to find the remote host's DNS name. The problem with this is that is seems slow(at least on my test server with a DSL connection). I thought the best way to speed things up would be putting the entire script into a file and then using img src=stats.php within the page. The problem is that I don't know how to output the image with PHP. The image would not be dynamic just a file on the server. I would appreciate peoples comments or other suggestions JJ Harrison [EMAIL PROTECTED] www.tececo.com -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] Re: Executing PHP script through image
Sorry wrong PHP list :} Jj Harrison [EMAIL PROTECTED] wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... I am making a stats program. When the nessicary include file is included it does a reverse-DNS lookup to find the remote host's DNS name. The problem with this is that is seems slow(at least on my test server with a DSL connection). I thought the best way to speed things up would be putting the entire script into a file and then using img src=stats.php within the page. The problem is that I don't know how to output the image with PHP. The image would not be dynamic just a file on the server. I would appreciate peoples comments or other suggestions JJ Harrison [EMAIL PROTECTED] www.tececo.com -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] Saving to local computer
Hello all, Im working on a project in witch i have to save to the users computer from where it views the php site on the server. Better explained in this graph: Im connection from 192.168.10.11 to 192.168.10.1 and the project is on 192.168.10.1. And from the project i need to save to 192.168.10.11's computer to C:\program files\ dir. Any way i can do this?? Thomas Henning -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] ntext data
Hi! As I wanted to retrieve a field of the data type ntext from the db, I got this error message: Warning: MS SQL message: Unicode data in a Unicode-only collation or ntext data cannot be sent to clients using DB-Library (such as ISQL) or ODBC version 3.7 or earlier. (severity 16) in c:\inetpub\wwwroot\test.php on line 18 What do I have to do? I had completed the same things with mysql and it worked without any problems... Best regards, Gabor -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] how do i establish odbc connection?
Hi all! I realized, that it is impossible to retrieve ntext from an MSSQL DB with php normally. (Is this correct?) But I think it should be possible to make it through ODBC. Can someone explain me how this goes? (I think I have set up one ODBC Data Source, but I am not sure) But I cannot even imagine how I use this stuff for establishing a connection... Does it really only go this way? Best regards, Gabor -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] Delete from multiple tables with php
Hi, What is the best way to simulate the following delete statement with php to MySQL 3.23..? $sql = DELETE ordlines.*, ordmaster.* FROM ordlines, ordmaster; $sql.= WHERE ordlines.ORDER_NO ='.$order.'; From what I've read MySQL doesn't support deletes from multiple tables. TIA, Steve. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Delete from multiple tables with php
I think this changed this in the more recent version(s) of MySQL. Check the MySQL docs which match your current version. Proceed from there, it's only a query. Miles Thompson At 03:11 PM 7/9/2002 -0400, Steve Bradwell wrote: Hi, What is the best way to simulate the following delete statement with php to MySQL 3.23..? $sql = DELETE ordlines.*, ordmaster.* FROM ordlines, ordmaster; $sql.= WHERE ordlines.ORDER_NO ='.$order.'; From what I've read MySQL doesn't support deletes from multiple tables. TIA, Steve. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] SQL mailing list
Do any of you know of any good, general SQL discussion mailing lists? Preferably DB-independent. I'd like to find a place to ask SQL questions and get a human response... TIA, -- Casey Allen Shobe / Network Security Analyst PHP Developer SecureWorks, Inc. / 404.327.6339 x169 / Fax: 404.728.0144 [EMAIL PROTECTED] / http://www.secureworks.net Content is my own and does not necessarily represent my company. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] Hostname
Is there a SQL hostname function that'll return the name of the host a db is running on? MySQL has the a SYSDATE() function, does anyone know of a HOSTNAME() function in SQL and/or MySQL? I know that I can find it either from the OS or in PHP, however the need right now is to have it in the SQL script itself. Another one if anyone here is familiar with MySQL. When I do an INSERT that contains the SYSDATE() function, it's inserted in GMT. Is there possibly a way to have it INSERT in local time (CST)? Thanks, Darren Young [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] Re: SQL mailing list
Hello, On 07/09/2002 05:22 PM, Casey Allen Shobe wrote: Do any of you know of any good, general SQL discussion mailing lists? Preferably DB-independent. I'd like to find a place to ask SQL questions and get a human response... This is a recorded message from a machine just to let you know that you may leave any SQL questions after the beep. beep :-) -- Regards, Manuel Lemos -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] A Simple Question
I recently discovered that you can pass variables through hyperlinks. (I didn't know this could be done) This will be very helpful for the project I'm working on but I cannot find any information on this subject. Does anybody know where I can find information on the syntax and limitations of this feature? - Do You Yahoo!? New! SBC Yahoo! Dial - 1st Month Free unlimited access
Re: [PHP-DB] A Simple Question
Suppose you are using PHP. A link like this: http://yourdomain.com/yourpage.php?var1=value1var2=value2var3=value3 will do the trick. And in the page that receives this link (yourpage.php that is), use $_GET[] to get the value: $var1 = $_GET[var1]; $var2 = $_GET[var2]; $var3 = $_GET[var3]; Tony S. Wu Manuel at [EMAIL PROTECTED] wrote: I recently discovered that you can pass variables through hyperlinks. (I didn't know this could be done) This will be very helpful for the project I'm working on but I cannot find any information on this subject. Does anybody know where I can find information on the syntax and limitations of this feature? - Do You Yahoo!? New! SBC Yahoo! Dial - 1st Month Free unlimited access -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-DB] A Simple Question
Also, as far as limitations go, the following are considerations; 1. You can't pass an array using the querystring 2. Multiline variables (ie. textarea contents) are bad 3. There is a limit of 255 or something characters to a URI (someone?) 4. Be careful with the $_GET[] array that Tony mentions, it is only available on more recent versions of PHP, before that it was $HTTP_GET_VARS and a lot of people had been using just plain $var1 or whatever, assuming that register_globals would always be ON in the php.ini file (which also changed in recent versions). HTH Beau // -Original Message- // From: Tony [mailto:[EMAIL PROTECTED]] // Sent: Wednesday, 10 July 2002 7:42 AM // To: Manuel; [EMAIL PROTECTED] // Subject: Re: [PHP-DB] A Simple Question // // // Suppose you are using PHP. // A link like this: // // http://yourdomain.com/yourpage.php?var1=value1var2=value2va // r3=value3 // // will do the trick. // And in the page that receives this link (yourpage.php that // is), use $_GET[] // to get the value: // // $var1 = $_GET[var1]; // $var2 = $_GET[var2]; // $var3 = $_GET[var3]; // // Tony S. Wu // // // Manuel at [EMAIL PROTECTED] wrote: // // // I recently discovered that you can pass variables through // hyperlinks. (I // didn't know this could be done) This will be very helpful // for the project I'm // working on but I cannot find any information on this subject. // // Does anybody know where I can find information on the // syntax and limitations // of this feature? // // // // - // Do You Yahoo!? // New! SBC Yahoo! Dial - 1st Month Free unlimited access // // // // // -- // PHP Database Mailing List (http://www.php.net/) // To unsubscribe, visit: http://www.php.net/unsub.php // -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] A Simple Question
4. Be careful with the $_GET[] array that Tony mentions, it is only available on more recent versions of PHP, before that it was $HTTP_GET_VARS and a lot of people had been using just plain $var1 or whatever, assuming that register_globals would always be ON in the php.ini file (which also changed in recent versions). 4. Be careful with the $_GET[] array that Tony mentions, it is only available on more recent versions of PHP, before that it was $HTTP_GET_VARS and a lot of people had been using just plain $var1 or whatever, assuming that register_globals would always be ON in the php.ini file (which also changed in recent versions). register_globals was turned off by default in the INI file in 4.2.0+ so I would recommend against using them. Besides compatability issues, there are security issues with it. Of course, to maintain backward compatability (Superglobals are only supported in 4.1.0+) you might want to use the $HTTP_POST_VARS, $HTTP_GET_VARS e.t.c. which are being phased out however. Remember though, 4.1.0 was released on the 10th of Decemeber, so there's a good chance many hosts have upgraded to that version or greater, but there are always the late ones. Good reading: http://www.php.net/manual/en/language.variables.predefined.php -- Adam Alkins http://www.rasadam.com -- -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
