rockarolla
Members-
Content Count
45 -
Joined
-
Last visited
About rockarolla
-
Rank
Newbie [Level 3]
Profile Information
-
Location
Japan
-
rockarolla started following Mysql And User File_priv
-
I have a small application that spawns several threads which produce output that I insert into the database. The output from one thread is an array and I use cursor.executemany. In the beginning I was always getting the mysql error ...I managed to resolve this issue - partially it was coming from IDLE editor and the open python shell - seems they were not unlocking the tables while open - so in order for my code to run I use to run it from the shell ... The next step to handle this was to lock the table before every insert - despite that each thread is using its own mysql connection ... At this stage the error still occurs - and this results in loss of data and CPU usage.... Any exerience related to python and mysqldb and executemany and threading will be greatly appreciated!
-
Ha a bittorrent would take you few weeks...but if you are really serious about it and have the required patience I would tell you just go to the python official web site and quickly dip trhough their tutorial, then you would need the GTK module where all the GUI comes - its actually quite straight forward and easy to utilize and they have a very good tutorial - (there are few of them to be installed for it to work...) and then you would need py2exe to compile your program to an executable windows application ...well I think i was wrong in my estim ... you'll have to devote a few months for this to work properly - but maybe first check if someone would be interested in it ... folks need fast download ...
-
HI,I've hit the grain while trying to import file to mysql database - I need to enable file permissions of the database user but this seems not possible with most of the hosting providers. The problem is to set file_priv of the database user to "Y" . This is done in the "user" table of the maintanance database named "mysql". cPanel doesn't allow this. Via the cPanel you can only allow privileges on table querries but you cannot grant host file privileges to the database user - which makes querries like:"LOAD DATA INFILE 'filename' INTO TABLE tablename..."impossible to use - you'll get the access denied errors ...Any workaround will be greatly appreciated!
-
How To Create A PHP Based Hit Counter With MySQL
rockarolla replied to iGuest's topic in Programming
only to mention, I think the word unique is not allowed... I would prefer to make the counter using session...just in case cookies aren't allowed and because using cookies is not always safe. I think they do encourage ppl to use session for cookies. -
REsolved. The problem was the php.ini file - the automatic configuration done by mysql isn't working properly. You need to add some extension caluses in the php.ini file to dynamic libraries that aren't present explicitely....I found an answer - rather a workaround here: http://www.tanguay.info/wamp/installPhp5.php5?step=15 simply add the lines to php.ini: extension=php_mysqli.dll however, this libabry doesn't exists - its fictious in that it can be obtained by renaming php_mysql.dll to php_mysqli.dll (you may find them in the ext folder of your php installation directory) I have them both in the extension clause - now cannot be bothered as to check which one is necessary(some forums say both anyway). I don't know how such a bug can exists? Maybe its a third party stuff interested in promoting their software...
-
I bumped on this combo server applications but I preferred to use the raw distributions...I would appreciate if you could check for me the config files if there are any (e.g. httpd.conf of Apache and the php.ini ) and give me the lines including mysql, safe there are no personal or sequrity issue therewith!Thanks.
-
I have problems running PHP MySQL function in a windows set web environment. PhP scripts are executed but if I try to use mysql connect and other like functions I get a blank window (while using the browser).The command line client is working...I've added the path to libmysql.dll and the extension=php_mysql.dll in the php.ini.
-
file based counter may jam - sometimes it wont be able to overwirte the data - when many visitors navigate to your web. The other problem is if you ain't got permissions to open a file on your server...hence host dependent.
-
Thats my point. The database table has an user/pass so it might not be accessible for a bot or it might be...I think they ``crawl'' a particular site by ``virtually opening'' it and then check the content...at least this is my experience...as I really need to know this I'm making some crawling around too to become an expert... see how if I'll share it ... here are the advises given by G: https://support.google.com/webmasters/?answer=40349
-
Hi,I have made my web site solely stored in a SQL database...that will say if I need to load a page I take it our from the data base and then display it. My question is: is any searcg engine able to ``crawl'' into my web site content?I would appreciate some info so that I can change the way my web works.
-
Well nice tutorial - am Example! But when do you need to write HTML code with a PhP chunk? To me it seems much easier to have a text file with the HTML file - call it template - and insert in it only the new elements I need dynamically dependng on a conditional statement.Another way is - if you want to use PhP to write your HTML code is to read the above template file in an array (or even from the database) and insert it at the place where you need it with a simple function.Well thats my view...I used to use C code to create LaTeX graphics in a similar manner and I am preparing to generate the PhP code for my web site like this.Actually if you want to save writing, you have to use loops - looping is the power of the computers!
-
Lost Connection To Mysql ,..., System Error: 111 In
rockarolla replied to rockarolla's topic in Programming
I don't think so. Here is my code. Its a very simple code just to see if I can ever establish a connection with my database: function open_connection() { $host='localhost:3307'; $user='any'; $db='my_db'; $password='my_pass'; $conn=mysql_connect($host,$user,$password); mysql_create_db ($db,$conn); mysql_select_db($db); return $conn;} If I call this function within my file I get the error: Warning: mysql_connect() [function.mysql-connect]: Lost connection to MySQL server during query in I've looked about several forums and I didn't get any concern to my code. Also I tried using mysql_pconnect() as someone suggested that the problem maybe dropping connection, but it didn't work as well. I don't have any rights to configure neither php nor mysql. So I guess the provider doesn't want anyone to connect to their database... On the same host I cannot use code like this: function add_hits(){ $opFile = fopen ("counter.txt", "r"); $handle = fread ($opFile, filesize ("counter.txt")); fclose ($opFile); . . . so I think at the end that this is a server issue. -
Ehhh if I check the system requirements I get somehow disharted: I ain't sure if I comply with thi requrements...I don't know even how to check it under Windows. Anyway I'll try it out. I take the challeges of the freeware.Thanks
-
Is X-Men Possible With Genetic Engineering ?
rockarolla replied to Darkwolf11235's topic in Science and Technology
Not only lost limbs, they are doing quite some stuff for growing new organs for transplantation. But it seems not that easy - and thats because the experiments with anumals and ppl are forniden. I have some suspictions that at some places these is not the case. Probably secretly experiments of all kinds are carried out and not for the above mentioned noble goals...The best thing of course wll be to battle death I see myself as immortal