pouët.net

Important Information for all users of untergrund.net

category: general [glöplog]
It works :)
Thanks a lot!
added on the 2011-10-16 20:39:58 by Strider Strider
Hooray. Sorry for the delay on fixing this.
added on the 2011-10-17 00:45:59 by scamp scamp
Hi,

I have a question: exactly, how can I access mySql db? Is the password is same as for ftp? I can connect to database without password.
I've tried everything what came to my mind, but without success. In my script mysql_select_db() fails, but I have no rights to create a schema.

Thanks.
added on the 2011-10-19 14:56:03 by martin martin
thank you, scamp. works fine now :)
added on the 2011-10-24 20:08:48 by moqui moqui
bump
added on the 2011-11-01 21:47:28 by pista pista
@martin: If you're able to connect to the local MySQL as root, simply administer your own users.
1: mysql
2: use mysql
3: select * from user

There's your complete table of allowed users. To "create" a new user, simply create a new database (if you don't have an existing one) and then do a "grant all privileges to <username>@localhost identified by '<password>' and the user will be added to your list of allowed users. And might I suggest you use PDO to access your data from PHP. It's really a more intuitive way to serve your data and there's a bunch of object-relation models that makes data-management really easy. I'd stay away from the really large ones since they may be a bit tricky and confusing at first sight. Instead, use something really simple as for example Uteeni - it's as simple as these 10 steps:

1: Create a new table using your preferred mysql client (let's call the table 'Example')
2: cd to where you put the uteeni-folder
3: php class_builder.php
4: Answer the prompt (1 for MySQL)
5: Enter name of the table (Example)
6: Edit your php document
7: require_once(class_loader.php) (the uteeni generic class-loader)
8: $ex = new Example();
9: $ex->test_property = "some string"
10: $ex->save();

To retrieve and manipulate the data you just stored:
$ex = new Example();
$ex->find_by_test_property("some string");
$ex->test_property = "another string";
$ex->save();

It's really basic and will save you hours of agony typing all those mysql-statements. It's lightweight and doesn't require shitload of configuration. requires PDO, though.
added on the 2011-11-01 23:48:36 by Punqtured Punqtured
Darn - wrong grant-statement. It should be:
grant all privileges on <databasename>.<tablename or *> to <username>@localhost identified by '<password>'

Sorry about that.
added on the 2011-11-01 23:50:00 by Punqtured Punqtured
hey punqtured, do you think he has root access to the shared mysql installation? :)
Yeah, I just saw that the minute after I posted it ;-)
added on the 2011-11-02 16:53:10 by Punqtured Punqtured
@Punqtured:

Thank you very much for your help.
I will try Uteeni, sounds interesting. I have used ORM tools in Java, like Hibernate.
added on the 2011-11-04 14:07:17 by martin martin
And i forgot to mention, that i can't create a database on untergrund, because i have no rights for it. mysql_connect() is successful with my username. So i can connect, but i don't know what to do next.

Can you please help me this?
added on the 2011-11-04 14:34:05 by martin martin
martin: have you looked in phpmyadmin? You should have a database with the same name as your username.
added on the 2011-11-04 15:09:50 by gasman gasman
gasman: thanks, i didn't know that phpMyAdmin exists on untergrund.
But sadly I can't log in. Tried to use the untergrund credentials, but no success.
added on the 2011-11-04 18:41:44 by martin martin
Hopefully you have kept your untergrund.net account registration mail, because all the required information should be in there.
@Saga Musix: yes, i kept it. Bud i don't know if i requested mysql access or not back then. But i can't log in with phpmyadmin, so maybe the problem is, that i have't requested a mysql account.
added on the 2011-11-05 01:01:13 by martin martin
martin: Drop me a mail with your account name from the mail you registered with and I'll enable a mysql account for you.
added on the 2011-11-05 17:02:32 by scamp scamp
scamp: mail sent.
Thank you very much.
added on the 2011-11-05 20:26:02 by martin martin
Bump!
added on the 2011-11-16 10:16:33 by martin martin
Is there a problem with the ftp server for untergrund.net at the moment?

All the download links to the prods on my website that are served from there are broken and I can't upload to my directory on the ftp server either :(
added on the 2012-01-25 15:11:56 by pmc pmc
what's the status on the FTP server? i keep getting password dialogs on public downloads.
same here
added on the 2012-01-26 20:07:16 by dipswitch dipswitch
I have the problem with FTP too, people keep poking me about broken downloads.
added on the 2012-01-27 05:48:24 by Shiru Shiru
I have the same problem. All my public links are now useless. :/
added on the 2012-01-27 06:59:47 by ham ham
So, any updates on that issue?
added on the 2012-01-30 11:01:20 by Tomoya Tomoya
Me too. Has anybody mailed scamp about it yet?
added on the 2012-01-30 13:42:50 by raer raer

login