malaga

Members
  • Content Count

    32
  • Joined

  • Last visited

About malaga

  • Rank
    Advanced Member

Recent Profile Visitors

The recent visitors block is disabled and is not being shown to other users.

  1. hello dear all i am trying to make sure that i have set up the MySQL use to be able to access the database via localhost? - this is pretty important for me - i need to have more insights! Aferward i have to try using the following code to connect to the DB <?php $mysqli = new mysqli('localhost', 'my_user', 'my_password', 'my_db'); /* * This is the "official" OO way to do it, * BUT wait - the $connect_error was broken until PHP 5.2.9 and 5.3.0. - so i have to make sure if i am the one that must be careful here */ if ($mysqli->connect_error) { die('Connect Error (' . $mysqli->connect_errno . ') ' . $mysqli->connect_error); } $mysqli->close(); well i have to do some more test. dear experts here at the great Armbian-Forums - i keep you posted - and i come back and report all the findings.
  2. some words regarding the installation: I have Linux Server. Apache 2.4.10, PHP Version 5.6.39 and mysqlnd 5.0.11-dev - 20120503 - installed. There are several wordpress website running on server. I have checked this all one week ago, In the phpinfo(); what do you suggest - should i ask my serveradmin that he will update & upgrade the whole system - in order to have a modern system... And then i run the mysqli_error_(function)!?
  3. Hello dear experts at Armbian well the mysql_connect_error-script is a great help: It returns a string description of the last connect error ( see more infos here: https://www.php.net/manual/en/mysqli.connect-error.php ). The mysqli_connect_error() function returns the error description from the last connection error, if there is any error-note. the return value are the following ones: a. A string that describes the error. b. an empty string if no error occurred. at least this goes for the Version: PHP 5, PHP 7 well - if we run the code below we can get the info bout the option to connect to the db. What if we run this as a mysql-test-script, and what if we will want to convert it to use mysqli? Can this be done by changing mysql _query($sql); to mysqli _query($sql); ? <?PHP // the test-script that we are running. $DB["dbName"] = "emails"; $DB["host"] = "localhost"; $DB["user"] = "root"; $DB["pass"] = ""; $link = mysql_connect($DB['host'], $DB['user'], $DB['pass']) or die("<center>Howdy - be aware; There a thing happenede - An Internal Error has Occured. Please report following error to the webmaster shot him a mail now.<br><br>".mysql_error()."'</center>"); mysql_select_db($DB['dbName']); // end header connection part // function from a functions file that I run a mysql query through in any page. function executeQuery($sql) { $result = mysql_query($sql); if (mysql_error()) { $error = '<BR><center><font size="+1" face="arial" color="red">An Internal Error has Occured.<BR> The error has been recorded for review</font></center><br>'; if ($_SESSION['auto_id'] == 1) { $sql_formatted = highlight_string(stripslashes($sql), true); $error .= '<b>The MySQL Syntax Used</b><br>' . $sql_formatted . '<br><br><b>The MySQL Error Returned</b><br>' . mysql_error(); } die($error); } return $result; } // example query ran on anypage of the site using executeQuery function $sql='SELECT auto_id FROM friend_reg_user WHERE auto_id=' .$info['auto_id']; $result_member=executequery($sql); if($line_member=mysql_fetch_array($result_member)){ extract($line_member); } else { header("location: index.php"); exit; } ?> If we do replace mysql_* with mysqli_* then we will have to bear in mind that a whole load of mysqli_* functions need the database link to be passed. E.g.: the following ones. mysql_query($query) becomes mysqli_query($link, $query) I.e., lots of checking required. on the other hand side: is it suffice if we replace every mysql_* function call with its equivalent mysqli_*, when we will use the procedural API (note: there is some code based on the MySQL API, which is a procedural one - at least afaik), To help with that, the The MySQLi Extension Function Summary-manual is definitely something that will prove helpful. We can do the following: we have the following options to do that: - mysql_connect will be replaced by mysqli_connect - mysql_error will be replaced by mysqli_error and/or mysqli_connect_error, depending on the context - mysql_query will be replaced by mysqli_query ,,,, and so on and so forth. Note: For some functions, we may need to check the parameters very very carefully: Maybe there are some differences here and there -- but not that many differences. Belive me. Both mysql and mysqli-codes are based on the same library ( the great and powerful libmysql ; at least for PHP-version <= 5.2) Usage - for instance: with mysql, we have to use the mysql_select_db once connected, to indicate on which database we want to do our queries mysqli, on the other side, allows us to specify that database name as the fourth parameter to mysqli_connect.
  4. hello dear experts meanwhile i have tried to install wp on a rootserver that is administrated by my friend i have got issues while trying to establish a db connection. then i tried to run a test-teh connection script which gives back the following results Warning: mysqli_connect(): (HY000/2002): No such file or directory in /sites/www.mysite.de/testconnection.php on line 2 Warning: mysqli_error() expects exactly 1 parameter, 0 given in /sites/www.mysite.de/testconnection.php on line 4 Could not connect: well - what does this script-results say - do i have issues and errors in the path of the pipe!?do i have to do corrections here * For information on other constants that can be used for debugging, * visit the Codex. * * @link https://codex.wordpress.org/Debugging_in_WordPress */ define( 'WP_DEBUG', false ); /* That's all, stop editing! Happy publishing. */ /** Absolute path to the WordPress directory. */ if ( ! defined( 'ABSPATH' ) ) { define( 'ABSPATH', dirname( __FILE__ ) . '/' ); } /** Sets up WordPress vars and included files. */ require_once( ABSPATH . 'wp-settings.php' ); well - i am musing what is going on here
  5. hello dear Armbian-experts, How to do a command line test of a connection remotely well - there are several ways to test the DB connection remotely, while the access of the MySQL server from another Linux® server. See - for example the following - that uses 44.55.22.11 as the IP address of the MySQL server: # mysql -u fooUser -p -h 44.55.22.11 Enter password: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 17 Server version: 5.0.45 Source distribution Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql> _ some musings: When you set up a remote user, consider the following information: A local user is of course very very different from a remote user. For example, we can say fooUser@localhost is not the same as fooUser@1.2.3.4.5.6.7.8 If we will want both users to have the same permissions, we need to duplicate permissions. Well we have to admit that it is a fact that we cannot recommend granting ALL permissions. For standard users, we recommend granting GRANT SELECT,INSERT,UPDATE,DELETE permissions. Honestly - to speak frankly: To grant access to only a specific table, we can use the database.table command. some examples: Lemme give soom Examples; let us take for example, in the preceding step, you could use fooDatabase.fooTable instead of fooDatabase. what do you say..!?
  6. od day dear all, i _2019_06_05_Verses_for_google_calendar.ods!? see the differnt formats - in calc- and in a printed sheme.... or in other words - ready to print. question how to arrange to port to the google-calendar!? i guess that i need to make sure that the Start Date column is formatted MM/dd/yyyy. Since i only need all day events i guess that i'll just need a, Start Date column, not the End Date or Time columns. I'm not sure if i need to work over the multiple "Description" columns though... guess that i have to merge them into a single column I suppose. well it does not work at all
  7. hello dear experts Where would you recommend me to store the Keepass-file? Well - for most of the use-cases usually i have all my personal documents in my cloud account. The pro: i can access it from everywhere in the world. With any device. But besides that i am not so sure if this is safe. Especially if it comes to such things like keepass: Some friends mentioned that it is not so safe: Question; would it be safe to use the cloud for the keepass-file? Can i secure it even further, by adding another (extra) layer of security by encrypting the file. the generalized question is this: How safe is it to store the keepass-file in the (wrong place) like in the cloud? What risks do I need to know about? What can I do with the KeePass password file, there are several arguments to decide where to store it. if the passwords are really, really important to someone, one should make the decision based on: - the possible risk of the file being hacked by some hackers - what can we do if we consider to get hacked - what if someone may compromise the file just with a hack - is it preferable that the DB file not get in the wild, - there may be more and other terrible risks - which one do you take into consideration"? so there some difficult questions arise: What should i do - what can be done with the passwd. Can I secure it even further, by adding another extra layer of security by encrypting the file i am going to store in cloud storage online. look forward to hear from you Well i guess: The best place to store the Keepass DB file is wherever it is most convenient for someone. With a sufficiently strong and arbitrarily defined password - like so: 3112-.,,2-1^^^ and so forth. Well i think that we should make use of a long password (30+ characters) well one that is not guessable outside of brute force Belive it or not: i have heared that some like storing the Keepass DB in Google Drive. Question; is this not a big big security hole!?
  8. hello dear all, I've been using the lm-sensors tool for years now - first time in Ubuntu and now i want to use it in Manjaro - my actually fav system LM-Sensors - it does a lot: It monitors CPU temperature, the fan speeds, and - additionally - also the motherboard voltages that could be measured. After using it for some time in Ubuntu - my previous fav-linux.i now want to use some advanced uses of lm-sensors - i have heard that we can use it in combination with some graphical interfaces to interact with it. first i have to do the Installation: step one: Install lm-sensors, then run it with no options to see what it does: $ sensors coretemp-isa-0000 Adapter: ISA adapter Physical id 0: +47.0°C (high = +90.0°C, crit = +120.0°C) Core 0: +45.0°C (high = +90.0°C, crit = +120.0°C) Core 1: +47.0°C (high = +90.0°C, crit = +120.0°C) Core 2: +44.0°C (high = +90.0°C, crit = +120.0°C) Core 3: +46.0°C (high = +90.0°C, crit = +120.0°C) This is on an Ubuntu PC. My Manjaro system installs it a bit different i think - and afterwards i have to take care for the configuration, on older systems - (note 10 years ago i used Ubuntu) i have followed another setup: then i go ahead: Run sensors-detect to set it up to detect the sensors and the temp of the CPU. in the past i have learned that the safest method and way to do a setup and basic configuration of lm-sensors is to accept all of the defaults by: $ sudo sensors-detect # sensors-detect revision xyz (2019-01-30 12:00:33 +0200) and.... after getting the first scan - we can the setup in modify /etc/modules: but how to go ahead now.... how to combine it the get the advanced features - and graphical output!?
  9. hello dear guidol - many many thanks for the quick reply . I am glad to hear from you but while trying to achieve data from the system i get back the following> see what i have done Note - as mentioned above: i Just wanted to get info bout the kernel: in latests Armbian we can find armbian specific info in following file /etc/armbian-release see what i have got back... bash: /etc/armbian-release: Permission denied martin@bananapi:~$ su Password: root@bananapi:/home/martin# /etc/armbian-release bash: /etc/armbian-release: Permission denied root@bananapi:/home/martin# i will try to go ahead and find out more. I will come back later the day and report all the findings. Have a great day.
  10. hello dear All, first of all - i am very glad to be here in this great forum. i have heard that i can run Armbian on Orange Pi as well. And i have also heard some thing regading H6. The implementation of the PCI Express controller of H 6 is known to be broken. Is it still the case. Is there any extended H6-support through armbian?
  11. hello dear all, i am running Armbian on a Banana Pi for more than one month - all goes well No i wanted to do some checks - and i wanted to check the version of the kernel on bash - with /etc/armbian-version but this is only accessible when logged in as superuser At the moment i do not remember the credentials for the super user so i enter su and then a passwd - but i get back "Authentification failure" BTW: with password 1234 i do not succeed. question: What can i do now!?
  12. dear community i own a udoo quad which Armbian does fit to this hardware? love to hear from you
  13. dear community i am so glad to be here on this great forum - this is a great place. i have installed Armbian on a. banana pi b. orange-pi and futhermore i will try to install it on Udoo Quad at the moment i am workin on a new plan: i am planning a Wi-Fi controlled rc-car using Arduino UNO, ESP8266 Websockets or UDP the question that arises here. how would you decide? i want to create an Arduino project about a Wi-Fi controlled (ESP8266) RC car using. - with a tight budget you can’t really buy everything you need at once. what is needed: An Arduino UNO An ESP8266 An L298N motor driver - with or without H-bridge An LF33CV 3.3V regulator An RC car Also batteries that meet your needs / much better: a power-pack regarding the protocolls - not yet every decision is made: - which protocol should i use!? - WebSocket protocol or UDP-protocoll? i need to figure out what else is needed to run this project with ESP8266 / NodeMCU one. what is WebSocket Protocol? guess that i first will try out to go with the WebSocket-approach but furthermore: well after setting up all with a WebSocket-approach i afterwards will also try controlling the car with other protocols like HTTP or UDP to see the difference, if any. what do you think?
  14. hello dear all, good day dear Armbian-experts recently i have managed to get Armbian up and running on a Banana Pi. I was very very glad. now i am digging deeper into the system and try to learn all the necessary things. regarding another system: on orange pi -pc i want to install armbian - from this page https://www.armbian.com/orange-pi-pc/ i fetch Armbian Stretch mainline kernel 4.14.y Server or light desktop usage scenarios. Stable question: can i upgrade after the installation the system to the newest kernel... ?!? Is this possible?